Batch Product Creation with YAML

V5 Tutorial
1

Use Batch Product Creation feature not to go crazy while creating products.

V5’s Batch Product Creation feature allows importing products from formatted text data. That format is called YAML. It is human readable and easily editable with your favorite text editor.

- 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

Notepad++ supports YAML format so you can benefit from syntax highlighting, tree list navigation and auto completion features.

000168.jpg1275×1120 119 KB

By 5.1.50 release we’ll also support Product Export as YAML format so you can easily transfer items between setups. I’ll add required Data Export template soon.

6 Likes
2

Many thanks Emre… Its a great improvement to ease and simplify the use of our POS.

2 Likes
3

Great job, this will be a hugely valuable tool for me :smile:

Nice :smile:

Wish I could type that fast :stuck_out_tongue:

4

Dear guys, @emre, @Jesse, @JTRTech, @QMcKay… nice reunion… jajajajajjaa, sorry… I would like to export products with YAML and then import those products in a different machine… how to do that… could you throw me a line here?

Thanks!!!

G.

5

Emre said by time .50 public, did it get to public yet?

2 Likes
6

nooo… not yet, I beleive… thats why I could not find the option…
well… buuuuuuuuuuuuuuu

Thanks!!!

G.

7

@gerlandog I will show you in the beta forum just give me a few minutes.

1 Like
8

I have not seen any mention of it since discussed a while back, are we going to see a way to export/import menus?

9

Its already there you have to define an export template for it.

EDIT:It looks like Emre is released the version so I will wait and let him finish the template in the tutorial.

1 Like
10

I saw it, but I could not make anything work, jajajajajajajajajajaj, yet…

Thanks!!!

G.

11

You need the correct export template to do it.

1 Like
12

Ihave seen this…

Pasted image1366×768 58.3 KB

But no PRODUCT Templates…

so I think we will have to wait…

G.

13

There will not be built in templates but it will resemble what you saw above with the YAML import template. Likely it will need some specific structure.

14

Sorry, I am not following… to early in the morning…

Thanks!!!

G.

15

You wont be able to just press a button and it export them. You will need to create your own template like you do for exporting CSV data. It will be YAML format and we need to know the structure first. I am sure he will release it soon.

16

This Data Export template should work. @gerlandog if you have non default products can you please paste it into the editor, export a file and send me that file?

[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}}
4 Likes
17

Here you are sir!!!

EDIT: Are there any tags to export Inventory Items and Receipts?

Thanks!!!

G.

Export.zip (614 Bytes)

18

Now to import them just copy whats inside the file it created and paste it inside Batch Create Products dialog box.

jordyn.png1695×973 36.9 KB

3 Likes
19

I was about to paste the same screen shot lol.

Seems like @gerlandog uses , as decimal separator so my prices was different.

1 Like
20

will the , make any troubles here?

Thanks!!

G.