How to Import Products to Shopware 6 With Different Stock Increment Strategies

- Our extensions, Shopware

Let’s suppose, you need to update the existing product catalog. But how to choose a specific update behavior? While Shopware 6 doesn’t provide much flexibility, the Improved Import, Export, and Mass Actions app lets you choose how to apply the provided product quantity. Do you want to replace the existing stock data with the new value or merge the two values? In the following article, we shed light on how to implement different stock increment strategies for Shopware 6 product import. You will learn how to import products to Shopware 6 and replace the existing stock information. At the same time, we will teach you how to run Shopware product import so that the existing stock data is increased by the provided quantity. Also, don’t forget to check our Shopware Cookbook for additional helpful suggestions.

Shopware 6 Product Import: Stock Increment Strategy

When you use the Improved Import, Export, and Mass Actions app for import and export processes, it offers lots of additional features that extend the default data transfer functionality of Shopware 6. The Stock increment strategy toggle is among such enhancements. You can find it in the Advanced settings section of each import profile: 

  • If disabled, you replace the existing product stock with the imported quantity specified in the import file. For instance, the store qty is 100 and the update qty is set to 50 in the import table. After the import, the store qty will be 50.
  • If enabled, you increase the existing product stock by the amount specified in the import file. If the actual product qty is 100 and the import table is set to 50, then the new store qty will be 150 after the import. 

Also, pay heed to the fact that activating the Stock increment strategy toggle unveils another switch – Reload product before update.

  • If disabled, the product qty is updated immediately without reloading the product data according to the selected stock increment strategy).
  • If enabled, the product data is reloaded first and then the qty is imported according to the selected stock increment strategy.

This feature is useful in a situation when a product is ordered from the storefront while you import the update. So, you need to enable it to update the qty after the order is placed to apply the imported stock update correctly. 

If you enable the Reload product before update feature, the product is reloaded first to get its actual quantity, and then the qty specified in the import file is added.

How to Import Products to Shopware 6 With Different Stock Increment Strategies

Now, let’s see how to import products to Shopware 6 using different stock increment strategies. 

Click the New Profile button under Extensions -> Improved Import, Export & Mass Actions -> Product Import to create a new import profile. 

shopware 6 xml import

You are redirected to the first screen of your new import profile called Select file. Follow these steps to configure a Shopeare 6 import procedure and choose a stock increment strategy that follows your demands: 

how to import xlsx to shopware 6

  1. Specify your profile’s name; 
  2. Select an entity you want to import – Products;
  3. Create a schedule of updates if necessary;
  4. Configure email notifications if wish to get updates on import results:
  5. Select your file format (XLSX, XML, or CSV);
  6. Choose your import source (e.g., file, URL, FTP, Google Drive, or Google Sheets);
  7. Configure advanced settings: URL rewrite behavior, media replacement behavior, and stock increment strategy:
    1. Enable or disable the Stock increment strategy toggle according to your preferences.
    2. Use the Reload product before update feature if you think it is suitable for your case.

The basic import settings are configured and the stock increment strategy is selected. It means that you can configure your mappings. The corresponding screen lets you specify which columns from the imported file match the properties of the products from your Shopware 6 website. 

With the Improved Import, Export, and Mass Actions app, you also get the ability to preview how products look after import. 

Next, click the Import button at the bottom of the Preview result page to start the import process.

You can read more about the enhanced Shopware 6 import in our Improved Import, Export & Mass Actions Manual. 

Other Features

The Improved Import, Export, & Mass Actions application allows you to handle the most common issues with Shopware 6 data transfers. For example, you can export all necessary product information from Shopware 6 into a single file (the default tools don’t let you do that). As a result, you can easily manage your catalog in a spreadsheet editor and re-import it back. Other significant advantages of our app include:

  • Product import and export with full support for custom attributes (properties);
  • Customer import and export with full support for addresses;
  • Orders export;
  • Full support for product variants with a full set of attributes;
  • Product properties mapping with mapping presets;
  • Import and export schedules;
  • Import and export of CSV, XLSX, and XLSX files;
  • Direct file uploads;
  • FTP/FTPS uploads.

You can find more information about the Improved Import, Export & Mass Actions app here:  

 

Post Tags: