Improved Import & Export major update - full Google Sheets & Drive integration. Fixed price Magento 1 > Magento 2 migration service! EXPLORE

"import"

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

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

FireBear Improved Import & Export for Magento 2 – Extension Change Log

- Magento 2, Our extensions
improved import and export - Magento 2 extension

The following blog post will help you retrace the evolution of the Improved Import & Export Magento 2 module. The article gathers updates associated with the extension’s each new version from the very beginning. At the time of 1.0.0, it was a basic import solution with an existing import jobs architecture and import cron automation. With the next few versions, the module got such enhancements as product attribute import on the fly, transfers from FTP, SFTP, URL, and Dropbox, custom mapping, etc. Each new release made the Improved Import stronger and stronger. However, it was still an import-only tool until 1.5.0 was released. With this version, our extension became capable of both import and export processes. You can peruse the detailed evolution of the module and see its latest features below. 

Extension Manual | FAQ | Demo | Sample Files

3.7.1 (released 15.10.2021)

Bugfixes

  • Fixed issue when creating configurable product during import resulted in adding system attribute values from child products even if these attributes have not been specified.

Improved Import Export Magento 2 Roadmap – vote for the most exciting features and we will implement them first. Leave your suggestions in the comments and we will add them to the poll.

Continue Reading

Improved Import & Export for Shopware 6 User Manual

- E-Commerce, Shopware

Improved Import & Export for Shopware 6
User Manual

Improved Import & Export is the Shopware 6 extension that is installed on your store manually, and allows you to import and export products and other entities in and out of your store fast and with the required values.

 

 

Latest release is 1.0.0

  • Import and export of products with custom properties and categories
  • Support of CSV files
  • Mapping of custom properties

Continue Reading

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

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 automate Magento 2 product catalog update from Google Sheets, FTP/SFTP, Google Drive, OneDrive, Dropbox

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

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

Import/Export cookbook: How to update Magento 2 product price and quantity using import and export. HINT: it’s fast and easy

Improved Import & Export Magento 2 extension documentation is huge! I know. It is aimed to cover every aspect of the extension.

However, you do not need to read it all, or understand each and every attribute of every entity. In this article, I will show you how to mass update Magento 2 product prices and quantity (stock) using import and export procedures.

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 update product price during Magento 2 import

- E-Commerce, Magento 2

Magento 2 lets you specify a new product price upon import, but what if you want to update category prices by $10? Or what if your supplier raised all prices by 10%? With the default data transfer tools, you have to apply such adjustments manually to every product in your catalog. The more products you have, the more time you will spend. Therefore, nobody wants to calculate and apply each new price manually. In this article, we will tell you how to automate the process. You will need the Improved Import and Export extension. The module dramatically extends the default data transfer capabilities of Magento 2 and introduces the ability to update product prices during Magento 2 import via Price Rules – a set of conditions that adjust the price of the imported products. 

Continue Reading