We need to upload a csv file with our products in to the Amazon API at a set time each day.
The import file format is attached, the headers are:
Category1 Category2 Category3 Category4 Category5 SubCategory Product Name ASIN# (Not actual ASIN, used as SKU) Barcode price Manufacturer Review Score Reviews# Amazon Rank Description Image1 Image2 Image3 Image4 Image5 Quantity
We need some advanced features as included below;
A blacklist file, which allows us to exclude items by SKU from being listed
A ASIN match file, where we can link ASINS with SKUs to output the correct sku to Amazon
An ASIN match file, which allows us to link SKUs and ASINS, so the ASIN is placed into the output file rather than the barcode
A config file to set all of the variables, including amazon account details/API keys and source file address. Also in this config file should be;
A fixed and percentage profit amount to add onto the price.
We should be able to set a maximum and minimum price for products to be included in the output.
We would like to be able to set a maximum quantity to list, so if the quantity in the file is higher, or does not exist it defaults to this value.
We would like the option to be able to place a two character code onto the front of the SKU.
We would like a comment setting to set the text that appears in the comments section, to be appended to the product name from the source file.
We would like to be able to filter the output by manufacturer or category (As listed in the source csv file)
The script should remove all of the previously uploaded products, so that there are no products left on the account before the new add is done.
Also to be included in this project, although can be done at the end, is the same upload but using our creloaded/oscommerce website DB as the source, not the csv file.
We would like the previous upload files to be kept in a backup folder so that they can be reviewed if there are any errors.
If you are able to complete this project then please place a bid