Importing product feed into magento

[xhale2007]

Morning guys.

My latest supplier has a great .csv data feed, which id really like to import into my magento store.

The problem is its laid out completely different to the magento feed i have just exported. (by laid out different, i mean all names of coloums etc are different)

What the best way of going about getting this imported? There is around 3700 items within it. Its updated daily with stock counts etc as well.

Regards

Dan

 

[ShortCouture]

you would probably be better off asking this question on the magento forums.

just google for them.

 

[alanc]

You can do some VBA programming within an Excel spreadsheet that can take it's own data and populate another page or output a file in the converted format.

Either do this yourself or find someone who knows about programming spreadsheets.

 

[iboxsecurity]

You should look to get a development company to build something for you that will do the import.

We are just finishing up a script that will import a suppliers XML feed into a magento store for a client at the moment pretty much the same thing you are after.

 

[edmondscommerce]

It would be amazing if they did give you a feed in perfect Magento format.

You can try manually moving columns around and inputting to a Magento format feed.

You could try to use some excel magic to automate that process a bit if you want or as ibox says, the best solution is a proper custom feed import system.

A full custom feed import system should handle grabbing the feed from the supplier, checking and sanitising errant data and then importing data that has changed since the last import.

If you want a more regular stock/price update as well as a more comprehensive listings update that's also a good idea. Just updating stock and price is a lot faster than doing a full update.

If the volume of items gets high then its well worth checking out uRapidFlow which can handle large volumes and can form part of an automated system

 

[zilabee]

This is not a big problem for us, we are currently working on an Ecommerce store in Magento which is importing feeds from different suppliers such as ETC, C2000, Ingram Micro. Midwich, Rocate and Westcoats. We have developed some scripts in PHP to import these feeds and will definetly be able to assist you.

 

[xhale2007]

I have access to an xml feed and a .csv feed.

The xml mainly has stock counts, and the .csv has everything from product code to descriptions etc.

What sort of job is making this script to add these products? How much am i looking at roughly?

Dan

 

[zilabee]

I would be interested in having a look at your xml feed, does this also include the product images. I assume the product images are URLs.

You would need to create a PHP script which will be used to import the products, are you importing one off or are you updating the data regularly with new prices etc.

The script can be run as a cronjob scheduled to import data automatically either daily or weekly or as required.

If we can have a look at your data it will help us provide a quote.

 

[xhale2007]

I dont know how it will work, or how it can be made to work.

The descriptions are in plain text format, no html. So these are going to look wrong if added as they are. With approx 3500 items, its going to be a bit of a task to edit all of these.

Unique ID
Product Code
Subproduct Code
Product Name
Description
materials
Size (imp)
Size (met)
Power
Trade Price
RRP
CategoryRange
ImageName
ThumbImageURL
ViewImageURL
Hi-Res URL
Stock
StockLevel
MPN
Manufacturer


Thats how the coloums are laid out within my .csv

 

[zilabee]

Who is the supplier for this feed? Most suppliers are able to provide the data you need for your feed and maybe able to provide descriptions in HTML format.

One of the problems with feeds is that you have to live with data they provide, maybe just import the descriptions are they are. It all depends on your site, is this currently live or under development.

Are these products being imported into a single category or different categories?

The feeds we have consist of over 30k products in one csv file.

 

[zilabee]

Can you please visit our website at zilabee.com and send a quick brief. I will help you investigate this issue and provide a quote.

 

[xhale2007]

Ill have to ask them about the feeds, and see if they are able to provide anything else. Dont think they can.

Site is currently live, but its an out dated version of magento, and it has a an error, so before i sort these feeds, im going to quickly rebuild the site on a newer version of magento. Should take very long, as i havent changed anything other than the theme.

Products will go into seperate catagories. These are named in the catagory range coloum.

This is sounding like alot of hassle. Might be worth doing them one at a time manually over a few months.

 

[edmondscommerce]

One top tip here is this:

Beware of Custom Systems that are not Upgrade Compatible

For speed, they may decide not to use the standard Magento API or Objects. If they do this you may well find that come upgrade time, which for Magento store owners should be at least once per year though probably more often, your import feed may either stop working altogether or, in a way worse, may still work but start introducing bugs.

We have already had one client who had to abort an upgrade from Magento 1.3.x due to this problem, so they lost money on the aborted upgrade and are still locked into a now very out of date version of Magento.

The same goes for any custom system that is built outside of the standard Magento way of doing things.

 

[PMSToys]

Looks like a 1on1 feed to me. I'm using the same csv lol

 

[dannier]

i have totally no idea of that sorry for no suggestion.