Excel file to sambapos

Read further up the post Emre has posted a link to a tutorial give that a read. It tells you the exact format you need to use so you can just copy and paste it, chnage the details to your products and copy and paste that YAML data into the batch create product settings and it will add them all

Isn’t this picture?

Thanks Guys I understand now how is working but my problem now is that I have almost 7000 products is for a DollarStore in florida and I like to know if I can import my products before I buy the professional version.
my products are in excel I send to you a copy to check if you have time.

Thanks inventario dollar store.zip (84.4 KB)

This is the code to just paste inside Batch Product Creation:

I’ll answer it again just in case you missed my response. You can not import an excel file but you can use YAML to batch create products.

Search the 'net to find tools to convert CSV to YAML.

Or use Excel to read the CSV data and use this formula in a Cell:

=CONCATENATE("- Name: ", A2, CHAR(10), "  GroupCode: ", "Imported", CHAR(10), "  Barcode: ", C2, CHAR(10), "  Portions: ", CHAR(10), "  - Name: Normal", CHAR(10), "    Price: ", G2)

That produces YAML formatted data from your CSV file. Copy the formula to every row.

:warning: You will probably want to clean up your CSV data file. There are duplicate Products, and some without names and/or prices.

Copy all the formatted data and paste it into Word or Wordpad or Notepad++. (Windows Notepad will not work due to a “quote” issue!)

Copy the data from the above text editor (i.e. Wordpad), and paste it into SambaPOS Batch Create Products tool.

This is the result:


…you are the best thanks for your clear explanation hope people can explain like that

Thanks very much Now I have all my inventory in samba pos thanks to you

Good bless you

1 Like

Thanks my friend now I know how use YAML in notepad++ so I fixing now my problem thanks very much

1 Like

Hi my friend I do a backup on V5 demo and now don’t let me open said invalid licence and when I try to restore the backup in other computer whit V5 this is what appear

You can not restore v5 database into an older version. You can login to www.sambamarket.com and clear your license key and reactivate license on the restored database.

License is only good for a single database so if you activate license on a database but then restore a different database it will not work until you clear license key and reactivate license on new database.

It will allow you to backup and restore the same database.

Ok. Now how can export the products to edit on notepad++ or YAML?

The same topic linked above contains a post by Emre on how to Export to YAML using Reports > Data Exports feature …

Here is an alternate method to Export/Import Products and Menus directly from/to the Database Tables, using SSMS…

1 Like

How can add Multiplier

    GroupCode: ŞARKÜTERİ
    Barcode: 00001
    • Name: Normal
      Multiplier: 1000
      Price: 13
    GroupCode: UNLU MAMÜLLER
    Barcode: 00002

1 Like

Data Export ok, i want import multiplier 1000

Scale prices are automatically updated in SambaPOS V5 as the prices of the products change

I got this formulla ERROR:

That is a generic error message generated by Excel that provides no good information on the problem.

There is no way to know what is causing the error other than to understand how Excel’s CONCATENATE function works and compare it to the data from the cells that you are feeding in to it.

It looks like you are using CHAR[10] as the 3rd parameter, which is incorrect.
It should be be CHAR(10)

1 Like

Can you send me an excel file with this formulla? i’d tried many times and the same problem
Thanks you

No. I already gave you the formula.

You chose to edit it to contain CHAR[10] which is breaking it causing the error, because Excel does not accept that syntax.

It should be CHAR(10) not CHAR[10]

Thaks you for your quick response, but i got the same error.
In google sheets i got the same error.
if u can see, the ", in the formulla box appears highlighted.