Excel file to sambapos

[RickH]

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

[sukasem]

@Roy_Veitia

There are some tutorial with picture

Isn’t this picture?

Batch Product Creation with YAML

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

[Roy_Veitia]

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)

[Roy_Veitia]

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

[Jesse]

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.

[QMcKay]

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.

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:

[Roy_Veitia]

…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

[Roy_Veitia]

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

[Roy_Veitia]

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

[Jesse]

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.

[Roy_Veitia]

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

[QMcKay]

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

@emre

This Data Export template should work.

[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}}

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

How to export and import Menus from one Database to Another

I was using SQL Express 2014 and Microsoft SQL Server Management Studio 2014 for this. I will show you how to use Microsoft SQL Server Management Studio to Export your Menu and Products into a SQL Script so you can use Database Tools to import your entire Menu if you ever need to rebuild your database for some reason or you want to use a non production computer to build a menu and then import it to your production system. For whatever reason this may be useful to you here is a simp…

[Azad]

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:
  • Name: Normal
    Multiplier: 1
    Price: 1,5
    
    

[emre]

[Azad]

Data Export ok, i want import multiplier 1000

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

[Caleido_Lab]

I got this formulla ERROR:

[QMcKay]

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)

[Caleido_Lab]

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

[QMcKay]

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]

[Caleido_Lab]

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.

reggards