Magento Products Mass Import

I have a new Magento installation on a US based server that is running well. I installed a template that my client purchased and am currently working on graphical changes to the template for the client (my next hire project will likely be to implement the graphical changes)

This is a sports products site for all major US sports. The client is setup with a supplier to ship all the products for him, and has an excel file of the supplier's inventory and that is what needs to be imported. Believe it or not, it is 26,000 products.

So, here are what needs to be known:

- Top level categories are sports (NFL, NBA...) and are in the system already

- 2nd level categories are teams and are in the system already

- From there we'll want to use attributes to further divide the products (shirts, hats, balls, cards, etc) these are in the system

- Products will need to belong to 2 categories - the sport and team category. So, adding 2 categories to the appropriate field for import is important. I can get one category to import but haven't found anything on the web about how to specify 2 categories in that field correctly.

- Obviously the products will need to be parsed via searching and filtering in Excel to be able to put the right data in the right category and attribute fields. This is why I'd like someone with some familiarity with US sports.

- Not sure how to deal with images yet- all the images live on the supplier's server and we are allowed to link to them, but they are in folders and I think Magento only allows local image URLs as images. So this may be a case of me downloading all those images, getting them into a single folder and uploading to the host. However the image names are in the export file.

Since the export file from Magento and the Excel file from the distributor don't match, obviously some manipulation needs to happen on the file before import. Also I am guessing that the import will need to be broken up into something like 5 imports so Magento has an easier time with the number of products.

Taidot: Ostoskärryt

Näytä lisää: magento image import, mass import products magento, mass import image magento, magento mass import, magento controller override, magento controller, magento script, why will no one hire me, why hire us, why hire me, top searching, single match, searching supplier, next hire, local hire, how to get t shirts, how 2 hats, $5 shirts, magento uploading inventory excel, magento image display using supplier url, mass upload product magento, magento import field order, magento mass import products, magento distributor import, magento mass import images

Tietoa työnantajasta:
( 0 arvostelua ) Novato, United States

Projektin tunnus: #455931

Myönnetty käyttäjälle:


Hi, I have gone over your RFP,Please Read My PMB for vital information regarding the bid

$450 USD 12 päivässä
(4 Arvostelua)

12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Dear friend, Pls look into pm. Regards, Rahman.

$600 USD 5 päivässä
(11 arvostelua)

We can do it

$450 USD 6 päivässä
(18 arvostelua)

check our message. thank you

$750 USD 20 päivässä
(4 arvostelua)

WE are ready,pl check pmb

$550 USD 10 päivässä
(1 arvostelu)

Hello Sir, Please check [url removed, login to view] experts!!!waiting for the selection. Regards, Kate

$600 USD 15 päivässä
(2 arvostelua)

can be done. lets start:)

$750 USD 5 päivässä
(2 arvostelua)

Please check PMB

$700 USD 10 päivässä
(0 arvostelua)

please kindly check your PMB thanks.......

$500 USD 25 päivässä
(0 arvostelua)

Please see PM

$750 USD 30 päivässä
(0 arvostelua)

I have done through your requirements. I think, we are the service provider who can provide you the best solutions. For more information, look at next PMB. Thanks Ankur

$700 USD 15 päivässä
(0 arvostelua)

Greetings from an Indian Company. We are an established Indian web Development Company having vast set of experience in developing and designing complex [url removed, login to view] team consists of designers and developers who Lisää

$750 USD 20 päivässä
(0 arvostelua)