We're in the process of updating our Magento store. We're making major changes to the categories, renaming categories, and adding new categories and subcategories. We have a large database of products, and this means that the products will be reassigned to the new category and subcategory structure. I have pulled reports from our ERP system with the product sku's for each category and subcategory in the new store. (Did not pull products from Magento)
My question is, can I use a Dataflow Advanced Profiles to import the spread sheets with the product sku's and assign all the sku's for each import to the new category? We have a lot of Grouped products in the store, If this works, will I need to do a separate import for the grouped sku's?
I want to avoid doing this manually as we have 3 separate stores. Any suggestions you have to offer would be greatly appreciated.
Current Live store front: Magento Community Edition 1.7.02
New/Updated store in development: Magento Community Edition 1.9.11
Yes you can do this, but you should be careful to only update the products that you want updated. Do not leave products on your list that don't need updating as you can change the inventory values by accident.
You may also want to consider a tool like MAGMI to have an easier way of updating your products.
Finally, this extension will work on your store in real time
It will allow you to update your products in a spreadsheet without having the hassle of doing uploads and downloads
Thanks for the reply. Good to know...so I guess I'll do a test on a small batch of products. Many of the products will be in multiple categories, so my approach will be to update one category at a time.
Thanks for the tool recommendations. At a quick glance, they each look pretty good and could definitely save time. Cobby looks more stable than Magmi based on reviews and other info on the website.
I noticed your comment about inventory levels changing and figured you understand the Dataflow Profile mess of Magento really well.