CSV (can be changed also to another format) import of products (combinations) into prestashop 1.5
Should be splitted into two parts (because it is not necessary to update all the products all the time):
1. Full Update of the stock and price(will be used sometimes)
2. Changed Items Update of the stock and price (will be used minimum once per day, may be also triggered more often)
A CSV File will be generated with the changes of the last hour, for example:
(Reference Code, Size, Combination Quantity, Price, taxRate (if necessary – will be the same all the time), feature1)
Product1_referenceCode, 48, 5, 129, taxrate, 2014_v
Product2_referenceCode, 50, 3, 99, taxrate, 2014_v_p
Product3_referenceCode, 48, 5, 129, taxrate, 2013_v
Ad 2. With that information the webshop should be updated (key is the product reference code). There is just a small filter in between: Products with a reference code starting with one or two specific letters should be ignored. If there is no corresponding product, there should be a log file with the missing reference code (which could be also sent to a specific email adress)
Ad 1. The Full Stock update should be done in the opposite direction to find out if there is a product in the webshop with no corresponding reference number (because of whatever reason). Therefore the products from the webshop should be taken and checked if there is a corresponding reference number, if yes, of course the update should be the same as in the partial update routine, but if not there should be also a log file which should be also emailed with the reference numbers without having corresponding reference numbers in the csv file. (The filter should be included as before).
I think that there are basically two ways to do this:
1. executable (in that case I prefer c#) which will run on the local windows computer where the CSV File will be generated all the time when stock changes happened. The updates should then be done on the remote hosted prestashop webshop.
2. A php file which will be hosted on the same remote host like the prestashop webshop and gets the csv file from another webserver where it can be downloaded (or it can be also automatically uploaded)
There should be also a logfile for any update which has been done automatically.
So, basically it is just a csv file to mysql file update with a few filters, logfiles and checks.
Hopefully all details are clear, if not, please don’t hesitate to ask me.
The project name should be more "UPDATE of product combinations quantity" instead of import - sorry about that, but however, should be still the same project.
Also, when the stock quantity of a product changes of course the product itself should change the view status in the webshop or write a logfile to see which product run out of stock or another possibility is to let it online available with no stock and no price for two more weeks and then disable it - this should be just one more sql update statement.
just added a more detailed specification - looks huge, but it is just very detailed to avoid any confusion - basically it is just updating mysql database of prestashop with data out of a csv file
17 freelancers are bidding on average $279 for this job
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start thanks