---
title: Product Import Field Reference
description: Complete reference table of all fields available for product import in Shopware 6, including system field names, descriptions, and example values.
---

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](/entities/products/).

For an extended reference with more examples, see the [Shopware 6 Master Table](https://docs.google.com/spreadsheets/d/1h3cDhYkSL9tisi0c0X3Okn5jQkMDQkRbPqzWp-c3Pyg/edit#gid=0).

| **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}}` | Colour:Green\|Size:L |
| 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 |