php script for prestashop 1.6 - product import

Prestashop 1.6.x.x product import

There are some tasks that you need to evaluate before proceed to read this article.
Are you able to log to your site via ftp?
Do you have any confidence with kron task, like windows too?
if the answer is yes to both, you will be able to use this self php script, for import a excel file with category and products directly in the database of prestashop.
I have created for prestashop 1.6.0.9 and i think it will work for the next version, not for the previous.
the script follow this idea:

1. check the created category
2. update the category with new category if not present
3. check the product already present in the catalogue
4. if already present update the quantity and the price
5. if not insert this new product

the point number 4th is really important because if you have a tons of product reload all of this could be a problem for your bandwidth...

in my previous post i have spoked about the point 1 and 2, now i show which table of the db are involved in the other point:

ps_product

ps_product_lang

ps_product_shop

ps_produt_shop_lang

ps_stock_available

 

for create the script you must reiterate many times like the number of the product around the tables, take care of the id's of each product and don't make confusion and in a fast way you will be able to obtain a good sripts.

good work