Magento Product Import

Closed

Description

This is a project for our Magento Commerce website.

A demo store is installed at [url removed, login to view]

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 [url removed, login to view]

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: Data Entry, Data Processing, Excel, PHP

See more: magento ingram micro, magento category import, ingram micro magento, magento import products csv ingram, magento ingrammicro, magento auto import, magento product data import, import files magento, magento import csv, magento import categories, magento import products, magento ingram, magento products import ingram, magento import export erp, magento import script, import product magento commerce, magento category importer, magento import large product csv doesnt finish, import products magento, import export magento, import category magento, pricezip ingram micro, import categories magento, magento lightbox, import data magento

Project ID: #338404

14 freelancers are bidding on average $496 for this job

maruti1001

Hi I can do this import task, what other task do you have?

$500 USD in 10 days
(5 Reviews)
4.0
AGSTechnologies1

We have gone through the information that you have provided and understand your requirements very well. We have excellent expertise in PHP5, MYSQL, DRUPAL, JOOMLA, HTML, CSS, AJAX, JAVA, J2ME, JSP, SEO, SEM, ASP.NET, V More

$725 USD in 25 days
(2 Reviews)
3.8
violetweb

Magento module. SEe PMB.

$700 USD in 3 days
(1 Review)
3.4
chandegara

Hello Sir I am ready ti start this work. Please check PMB.

$500 USD in 10 days
(2 Reviews)
1.9
rrakhmit

i can do it very efficiently.

$250 USD in 10 days
(0 Reviews)
0.0
commerce888

I am in Los Angeles and can work it quickly.

$300 USD in 1 day
(0 Reviews)
0.0
najibk

I am the developer behind top-rated Magento community extensions, part of Magento groups, in the process of becoming a Premium Magento Partner, and have a history of working with custom Magento modules. In addition, m More

$750 USD in 10 days
(0 Reviews)
0.0
zamanboby

Hi, this is zaman,we are a team,we can serve you,we are adept in website building. as to your project ,LAMP(linux+apache+mysql+php)is better,we can provide you the whole solutions and at the back end,we will provide yo More

$250 USD in 20 days
(0 Reviews)
0.0
rkthakur

Dear Sir/Madam I possess 4 years of experience in E-commerce site custom made as well as open source like Magento, Oscommerce, Creloaded, Virtual mart. My expertise is in E-Commerce. My expertisation in More

$750 USD in 15 days
(0 Reviews)
0.0
imsolcube

Let me do it, just give me more detail.

$495 USD in 7 days
(0 Reviews)
0.0
henryfeng

Hi, this is henry,we are a team,we can serve you,we are adept in website building. as to your project ,LAMP(linux+apache+mysql+php)is better,we can provide you the whole solutions and at the back end,we will provide More

$580 USD in 19 days
(7 Reviews)
2.8
aedit

Dear sir/madam I have 5 pc with hi speed internet connection and have 1 years eexperience in the respective field and all all kind of data entry services & all kind of Software development. i m waiting for ur respo More

$250 USD in 10 days
(0 Reviews)
0.0
ptctech

I can do it on time. Please give me more details. Thanks

$550 USD in 5 days
(0 Reviews)
0.0
vijagadhavi

hi sir, i have did the same thing as you required in your project. i can do that easily and better. i have good exp in magento till now. so give me chance me to prove myself by my work. Thank you ' Vijay gadhavi

$350 USD in 11 days
(0 Reviews)
3.4