How to Import Magento 2 Advanced Pricing
Although setting up tier prices in Magento 2 is an exhausting task, you can dramatically simplify the related chores. But why is it so time-consuming? Setting up advanced pricing in Magento 2 requires going through the products one by one, submitting values in a dedicated window, and then saving. The more products you have, the more actions you need to apply. However, the Magento 2 import procedure lets you save hours of manual management time. In this article, we describe how to import advanced pricing to Magento 2. Below, you will find a sample advanced pricing import table described. Next, we provide advanced pricing attributes used in Magento 2. With this information in mind, you can proceed to importing Magento 2 tier prices.
Unfortunately, the default Magento 2 import tools only let you import products and advanced prices separately. It means that you need to upload one file with product data except for tier prices which are provided via another spreadsheet. You must admit that it is not very convenient, especially when you move the entire catalog.
To address this issue, we describe another procedure, involving the Improved Import and Export extension. With this tool, you can import both products and tier prices in a single file. Importing Magento 2 products with tier prices in a single file is based on the following steps. Firstly, prepare an import table, following our recommendations. After that, create a new import job as described in this blog post.