How to Switch Website When Importing Products from CSV in Magento

importproduct

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?

Best Answer

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

Related Solutions

Magento – Importing product weights when multiple rows in CSV per product

The file you generated through Magento Export (whether this is default import/export module or default dataflow profile) is NOT going to work if you import it back, because it doesn't preserve the format.

If you want to update weights, I would recommend this:
1) filter your CSV in Excel, filter only those which have "sku" field assigned
2) copy-paste the filtered rows into new spreadsheet
3) leave only 2 columns - "sku", "weight"
4) import it back.

I'm pretty sure it's the easiest flow to solve your concrete task.

For those who are looking for tool for Magento that allows both export and import while having similar format for both routines, check out this one.

Magento – Attributes with Website Scope Empty in Frontend When Imported with Store ID

The problem was caused from another part of the script which loaded the product again to set the store view specific values. And the problem was to set the store id before loading the product.

My old code:

$product_de = Mage::getModel('catalog/product');
$product_de
    ->setStoreId('1')
    ->load($id)
    ... // set some store view specific data
    ->save();

The fixed code:

$product_de = Mage::getModel('catalog/product');
$product_de
    ->load($id)
    ->setStoreId('1')
    ... // set some store view specific data
    ->save();

Now only one entry get's inserted in the catalog_product_entity_* table – with store_id = 0.

Strange because I've seen it in the other order e.g. here: http://www.webguys.de/magento/produkte-mehrsprachig-importieren/ (german website)

Don't know if this is a bug, or there is a reasonable explanation for this behaviour.

Best Answer

Related Solutions

Magento – Importing product weights when multiple rows in CSV per product

Magento – Attributes with Website Scope Empty in Frontend When Imported with Store ID

Related Topic