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

Import XML product data from an ERP to Magento - Super Attribute Pricing? 
 
pezi5499
Jr. Member
 
Total Posts:  6
Joined:  2008-03-05
Munich
 

I am trying to import XML product data from an ERP (enterprise resource planning) or merchandise / inventory management / control / planning system to a Magento-based onlineshop for clothes.

This works pretty well.

First step: configure some products as you would like to have them in Magento Admin. Then export them (all fields) in csv-format.

Second step: Write a script that converts the XML data to a csv-file according to Magento’s csv-format. There you can perform tasks as converting one single product with different sizes to one configurable product and several simple products with one size each (one csv-line per product).

Third step: Import the csv-File to Magento according to:

Importing products - using a cron job to call Magento Dataflow import

Fourth step: correct the database with sql-statements as described here:

Configurable Products?

You can pack all steps into one file, which you can regularly call by a cronjob

Last step: How can I import or set the super attribute pricing (provided I know which simple-product has to cost how much more) to Magento?
Does anybody have a ready solution to this he is willing to provide?
I am currently researching with:

foreach ($product->getConfigurableAttributes() as $attribute{
     
echo $attribute->getLabel()."<br />\n";
}
and with:
$attribute->_afterSave();

hot or not?

 
Magento Community Magento Community
Magento Community
Magento Community
 
R O B
Jr. Member
 
Avatar
Total Posts:  11
Joined:  2009-06-26
the Netherlands
 

I also like to know!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Cool & Deadly
Member
 
Total Posts:  46
Joined:  2010-08-11
 

me too :-(

 
Magento Community Magento Community
Magento Community
Magento Community
 
sergiy90
Jr. Member
 
Total Posts:  20
Joined:  2012-08-14
 

I, personally, don’t convert xml to csv. I know that paying money is, maybe not that want you need, but I use file2cart service. So, i took my xml and import products directly from it! (saves time)

Sorry, if it doesn’t help! =)) Best wishes!

 
Magento Community Magento Community
Magento Community
Magento Community
 
quicksand14
Sr. Member
 
Total Posts:  150
Joined:  2010-09-30
 

File2Cart is actually easy and it works. +1 for this

 
Magento Community Magento Community
Magento Community
Magento Community
 
oktacy
Jr. Member
 
Total Posts:  12
Joined:  2012-05-29
 

ucuz ve en uygun fiyatlı cep telefonu alışveriş sitesi yapıyorumda xml ile ürün çekmem gerekiyornasıl yapabilirim.
mesela başka bir sitede bulunan tüm sıfır ve ikinci el cep telefonu bilgilerini kategorilerini örnegim samsung iphone htx blackberry nokia gibi ve tüm cep telefonu ürünlerini nasıl çekebilirim siteme.

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