Batch Product Creation with YAML

V5 Tutorial
21

On mine it did. I would think on yours it would not though. Test it on a fresh database and see… or backup your database and then test it.

1 Like
22

If your decimal separator is , no it won’t make a trouble. Worst thing may happen will be correcting prices with price list editor.

1 Like
23

If you look at the export file it exported the prices just fine… My regional settings wont allow the , separator so it messes things up… but yours should allow it and it should copy over fine.

2 Likes
24

Are there any tags to export Inventory Items and Receipts?

so we close the whole cycle of products.

Thanks!!!

G.

25

Maybe you should just backup > restore and clear database transactions.

26

Yes, there are Report Tags for Inventory. I don’t think there are any for Recipes.

1 Like
27

Sorry, I think I missed something here…

Thanks!!!

g.

28

You can create a backup on system 1, restore it on system 2. So everything comes to system 2. Clearing transactions will allow you to start fresh. Did I misunderstood your need?

29

yes… sorry…
I just wante to export
Products, menu, inventory and receipts,

I am working on a no licenced machine (just adding stock, testing stucff) and would like to export to the working/licenced machine…

By the way, did you read the PM?

Thanks!!!

G.

30

Hmm. I see. This is a different case as you already have data in your target machine. That should be handled differently.

I read your PM. Thank you for noticing that.

1 Like
31

you are most welcome!!!

Thanks!!

G,

32

I had a couple questions on the YAML:

  1. What are all the fields supported via the YAML - are there any that can be populated that aren’t mentioned above?
  2. Am I able to create menu items from YAML, and add relevant fields such as menu item name / header, sub menu tags, etc?

I’m really looking for a way I can add more data in one pass, especially being able to have a different menu button name / header, and being able to add menu subcategories.

33

export.png1013×544 21.5 KB
I am unable to export, it seems the button to export isn’t functioning.

If I preview I have no option to save, its greyed out.

Anyone have this problem?

Matt

Edit: I have managed to export but it says that it isn’t in the correct format when I paste it in Batch Create Products

Matt

It seems to not be formatting correct. Working it against the export file added above I have noticed I have to put sort out the portions by adding a 3 into the portion area, but the first set, Name, Groupcode, Barcode and Tag are not making a new line.

Have added a file of what its throwing off, Ive tried to amend it but unsuccessfully.

Matt

34

I have tried editing with TextWrangler, but it seems to error on the Tags. I have added the correct tags into the tags on the program settings aswel just incase it was that but still don’t seems to work.

ive tried to manually make this but I cant get it to work.

if anyone can help me with the above script that would be amazing, cos it don’t work :frowning:

35

Download and install Notepad++ it supports YAML formatting and you can spot your mistakes easy. Copy and paste your YAML here if you dont mind.

36

ive also had issues with this… seems like when its exporting the alignment is off compared to some of the examples above some of the lines are combined instead of having everything on its own line for groupcode, price, name etc… see examples below.

This is the example @emre posted:

- Name: Test Item 1
  GroupCode: Test Items
  Barcode: 12345
  Tag: Tag1
  Portions:
  - Name: Pcs
    Price: 5
  - Name: Pack
    Price: 10
  Tags: 
  - Name: Custom Tag 1
    Value: Tag Value 1
  - Name: Custom Tag 2
    Value: Tag Value 2
- Name: Test Item 2
  GroupCode: Test Items
  Barcode: 22222
  Tag: Tag2
  Portions:
  - Name: Pcs
    Price: 5
  Tags:
  - Name: Promotion
    Value: VIP
  - Name: Item Type
    Value: Bar Item

And this is what Im getting when I do the export:

- Name: 8oz HAMBURGER STEAK  GroupCode: MEAT & VEGGIES  Barcode:   Tag: 
Portions: - Name: 2 VEG    Price: 7.79
- Name: 3 VEG    Price: 8.79
- Name: MEAT ONLY    Price: 5.79
- Name: SR 2 VEG    Price: 6.59
- Name: SR 3 VEG    Price: 7.59
Tags: 
- Name: PORK TENDERS OVER RICE  GroupCode: MEAT & VEGGIES  Barcode:   Tag: 
Portions: - Name: 2 VEG    Price: 7.79
- Name: 3 VEG    Price: 8.79
- Name: MEAT ONLY    Price: 5.79
- Name: SR 2 VEG    Price: 6.59
- Name: SR 3 VEG    Price: 7.59
Tags:

Template I used was this:

[DataExport:0]
@{REPORT MENU ITEM DETAILS:M.Id::|}
{REPORT MENU ITEM DETAILS:M.Name,M.GroupCode,M.Barcode.M.Tag:M.Id == $1:
- Name\: {0}
  GroupCode\: {1}
  Barcode\: {2}
  Tag\: {3}
}
{REPORT PORTION DETAILS:P.Name,P.Price:P.MenuItemId == $1:
  - Name\: {0}
    Price\: {1}:
  Portions\: {0}}
{REPORT MENU ITEM TAG DETAILS:T.Name,T.Value:M.Id==$1:
  - Name\: {0}
    Value\: {1}:
  Tags\: {0}}
1 Like
37

^^ this

Using the template above, no matter how I change it it always formats as above.

Matt

38

@Jesse this is what I’m using, as shown by emre above

Matt

39

Its probably a template formatting issue. Let me look at it.

40

think we crossed lines there, its above :slight_smile: