In case you run a multilingual store, this article will be helpful. Being based on the
Table of contents
Store View-Based Product Data Import for Magento 1
ruuter writes that
Store View-Based Product Data Import for Magento 2
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::
Please make sure attribute "sku" is not empty
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 ones in 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, the correct Magento 2 approach 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 required attributes. How can you improve this approach even more? Find the answer below.
To improve the procedure mentioned above, you need the Improved Import & Export Magento 2 extension. Not many tools provide at least a half of features available with the module. Being one of the most robust import/export solutions in the ecosystem, it already implements a bunch of significant improvement; however, more critical updates are planned for the nearest 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!
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.
First of all, the Improved Import & Export Magento 2 extensions 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 the 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?
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 for the end of the next week.
The extended flexibility regarding schedules is illustrated below:
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 once 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 regarding mapping presets for your particular integrations.
Now, when 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 focussed 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 the 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. And the third opportunity is introduced with the 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.
Now, 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 any question. To do so, follow the link below and contact our support:
For more useful articles, check our Cookbook.'