Đã hoàn thành

ZenCart Product import automation from csv Need compleated

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.

Kĩ năng: PHP, Zen Cart

Xem nhiều hơn: zen writing, web based ssh, values of report writing, tree update, tree insert, the formula for writing a report, temp work, model of report writing, formula writing, format pricing, data trees, comments to writing list, stock categories, feature writing format, zencart, script automation, Report automation, product upload and stock update script, pricing model, import database, import csv, d tree, d product model, csv php, csv import

Về Bên Thuê:
( 1 Nhận xét ) Tulsa, United States

ID dự án: #1083778

Được trao cho:


Complete csv import script

$300 USD trong 5 ngày
(43 Đánh Giá)

6 freelancer đang chào giá trung bình $405 cho công việc này


--Hi please check **PMB** for details.

$250 USD trong 8 ngày
(45 Nhận xét)

Expert here please view the PM

$400 USD trong 5 ngày
(22 Nhận xét)

Hi, please check PM.

$280 USD trong 4 ngày
(39 Nhận xét)

Hi, please check your pmb for more info.

$500 USD trong 5 ngày
(0 Nhận xét)

Please check PMB and lets start immediately! (Quality Services & Competitive Deadline are like two sides of a Coin!)

$700 USD trong 5 ngày
(1 Nhận xét)