Listing
This page describes the data sources and filters that are available when exporting listings with the catalogue tool. This page serves purely as a reference and it assumes that you already have a basic understanding of the catalogue tool.
Export type: Listing
The export type described on this page is found in the menu Data » Catalogues. When creating a new catalogue, first select the template type cdiscount or octopia from the upper drop-down list. Then you can select the export type Listing from the middle drop-down list.
1. Data sources
This chapter lists all of the listing data sources that can be exported with the catalogue tool.
1.1. Market Ident Number
1.1.1. Moin
The "My OTTO Identification Number" is an alphanumeric product identification that is provided by OTTO Market. Since August 11th, 2021, every product on OTTO Market must have a MOIN.
Note: The MOIN is assigned by OTTO Market. You do not create it yourself. If you sell a product on OTTO Market and it’s also available through other sellers, then all of the offers will have the same MOIN.
| Field | Explanation |
|---|---|
Value |
The value of the MOIN. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: MOIN » Column: Value |
Country ID |
The country of the MOIN. Is specified by the internal PlentyONE country ID. See the list of country IDs. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: MOIN » Column: Country |
Country name |
The country of the MOIN. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: MOIN » Column: Country |
Link-ID |
The ID of the link between the MOIN and the variation. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: MOIN » Column: ID |
Link position |
The position of the MOIN. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: MOIN » Column: Position |
1.1.2. ePID
The "eBay Product ID" is a product identification that is provided by eBay.
| Field | Explanation |
|---|---|
Value |
The value of the ePID. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: ePID » Column: Value |
Country ID |
The country of the ePID. Is specified by the internal PlentyONE country ID. See the list of country IDs. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: ePID » Column: Country |
Country name |
The country of the ePID. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: ePID » Column: Country |
Link-ID |
The ID of the link between the ePID and the variation. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: ePID » Column: ID |
Link position |
The position of the ePID. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: ePID » Column: Position |
1.1.3. ASIN
The "Amazon Standard Identification Number" is a 10-digit, alphanumeric product identification that is provided by Amazon. The ASIN and ISBN are identical for books. The ASIN can be found on Amazon’s product page.
| Field | Explanation |
|---|---|
Value |
The value of the ASIN. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: ASIN » Column: Value |
Country ID |
The country of the ASIN. Is specified by the internal PlentyONE country ID. See the list of country IDs. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: ASIN » Column: Country |
Country name |
The country of the ASIN. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: ASIN » Column: Country |
Link-ID |
The ID of the link between the ASIN and the variation. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: ASIN » Column: ID |
Link position |
The position of the ASIN. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Type: ASIN » Column: Position |
1.2. Barcode
| Field | Explanation |
|---|---|
Barcode code |
The code to the barcode. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Barcodes » Column: Code |
Barcode name |
The name of the barcode. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Barcodes » Column: Name |
Barcode ID |
The ID of the barcode. Corresponds to the option in the menu: Setup » Item » Barcode » Column: ID |
List of barcode types in the system |
Here you’ll see a list of the barcode types that you’ve already configured in the menu Setup » Item » Barcode. When you add a barcode type to the catalogue, the actual code that was saved for this barcode type in the variation data record will be exported. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Barcodes » Column: Code |
1.3. Default category
|
Category vs. Default category
Variations can be linked to multiple categories:
|
| Field | Explanation |
|---|---|
Category ID |
The ID of the category. |
Category name |
The name of the category. Corresponds to the option in the menu: Item » Category » [Open category] » Tab: Settings » Entry field: Name Note: You can re-use category names as long as they are used in different categories or on different levels. Within one category, however, the names may only be used once per level. SEO tip: Enter different meta titles and meta descriptions for categories of the same name. |
Category description |
The text and HTML formatting saved in the tab Description 1. Corresponds to the option in the menu: Item » Category » [Open category » Tab: Description 1] |
URL name |
The category’s URL name. Corresponds to the option in the menu: Item » Category » [Open category] » Tab: Settings » Entry field: URL name |
Meta title |
The category’s meta title. The meta title is displayed in the tab title of the browser and in search engine results. Corresponds to the option in the menu: Item » Category » [Open category] » Tab: Settings » Entry field: Meta title |
Meta description |
The category’s meta description. The meta description is analysed by search engines. As such, it is especially important for the homepage. The meta description should contain the most important content in one sentence. Corresponds to the option in the menu: Item » Category » [Open category] » Tab: Settings » Entry field: Meta description |
Meta keywords |
The category’s keywords. Corresponds to the option in the menu: Item » Category » [Open category] » Tab: Settings » Entry field: Meta keywords |
Path |
This data souce corresponds to the category’s breadcrumbs path. Enter a separator, i.e. decide which symbol or character should appear between the individual category levels. Example: If you use the separator |
Branch 1; |
You can save up to 6 category levels in the PlentyONE back end. These data sources correspond to the individual levels of the category’s breadcrumbs path. Example: Your system includes the category: Shoes » Women » Boots » Uggs.
|
1.4. Item
| Field | Explanation | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Age restriction |
The item’s age rating.
Corresponds to the option in the menu: Item » Items » [Open item] » Element: Settings » Drop-down list: Age restriction Note: Items with an 18+ age rating must be linked to a shipping profile for which the PostIdent option was activated. |
||||||||||||||||||||||
Amazon FBA platform |
Specifies the item’s Amazon marketplace, assuming that the item is sold via FBA.
Corresponds to the option in the menu: Item » Items » [Open item] » Element: Amazon » Drop-down list: FBA Fulfillment |
||||||||||||||||||||||
Amazon product type (deprecated) |
The Amazon product type that was selected for the item. Is specified by the product type ID. You can think of the product type as the Amazon category under which this item should appear. When you transmit your items to Amazon, you’ll transmit one product type at a time, i.e. one category at a time. Corresponds to the option in the menu: Item » Items » [Open item] » Element: Amazon » Drop-down list: Product type (deprecated) Note: You can download an overview of Amazon product types here. The table lists the product types and their corresponding IDs. |
||||||||||||||||||||||
The Amazon product type that was selected for the item. Is specified by the product type ID. The product type is the Amazon category under which this item should appear. These product types are used for the new connection to Amazon. Corresponds to the option in the menu: Item » Items » [Open item] » Section: Amazon » Drop-down list: Product Type Note: There are only active values in the drop down list. In the Setup » Markets » Amazon » Add catalogue templates menu you can activate and deactivate values. |
|||||||||||||||||||||||
Condition API ID |
The item’s API condition. Is specified by the condition ID.
Corresponds to the option in the menu: Item » Items » [Open item] » Element: Settings » Drop-down list: Condition for API |
||||||||||||||||||||||
Condition API name |
The item’s API condition. Is specified by the condition name. Corresponds to the option in the menu: Item » Items » [Open item] » Element: Settings » Drop-down list: Condition for API |
||||||||||||||||||||||
The item’s condition. Is specified by the condition ID.
Corresponds to the option in the menu: Item » Items » [Open item] » Element: Settings » Drop-down list: Condition |
|||||||||||||||||||||||
Condition name |
The item’s condition. Is specified by the condition name. Corresponds to the option in the menu: Item » Items » [Open item] » Element: Settings » Drop-down list: Condition |
||||||||||||||||||||||
Contact form |
The contact form of the manufacturer. Corresponds to the option in the menu: Setup » Item » Manufacturers » Open manufacture » Entry field: Contact form |
||||||||||||||||||||||
Coupon restriction |
Specifies whether it is possible to redeem promotional coupons for this item.
Corresponds to the option in the menu: Item » Items » [Open item] » Element: Settings » Drop-down list: Promotional coupon/POS discount |
||||||||||||||||||||||
eBay category 1; |
The eBay category ID for this item. Corresponds to the option in the menu: Item » Items » [Open item] » Element: Multi-Channel » Entry field: eBay category 1 & 2 Use case: in the first step, you’ll create listing templates that apply to all categories. Then in the second step, you’ll specify the category ID for each individual item. |
||||||||||||||||||||||
eBay preset ID |
The listing template that this item is linked to. Is specified by the listing template ID. You can find the listing template IDs in the menu Sales Channels » Listings. Corresponds to the option in the menu: Item » Items » [Open item] » Element: Multi-Channel » Drop-down list: Listing template |
||||||||||||||||||||||
eBay store category 1 |
The eBay store category ID for this item. Corresponds to the option in the menu: Item » Items » [Open item] » Element: Multi-Channel » Entry field: Store category 1 & 2 Use case: in the first step, you’ll create listing templates that apply to all store categories. Then in the second step, you’ll specify the store category for each individual item. |
||||||||||||||||||||||
EU Responsible Contact form |
The contact form of the manufacturer’s EU-responsible person. Corresponds to the option in the menu: Setup » Item » Manufacturers » Open manufacture » Entry field: Postcode Note:
|
||||||||||||||||||||||
EU Responsible Country Id |
The internal country ID of the manufacturer’s EU-responsible person. In other words, the PlentyONE ID for the country. Corresponds to the option in the menu: Setup » Item » Manufacturers » [Open manufacturer] » Entry field: EU Responsible Country Note:
|
||||||||||||||||||||||
EU Responsible Country name |
The country of the manufacturer’s EU-responsible person. Is specified by the country name. You can find a list of country names here. Corresponds to the option in the menu: Setup » Item » Manufacturers » [Open manufacturer] » Entry field: EU Responsible Country Note:
|
||||||||||||||||||||||
EU Responsible Email |
The email address of the manufacturer’s EU-responsible person. Corresponds to the option in the menu: Setup » Item » Manufacturers » [Open manufacturer] » Entry field: EU Responsible Email Note:
|
||||||||||||||||||||||
EU Responsible house no |
The house number of the manufacturer’s EU-responsible person. Corresponds to the option in the menu: Setup » Item » Manufacturers » [Open manufacturer] » Entry field: EU Responsible House No. Note:
|
||||||||||||||||||||||
EU Responsible name |
The name of the EU-responsible person of the manufacturer. This can be a natural or legal person. Corresponds to the option in the menu: Setup » Item » Manufacturers » [Open manufacturer] » Entry field: EU Responsible Name Note:
|
||||||||||||||||||||||
EU Responsible Phone number |
The telephone number of the manufacturer’s EU-responsible person. Corresponds to the option in the menu: Setup » Item » Manufacturers » [Open manufacturer] » Entry field: EU Responsible Phone number Note:
|
||||||||||||||||||||||
EU Responsible post code |
The postcode of the manufacturer’s EU-responsible person. Corresponds to the option in the menu: Setup » Item » Manufacturers » [Open manufacturer] » Entry field: EU Responsible Postcode Note:
|
||||||||||||||||||||||
EU Responsible street |
The street name of the manufacturer’s EU-responsible person. Corresponds to the option in the menu: Setup » Item » Manufacturers » [Open manufacturer] » Entry field: EU Responsible Street Note:
|
||||||||||||||||||||||
EU Responsible town |
The town of the manufacturer’s EU-responsible person. Corresponds to the option in the menu: Setup » Item » Manufacturers » [Open manufacturer] » Entry field: EU Responsible Town Note:
|
||||||||||||||||||||||
External manufacturer name |
The manufacturer of the item. Is specified by the external manufacturer name. You can find the external manufacturer names in the menu Setup » Item » Manufacturers. Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic settings » Drop-down list: Manufacturer |
||||||||||||||||||||||
Flag 1; |
The item’s first or second flag. Is specified by the flag ID. |
||||||||||||||||||||||
Is serial number |
Specifies whether it is possible to scan this item’s serial number during a process.
Corresponds to the option in the menu: Item » Items » [Open item] » Element: Settings » Drop-down list: Serial number |
||||||||||||||||||||||
Is shippable by amazon |
Specifies whether the FBA function is used for this item.
Corresponds to the option in the menu: Item » Items » [Open item] » Element: Amazon » Checkbox: Amazon FBA Note: By doing so, the FBA stock of this item can be imported into PlentyONE and Amazon Multi-Channel orders that are shipped with FBA can be booked. |
||||||||||||||||||||||
Is shipping package |
Specifies whether the item is a shipping package.
Corresponds to the option in the menu: Item » Items » [Open item] » Element: Settings » Drop-down list: Shipping package Note: Shipping packages have specific dimensions. If you enter dimensions for your variations, then the appropriate shipping package will automatically be assigned. |
||||||||||||||||||||||
Is subscribable |
Specifies whether a subscription is available for the item.
Corresponds to the option in the menu: Item » Items » [Open item] » Element: Settings » Drop-down list: Subscription Note: Subscriptions are set up in the scheduler. The scheduler is an individual module in PlentyONE that allows an item to be shipped in regular intervals. The scheduler menu is only visible in PlentyONE if you’ve booked the module. |
||||||||||||||||||||||
Item ID |
The item’s ID. The item ID is a unique, consecutive number that is used to identify each item in PlentyONE. Note: Every “Export Key” needs to be unique. So if you use the item ID and the variation ID together, then make sure to give each “Export Key” a unique name. Further information. |
||||||||||||||||||||||
Item type |
Indicates the type of item.
|
||||||||||||||||||||||
Manufacturer country ID |
The country where the item was manufactured. Is specified by the country ID. You can find a list of country IDs here. Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic settings » Drop-down list: Manufacturing country |
||||||||||||||||||||||
Manufacturer country name |
The country where the item was manufactured. Is specified by the country name. You can find a list of country names here. Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic settings » Drop-down list: Manufacturing country |
||||||||||||||||||||||
Manufacturer ID |
The manufacturer of the item. Is specified by the manufacturer ID. You can find the manufacturer IDs in the menu Setup » Item » Manufacturers. Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic settings » Drop-down list: Manufacturer |
||||||||||||||||||||||
Manufacturer logo |
The URL that leads to the manufacturer’s homepage. The URL can have up to 2,000 characters. Corresponds to the option in the menu: Setup » Item » Manufacturers » [Open manufacturer] » Entry field: Homepage |
||||||||||||||||||||||
Manufacturer name |
The manufacturer of the item. Is specified by the manufacturer name. You can find the manufacturer names in the menu Setup » Item » Manufacturers. Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic settings » Drop-down list: Manufacturer |
||||||||||||||||||||||
Max. order quantity |
The item’s maximum order quantity. This value limits how many copies of the item can be bought at once.
Corresponds to the option in the menu: Item » Items » [Open item] » Element: Settings » Entry field: Max. order quantity |
||||||||||||||||||||||
Revenue account |
The item’s revenue account. Corresponds to the option in the menu: Item » Items » [Open item] » Element: Settings » Entry field: Revenue account |
||||||||||||||||||||||
Stock type |
The item’s stock type.
Corresponds to the option in the menu: Item » Items » [Open item] » Element: Settings » Drop-down list: Stock type |
||||||||||||||||||||||
Store special ID |
Specifies whether the item is part of a store special. Is specified by the store special ID.
Corresponds to the option in the menu: Item » Items » [Open item] » Element: Webshop » Drop-down list: Webshop |
||||||||||||||||||||||
Store special Name |
Specifies whether the item is part of a store special. Is specified by the store special name. Corresponds to the option in the menu: Item » Items » [Open item] » Element: Webshop » Drop-down list: Webshop |
1.5. Item text
| Field | Explanation |
|---|---|
Name 1 |
The item’s name 1. This is the item’s default name, which is used in the plentyShop and on marketplaces. Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Name 1 Once you’ve added this data field, you can use the drop-down list to specify which language version of the text should be exported. |
Name 2 |
The item’s name 2. This is an alternative item name that can be used for example for markets. Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Name 2 Once you’ve added this data field, you can use the drop-down list to specify which language version of the text should be exported. |
Name 3 |
The item’s name 3. This is an alternative item name that can be used for example for markets. Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Name 3 Once you’ve added this data field, you can use the drop-down list to specify which language version of the text should be exported. |
Preview text |
The item’s preview text. Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Preview text Once you’ve added this data field, you can use the drop-down list to specify which language version of the text should be exported. Note: The preview text is a short text which can be displayed in item lists. |
Meta description |
The item’s meta description. Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Meta description Once you’ve added this data field, you can use the drop-down list to specify which language version of the text should be exported. Note: The meta description makes it easier for search engines to find the item. |
Meta keywords |
The item’s meta keywords. Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Meta keywords Once you’ve added this data field, you can use the drop-down list to specify which language version of the text should be exported. Note: The meta keywords make it easier for search engines to find the item. |
Item text |
The item text is a detailed description, which is displayed in the item layout in the plentyShop. Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Item text Once you’ve added this data field, you can use the drop-down list to specify which language version of the text should be exported. |
Technical data |
The item’s technical data. Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Technical data Once you’ve added this data field, you can use the drop-down list to specify which language version of the text should be exported. |
URL path |
The item’s URL path in the plentyShop, composed of categories and item name. |
1.6. Attribute
Folder level
The folders here correspond to the various attributes that you’ve already created in the menu Setup » Item » Attributes. Open the folder of whichever attribute has information that you want to export.
Data source level
| Field | Explanation |
|---|---|
Attribute ID |
The attribute that’s linked to the variation. For example “Colour” or “Size”. Is specified by the attribute ID. You can find the attribute IDs in the menu Setup » Item » Attributes. |
Attribute name |
The attribute that’s linked to the variation. For example “Colour” or “Size”. Is specified by the internal attribute name. You can find the internal attribute names in the menu Setup » Item » Attributes. |
Value ID |
The attribute value that’s linked to the variation. For example “blue”, “red” or “green”. Is specified by the attribute value ID. You can find the attribute value IDs in the menu Setup » Item » Attributes » [Open attribute] » Tab: Values. |
Value name |
The attribute value that’s linked to the variation. For example “blue”, “red” or “green”. Is specified by the internal attribute value name. You can find the internal attribute value names in the menu Setup » Item » Attributes » [Open attribute] » Tab: Values. |
1.7. SKU
| Field | Explanation |
|---|---|
SKU |
Select the order referrer from the drop-down list. Enter the account if needed. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: SKU Note: Not every marketplace has an account. In such cases, enter 0 as the account ID. |
Parent SKU |
Select the order referrer from the drop-down list. Enter the account if needed. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: SKU Note: Not every marketplace has an account. In such cases, enter 0 as the account ID. |
Status |
Select the order referrer from the drop-down list. Enter the account if needed. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: SKU Note: Not every marketplace has an account. In such cases, enter 0 as the account ID. |
|
What is the difference between SKU and parent SKU?
The parent SKU is only necessary if you work with variation items.
You only need the SKU for items without variations. |
1.8. Stock
Folder level
Stock levels can be managed for every warehouse separately. The folders here correspond to the various warehouses that you’ve already configured in the menu Setup » Stock » Warehouse. Open the folder of whichever warehouse has stock information that you want to export.
|
What about the folder “Total virtual stock”?
This folder corresponds to the sum of all your sales warehouses. Example:
|
Data source level
| Field | Explanation |
|---|---|
Physical stock |
The quantity of items that are actually in the warehouse. Corresponds to the option in the menu: Item » Items » [Open item] » Stock » Column: Physical stock |
Net stock |
The quantity of items that are available for sale. The net stock is a subset of the physical stock. Substract all reserved quantities from the physical stock and you will get the net stock. Corresponds to the option in the menu: Item » Items » [Open item] » Stock » Column: Net stock |
Reserved stock |
The quantity of items that are reserved. A variation will be reserved as soon as an order or a warranty is created. The stock is reserved until either outgoing items are booked or until the order or the warranty is cancelled. The reserved stock is part of the physical stock because the reserved stock is still present in the warehouse. Corresponds to the option in the menu: Item » Items » [Open item] » Stock » Column: Reserved stock |
Reorder level delta |
The difference to the reorder level. The difference either tells you how many items still need to be sold in order to reach the reorder level or it tells you how many items you need to reorder to reach the reorder level. This means if the difference is negative your stock is still above the reorder level. If the difference is positive, your stock is below the reorder level. Corresponds to the option in the menu: Item » Items » [Open item] » Stock » Column: Reorder level Δ |
1.9. Variation
| Field | Explanation | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Active |
Specifies whether the variation is activated.
Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Availability and visibility » Option: Active Background info: Variations only become visible in the plentyShop or on marketplaces once they have been activated. In other words, you can work on inactive variations without your customers noticing. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Availability days |
Specifies the variation’s delivery time. Is specified by the average delivery time in days. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Availability » Symbols 1-10 Note: The availability levels are configured in the menu Setup » Item » Availability. There you can find the availability IDs, texts, symbols and average delivery times in days. Note: The availability is a static setting. In other words, the selected availability level does not change, regardless of the actual stock levels. The setting is only relevant if stock availability is not set automatically. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Availability ID |
Specifies the variation’s delivery time. Is specified by the ID of the availability level (1-10). Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Availability » Symbols 1-10 Note: The availability levels are configured in the menu Setup » Item » Availability. There you can find the availability IDs, texts, symbols and average delivery times in days. Note: The availability is a static setting. In other words, the selected availability level does not change, regardless of the actual stock levels. The setting is only relevant if stock availability is not set automatically. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Availability name |
Specifies the variation’s delivery time. Is specified by the text of the availability level. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Availability » Symbols 1-10 Note: The availability levels are configured in the menu Setup » Item » Availability. There you can find the availability IDs, texts, symbols and average delivery times in days. Note: The availability is a static setting. In other words, the selected availability level does not change, regardless of the actual stock levels. The setting is only relevant if stock availability is not set automatically. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Available if net stock is positive |
Specifies whether the variation is automatically available and purchasable in the plentyShop when it is in stock. Note: Both of the “online store availability” options complement each other and are only applied if the Limitation option is set to To net stock.
Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Availability » Checkbox: Show in online store: Available automatically if net stock is positive |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Available until |
Specifies the last date when the variation is available.
The date is exported in the following format: Example: Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Availability » Entry field: Available until |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Bundle type |
Indicates whether the variation is an item bundle or a bundle component.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Ceres product URL |
The URL where this item can be found in the plentyShop. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Content unit ISO |
The unit of the variation. Is specified by the unit’s ISO code. You can find a list of ISO codes here. Alternatively, you can find the ISO codes in the menu Setup » Item » Units. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Dimensions » Drop-down list: Content Note: Use this export field together with Content value. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Content unit name |
The unit of the variation. Is specified by the unit name. You can find a list of unit names here. Alternatively, you can find the unit names in the menu Setup » Item » Units. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Dimensions » Drop-down list: Content Note: Use this export field together with Content value. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Content value |
Specifies the variation’s numerical content. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Dimensions » Entry field: Content Note: Use this export field together with Content unit ISO or Content unit name. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Customs |
The customs value saved for the variation as a percentage. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Costs » Entry field: Customs |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Customs tariff number |
The variation’s customs tariff number. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Costs » Entry field: Customs tariff number Note: In PlentyONE, it’s possible to save a different customs tariff number for each variation. Example: In some countries, children’s clothing is taxed differently depending on the size. In this case, it makes sense to save the customs tariff number separately for each variation. Inheritance: The customs tariff number is automatically passed down from the main variation to the sub-variations. This means:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Default shipping costs |
The shipping costs that are calculated once per day. This data source is not very precise. We recommend using the data source Shipping costs » Net instead. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Estimated available at |
The variation’s estimated available at date. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
External variation ID |
The external variation ID. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Basic settings » Entry field: External Variation ID Use case: The external variation number facilitates importing items and variations from an external system. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Extra shipping charge 1; |
The extra shipping charge, i.e. a fee that is charged in addition to the normal shipping costs. Extra shipping charges are useful for large or bulky items that are particularly expensive to ship.
Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Dimensions » Entry field: Extra shipping charge 1 / 2 Additional settings: In each of your shipping profiles, specify whether these extra charges should be added to the basic shipping costs. Note: The manual also includes several example calculations for extra shipping charges. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Gross weight in g |
The variation’s gross weight in grams. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Dimensions » Entry field: Gross weight Background info: For individually packaged variations, the gross weight is the weight of the variation including packaging. The value is used to calculate shipping packages and weight-based shipping costs. Item bundles: The gross weight can automatically be calculated based on the bundle components. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Has calculated bundle moving average price |
Indicates whether the option Bundle moving average purchase price (net): Automatically calculate from bundle components is activated.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Has calculated bundle net weight |
Indicates whether the option Bundle net weight: Automatically calculate from bundle components is activated.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Has calculated bundle purchase price |
Indicates whether the option Bundle net purchase price: Automatically calculate from bundle components is activated.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Has calculated bundle weight |
Indicates whether the option Bundle gross weight: Automatically calculate from bundle components is activated.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Height |
The variation’s dimensions in millimetres. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Dimensions » Entry field: Length/Width/Height |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ID of main variation |
Specifies the ID of the corresponding main variation. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Interval order quantity |
Specifies which quantity intervals the variation can be ordered in. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Availability » Entry field: Interval order quantity Note: Decimal values are possible, e.g. allowing customers to order products by weight or length. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Invisible in item list |
Specifies whether the variation is only accessible via the direct URL. This means, whether the variation is always invisible in the categories, search results, store specials, cross-selling lists and lists of last seen items. Relationship to other settings: Both of the client visibility options take priority over the "item list" options. We recommend that you either control the visibility with the “client” option or the “item list” option. They should not be combined.
Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Availability » Checkbox: Item list: Always invisible |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Is invisible in list if net stock is not positive |
Specifies whether the variation is invisible in plentyShop item lists when it is out of stock. Background info: When this happens, the variation can only be accessed using the direct URL. The variation will not appear in the categories, search results, store specials, cross-selling lists and lists of last seen items. Note: The functions Visible automatically if net stock is positive and Invisible automatically if net stock is 0 or negative complement each other and are only applied if the Limitation option is set to To net stock. Relationship to other settings: Both of the client visibility options take priority over the "item list" options. We recommend that you either control the visibility with the “client” option or the “item list” option. They should not be combined.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Is main variation |
Indicates whether the variation is a main variation.
Note: This assumes that you are dealing with a sub-variation. The line is blank if you are dealing with a main variation. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Is visible in list if net stock is positive |
Specifies whether the variation is visible in plentyShop item lists when it is in stock. This means, whether the variation appears in the categories, search results, store specials, cross-selling lists and lists of last seen items. Note: The functions Visible automatically if net stock is positive and Invisible automatically if net stock is 0 or negative complement each other and are only applied if the Limitation option is set to To net stock. Relationship to other settings: Both of the client visibility options take priority over the "item list" options. We recommend that you either control the visibility with the “client” option or the “item list” option. They should not be combined.
Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Availability and visibility » Option: List automatic visibility: Visible in item list if net stock is positive |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Length |
The variation’s dimensions in millimetres. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Dimensions » Entry field: Length/Width/Height |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Main warehouse ID |
Specifies the variation’s main warehouse. Is specified by the warehouse ID. You can find the warehouse IDs in the menu Setup » Stock » Warehouse » [Open warehouse] » Settings. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Shipping » Drop-down list: Main warehouse |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Main warehouse name |
Specifies the variation’s main warehouse. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Shipping » Drop-down list: Main warehouse |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Max. order quantity |
Specifies the maximum quantity that is permitted per order. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Availability » Entry field: Max. order quantity Note: Decimal values are possible, e.g. allowing customers to order products by weight or length. Note: You can use the maximum order quantity in combination with pre-orders, for example to prevent competitors from completely buying out the variation at a reduced price. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Min. order quantity |
Specifies the minimum quantity that is permitted per order. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Availability » Entry field: Min. order quantity Note: Decimal values are possible, e.g. allowing customers to order products by weight or length. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Model |
The variation’s model name. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Basic settings » Entry field: Model |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Moving average price |
The net moving average purchase price. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Costs » Entry field: Net moving average purchase price Note: It is recalculated every time stock is booked in. It is calculated from the purchase prices of all stocks that are available for the variation in the warehouse. Go to Setup » Stock » Stock » Incoming items and see which warehouses were activated with the setting Warehouse for moving average price. The moving average purchase price only takes items into account that were booked into one of these warehouses. If no warehouse is active, then no moving average purchase price is calculated. Item bundles: the moving average purchase price can automatically be calculated based on the bundle components. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Net purchase price |
The net purchase price. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Costs » Entry field: Net purchase price Note: The purchase price is either calculated automatically or managed manually depending on how the settings were saved in the menu Setup » Stock » Stock » Incoming items. Item bundles: the net purchase price can automatically be calculated based on the bundle components. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Net storage costs |
The net storage costs for the variation. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Costs » Entry field: Net storage costs |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Net transportation costs |
The net transportation costs for the variation. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Costs » Entry field: Net transportation costs Note: This value is used for price calculations and for calculating the acquisition price. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Net weight g |
The variation’s net weight in grams. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Dimensions » Entry field: Net weight Background info: The net weight is the weight of the variation without packaging. Item bundles: The net weight can automatically be calculated based on the bundle components. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Not available if net stock is 0 or negative |
Specifies whether the variation is automatically unavailable when it is out of stock. Note: Both of the “online store availability” options complement each other and are only applied if the Limitation option is set to To net stock.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Number of packing units |
Specifies the number of packing units if the item consists of multiple packages. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Shipping » Drop-down list: Packing quantity Note: The value 0 means that an item should always be shipped in a single package, regardless of the quantity. This setting also applies to various items. This means that all items of an order that have the value 0 will be packed into one package. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Online store: invisible if net stock is 0 or negative |
Specifies whether the variation is automatically invisible if it is out of stock. Note: Both of the “client visibility” options complement each other and are only applied if the Limitation option is set to To net stock. Relationship to other settings: Both of the “client visibility” options take priority over the item list options. We recommend that you either control the visibility with the “client” option or the “item list” option. They should not be combined.
Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Availability » Checkbox: Client: Invisible automatically if net stock is 0 or negative |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Online store: visible if net stock is positive |
Specifies whether the variation is automatically visible in the plentyShop when the net stock is positive. Note: Both of the “client visibility” options complement each other and are only applied if the Limitation option is set to To net stock. Relationship to other settings: Both of the “client visibility” options take priority over the item list options. We recommend that you either control the visibility with the “client” option or the “item list” option. They should not be combined.
Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Availability » Checkbox: Client: Visible automatically if net stock is positive |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Operating costs |
The operating costs saved for the variation as a percentage. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Costs » Entry field: Operating costs |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Order picking |
The type of picking.
Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Shipping » Drop-down list: Order picking |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Packing unit quantity |
Specifies the number of packing units if the item consists of multiple packages. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Shipping » Drop-down list: Packing quantity Note: The value 0 means that an item should always be shipped in a single package, regardless of the quantity. This setting also applies to various items. This means that all items of an order that have the value 0 will be packed into one package. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Packing unit type ID; |
Specifies the type of packaging if the item consists of multiple packages.
Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Shipping » Drop-down list: Packing unit |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Pallet type ID |
Specifies the variation’s pallet type. Is specified by the pallet type ID. You can find a list of pallet type IDs here. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Shipping » Drop-down list: Pallet type |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Pallet type name |
Specifies the variation’s pallet type. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Shipping » Drop-down list: Pallet type |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Position |
The variation’s position number. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Basic settings » Entry field: Position Variations can be sorted by their position number in the back end and front end. Back end: Search for items in the menu Item » Edit items. Move your mouse cursor over the column header Position. Click on the small triangle () to display the items in ascending or descending order by their position number. Front end: Select the appropriate sorting option in the plentyShop LTS assistant. Note: Open the plentyShop LTS assistant and navigate to Pagination and sorting » Additional sorting options. If the option Calculate the variation position based on monthly sales is set to Yes, then manually entered position numbers will be overwritten. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Price calculation UUID |
The UUID of the price calculation that is linked to the variation. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Release date |
Specifies the date when the variation becomes available.
The date is exported in the following format: Example: Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Availability » Entry field: Release date Note: The variation can be visible in the plentyShop before this date, e.g. for Advance orders. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sales rank |
The variation’s sales rank. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Show unit price |
Specifies whether the unit price is displayed in the online store.
Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Dimensions » Checkbox: Show unit price Background info: The unit price tells you how much the item costs per pound, litre or other unit of measure. It’s calculated based on the item’s unit, content and price. The unit price allows consumers to compare prices. In some countries, the unit price must be specified for products that are sold by weight, volume, length or surface area. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Stock limitation |
Specifies which stock limitation setting the variation has.
Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Availability » Drop-down list: Limitation |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Units contained |
Units contained describes several sales units combined in one package. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Dimensions » Entry field: Units contained Note: This value does not influence how the unit price is calculated. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Variation ID |
The ID of the variation. Note: Every “Export Key” needs to be unique. So if you use the item ID and the variation ID together, then make sure to give each “Export Key” a unique name. Further information. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Variation name |
The name of the variation. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Basic settings » Entry field: Variation name |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Variation No. |
The variation’s number. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Basic settings » Entry field: Variation No. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Vat |
The variation’s VAT rate. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Costs » Drop-down list: VAT |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
VAT ID |
The variation’s VAT rate. Is specified by a number that represents VAT rate A, B, C, D, E or F. You can find the VAT rates in the menu Setup » Client » [Select client] » Locations » [Select location] » Accounting » Tab: VAT rates » [Open configuration].
Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Costs » Drop-down list: VAT |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Width |
The variation’s dimensions in millimetres. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Dimensions » Entry field: Length/Width/Height |
1.10. Property
Folder level
The folders here correspond to the various property groups that you’ve already created in the menu Setup » Settings » Properties » Groups. Open a group’s folder and then add whichever properties have values that you want to export.
Data source level
The data sources here correspond to the various properties that you’ve already created in the menu Setup » Settings » Properties » Configuration. Add whichever properties have values that you want to export. The value that’s saved for the property in the variation data record will be exported. Specifically, that means:
| Property type | Explanation |
|---|---|
None; |
Since no value is entered into the menu Item » Items » [Open variation] » Properties, no value is exported. The line will be empty in the export file. This means: It is not currently possible to differentiate between variations that are linked to this type of property and variations that are not linked to this type of property. This is a known issue and it will be fixed in the future. |
Date; |
The value saved in the menu Item » Items » [Open variation] » Properties » Column: Value will be exported. |
HTML; |
The text saved in the menu Item » Items » [Open variation] » Properties will be exported. Note: Texts can be saved in multiple languages. Use the drop-down list to specify which language version of the text you want to export. If you want to export the text in multiple languages, then you will have to add the data source multiple times. |
Multi selection |
If you export a file in CSV or TXT format, then you’ll only see the word "Array" instead of the actual export values. This means: It’s not possible to tell which selection values were linked to the variation. This is a known issue and it will be fixed in the future. Possible workaround 1: Would it be an option for you to download a JSON or XML file instead? With these file types, you can see which selection values were linked to the variation.
Possible workaround 2: Export the data with the tools FormatDesigner and Elastic Export instead. |
|
Default name of the “Export Key”
By default, the export file’s column header is given the name: "property-GroupID-PropertyID".
|
1.11. Image
Folder level
| Folder | Explanation |
|---|---|
All images |
The export file contains item images and variation images. |
Item images |
The export file contains item images. |
Variation images |
The export file contains variation images. |
Data source level
| Field | Explanation |
|---|---|
Image list |
Enter a number into the text field Maximum number of images. If you do not enter a number, then this field will be empty when it is exported. If you export a file in CSV or TXT format, then you might only see the word "Array" instead of the actual export values. This happens e.g. when exporting multiple images. This is a known issue and it will be fixed in the future. Possible workaround 1: Would it be an option for you to download a JSON or XML file instead? With these file types, you can see the actual export values.
Possible workaround 2: Export the data with the tools FormatDesigner and Elastic Export instead. |
Single image |
Enter a position number into the text field Image position. This specifies which image should be exported. If you do not enter a number, then the image with the lowest position number will be exported. Corresponds to the option in the menu: Item » Items » [Open item\\] » Images » Details » Entry field: Position |
1.12. Shipping costs
| Field | Explanation |
|---|---|
Net |
The item’s shipping costs. This data source gives you a precise live-calculation of the shipping costs. We recommend using this field over the field Variation » Default shipping costs. Which conditions should be used when calculating the shipping costs? For example, which order referrer, sales price and country? Choose your answers from the drop-down lists. Example of use: You could use this field to compare an item’s shipping costs within the UK and abroad. Add the field twice and decide which countries should be used when calculating the shipping costs. Make sure that the “Export Keys” have unique names. |
1.13. Sales price
| Field | Explanation |
|---|---|
Sales price |
Select a currency and one of the the sales prices that you’ve already configured in the menu Setup » Item » Sales prices. This causes the actual monetary price, which is saved in the variation data record, to be exported. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Sales prices Example: Catalogue data source and variation data field
Note: Add the field multiple times if you want to export multiple sales prices. In this case, make sure that the “Export Keys” have unique names. |
Lowest price during the last 30 days |
The value that is saved as the lowest price during the last 30 days. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Sales prices » Column: Lowest price during the last 30 days |
Lowest price automatically detected |
Indicates whether the lowest price of the last 30 days was automatically calculated.
Note: If you export the information in JSON format, then you will receive the values "true" and "false" rather than an empty line and "1". |
1.14. Unit price
| Field | Explanation |
|---|---|
Price |
The item’s unit price. The unit price tells you how much the item costs per pound, litre or other unit of measure. It’s calculated based on the item’s content, unit and price. Additional step: Select the appropriate sales price from the drop-down list. |
Unit ISO |
The unit of the variation. Is specified by the unit’s ISO code. You can find a list of ISO codes here. Alternatively, you can find the ISO codes in the menu Setup » Item » Units. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Dimensions » Drop-down list: Content Additional step: Select the appropriate sales price from the drop-down list. |
Unit Name |
The unit of the variation. Is specified by the unit name. You can find a list of unit names here. Alternatively, you can find the unit names in the menu Setup » Item » Units. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Dimensions » Drop-down list: Content Additional step: Select the appropriate sales price from the drop-down list. |
Quantity |
The price per [quantity] unit.
Additional step: Select the appropriate sales price from the drop-down list. |
1.15. Referrer
| Field | Explanation |
|---|---|
Referrer ID |
Specifies the IDs of the sales channels that the variation is linked to. You can find the list of order referrer IDs in the menu Setup » Orders » Order referrer. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Sales channels |
1.16. Timestamp
The timestamps indicate when specific events occurred. For example:
-
When the item was created or last modified.
-
When the variation was created or last modified.
-
When the barcode, property, manufacturer, category etc. was last modified.
1.17. Tags
| Field | Explanation |
|---|---|
Tag Id |
Specifies the IDs of the tags that are linked to the variation. You can find the list of tag IDs in the menu Setup » Settings » Tags. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Tags |
Tag Name |
Specifies the names of the tags that are linked to the variation. Corresponds to the option in the menu: Item » Items » [Open variation] » Element: Tags |
1.18. Inheritance
Specifies whether the data is inherited from the main variation.
-
0= Inheritance is deactivated. -
1= Inheritance is activated.
Further information about inheritance.
2. Filters
This chapter lists all of the filters that you can use to limit which items are included in the export file.
| Filter | Explanation | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Has a SKU |
Limits the export to variations that have a SKU for a specific marketplace. |
||||||||||||||||||||
Item IDs |
Limits the export to items with a specific ID. Note: Use commas without spaces to separate multiple IDs.
Example: |
||||||||||||||||||||
Variation is active |
Limits the export to variations that are either active or inactive. |
||||||||||||||||||||
Visible for at least one market |
Select one or more marketplaces from the drop-down list. Limits the export to items that are available for at least one of these markets. This is an “or” filter
Example: If you select the markets eBay, Amazon and Zalando, then the export file will include items that are available on eBay OR Amazon OR Zalando. Differentiation: There is also an “and” filter. Further information. |
||||||||||||||||||||
Has Tags |
Select one or more tags from the drop-down list. Limits the export to items that are linked to all of the selected tags. This is an “and” filter
Example: If you select the tags “Signed copy”, “Collector’s item” and “Antique”, then the export file will include items that are linked to the tag “Signed copy” AND “Collector’s item” AND “Antique”. Differentiation: There is also an “or” filter. Further information. |
||||||||||||||||||||
Linked to at least one property selection value |
Enter the IDs of one or more selection values into the text field. You can find the IDs in the menu Setup » Settings » Properties » Configuration » [Open property of type “Selection” or “Multi selection”] » Area: Selection values. Note: Use commas without spaces to separate multiple IDs.
Example: Limits the export to variations for which at least one of these selection values was activated. This is an “or” filter
Example: If you enter the IDs for Value1, Value2 and Value3, then the export file will include variations for which Value1 OR Value2 OR Value3 was activated. Differentiation: There is also an “and” filter. Further information. |
||||||||||||||||||||
At least one availability |
Select one or more availability IDs from the drop-down list. Limits the export to variations with one of these availability levels. Note: You can find a list of availability IDs, texts, symbols and average delivery times in days in the menu Setup » Item » Availability. |
||||||||||||||||||||
Has flag 1; |
Select one or more flags from the drop-down list. Limits the export to items with one of these flags. |
||||||||||||||||||||
Item created at |
Limits the export to items that were created on a specific date. Formatting:
Enter the date in the format Operators in the left drop-down list
|
||||||||||||||||||||
Item updated at |
Limits the export to items that were last modified on a specific date. Formatting:
Enter the date in the format Operators in the left drop-down list
|
||||||||||||||||||||
Variation created at |
Limits the export to variations that were created on a specific date. Formatting:
Enter the date in the format Operators in the left drop-down list
|
||||||||||||||||||||
Variation updated at |
Limits the export to variations that were last modified on a specific date. Formatting:
Enter the date in the format Operators in the left drop-down list
|
||||||||||||||||||||
Belongs to at least one Amazon product category |
Select one or more Amazon product categories from the drop-down list. Limits the export to items with this Amazon product type. |
||||||||||||||||||||
Item type |
Limits the export to a specific type of item. |
||||||||||||||||||||
Variation is main variation |
Limits the export to variations that are either the main variation or a sub-variation. |
||||||||||||||||||||
Variation has an image |
Limits the export to variations, which have an image saved for them. |
||||||||||||||||||||
Variation is in categories |
Enter the IDs of one or more categories into the text field. You can find the category IDs in the menu Item » Category (ID appears when you move your mouse over a category). Note: Use commas without spaces to separate multiple IDs.
Example: Limits the export to variations that are linked to all of these categories. This is an “and” filter
Example: If you enter the category IDs 14, 15 and 16, then the export file will include variations that were linked to the categories 14 AND 15 AND 16. Differentiation: There is also an “or” filter. Further information. |
||||||||||||||||||||
Variation is in one of these categories |
Enter the IDs of one or more categories into the text field. You can find the category IDs in the menu Item » Category (ID appears when you move your mouse over a category). Note: Use commas without spaces to separate multiple IDs.
Example: Limits the export to variations that are linked to at least one of these categories. This is an “or” filter
Example: If you enter the category IDs 14, 15 and 16, then the export file will include variations that were linked to the category 14 OR 15 OR 16. Differentiation: There is also an “and” filter. Further information. |
||||||||||||||||||||
Item has manufacturers |
Select one or more manufacturers from the drop-down list. Limits the export to items that were manufactured by one of these companies. |
||||||||||||||||||||
Visible for markets |
Select one or more marketplaces from the drop-down list. Select one or more marketplaces from the drop-down list. Limits the export to items that are available for all of these markets. This is an “and” filter
Example: If you select the markets eBay, Amazon and Zalando, then the export file will include items that are available on eBay AND Amazon AND Zalando. Differentiation: There is also an “or” filter. Further information. |
||||||||||||||||||||
Bundle type |
Select one or more options from the drop-down list.
|
||||||||||||||||||||
Visible for a client |
Select one or more clients from the drop-down list. Limits the export to variations that are available for at least one of the selected clients. This is an “or” filter
Example: If you select the clients "Standard Shop", "Shop2" and "Shop3", then the export file will include variations that are available for the clients "Standard Shop" OR "Shop2" OR "Shop3". Differentiation: There is also an “and” filter. Further information. |
||||||||||||||||||||
Visible for clients |
Select one or more clients from the drop-down list. Limits the export to variations that are available for all of these clients. This is an “and” filter
Example: If you select the clients "Standard Shop", "Shop2" and "Shop3", then the export file will include variations that are available for the clients "Standard Shop" AND "Shop2" AND "Shop3". Differentiation: There is also an “or” filter. Further information. |
||||||||||||||||||||
Linked to property selection values |
Enter the IDs of one or more selection values into the text field. You can find the IDs in the menu Setup » Settings » Properties » Configuration » [Open property of type “Selection” or “Multi selection”] » Area: Selection values. Note: Use commas without spaces to separate multiple IDs.
Example: Limits the export to variations for which all of these selection values were activated. This is an “and” filter
Example: If you enter the IDs for Value1, Value2 and Value3, then the export file will include variations for which Value1 AND Value2 AND Value3 were activated. Differentiation: There is also an “or” filter. Further information. |
||||||||||||||||||||
Has at least one tag |
Select one or more tags from the drop-down list. Limits the export to items that are linked to at least one of the selected tags. This is an “or” filter
Example: If you select the tags “Signed copy”, “Collector’s item” and “Antique”, then the export file will include items that are linked to the tag “Signed copy” OR “Collector’s item” OR “Antique”. Differentiation: There is also an “and” filter. Further information. |
||||||||||||||||||||
Variation has child variations |
Limits the export to variations that either have sub-variations or that do not have sub-variations. |
||||||||||||||||||||
Sales price updated at |
Limits the export to variations whose sales price was last modified on a specific date. Formatting:
Enter the date in the format Operators in the left drop-down list
|
||||||||||||||||||||
Stock updated at |
Limits the export to variations whose stock was last modified on a specific date. Formatting:
Enter the date in the format Operators in the left drop-down list
|
3. FAQ
The “Export Keys” are the names of the column headers, as they will appear in your export file. Every “Export Key” needs to be unique.
-
Negative example: You use the data sources Item ID and Variation ID. You give both “Export Keys” the name “id”. As a result, the export file only includes one of the two IDs. A column is missing in the export file.
-
Positive example: You use the data sources Item ID and Variation ID. You give one “Export Key” the name “VariationID” and the other “ItemID”.
When you add a data source, you’ll see the option “Comparative value”. This option is accidentally displayed here. It is not intended for standard formats, but rather for other use-cases. This is a known issue and it will be fixed in the future. Until then, simply leave the “Comparative value” option blank since it doesn’t affect the standard format.
You might have multiple data sources with the same “Export Key”. Every “Export Key” needs to be unique.
-
Negative example: You use the data sources Item ID and Variation ID. You give both “Export Keys” the name “id”. As a result, the export file only includes one of the two IDs. A column is missing in the export file.
-
Positive example: You use the data sources Item ID and Variation ID. You give one “Export Key” the name “VariationID” and the other “ItemID”.
If you export a file in CSV or TXT format, then you might only see the word "Array" instead of the actual export values. This happens e.g. when exporting multiple images or when exporting multi-selection properties. This is a known issue and it will be fixed in the future.
Possible workaround 1: Would it be an option for you to download a JSON or XML file instead? With these file types, you can see the actual export values.
-
Click on Settings.
-
Scroll down to the section Format settings.
-
Select JSON or XML from the drop-down list Format.
-
Save () the settings and download the file (file_download).
-
Caution: If you want to revise the file and import it again. Note that the import tool only accepts the file types CSV and TXT.
-
Possible workaround 2: Export the data with the tools FormatDesigner and Elastic Export instead.
Yes. Export the file in CSV or TXT format. Then revise the file and import it again. Note that the import tool only accepts the file types CSV and TXT.