Excel file to sambapos


  • name: Xavier
    country: Australia
    age: 24
  • name: Don
    country: US

I have to tell you that I don’t have the idea what I doing Im new in samba I just want to import my excel product list to samba but I don’t now how. thanks for you help

Did you read the tutorial he posted? Your YAML is not correct. It helps if you use the actual YAML not a sample that has nothing to do with what your doing.

You can’t just import your excel file which is why we recommended YAML. Please take the time to read the tutorial he posted for batch product creation using YAML

It is highly recommended to use Notepad++ so it highlights any mistakes.

1 Like

ok thanks let me read the tutorial thanks

2 Likes

man sorry I can’t understand.There are some tutorial with picture to see how can import my products from other POS software to samba using YAML?

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:

5 Likes

…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

  • Name: EZİNE PEYNİRİ KG
    GroupCode: ŞARKÜTERİ
    Barcode: 00001
    Portions:
    • Name: Normal
      Multiplier: 1000
      Price: 13
  • Name: POĞAÇA ADET
    GroupCode: UNLU MAMÜLLER
    Barcode: 00002
    Portions:

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: