I have a Zen cart store [url removed, login to view] and I need to keep the products up to date with stock levels and prices from here.. [url removed, login to view]
As we have a different pricing structure in this store we would like to be able to set certain parameters to the import such as all items between prices 1.00 to 10.00 are 10% higher and all prices 10.01 to 50.00 are 5% lower etc. . I would like to be able to create as many of these as needed in the future ( I can edit the php file if i have instructions). The import will need to be able to run quickly to ensure it does not 'timeout' on my hosting, maybe by cutting the import into batches?? The import will need to be set as a cron job to run automatically which my hosting allows but I will need instructions.
The import must update the tables for prices and stock and if the sku/product code doesn’t exist it must add it as a new product with a status of being inactive to allow us enter all the details and set as active.
1, Create import script to update our zencart site from live feed [url removed, login to view]
2, Create ability to allow us to set pricing structures as needed, ideally from within Zencart admin but can do edits to php file if given instructions.
3, Ensure script does not timeout on our hosting (maybe by only importing a set number of products at a time).
4, Ensure script updates zencart site with prices, stock quantity and add new unknown items if found.
5, Give instructions to set up as cron job.
6, Ensure script is fully commented to allow me to make easy changes in the future, if for example the tables change or we move the site etc.
One last part.. for this to work i need to update the product numbers.. i can supply an excel file of the current product code and the new one that each product needs updating to. that part should be a one off task for the update script to work.