To import products to your Shopware 6 store you need a properly formatted CSV file with the product data, such as product names, manufacturer code, and description. And a tool you would use to import this file to your store.
In this article I will explain the general basics of importing data to the Shopware 6 store, and will tell you about Improved Import, Export & Mass Actions application you can use to import and export products from your store, manage the data, use it as a PIM software and many more.
The first thing you need to know before importing products to Shopware 6 is that your store requires product data imported in a certain way - the way the data is stored inside the Shopware database.
It means that some of the fields that you populate when creating a product, require a particular data format. For example the price in shopware requires you to use a full stop for decimals - 49.99, you cannot use a comma to specify the price of the product.
Below in the table, we have described every single product property that is available for import with the information on what values are supported by Shopware 6.
When editing the CSV file with the product data, we strongly advise to use Google Sheets or Numbers (if you are using MacOS) instead of Microsoft Excel. The reason being, Excel overplays assisting and may change the format of the cells to ‘Date’, convert your numerals into month names, and generally tends to mess with your file.
NOTE: To edit a CSV file inside Google Sheets, you need to make sure the delimiter you use is a comma ‘,’. If you are using a semicolon, Google Sheets will have trouble parsing your data properly in the cells.
Reading a CSV table with the exported products or products you want to import may be troublesome if you do not know which values are required by Shopware 6. That’s why we have composed this Master Table and described every Shopware 6 product property and which values the Shopware expects you to send.
If you are new to import procedures, we recommend importing this table first to see how the products are created during import and how you can adjust the product attributes directly in a CSV.
The Master Table for Shopware 6 represents different entity properties (attributes), same values, and a set of instructions on which values are accepted.
To start understanding the product properties we recommend that you read the explanations comparing it to the Shopware 6 Master Table.
You may also want to import the Master Table to your store using Improved Import, Export & Mass Actions application to see how the products behave. All products in the table are disabled and won’t affect your store performance.
| Property name | Reference | Accepted value | Value example |
|---|---|---|---|
| id | Unique ID of the product inside the Shopware 6 database. | ||
| Cannot be found inside the administrator area. | |||
| Is used to identify the product along with the product_number, however not required. | Should be composed of exactly 32 symbols with numerals 0-9 and letters a-f | e0da4df2189a44cb89871e6c297644a2 | |
| parent_id | ID of the parent product. | ||
| This property is only used for product variations to identify the parent product it belongs to. | Should be composed of exactly 32 symbols with numerals 0-9 and letters a-f | e0da4df2189a44cb89871e6c297644a2 | |
| product_number | Product Number, a unique product code - read SKU. |
Required property for creating a product | Can contain any characters and spaces | FB123 | | active | Active property - defines if the product is enabled | 1 - product is active 0 or EMPTY - product is inactive | 1 | | stock | Product Stock quantity available | Any numeric value without decimals | 123 | | name | Title of the product | Can contain any characters and spaces | My 1st product | | description | Description of the product | Can contain any characters and spaces | This is my test product sold at Shopware 6 store | | price_net | The Price of the product | Any numeric value with . used for decimals, cannot use comma for decimals | 19.99 | | price_gross | The Price of the product including tax | Any numeric value with . used for decimals, cannot use comma for decimals | 20.99 | | list_prices_net | The List Price of the product | Any numeric value with . used for decimals, cannot use comma for decimals | 9.99 | | list_prices_gross | The List Price of the product including tax | Any numeric value with . used for decimals, cannot use comma for decimals | 10.99 | | purchase_prices_net | Purchase Price of the product | Any numeric value with . used for decimals, cannot use comma for decimals | 6.99 | | purchase_prices_gross | Purchase Price of the product including tax | Any numeric value with . used for decimals, cannot use comma for decimals | 7.99 | | tax_id | ID of the Tax Rate found in your store database | Should be composed of exactly 32 symbols with numerals 0-9 and letters a-f
If no Tax ID specified, it will be associated or created using the 'tax_name' and 'tax_rate' attributes values | e0da4df2189a44cb89871e6c297644a2 | | tax_rate | Tax Rate percent | Any numeric value with . used for decimals, cannot use comma for decimals | 18 | | tax_name | The name of the Tax Rate | Can contain any characters and spaces | New tax | | cover_media_url | Cover Image of the product | A single URL of an image | https://firebearstudio.com/skin/frontend/firebear/default/images/logo.png | | media | Image(s) of the product | Multiple URLs of the images separated by the pipe symbol | | https://firebearstudio.atlassian.net/wiki/spaces/FSPD/pages/1506640052/Sample+CSV+file# | | manufacturer_id | ID of the Manufacturer found in your store database | Should be composed of exactly 32 symbols with numerals 0-9 and letters a-f
If no Manufacturer ID specified, it will be associated or created using the 'manufacturer_name' attribute value | e0da4df2189a44cb89871e6c297644a2 | | manufacturer_name | Manufacturer of the product | Can contain any characters and spaces | Firebear Studio | | categories_all_paths | Categories the product belongs to | Can contain any characters and spaces.
Multiple category paths separated by pipe symbol |
Must include full paths to the end category starting with parents.
If categories you import do not exist at the store - they will be created | Firebear Studio Category #1/Firebear Studio Subcategory #1|Firebear Studio Category #1 | | sales_channel | ID of the Sales Channel found in your store database | Should be composed of exactly 32 symbols with numerals 0-9 and letters a-f | e0da4df2189a44cb89871e6c297644a2 | | sales_channel_names | Name of the Sales Channel the product belongs to | Can contain any characters and spaces | First sales channel | | width | Width of the product | Any numeric value with . used for decimals, cannot use comma for decimals | 123.5 | | height | Height of the product | Any numeric value with . used for decimals, cannot use comma for decimals | 123.5 | | length | Length of the product | Any numeric value with . used for decimals, cannot use comma for decimals | 123.5 | | weight | Weight of the product | Any numeric value with . used for decimals, cannot use comma for decimals | 123.5 | | ean | EAN of the product | Can contain any characters and spaces | EAN123987 | | releaseDate | Release Date of the product | Requires date format YYYY-MM-DD. Can also include timestamp YYYY-MM-DDThh:mm:ss. And time zone YYYY-MM-DDThh:mm:ss+hh:mm | 2020-10-15T23:00+1:00 | | manufacturerNumber | Manufacturer Number of the product | Can contain any characters and spaces | FBS123 | | optionIds | IDs of the custom product properties that are found inside your store database | Should be composed of exactly 32 symbols with numerals 0-9 and letters a-f | e0da4df2189a44cb89871e6c297644a2 | | options | Variation options, such as size or color. Only available for variation products | Composed of the name of the property and its value separated by :
Multiple options separated by pipe symbol |
For example: Colour:Red|Size:L | Size:S | | shipping_free | Free Shipping of the product | 1 - Free Shipping enabled 0 or EMPTY - Free Shipping disabled | 1 | | is_closeout | Clearance Sale setting of the product | 1 - Clearance Sale enabled 0 or EMPTY - Clearance Sale disabled | 1 |
When creating and editing products in Shopware 6 you can manually created additional product properties, such as ‘size’ and ‘color’, which are required for your products. Such properties can also be imported and exported using Improved Import, Export & Mass Actions application by Firebear Studio.
