The following is a summary of what needs to be done for this ZenCart project.
Our distributor provides us with two CSV spreadsheets.
One spreadsheet (_detailed) contains a list of all the items that the distributor carries and lots of information about each item. This spreadsheet is update approx every 90 days, and is available to download.
The other spreadsheet (_inventory) contains a list of the items that we are approved to resell, along with current inventory in stock, and our cost price. This spreadsheet is updated in real time and is available to download (via cron).
_detailed CSV structure:
_inventory CSV structure:
We need you to write a script that will select products from the approved _inventory spreadsheet, match them with the _detailed spreadsheet and populate those items to the ZenCart catalog with the proper category, images, quantity in stock, price (with our retail price mark-up % applied), description, weight (for shipping purposes), etc.
This script will need to be run via cron daily, and also available to be run on demand. Also obviously we need to insert new items, as they become available, check for modified items (if inventory, price, images, description, changes).
The distributor carriers various products, but we are only selling cell phone accessories. So all non-cell phone related products can be ignored. We will help you determine which categories from the distributor spreadsheet will align with our own zencart categories.
From a previous project we have some code that was written by a developer using the same spreadsheets to achieve a similar goal, so it would be useful to review and use this code to your advantage.