Need to automate process of weekly import/update of a CSV containing aprox. 26000 items into a zencart E-store. The process need's to access the the CSV file from an FTP site weekly, change price and qty values as well as and new products and category. The process need to restructure the data for import, convert pricing based on formula,add category's and category images . Will also need to be able to include and exclude products based on aux. text files as part of the update process and be able to restructure cataogy trees as specified in text files. Basic feature list needed - The process must not interfiere with other products and category's in store.
1. Process will run automatically via cron assuming 1&1 provides a working version of cron. If not an SSH command will run this process.
2. The process will get the csv file from the ftp server
3. 4 auxiliary text files will be part of the upload process:
a. Exclude these items – based on model #, a newline for each item. Text after a comma will be considered comments
b. Price these items not based on the formula, based on model #, a new line for item – model#, price
c. Category transformation – Format TBD. This will allow the upload to transform products from one category tree to another.
d. Process created file – Out of Stock count and exclude. This file will “count” number of times an item was out of stock. After X repeats the item will be auto-excluded from the load.
4. 4. Update/Insert items to database – using pricing formula or fixed price from file.
5. 5. Insert missing categories to file.
6. 6. Generate missing image-file report.
Parameter configuration will be done via a custom [url removed, login to view] file in the process working directory which is outside of the web-space.
7. Add upload screen for 3 auxiliary files to server from Zencart Admin section.
Most of this project is completed, we need it finished
A good amount of the work is done.
The autopopulate script is getting the FTP files, writing them to a temp dir for processing and also reading the extra command files.
The way the script is written it never gets into the processing of the files into the DB. I wrote some echo to the screen statements in the code area where it should process to DB and they did not get written to the screen..
With that said, I believe it would require about 6 hrs to finish debugging and make the updates and fix the file upload buttons. There are over 2700 lines of code in the script so it’s a little complicated to sort out quickly.