Product Import Field Reference
Use this page as a lookup table when you need the exact field name, system field name, description, or example value for a product import.
For product workflows and entity-specific behavior, start in the Products section.
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 |
