How to Import Magento 2 Product by Store View?

You’ve come to the right place if you run a multilingual storefront or use several different store views. Below, we explore a situation when you need to import Magento 2 product data by store view. While this procedure may seem quite exhausting when you use the default import tools, you may rely on several other ways to simplify these data management chores. Below, we provide community-based recommendations on Magento 2 product import per store view for both Magento 1 and Magento 2. At the same time, you will find a solution proposed by the Firebear team. 

The article incorporates materials from the StackExchange question by ruuter. Once we came across it, we thought it was good to share our experience in this area. Thus, if you don’t know how to import individual product data per store view in Magento 2, we will teach you below. 

Also, note that the article compares the traditional approach that works for Magento 1.x with the new way introduced in Magento 2. As for the improved solution, we shed light on the associated product import automation, product data transfers per store view from external sources, and the use of alternative data sources, such as Google Sheets or API connections.

Magento 1 Product Import by Store Siew

ruuter writes that In Magento 1.x, it is possible to run a store view-based product data import by having each store data in a new line with empty SKU fields.

And, as you might have already guessed, this approach doesn’t work anymore. What does the author offer instead?

Magento 2 Product Import by Store Siew

First of all, ruuter tried the following way to organize data in a CSV file:

And it didn’t work resulting in the following error::

Next, the author tried to import translations separately. He decided to add store_view_code with the appropriate value:

This approach works only partly. It imports content to the correct store view but causes an unexpected problem. If you implement it, get ready for the disappearance of default names from the database.

But how to run the update correctly avoiding coding practices?

The solution is pretty simple as always. You need to modify the second approach illustrated above.

Import all store views in one import and include the default one.

In case of a separate import, you reset field data for all store views and keep the ones in the last import. So, what is the difference between 1.x and 2.x approaches?

In Magento 2, SKUs must be set for each store view when you import individual product content for each store view. Thus, a correct Magento 2 CSV looks as follows:

It is also necessary to mention that the aforementioned approach works only as an update of already existing products. To run the initial import, add the required attributes. You can find more information in our Magento 2 Product Import Guide.

How can you improve this approach even more? Find the answer below.

Improved Magento 2 Product by Store Siew Import

To improve the procedure mentioned above, you need the Improved Import & Export Magento 2 extension. Not many tools provide at least half of the features available with the module. Being one of the most robust import/export solutions in the ecosystem, it already implements a bunch of significant improvements; however, more critical updates are planned for the near future, for instance, product data auto-translation during import by Google or Bing. With this feature, you will forever forget about complicated multi-store import processes due to the following algorithm:

• Import default store view data;
• Select store views and corresponding translations;
• Run the update.

Next, the Improved Import & Export Magento 2 extension will translate the provided document to the corresponding languages and update the specified store views automatically. You don’t need to worry about data file improvements that make the algorithm from the previous chapter possible – our module will do everything for you! Follow this link for more information: 

Get Improved Import & Export Magento 2 Extension

Magento 2 Import/Export Benefits

As long as automated translations are under development, you can still leverage a plethora of enhancements introduced in the Improved Import & Export Magento 2 extension while importing individual product data for each store view.

Better Performance

First of all, the Improved Import & Export Magento 2 extension offers much better performance than the default import solution of the platform. If you have to deal with massive data files, this reason is enough to switch to an alternative tool. But there are many more improvements we’d like to draw your attention to.

Fully Automated Updates

Perhaps, one of the most intriguing aspects of the Improved Import & Export Magento 2 extension is the ability to automate your updates making data import/export entirely autonomous. How is it possible?

Schedules

The Improved Import & Export Magento 2 extension fully supports schedules; there are several ways to create them.

Since the extension is based on cron, you can leverage the standard cron syntax to create any custom interval to run import/export processes automatically. It is possible to tailor the schedule to the highest possible precision so that it is suitable even for the most demanding requirements.

Alternatively, you can select one of the predefined intervals. Also, note that it is possible to customize the chosen interval as much as your business requires.

In addition to advanced automation options, the Improved Import & Export extension still lets you create import & export jobs available for a manual run only. At the same time, the module provides the ability to launch every process asynchronously before or after the planned update. Thus, it is not a problem if you need to import data right now, but the process is launched at the end of the next week.

The extended flexibility regarding schedules is illustrated below:

Mapping

Another important aspect of making your store view-based data imports automated is related to mapping. Since different systems have different attributes, you cannot take the external output and move it to Magento 2. It is necessary to edit each data file manually, matching external attributes to the ones used by Magento 2.

Luckily, the Improved Import & Export Magento 2 extension essentially simplifies this process by introducing a user-friendly mapping interface. The module not only eliminates manual data editing, but it also reduces constant attributes matching to a one-time procedure.

You need to create a mapping scheme once. Next, the Improved Import & Export Magento 2 extension saves it and applies for all further updates. The process is straightforward:

Moreover, we’ve decided to simplify it even more with the premade mapping presets. Our specialists have already designed presets that can be applied within a few clicks. The following gif image illustrates the process:

Please, contact our support for further information about mapping presets for your particular integrations.

Advanced Connectivity

Now, that you know that the Improved Import & Export extension provides the ability to automate all import and export processes synchronizing your e-commerce store with external systems, we should say something about the extended connectivity opportunities provided by the module.

Our tool supports multiple file standards. Since Magento is focused on CSV, you may face various problems when the output is provided in another format. However, the Improved Import & Export Magento 2 extension eliminates most issues caused by the default limit of the platform. It offers support for XML and JSON so that you can freely import and export data in CSV, XML, and JSON.

Another critical moment is the ability to use various file sources. Due to the extended FTP/SFTP support, you can freely transfer data using either a local or remote server. Alternatively, the Improved Import & Export Magento 2 extension allows you to leverage a Dropbox account for the same purposes. The third opportunity is introduced with direct URL uploads. It works for import processes only. It is also worth mentioning that all compressed data is unzipped automatically during the import.

If file transfers are not enough to satisfy your e-commerce needs, the Improved Import & Export Magento 2 extension offers the ability to import data from Google Sheets. The process looks as follows:

Alternatively, you can rely on the REST API import/export functionality of the module. Thus, the extension provides an opportunity to connect your store to an external system directly without any intermediaries. Watch the following video to explore more features of the Improved Import & Export Magento 2 extension.

Magento 2 Product per Store View Import FAQ

If you still have questions regarding importing products to Magento 2, pay attention to the following Q&A sections. Below, we shed light on different aspects of transferring product data per store view.

Conclusion

Importing Magento 2 products by store view is not a big deal. You can do that with the default imported or switch to the improved way. It’s up to you to decide which approach suits you best.

Now, that you know the improved way of importing individual product data for each store view in Magento 2 as well as understand other benefits introduced with the Improved Import & Export extension, don’t hesitate to ask questions. To do so, follow the link below and contact our support:

Get Improved Import & Export Magento 2 Extension