Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Um, any documentation? 
 
NathanJ
Member
 
Total Posts:  44
Joined:  2008-04-07
 

I guess I’m missing the obvious, but I can’t find any documentation on importing products via a CSV file. I have some specific questions about this process but can’t even find the basics.

Can anyone point me in the right direction?

Thanks…

 
Magento Community Magento Community
Magento Community
Magento Community
 
adimagento
Guru
 
Avatar
Total Posts:  626
Joined:  2007-08-29
Los Angeles, CA
 

This is some of what is available at this time:

http://www.magentocommerce.com/blog/comments/announcing-magento-dataflow-a-flexible-data-exchange-engine/

 
Magento Community Magento Community
Magento Community
Magento Community
 
Lefty1
Jr. Member
 
Total Posts:  6
Joined:  2008-03-20
 

Same question I asked.  It is very important that this topic should get some heavy detailed documentation and fast.  I’m on a deadline and need to get my store up and running.  I have over 13,000 products to sell.  It’s either get this thing rolling or jump to a ready made platform.  I find that many e commerce solutions share the same problem as far as documentation.

 
Magento Community Magento Community
Magento Community
Magento Community
 
NathanJ
Member
 
Total Posts:  44
Joined:  2008-04-07
 

Thanks for the replies.

Are there any sample import CSVs for download? Or can I generate one by manually adding a couple of products, exporting that to a CSV, then using that output as my template?

Couple of other questions: 

- Can I put XHTML into an item’s description field in the CSV?

- Can I upload multiple image filenames for each product?

- Can I import custom field values through the CSV file?

Thanks....

 
Magento Community Magento Community
Magento Community
Magento Community
 
adimagento
Guru
 
Avatar
Total Posts:  626
Joined:  2007-08-29
Los Angeles, CA
 

We should have descriptive documentation for DataFlow by the end of this week. I’m sure this will make things much easier.

 
Magento Community Magento Community
Magento Community
Magento Community
 
NathanJ
Member
 
Total Posts:  44
Joined:  2008-04-07
 

Great, thanks…

 
Magento Community Magento Community
Magento Community
Magento Community
 
sherrie
Mentor
 
Avatar
Total Posts:  1655
Joined:  2007-12-14
Waterloo, ON
 
NathanJ - 30 June 2008 01:43 PM

Thanks for the replies.

Are there any sample import CSVs for download? Or can I generate one by manually adding a couple of products, exporting that to a CSV, then using that output as my template?

Yes you can set up a couple products and then export them to get a sample csv file.  There is a screencast that shows exporting - or you can simply use the preset for it under System > Import/Eport > Profiles

 
Magento Community Magento Community
Magento Community
Magento Community
 
NathanJ
Member
 
Total Posts:  44
Joined:  2008-04-07
 

Thanks.

Any experience with my other questions?

- Can I put XHTML into an item’s description field in the CSV?

- Can I upload multiple image filenames for each product?

- Can I import custom field values through the CSV file?

Thanks again.

 
Magento Community Magento Community
Magento Community
Magento Community
 
sherrie
Mentor
 
Avatar
Total Posts:  1655
Joined:  2007-12-14
Waterloo, ON
 

- Can I put XHTML into an item’s description field in the CSV?

I’m not sure, I haven’t tried this yet.

- Can I upload multiple image filenames for each product?

There are a few threads in this forum as to how to do that - I’ve only uploaded the Base Image, Small Image, and Thumbnail thus far.

- Can I import custom field values through the CSV file?

If you’re referring to product attributes then yes, if not - what are you referring to?

 
Magento Community Magento Community
Magento Community
Magento Community
 
NathanJ
Member
 
Total Posts:  44
Joined:  2008-04-07
 

Thanks.

I think we’re on the same page re: custom fields/attributes. I’m talking about, for instance, creating a field name like “Partner Only”. The field won’t affect the price, and it won’t be an option they can select when adding to the cart or checking out, but it will be something they can search or filter by, and something that will be displayed on the item’s page.

 
Magento Community Magento Community
Magento Community
Magento Community
 
sherrie
Mentor
 
Avatar
Total Posts:  1655
Joined:  2007-12-14
Waterloo, ON
 

Well, as long as we’re still talking 1.0 attributes and not 1.1 custom options, all you need to do is add them on the right in the csv file.  The best way to see how to do this is to add those attributes to your test products before exporting so you can see how it builds them in there.  I was able to do this for Size and Color for over 2000 products.

 
Magento Community Magento Community
Magento Community
Magento Community
 
NathanJ
Member
 
Total Posts:  44
Joined:  2008-04-07
 

1.1? Is there a beta of that or something? I thought the current was 1.0.x…

 
Magento Community Magento Community
Magento Community
Magento Community
 
sherrie
Mentor
 
Avatar
Total Posts:  1655
Joined:  2007-12-14
Waterloo, ON
 

It’s actually not even beta yet, it’s still alpha, but i have it installed on a test site - I just wanted to make sure we were talking about the same thing. smile

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top