Web Design Company in Mumbai, India and North Carolina, USA
How to Import Products into Shopware 6.

How to Import Products into Shopware 6.

March 28, 2023
Written By Sumeet Shroff

Shopware Design and Devlopment

A. A Beginner's Guide to Importing Products in Shopware 6

Hey there! If you're looking to increase the productivity of your online business by learning how to import products into Shopware 6, you've come to the right place. Shopware 6 is a powerful e-commerce platform, and importing things may save you a lot of time. In this lesson, I'll show you how to accomplish it.

1. Prepare Your Data

Before entering Shopware 6, you should have all of your product information available. To do this, a CSV or Excel file with the essential data must be created. Include in your data SKUs from your Shopware shop, product names, descriptions, price, and any unique attributes you've established.

Step 2: Format Your Data

Ascertain that your data is in the proper format for import. Whenever feasible, use a comma-separated values (CSV) file. Check that each column in your spreadsheet reflects a separate aspect of your Shopware items.

The Default Profile for products contain the following fields


id - Unique ID. Not more than 24 characters. parent_id - Used in case there is a Variant product_number - SKU. Has to be Unique active - Number - 1 if active and 0 if inactive stock - Number. Can be anything name - Name of the product description - Description can be HTML price_net price_gross purchase_prices_net purchase_prices_gross tax_id tax_rate tax_name cover_media_id cover_media_url cover_media_title cover_media_alt manufacturer_id manufacturer_name categories sales_channel propertyIds optionIds


Please note that if you want to upload Multiple images for the same product, then you need to add a new field to the Profile.


media - Value can be URLs seperate by | [divider] like this - https://website.com/wp-content/uploads/2020/10/MZ529C-2-Yellow-Back.jpg|https://website.com/wp-content/uploads/2020/10/MZ529C-2-Orange.jpg


Create a new Profile from the default Profile and add the field.

Split the CSV into 300 products each file as it takes time to download and import the products.

Step 3: Access Shopware's Admin Panel

To log in, launch the Shopware 6 backend and input your credentials. Before continuing, make sure your Shopware store is up and operating.

Step 4: Navigate to the Import/Export Section

In the Shopware control panel, go to "Configuration" and then "Import/Export." There are several additional import/export options accessible here.

Step 5: Choose Import Profile

To import your product information, select the appropriate "Default Import Profile" from the drop-down option. Shopware comes with a number of different import profiles that you may utilise. If you want to import items, choose the "Products" profile.

Step 6: Upload Your Data File

Select "Import" from the menu to import your prepared data file. Check that you're using the correct file type (usually CSV). Shopware will validate the file and notify you of any issues or warnings.

The Errors can by found by Downloading the file "Download Invalid Records" and in the last column, you will get the Error message - e.g.


Product with number "323" already exists.

Step 7: Map Your Data Fields

When you set up your Shopware shop, you'll be invited to match your data fields to the applicable product properties. This is a required step for importing data into the right fields. Simply follow the on-screen instructions to map the fields in your CSV to their counterparts in Shopware.

Mapping is an option that you can use but you must avoid having different fields name other than the default one that Shopware uses. Keep the same fields name as Shopware


id parent_id product_number active stock name description price_net price_gross purchase_prices_net purchase_prices_gross tax_id tax_rate tax_name cover_media_id cover_media_url cover_media_title cover_media_alt manufacturer_id manufacturer_name categories sales_channel propertyIds optionIds

Categories are not Category names or titles but there are Category IDs. Hence you should add the Categories to Shopware first and then add the Category ID to the data.

Similarly with Tax ID

Step 8: Handle Duplicates

Configure Shopware's duplicate management to your liking. During the import process, you may choose to update existing items or skip them entirely. The answer to this question is based on whether you are offering new products.

Step 9: Start the Import

Check that everything is in order, then click the "Start Import" button. Shopify will begin receiving your products. If your data file is very huge, this may take some time.

Step 10: Review and Verify

Once the import is complete, review the import summary to ensure that everything happened as expected. Error warnings must be closely monitored and addressed as quickly as feasible. If there are issues, you may need to repair your data file and re-import it.

Conclusion

Congratulations! Your product import to Shopware 6 proceeded without a hitch. Importing products is a time- and labor-saving feature for running an online business. Maintain your store's relevance and competitiveness by importing new items on a regular basis and updating the information on your old ones. Sell successfully!

Sumeet Shroff

Sumeet Shroff

Loading...