Magento Product Import

CLOSED
Bids
14
Avg Bid (USD)
$496
Project Budget (USD)
$250 - $750

Project Description:
This is a project for our Magento Commerce website.
A demo store is installed at www.dgtech.co.nz/magento

We need a script made or Magento Data Flow customised for us to import CSV files into Magento.

Once the initial import is completed we would want a cron job or similar to auto matically import some CSV only to update prices.

The CSVs are all from different suppliers so have different layouts. The product model should be used as the SKU I guess. The prices are costs without GST (New Zealand TAX).

Attached zip file of CSVs and another suppliers CSV is located at http://www.dgtech.co.nz/IngramMicro.zip

The Ingram Micro file is split into many parts and needs to be joined using vlookups and if functions, i tried and got every thing except the third category. Also attached is the explanation of how the Ingram Micro files are laid out- these the are categories on the main file, 13441JASK:
Product Code, Manufacturer Code, Long Description, Your Buy Price, Stock on Hand Figure, Next Available, Brand Number, Category 1 Number, Category 2 Number, Vendor Category Number

I get only 2 or 3 CSVs by FTP, the rest are by email. Ingram Micro is the main CSV and we need to follow the columns from it. Every supplier names the product category differently eg, one says CPU, the other says Processor. The ingram micro file will provide 4 levels of categories and the other csv products need to be put under the ingram micro categories. This can be done manually or a script which could the the following:
If category 1 = processor in other csvs then rename to CPU (or what ever it says in the Ingrammicro csv.

Once the product import system is complete we also need other modifications which will be negotiated, eg, since prices in csv are costs we need a mod which puts a certain %age markup on it to make a retail price.

Skills required:
Data Entry, Data Processing, Excel, PHP
Additional Files: DGTECH_CSV.zip price_product_file.doc
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.