Product Import Field Reference
In this section, you’ll find a comprehensive reference table that details the key fields involved in importing product data into Shopware 6. Each row in the table provides essential information, including the field name as it appears in the Shopware interface, the corresponding system field name, a brief description of the field’s purpose, and an example value to guide your data formatting.
For an extended reference with more examples, see the Shopware 6 Master Table.
| Field Name | System Field Name | Description | Value Example |
|---|---|---|---|
| General information | |||
| Name | name | Title of the product. Can contain any characters and spaces. | Bluetooth Speaker |
| Manufacturer | 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 is specified, it will be associated or created using the ‘manufacturer_name’ attribute value | 018ee103cded7015994e5f9aac551847 |
| Manufacturer | manufacturer_name | Manufacturer of the product. Can contain any characters and spaces. | EchoWave |
| Product UUID | id | Unique ID of the product inside the Shopware 6 database. Cannot be found inside the administrator area. 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. | 018e3856658271228f10807956b7e3f9 |
| Parent product UUID | 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 | 018e38561e2d72ea81f49d3fc8a2b141 |
| Product number | product_number | Unique product code - SKU. This property is required for creating a product. Can contain any characters and spaces | FB10001 |
| Parent product number | parent_sku | Product number of the parent product. This property is only used for product variations to identify the parent product it belongs to. Can contain any characters and spaces. | FB10002 |
| Variant properties | options | Options of product variants. Value: `{{Property1}}:{{Value}} | {{Property2}}:{{Value}}` |
| Stock | stock | Product Stock quantity. Any numeric value without decimals. | 17 |
| Active | active | Active property defines if the product is enabled. 1 - product is active; 0 or EMPTY - product is inactive. | 0 |
| Clearance sale | is_closeout | Clearance sale - defines if the product is on sale. 1 - product is on sale (enabled); 0 or EMPTY - product is NOT on sale (disabled). | 1 |
| Restock time in days | restockTime | Restock time in days. Must be a whole number without decimals. | 4 |
| Free shipping | shipping_free | Defines if free shipping is enabled. 1 - enabled; 0 or EMPTY - disabled. | 0 |
| Min. order quantity | minPurchase | The minimum amount of the given product per a single order. Must be a whole number without decimals. | 3 |
| Purchase steps | purchaseSteps | Scales in which the item is to be offered. Must be a whole number without decimals. | 2 |
| Max. order quantity | maxPurchase | The maximum amount of the given product per a single order. Must be a whole number without decimals. | 3 |
| Description | description | Description of the product. Can contain any characters and spaces | Compact and powerful audio device that delivers crystal-clear sound and deep bass. |
| Price (net) | price_net | The price of the product excluding tax. Must be a numeric value using a period (.) or (,) for decimals | 14.85 |
| Price (gross) | price_gross | The price of the product including tax. Must be a numeric value using a period (.) or (,) for decimals | 16 |
| List price (net) | list_prices_net | MSRP, RRP, or SRP of a product excluding tax. Must be a numeric value using a period (.) or (,) for decimals. | 11,45 |
| List price (gross) | list_prices_gross | MSRP, RRP, or SRP of a product including tax. Must be a numeric value using a period (.) or (,) for decimals | 12 |
| Purchase price (net) | purchase_prices_net | The monetary cost a business pays to acquire a good or service excluding tax. Must be a numeric value using a period (.) or (,) for decimals. | 11.45 |
| Purchase price (gross) | purchase_prices_gross | The monetary cost a business pays to acquire a good or service including tax. Must be a numeric value using a period (.) or (,) for decimals. | 12 |
| Cheapest price (last 30 days, net) | cheapest_price_net | Cheapest price (last 30 days, net) — the lowest price at which a product was sold within the last 30 days, excluding taxes. Must be a numeric value using a period (.) or (,) for decimals | 11.45 |
| Cheapest price (last 30 days, gross) | cheapest_price_gross | Cheapest price (last 30 days, gross) — the lowest price at which a product was sold within the last 30 days, including taxes. Must be a numeric value using a period (.) or (,) for decimals | 12 |
| Tax rate | 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 | 018ad59442067a2fa941a2c69908442e |
| Tax rate | tax_name | The name of the Tax Rate. Can contain any characters and spaces. | Reduced rate |
| Media Cover | cover_media_url | Cover Image of the product. A single URL of an image. | https://example.com/logo.png |
| Search keywords | keywords | SEO keywords. Multiple keywords separated by a comma (,). | Portable,Bluetooth,Speaker |
| Meta title | meta_title | SEO meta title. Can contain any characters and spaces. | Bluetooth Speaker |
| Meta description | meta_description | SEO meta description. Can contain any characters and spaces. | Compact and powerful audio device. |
| Media | media | Product Image(s). Multiple image URLs separated with a pipe symbol (|). | https://example.com/img1.png\|https://example.com/img2.png |
| Categories | categories_all_paths | Categories the product belongs to. Multiple category paths separated with a pipe symbol (|). Must include full paths to the end category starting with parents. If the categories you import don’t already exist in the store, they will be automatically created. | Catalog #1/Electronics/Audio & Sound Systems/Bluetooth Speakers |
| Categories | categoryIds | Category UUIDs separated with pipe |. This field can be used instead of categories_all_paths | 98432def39fc4624b33213a56b8c944d|1d51345c01af4236aba1b71ffa95453f |
| Sales Channels | 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. | 98432def39fc4624b33213a56b8c944d|1d51345c01af4236aba1b71ffa95453f |
| Sales Channels | sales_channel_names | Name of the Sales Channel the product belongs to. Multiple values separated with a pipe symbol (|). | Headless|Storefront |
| Width | width | Width of the product. Must be a numeric value using a period (.) for decimals. | 12 |
| Height | height | Height of the product. Must be a numeric value using a period (.) for decimals. | 13 |
| Length | length | Length of the product. Must be a numeric value using a period (.) for decimals. | 14 |
| Weight | weight | Weight of the product. Must be a numeric value using a period (.) for decimals. | 2 |
| Sales unit | purchaseUnit | Number of individual items that a company sells. Required to calculate the product’s unit price. Must be a numeric value. | 500 |
| Basic unit | basicUnit | Reference specification. Required to calculate the product’s unit price. Must be a numeric value. | 1 |
| Packaging unit | packUnit | Indicates how the product is delivered, e.g. in a carton or bottle. | bottle |
| Packaging unit plural | packUnitPlural | Plural form of the packaging unit. | bottles |
| Scale unit | unit_name | Unit of measurement used to define the relationship between a product’s selling unit and its base unit. | centimeter |
| Scale Unit Shorthand | unit_shortCode | Shorthand of the scale unit. | cm |
| GTIN/EAN | ean | Unique identifier used for products globally. Can contain any characters and spaces. | 6291047583921 |
| Release date | releaseDate | When a product can be purchased in the shop. | 2023-10-20T12:00:00.000+00:00 |
| Delivery time Name | delivery_time_name | Label assigned to a specific delivery time option. Can contain any characters and spaces. | 1-3 Tage |
| Delivery time Minimum | delivery_time_min | Delivery time minimum period. Numeric value without decimals. | 1 |
| Delivery time Maximum | delivery_time_max | Delivery time maximum period. Numeric value without decimals. | 3 |
| Delivery time Unit | delivery_time_unit | Unit of measurement for the delivery time, such as days, weeks, or months. | day |
| Delivery time UUID | delivery_time_id | Unique identifier assigned to a specific delivery time configuration. Should be composed of exactly 32 symbols with numerals 0-9 and letters a-f. | 018e1d6d1397727d81a53aac935b7fbe |
| Manufacturer product number | manufacturerNumber | Unique identifier or SKU assigned to a product by its manufacturer. Can contain any characters and spaces | SWB-2024-X1 |
| Tags | tags | Labels or keywords assigned to products. Separate multiple values with a pipe symbol (|). | WirelessAudio|PortableSpeaker|BluetoothSound |
| Layout | cms_page_id | Unique ID of the layout assigned to a product inside the Shopware 6 database. Should be composed of exactly 32 symbols with numerals 0-9 and letters a-f. | 7a6d253a67204037966f42b0119704d5 |
| Advanced pricing | advanced_prices | Advanced prices of the product. Contains complex values with ruleId, currencyId, priceNet, priceGross, quantityStart, quantityEnd attributes separated by commas. Multiple rules separated by pipe (|). | ruleId:4a3ec3a7eace4f5c8f7d734754ef7f24,currencyId:b7d2554b0ce847cd82f3ac9bd1c0dfca,priceNet:100.88,priceGross:120.88,quantityStart:1,quantityEnd:9 |
| Custom fields | cf_<technical_name> | All custom field names must begin with “cf_”. Following this prefix, include the technical name of the custom field. E.g. cf_custom_test_text_field | Test text |
| Properties | Geschlecht#68b8e43ccb1c454aa0647bbc4a0c6e0d | Product custom properties. Use column title format: [property_name]#[property_id]. Value format: [property_value]#[property_value_id] | Women#0e6ecc99f5e84d48b8550bb37690c1a2 |
| Translations | translations.de_DE.name | When importing translations to Shopware, the CSV file should include specific column headers. Use column title format: translations.[language code].[original column title] | Einfaches Firebear-Produkt #1 |
| Translations | translations.de_DE.description | Dies ist ein Testprodukt. | |
| Translations | translations.de_DE.metaTitle | meta_title-test-de | |
| Translations | translations.de_DE.metaDescription | meta_description-test-de | |
| Translations | translations.de_DE.packUnit | Packungseinheit | |
| Translations | translations.de_DE.keywords | eins,zwei,drei | |
| Translations (Custom fields) | translations.de_DE.cf_<technical_name> | To import translations for your custom fields, use format: translations.[language code].cf_[custom_field_technical_name] | test DE |
| Translations (Properties) | de-DE.Material#a67cdd9627cb488bb4cd91f3e8d66e32 | To add translations to your custom properties, use format: [language code].[property_name#property_id]. Value format: [property_value#property_value_id] | Damen#0e6ecc99f5e84d48b8550bb37690c1a2 |
| Variants storefront presentation | display_single_product_as_main_product | Corresponds to the “Display Single Product as Main Product” checkbox. 1 - enabled; 0 - disabled. | 0 |
display_single_product_as_variant | Represents the “Display Single Product as Variant” checkbox and the selected variant in the dropdown. The value consists of the variant ID. | 018e1d6d1397727d81a53aac935b7fbe | |
display_as_expand_product | Corresponds to the “Expand Property Values in Product Listings” checkbox. Multiple values separated with a pipe symbol (|). | Colour#269c7e40a54a462e884edb004c5f7bc8 |
