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

Need some Importing help ASAP
 
metaforgebrandon
Member
 
Total Posts:  57
Joined:  2009-03-26
 

I needed to change a bunch of product names.  I exported all my products into a spreadsheet, changed the names, and imported them back in.  For some reason I ended up with some duplicate products, with “.0” added to the sku.  How do I avoid this?

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Discovery
Enthusiast
 
Total Posts:  767
Joined:  2007-12-29
 

You can write a program with the SOAP API to update specific fields. Yes, this is a bit of work, but after a while the efforts will be rewarded down the line when you want to make some other changes.
Check the wiki for some articles on how to use the soap, then put a bit of php together to open your text file of sku’s and names. Then use product.update:

http://www.magentocommerce.com/wiki/doc/webservices-api/api#product_api

Here is a noddy soap example that you can extend:

http://www.magentocommerce.com/wiki/howto_find_products_that_are_lacking_tier_prices

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