I have created a new store for wholesale customers. For wholesale customers, I want to set a different price. We can set it by backend manually, when adding a new product by switching website. But I have lots of products. By doing manually, it takes too much time to finish.

How to switch website when importing product from CSV? I have tried with _product_websites, store_id, websites. etc., keyword with the corresponding wholesale id. It changes main store price too.

Have any idea?

  • What does importing products have to do with switching websites? You have one installation with different stores and websites I guess? Per website or shop you can set different prices.
    – SPRBRN
    Commented Feb 12, 2014 at 8:37
  • yeah. in single magento installation, i have 2 websites, each have one store. system->cofiguration->catalog-> price here i have set catalog price scope as website.
    – DRAJI
    Commented Feb 12, 2014 at 8:42
  • You could take a look at catalog price rules, but I'm afraid that they don't fit your needs. Another option is to look for a module to manage product prices.
    – SPRBRN
    Commented Feb 12, 2014 at 10:47
  • so can't we set different price to wholesale website by csv file?
    – DRAJI
    Commented Feb 12, 2014 at 10:50
  • 1
    @rxt fixed yar! thank you so much for your reply. In store field, i have replaced default "admin" by "wholesale" . Now the above issue was fixed
    – DRAJI
    Commented Feb 12, 2014 at 12:42

1 Answer 1


For Short answer, you can refer the comments under question.

For detail referrence

First setting price for wholesale to anyone product manually.

Goto catalog->manage products ->enter into anyone product. There, switch website into wholesale.

enter image description here

Here uncheck the use default value checkbox. Then enter wholesale price and hit save button.

Now This product having different price in main store and wholesale store

Then Export this product in system->import/export->Data flow-Profiles ->export all products. Then in profile wizard tab select your wholesale website in store

enter image description here

Then enter that sku in sku field

enter image description here

Then hit save and continue button. And run export. Then you can see that export file in var/export folder. In this excel file, you can see the difference for wholesale. In store field, you have to enter your wholesale website code.

Now make these changes in your new file. And import it again. It will be work. Cheers!

Note: Its only for editing products. Not for adding new products

For model CSV please look at here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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