Magento – Magento 2: Import Script Store Id Related Issue

customimportmagento2product

I'm using Magento 2 CE Version 2.1.3

Magento 2: Save all product data outside Magento with Images

Once I imported data from CSV using above script.

If put as ->setStoreId(0), then it will add two values for same Field In Database Table. One as Store Id 0 & Second As Store Id 1.

Example: catalog_product_entity_varchar

value_id    attribute_id store_id entity_id     value
100           70           0       10           Test
101           70           1       10           Test <- NOT NEEDED ENTRY

attribute_id 70 is for name (Product Name) from Table eav_attribute

Due to 2 values for Same Field. Each time have to delete Store Id 1 related value from Database respective Table, then it works fine on Frontend.

At the end data is not displaying properly as needed. Have to do each time Delete Query for Store Id in 5-6 tables.

Go to Admin -> Stores -> Configuration -> General -> General -> Single Store Mode

It always been issue. On Admin side it's taking Store Id 0 value & on frontend displays it's taking Store Id 1 Value.

Enable Single-Store Mode set to "Yes"

On Admin -> All Store Views -> Store Id = 0 -> Admin Using This
On Admin -> Default Store Views -> Store Id = 1 -> Frontend Using This

What i'm still missing in Script? Does Enable Single-Store Mode set to "Yes" helps?

Other workaround will be set Admin to Default Store Views. In my case i have only 1 store. So may be works.

While we do Default Magento Import/Export. It only uses Store Id 0 & it works fine.

Best Answer

$objectManager->get('Magento\Store\Model\StoreManagerInterface')->setCurrentStore('admin');

before importing the products will have the products use store id 0 ('admin') only

Looking at module-catalog\Model\ProductRepository.php:save() (Magento 2.1.2) it seems that the store id is retrieved from the current store on save, and not the one set via Product::setStoreId():

$productDataArray['store_id'] = (int)$this->storeManager->getStore()->getId();

Related Solutions

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.

Magento 2 – How to Create Product Programmatically with Different Store View Values

I think the best answer to this question currently looks like this (using price as example attribute):

/** @var  \Magento\Catalog\Model\ProductFactory */
protected $productFactory;

/** @var  \Magento\Catalog\Model\ResourceModel\Product */
protected $productResourceModel;

public function __construct(
    \Magento\Catalog\Model\ProductFactory $productFactory,
    \Magento\Catalog\Model\ResourceModel\Product $productResourceModel
)
{
    $this->productFactory = $productFactory;
    $this->productResourceModel = $productResourceModel;
}


private function setStoreViewPrice($productId, $storeId, $price)
{
    $product = $this->productFactory->create();
    $this->productResourceModel->load($product, $productId);
    $product->setStoreId($storeId);
    $product->setPrice($price);
    $this->productResourceModel->saveAttribute($product, 'price');
}

See also https://magento.stackexchange.com/a/114958/35180

Related Topic

Magento – Magento 2 : How affects Enable Single-Store Mode Yes/No