English Boards > V3 Development

Bulk Import Of Products

<< < (2/2)

emre:
Today we imported ~3200 items for a small market.

Note1: Import your data on 3.24 database and after import install latest version to upgrade. Since we constantly change database structure it might not work on further releases.

Note2: If your decimal separator is comma "," excel uses ";" char as delimiter and that creates issues. Change decimal separator to dot "." in excel and export it to csv.

Note3: If product names contains (') character that creates another issue. I've replaced them with notepad++.

The result is epic win :) We scanned every product we could found in the office and had real fun with it. Inventory items, recipes all created fine...

JohnS:

--- Quote from: emre on September 12, 2013, 08:43:08 pm ---Today we imported ~3200 items for a small market.

Note1: Import your data on 3.24 database and after import install latest version to upgrade. Since we constantly change database structure it might not work on further releases.

--- End quote ---

I have tested with 3.0.26 and have found no side affects or issues as yet. But to be safe always start with the last version that has been confirmed fully tested.


--- Quote from: emre on September 12, 2013, 08:43:08 pm ---Note2: If your decimal separator is comma "," excel uses ";" char as delimiter and that creates issues. Change decimal separator to dot "." in excel and export it to csv.

--- End quote ---

Unfortunately this will always be a case with translations. By default I use comma separated. I will test using a semicolon ; and make this the standard in future versions.


--- Quote from: emre on September 12, 2013, 08:43:08 pm ---Note3: If product names contains (') character that creates another issue. I've replaced them with notepad++.

--- End quote ---

There are some characters that PHP will have issues with, and these are definitely ' and "
I will look at stripping these characters from the imported data.


--- Quote from: emre on September 12, 2013, 08:43:08 pm ---The result is epic win :) We scanned every product we could found in the office and had real fun with it. Inventory items, recipes all created fine...

--- End quote ---

When faced with such a large volume of products to enter, this tool has been an amazing time saver. And it's not just for the initial import of products either, you can also use this to add extra products when new stock lines arrive.

This has been a great result. Thank you for the feedback.

JohnS:
Emre,

Something that I have just noticed, and this was with 3.0.24 as well as 3.0.26.
After an import, if you select Edit Product Properties for a Menu Category, the Product Name is identical to the Menu Name, ie it shows the \r in the name.
I have checked the database and the Product Names are correct. I'm not sure what is causing this. If you remove a product from a Menu Category and add it again, it will show correctly.

sukasem:

--- Quote from: JohnS on September 12, 2013, 11:09:57 pm ---Emre,

Something that I have just noticed, and this was with 3.0.24 as well as 3.0.26.
After an import, if you select Edit Product Properties for a Menu Category, the Product Name is identical to the Menu Name, ie it shows the \r in the name.
I have checked the database and the Product Names are correct. I'm not sure what is causing this. If you remove a product from a Menu Category and add it again, it will show correctly.

--- End quote ---

It's not just import product. I just did key in product from scratches, yeah it's the same issue.

crazypete:
Good day,

Did you manage to get this working as I also want to import all my products to inventory and recipe. I tried downloading the importer and was unsuccessful in downloading it. Is there maybe an easier way as I have thousands of products and should be imported as 1:1. I am running 3.033

Thanks in advance.

P

Navigation

[0] Message Index

[*] Previous page