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