"import"

Magento 2 import and export COOKBOOK index post. Use cases and instructions

- E-Commerce, Import / Export Cookbook, Magento 2, Our extensions

This is an index blog post for Magento 2 import and export use cases. In this post you will find links with the description to the posts which describe how to use Improved Import & Export extension for Magento 2.

Each use case article comes with the step by step instructions and screenshots illustrating the extension setup process. Each article covers a particular use case/question, for example: how to map product attributes, how to update stock and price of the Magento 2 product.

  • Read and bookmark articles
  • Try out the instructions at our Magento 2 demo store
  • Check out Master Table which contains samples of every Magento 2 entity export and import file.

Continue Reading

Import/Export cookbook: How to import products to Magento 2 with VAT price included and deduct the VAT automatically to display regular price

- E-Commerce, Import / Export Cookbook, Magento 2, Our extensions, Uncategorized

When you import products to your Magento 2 store, often the ‘Price’ column from the file already includes VAT. However, if you want to sell products for their real price, how do you import such products?

Do you edit the imported table manually before the import? Ask your supplier to send you prices without VAT?

However, you sometimes cannot get prices without VAT. Your supplier sends you the file from their warehouse, and cannot control how the prices are printed. Or the ERP system sends a json file, which is hard to edit.

You can do it, specify VAT and have it deducted automatically with the Improved Import & Export extension for Magento 2. Below, I will tell you how to do it, in a few steps.

Continue Reading

Import/Export cookbook: How to automate Magento 2 product catalog update from Google Sheets, FTP/SFTP, Google Drive, OneDrive, Dropbox

- E-Commerce, Import / Export Cookbook, Magento 2, Our extensions

Working with suppliers requires you to regularly update your Magento 2 product catalog with new prices, stock updates, and sometimes other relevant attributes. Store managers can spend a lot of time manually going product by product, spending their time and going attribute by attribute.

With Improved Import & Export extension for Magento 2 you can automate product catalog update tasks with cron scheduler and recurring import jobs, that automatically fetch the file with supplier updates from the source, and upload it to your store.

In the article below, I will give you step by step instructions on how to do it.

Continue Reading

Import/Export cookbook: How to update Magento 2 product prices during import quickly, without editing the CSV table

- Cryptocurrency, E-Commerce, Import / Export Cookbook, Magento 2

If you are a dropshipper or want to follow the inflation and increase product prices for your whole Magento 2 catalog or a part of it, you can do it quickly with the Improved Import & Export extension.

Export product catalog and import it back with the Price Rules – a quick filter that allows increasing and decreasing prices by a percent or a flat value.

Continue Reading

How to fix store ID-related issues on Magento 2 import

- E-Commerce, Magento 2

Magento 2 export CLI

StackExchange teems with interesting and useful tips related to Magento 2. This time, we’ve dug up a discussion where the author named Jackson complains about store ID-related issues that occur in Magento 2. Let’s take a look at the problem and provide several possible solutions. Jackson points to a particular script used to import data from a CSV file. However, the use of ->setStoreId(0) causes an issue – two values for the same field in the database table occur. As a result, it is necessary to delete second values to enable changes on the frontend but it often leads to the incorrect display. How to address the problem? You will find out how to fix store ID-related issues on Magento 2 import as it is portrayed in the discussion. At the same time, we provide a reliable alternative based on the Improved Import & Export. Also, you will discover other improvements associated with the module.
Continue Reading

How to Automate Magento 2 Import & Export

- E-Commerce, Magento 2

improved import and export - Magento 2 extension

We have very good news for you: it’s no longer necessary to import/export files to/from Magento 2 manually. And below we explain how to automate Magento 2 import and export processes. Check this post and you will find out how to save tons of time and effort making your daily routine fully automated.

Of course, you need a third-party extension to achieve your goal. And we recommend you to use the Improved Import & Export Magento 2 extension, since the Magento 2 Open Source platform doesn’t add any automation to import/export processes. As a result, you have to perform each run manually, but before diving deep into the nature of our solution, let’s tell a few words about the automation itself. Continue Reading

The Best Improved Import/Export Extensions for Magento 2

- E-Commerce, Magento 2

Import Export Magento 2 Modules

Improved import & export Magento 2 extensions are designed to simplify some routine Magento tasks. They revamp the default abilities of the platform by adding convenient import/export options. Although, Magento 2 provides a lot of ecommerce possibilities in this area out-of-the-box, they are still not enough for seamless migration to/from other systems as well as for performing some daily tasks. Furthermore, in case you want to import products from Magento 1 to Magento 2, one of the following tools will essentially simplify this procedure. Besides, check our digest of the Magento 1 export tools here: The Best Improved Import/Export Extensions for Magento. They will be necessary for moving data out of your old store. And don’t forget about the Complete Guide to Magento 2 Product Import / Export. In that post, we describe core nuances of the default import/export process as well as provide Magento 2 import csv examples and description. But what bout popular Magento 2 import extensions and Magento 2 export modules?

Continue Reading

How to improve Magento 2 import and export speed?

- Magento 2

improved import and export - Magento 2 extension

Have you ever wondered why Magento 2 import and export processes are so slow? If you move data to and from your store on a regular basis, low import/export speed may become really annoying. But what is the reason for this problem and how to solve it? You will find the answer below.

Also, the article provides an alternative solution for the Magento 2 import and export performance issue. The default data transfer solution is associated not only with relatively low speed stats but also with a plethora of other hurdles that don’t let your admins manage data most efficiently. However, there is a universal solution that addresses all the issues associated with Magento’s built-in tools – the Improved Import & Export extension. You will also find its core features described below. 
Continue Reading

How to fix the “URL key for specified store already exists” issue on Magento 2 import

- E-Commerce, Magento 2

Magento 2 export CLI

Let’s suppose that you need to import a product CSV file, that follows the Magento 2 requirements, to a new installation. What could go wrong? Unfortunately, several errors may occur when you do that, including “URL key for specified store already exists”. In the following article, we explore the issue on the example provided in a StackExchange discussion, where Zed Blackbeard argues that it is impossible to import products to Magento 2 due to the general system exception. Magento informs its administrator who runs the update that the URL key for the specified store already exists. After that, the system breaks the import. 

Below, you will discover the conditions that cause the problem. After that, the article provides several possible resolutions. To be more specific, we provide recommendations from the appropriate StackExchange discussion as well as deliver our approach that incorporates the Improved Import & Export extension. If you face other issues while using your Magento installation, you may try to find them described in this blog post: Magento 2 Cookbook.
Continue Reading