I am updating around 2500 product prices and I thought I can simply use the import/export function from Magento.

What I´ve done is an export of all products, updated the .csv file and now I want to import all the products again, in small batches of 200-300 products. For the export I only used the "SKU" and "price" and thats all what I want to import again also.

I´ve used my dev instance to do a test and it worked fine for all 2500 products, besides the fact that it took really long.

Now before I want to use it on my live instance I was wondering if there is anything missing or if anything could go wrong the way i do it. I´m thinking about Flat Catalog data or will this be ok?

  • Are you exporting all attributes or only price attribute?
    – lloiacono
    Feb 29 '16 at 14:18
  • I´ve updated my question, but I only use SKU and price
    – Klettseb
    Feb 29 '16 at 14:31
  • 1
    Indexes should be invalid after importing. Be ready to run the re-indexing as soon as you finish importing.
    – Prateek
    Feb 29 '16 at 15:08
  • What effects will that have?
    – Klettseb
    Feb 29 '16 at 15:39

I uploaded the .csv file and after that re-indexed all Indexes and then it was working as expected and the prices were updated so all good. So I recommend

1) Make sure your .csv file is consistent

2) Make a test run on your development site with re-indexing after the upload

3) Do the same steps on the live system, shouldn´t take too long for a few products, and I have split up my 3000 products in 3 parts so 1k products each time.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.