Skip to main content

Item (new)

This page describes the data fields and filters that are available when exporting item and variation data 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.

Format type: Item (new)

The format type described on this page is found in the menu Data » Catalogues. When creating a new catalogue, you’ll select the standard format from the upper drop-down list. Then you can select the format type Item (new) from the middle drop-down list.

catalogue item
What’s a standard format?
  • Definition: A standard format is used to export specific data from your plentymarkets system. Afterwards, you can revise the data and import it again.

  • Example: Imagine you want to update the prices and descriptions for several items at once. You could export a CSV file with the item data saved in your system. Afterwards, you could revise the file and import it again.

  • Differentiation: Note that standard formats only export data from your system. They do not transmit this data to marketplaces.

1. Data fields

This chapter lists all of the item data fields that can be exported with the catalogue tool.


1.1. ASIN

Folder level

ASIN codes can be saved separately for every Amazon country platform. The folders here correspond to the various Amazon country platforms, i.e. Amazon France, Amazon UK or Amazon Italy. Open the folder for whichever country platform has an ASIN code that you want to export.

What about the folder “Asin Default”?

This folder corresponds to the drop-down list All in the menu Item » Edit item » [Open variation] » Tab: Settings » Area: ASIN/ePID/MOIN.

asin all

Data field level

Field Explanation

ASIN Code

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.


1.2. Moin

Field Explanation

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.


1.3. Barcode

This folder lists 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.

Example: Catalogue data field and variation data field
  • Barcode Type = GTIN 13

  • Code = 0123456789012

barcode catalogue variation

1.4. Default category

Category vs. Default category

Variations can be linked to multiple categories:

  • Category: Imagine you sell a personalised bracelet. You want the bracelet to appear in the category “Gifts” and in the category “Women’s accessories”.

  • Default category: Decide which one of these categories should be the variation’s default category. The default category is the breadcrumb path displayed in the plentyShop. If a variation appears in multiple categories, then the breadcrumb bar will always display the default category path.

  • What is exported?:

    • If you use “Item (new)” as a standard format, then it will only be possible to export information about the default category. It is not currently possible to export information about other linked categories. Possible workaround: Export the data with the tools FormatDesigner and Elastic Export instead.

    • If you use “Item (new)” as a marketplace format (e.g. to transmit your product data to a sales platform), then you can export information about the default category and other linked categories.

category defaultcategory
Field Explanation

Category ID

The ID of the category.

Category name

The name of the category.

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.

Meta title

The category’s meta title. The meta title is displayed in the tab title of the browser and in search engine results.

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.

Meta keywords

The category’s keywords.

Path

This data field 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 - then a category path could look like this: shoes-women-boots-uggs

Branch 1;
Branch 2;
Branch 3;
Branch 4;
Branch 5;
Branch 6

You can save up to 6 category levels in the plentymarkets back end. These data fields correspond to the individual levels of the category’s breadcrumbs path.

Example: Your system includes the category: Shoes » Women » Boots » Uggs.

  • Branch 1 = Shoes

  • Branch 2 = Women

  • Branch 3 = Boots

  • Branch 4 = Uggs


1.5. Item

Filter Explanation

Item ID

The item’s ID. The item ID is a unique, consecutive number that is used to identify each item in plentymarkets.

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.

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.

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.

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.

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.

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.

Condition ID

The item’s condition. Is specified by the condition ID.

Values in the export file Options in the back end

0

[0] New

1

[1] Used

2

[2] New & with original packaging

3

[3] New with label

4

[4] Factory seconds

Condition API ID

The item’s API condition. Is specified by the condition ID.

Values in the export file Options in the back end

0

[0] New

1

[1] Used but as new

2

[2] Used but very good

3

[3] Used but good

4

[4] Used but acceptable

5

[5] Factory seconds

Note: The API condition is used for the market Amazon.


1.6. Item text

Filter 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.

Note: The maximum length of the item name is 240 characters. The item name is used to create the item URL. Open the plentyShop LTS assistant and navigate to the step SEO if you want to decide whether name 1, 2 or 3 should be used for the meta title and the item URL.

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.

Note: The maximum length of the item name is 240 characters. The item name is used to create the item URL. Open the plentyShop LTS assistant and navigate to the step SEO if you want to decide whether name 1, 2 or 3 should be used for the meta title and the item URL.

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.

Note: The maximum length of the item name is 240 characters. The item name is used to create the item URL. Open the plentyShop LTS assistant and navigate to the step SEO if you want to decide whether name 1, 2 or 3 should be used for the meta title and the item URL.

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.7. 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 field 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.8. 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 » Edit item » [Open variation] » Tab: Availability » Area: SKU

Note: Not every marketplace has an account. In this case, leave the field blank.

Parent SKU

Select the order referrer from the drop-down list. Enter the account if needed. Corresponds to the option in the menu: Item » Edit item » [Open variation] » Tab: Availability » Area: SKU

Note: Not every marketplace has an account. In this case, leave the field blank.


1.9. 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 warehouses. Example:

  • Warehouse 1: Physical stock = 10

  • Warehouse 2: Physical stock = 22

  • Total virtual stock: Physical stock = 32

Data field level

Field Explanation

Physical stock

The quantity of items that are actually in the warehouse.

Corresponds to the option in the menu: Item » Edit item » [Open item] » Tab: Stock » Column: Phy

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 » Edit item » [Open item] » Tab: Stock » Column: Net

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 » Edit item » [Open item] » Tab: Stock » Column: RS

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.


1.10. Variation

Filter Explanation

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.

Is main variation

Indicates whether the variation is a main variation.

Values in the export file Result in the back end

1

It’s a main variation.

Line is blank

It’s a sub-variation.

ID of main variation

Specifies the ID of the corresponding 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.

Position

The variation’s position number.

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.

Active

Specifies whether the variation is activated.

Values in the export file Options in the back end

Line is blank

No. Check mark is not placed.

1

Yes. Check mark is placed.

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.

Back end search: inactive variations are not found with the default search settings. Set the search filter Active to No if you want inactive items to be included in the search results.

Show unit price

Specifies whether the unit price is displayed in the online store.

Values in the export file Options in the back end

Line is blank

No. The unit price is not displayed in the online store.

1

Yes. The unit price is displayed in the online store.

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.

Variation number

Model

The variation’s model name.

External variation ID

The external variation ID.

Use case: The external variation number facilitates importing items and variations from an external system.

Net purchase price

The 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.

Order picking

The type of picking.

Values in the export file Options in the back end

single_picking

Single order picking possible

Note: Currently not in use.

no_single_picking

Single order picking not possible

Note: Currently not in use.

exclude_from_picklist

Exclude from pick list

Note: This option is well-suited, e.g. for variations that do not have barcodes and thus can not be processed with normal pick lists.

Relationship to other settings: Do you use the plugin Filter for shippable items? Then take a look at the plugin’s filter descriptions. Some filters only apply to variations that are excluded/not excluded from the pick list.

Stock limit

Specifies which stock limitation setting the variation has.

Values in the export file Options in the back end

0

None = The stock is not limited. The variation’s availability is not automatically monitored.

1

To net stock = The stock is limited to the net stock. The variation’s availability is automatically monitored.

2

Do not administer stock for this variation = If this setting is selected, then the variation’s Stock tab will not include the sub-tabs Correction, Stock, Supply and Item movement.

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.

Values in the export file Result in the back end

Line is blank

No. Check mark is not placed.

1

Yes. Check mark is placed.

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.

Values in the export file Result in the back end

Line is blank

No. Check mark is not placed.

1

Yes. Check mark is placed.

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.

Values in the export file Result in the back end

Line is blank

No. Check mark is not placed.

1

Yes. Check mark is placed.

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.

Values in the export file Result in the back end

Line is blank

No. Check mark is not placed.

1

Yes. Check mark is placed.

Max. order quantity

Specifies the maximum quantity that is permitted per order.

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.

Note: Decimal values are possible, e.g. allowing customers to order products by weight or length.

Interval order quantity

Specifies which quantity intervals the variation can be ordered in.

Note: Decimal values are possible, e.g. allowing customers to order products by weight or length.

Available until

Specifies the last date when the variation is available. The date is exported in the following format: Y-m-d H:i:s

Example: 2022-02-25 00:00:00

Release date

Specifies the date when the variation becomes available. The date is exported in the following format: Y-m-d H:i:s

Example: 2022-02-25 00:00:00

Note: The variation can be visible in the plentyShop before this date, e.g. for preorders.

Variation name

Extra shipping charge 1;
Extra shipping charge 2

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.

  • Extra shipping charge 1 applies to the first item.

  • Extra shipping charge 2 applies to each additional item.

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.

Units contained

Units contained describes several sales units combined in one package.

Note: This value does not influence how the unit price is calculated.

Number of packing units

Specifies the number of packing units if the item consists of multiple packages.

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.

Net transportation costs

The net transportation costs for the variation.

Note: This value is used for price calculations and for calculating the acquisition price.

Net storage costs

The net storage costs for the variation.

Customs

The customs value saved for the variation as a percentage.

Customs tariff number

The variation’s customs tariff number.

Note: In plentymarkets, 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:

  • you don’t need to enter customs tariff numbers for your sub-variations if you want them to have the same customs tariff number as the main variation.

  • you’ll need to enter a different customs tariff number for all of the sub-variations that should differ from the main variation.

Operating costs

The operating costs saved for the variation as a percentage.

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.

Values in the export file Result in the back end

Line is blank

No. Check mark is not placed.

1

Yes. Check mark is placed.

Default shipping costs

The shipping costs that are calculated once per day. This data field is not very precise. We recommend using the data field Shipping costs » Net instead.

VAT rate

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].

  • 0 = VAT rate A

  • 1 = VAT rate B

  • 2 = VAT rate C

  • 3 = VAT rate D

  • 4 = VAT rate E

  • 5 = VAT rate F

Availability ID

Specifies the variation’s delivery time. Is specified by the ID of the availability level (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 days

Specifies the variation’s delivery time. Is specified by the average delivery time in days.

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.

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.

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.

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.

Note: Use this export field together with Content value.

Content value

Specifies the variation’s numerical content.

Note: Use this export field together with Content unit ISO or Content unit name.

Ceres product URL

The URL where this item can be found in the plentyShop.

Gross weight in g

The variation’s gross weight in grams.

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.

Net weight in g

The variation’s net weight in grams.

Background info: The net weight is the weight of the variation without packaging.

Width;
Length;
Height

The variation’s dimensions in millimetres.


1.11. 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 field level

The data fields 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;
Order properties

Since no value is entered into the menu Item » Edit item » [Open variation] » Tab: 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;
File;
Whole number;
Decimal number;
Character string;
Selection

The value saved in the menu Item » Edit item » [Open variation] » Tab: Properties » Area: Variation properties » Column: Value will be exported.

HTML;
Text

The text saved in the menu Item » Edit item » [Open variation] » Tab: Texts 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 field 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.

  1. Click on Settings.

  2. Scroll down to the section Format settings.

  3. Select JSON or XML from the drop-down list Format.

  4. Save () the settings and download the file ().

    • 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.

Default name of the “Export Key”

By default, the export file’s column header is given the name: "property-GroupID-PropertyID".

  • Example: the column header "property-3-17" means that the export data relates to the property with the ID 17. And that this property is included in the group with the ID 3.

property exportkey name

1.12. Image

Folder level

Images can be saved for a specific variation or for the entire item.

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 field 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.

  1. Click on Settings.

  2. Scroll down to the section Format settings.

  3. Select JSON or XML from the drop-down list Format.

  4. Save () the settings and download the file ().

    • 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.

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.


1.13. Shipping costs

Field Explanation

Net

The item’s shipping costs. This data field 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.14. Sales price

This folder lists the sales prices that you’ve already configured in the menu Setup » Item » Sales prices. When you add a sales price to the catalogue, the actual monetary price, which is saved in the variation data record, will be exported.

Example: Catalogue data field and variation data field
  • Sales price = B2B customers

  • Currency = Euro

  • Monetary price = 15.99

salesprice catalogue variation

1.15. 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.

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.

Additional step: Select the appropriate sales price from the drop-down list.

Quantity

The price per [quantity] unit.

  • In most cases, the number 1 is exported. Example: the price per 1 kilogram. The price per 1 litre.

  • In some cases, the number 100 is exported. Example: the price per 100 grams. The price per 100 millilitre.

Additional step: Select the appropriate sales price from the drop-down list.

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: 11,12,13

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: 11,12,13

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;
Has flag 2

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 DD.MM.YYYY. Alternatively, click on the calendar symbol () if you would prefer to choose the date from the calendar.

Operators in the left drop-down list
Operator Explanation

Today

Only items that were created today will be exported.

Last

Enter a number of days into the field on the right. Only items that were created within the last [number] days will be exported.

Period

Enter a time period into the field on the right. Only items that were created during this time period will be exported.

=

Is equal to. Enter a date into the field on the right. Only items that were created on this date will be exported.

!=

Is not equal. Enter a date into the field on the right. Only items that were not created on this date will be exported.

>

Greater than. Enter a date into the field on the right. Only items that were created after this date will be exported.

>=

Greater than or equal to. Enter a date into the field on the right. Only items that were created on or after this date will be exported.

<

Less than. Enter a date into the field on the right. Only items that were created before this date will be exported.

<=

Less than or equal to. Enter a date into the field on the right. Only items that were created on or before this date will be exported.

Item updated at

Limits the export to items that were last modified on a specific date.

Formatting: Enter the date in the format DD.MM.YYYY. Alternatively, click on the calendar symbol () if you would prefer to choose the date from the calendar.

Operators in the left drop-down list
Operator Explanation

Today

Only items that were modified today will be exported.

Last

Enter a number of days into the field on the right. Only items that were modified within the last [number] days will be exported.

Period

Enter a time period into the field on the right. Only items that were modified during this time period will be exported.

=

Is equal to. Enter a date into the field on the right. Only items that were modified on this date will be exported.

!=

Is not equal. Enter a date into the field on the right. Only items that were not modified on this date will be exported.

>

Greater than. Enter a date into the field on the right. Only items that were modified after this date will be exported.

>=

Greater than or equal to. Enter a date into the field on the right. Only items that were modified on or after this date will be exported.

<

Less than. Enter a date into the field on the right. Only items that were modified before this date will be exported.

<=

Less than or equal to. Enter a date into the field on the right. Only items that were modified on or before this date will be exported.

Variation created at

Limits the export to variations that were created on a specific date.

Formatting: Enter the date in the format DD.MM.YYYY. Alternatively, click on the calendar symbol () if you would prefer to choose the date from the calendar.

Operators in the left drop-down list
Operator Explanation

Today

Only variations that were created today will be exported.

Last

Enter a number of days into the field on the right. Only variations that were created within the last [number] days will be exported.

Period

Enter a time period into the field on the right. Only variations that were created during this time period will be exported.

=

Is equal to. Enter a date into the field on the right. Only variations that were created on this date will be exported.

!=

Is not equal. Enter a date into the field on the right. Only variations that were not created on this date will be exported.

>

Greater than. Enter a date into the field on the right. Only variations that were created after this date will be exported.

>=

Greater than or equal to. Enter a date into the field on the right. Only variations that were created on or after this date will be exported.

<

Less than. Enter a date into the field on the right. Only variations that were created before this date will be exported.

<=

Less than or equal to. Enter a date into the field on the right. Only variations that were created on or before this date will be exported.

Variation updated at

Limits the export to variations that were last modified on a specific date.

Formatting: Enter the date in the format DD.MM.YYYY. Alternatively, click on the calendar symbol () if you would prefer to choose the date from the calendar.

Operators in the left drop-down list
Operator Explanation

Today

Only variations that were modified today will be exported.

Last

Enter a number of days into the field on the right. Only variations that were modified within the last [number] days will be exported.

Period

Enter a time period into the field on the right. Only variations that were modified during this time period will be exported.

=

Is equal to. Enter a date into the field on the right. Only variations that were modified on this date will be exported.

!=

Is not equal. Enter a date into the field on the right. Only variations that were not modified on this date will be exported.

>

Greater than. Enter a date into the field on the right. Only variations that were modified after this date will be exported.

>=

Greater than or equal to. Enter a date into the field on the right. Only variations that were modified on or after this date will be exported.

<

Less than. Enter a date into the field on the right. Only variations that were modified before this date will be exported.

<=

Less than or equal to. Enter a date into the field on the right. Only variations that were modified on or before this date will be exported.

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: 14,15,16

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: 14,15,16

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. 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.

Option Explanation

Not part of a bundle

Limits the export to variations that are neither an item bundle nor a bundle component.

Bundle

Limits the export to item bundles.

Part of a bundle

Limits the export to bundle components.

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: 11,12,13

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.

3. FAQ

What does “Export Key” mean?

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 fields 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 fields Item ID and Variation ID. You give one “Export Key” the name “VariationID” and the other “ItemID”.

catalogue export keys
What does “Comparative value” mean?

When you add a data field, 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.

comparative value
How do I export the file?
  1. Click on in the toolbar up top.
    → The export will start and it runs in the background. You can continue working during the export process.

  2. After a while (ca. 30-60 minutes), a message will appear in the notification centre ().

  3. Click on Download within the notification.

catalogue export
I only see the folder “Default category”. Can I also export the other categories?

Variations can be linked to multiple categories:

  • Category: Imagine you sell a personalised bracelet. You want the bracelet to appear in the category “Gifts” and in the category “Women’s accessories”.

  • Default category: Decide which one of these categories should be the variation’s default category. The default category is the breadcrumb path displayed in the plentyShop. If a variation appears in multiple categories, then the breadcrumb bar will always display the default category path.

  • What is exported?:

    • If you use “Item (new)” as a standard format, then it will only be possible to export information about the default category. It is not currently possible to export information about other linked categories. Possible workaround: Export the data with the tools FormatDesigner and Elastic Export instead.

    • If you use “Item (new)” as a marketplace format (e.g. to transmit your product data to a sales platform), then you can export information about the default category and other linked categories.

category defaultcategory
My export file is missing a column. Why?

You might have data fields with the same “Export Key”. Every “Export Key” needs to be unique.

  • Negative example: You use the data fields 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 fields Item ID and Variation ID. You give one “Export Key” the name “VariationID” and the other “ItemID”.

catalogue export keys
Only the word “Array” is exported. Why?

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.

  1. Click on Settings.

  2. Scroll down to the section Format settings.

  3. Select JSON or XML from the drop-down list Format.

  4. Save () the settings and download the file ().

    • 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.

Can I revise the file and import it again?

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.

To top