Item
This page explains the matching and mapping fields that you can use while importing item data and variation data. This page serves purely as a reference and it assumes that you already have a basic understanding of the import tool.
|
Requirements
In order to import item data, the following data records must be present in PlentyONE:
In order to import variation data with attributes, the following data records must be present in PlentyONE:
|
|
Practical example: Importing new items
Imagine you’re new to PlentyONE and you want to import all of your items and variations at once. How would that work? Take a look at this practical example, which guides you through the process step-by-step. |
1. Matching fields
Table 1 explains the fields that are available for matching item data. During the import, PlentyONE checks if the imported data record already exists based on the matching field.
| Matching field | Explanation |
|---|---|
Variation ID |
|
Variation number |
|
External variation ID |
|
Barcode |
Select the barcode type from the second drop-down list. |
Item ID |
For variations with attributes, use this field only in combination with attribute selection combination. |
Attribute value selection |
For variations with attributes, use this field only in combination with the item ID. Select the format from the second drop-down list that contains the data of the file. |
Supplier variation number |
2. Mapping fields
This chapter explains the fields that are available for mapping item data and variation data. Use these fields to specify which column of your file corresponds to which data field in your system.
Basic procedure:
-
In your CSV file: Enter a valid import value into a column.
-
In PlentyONE: Assign this column to the appropriate mapping field.
-
After the import: Check the result in the back end.
|
No mapping field? Default value applies!
If you don’t include a certain piece of information in your CSV file, i.e. if you don’t use a certain mapping field, then your item or variation will be given the default value. |
2.1. Item
2.1.1. Stock type
Enter the appropriate stock type into the CSV file.
Default value: 0
| Permitted import values in CSV file | Options in the drop-down list in the back end |
|---|---|
|
Stocked item |
|
Production item |
|
Colli |
|
Special order item |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic settings » Drop-down list: Type
2.1.2. Store special
Should this item be highlighted with a store special? If so, then enter the appropriate type of store special into the CSV file.
Default value: 0
| Permitted import values in CSV file | Options in the drop-down list in the back end |
|---|---|
|
None |
|
Special offer |
|
New item |
|
Top item |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Area: Online store » Drop-down list: Store special
2.1.3. Manufacturer ID
Who makes this item? Enter the manufacturer ID into the CSV file. You can only specify manufacturer data records that have already been created in PlentyONE. You can find the manufacturer IDs in the menu Setup » Item » Manufacturers.
Default value: No default value
Permitted import values: Numeric (internal ID)
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic settings » Drop-down list: Manufacturer
2.1.4. Manufacturing country
Which country was the item manufactured in? Enter the country ID into the CSV file. You can find a list of country IDs here.
Default value: 1 (Germany)
Permitted import values: Numeric (internal ID)
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic settings » Drop-down list: Manufacturing country
2.1.5. Revenue account
Enter up to 11 digits in the CSV file for the revenue account.
Default value: 0
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic settings » Entry field: Revenue account
2.1.6. Promotional coupon
Should it be possible to redeem promotional coupons for this item? Enter your choice into the CSV file.
Default value: 0
| Permitted import values in CSV file | Options in the drop-down list in the back end |
|---|---|
|
Permitted |
|
Not permitted |
|
Purchasable with coupon only |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic settings » Drop-down list: Promotional coupon/POS discount
2.1.7. Condition
Enter the item’s condition into the CSV file.
Default value: 0
| Permitted import values in CSV file | Options in the drop-down list in the back end |
|---|---|
|
[0] New |
|
[1] Used |
|
[2] New & with original packaging |
|
[3] New with label |
|
[4] Factory seconds |
You can find the result of the import in the back end menu: Item » Items » [Open item] » Element: Settings » Drop-down list: Condition
2.1.8. Condition for API
Enter the item’s API condition into the CSV file.
Default value: 0
| Permitted import values in CSV file | Options in the drop-down list in the back end |
|---|---|
|
[0] New |
|
[1] Used but as new |
|
[2] Used but very good |
|
[3] Used but good |
|
[4] Used but acceptable |
|
[5] Factory seconds |
You can find the result of the import in the back end menu: Item » Items » [Open item] » Element: Settings » Drop-down list: Condition for API
Note: The API condition is used for the market Amazon.
2.1.9. Subscription (yes/no)
Is a subscription available for the item? Enter your answer into the CSV file.
Default value: 0
| Permitted import values in CSV file | Options in the drop-down list in the back end |
|---|---|
|
No |
|
Yes |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic 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.
2.1.10. Serial number (yes/no)
Should it be possible to scan this item’s serial number during a process? Enter your answer into the CSV file.
Default value: 0
| Permitted import values in CSV file | Options in the drop-down list in the back end |
|---|---|
|
No |
|
Yes |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic settings » Drop-down list: Serial number
2.1.11. Shipping package (yes/no)
Do you want to use shipping packages for this item? Enter your answer into the CSV file.
Default value: 0
| Permitted import values in CSV file | Options in the drop-down list in the back end |
|---|---|
|
No |
|
Yes |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic 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.
2.1.12. Fulfilment by Amazon (FBA)
Should the item be sold via FBA? If so, then enter the appropriate Amazon marketplace into the CSV file.
Default value: 0
| Permitted import values in CSV file | Options in the drop-down list in the back end |
|---|---|
|
Do not use |
|
AMAZON_EU |
|
AMAZON_FE |
|
AMAZON_NA |
|
FBA and SellerCentral |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Multi-Channel » Area: Amazon » Drop-down list: FBA Fulfillment
2.1.13. Shipment by Amazon (FBA)
Specify whether you want to use the FBA function for this item.
Default value: 0
| Permitted import values in CSV file | Result in the back end |
|---|---|
|
No. Check mark is not placed. |
|
Yes. Check mark is placed. |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Multi-Channel » Area: 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.
2.1.14. Amazon product type (Deprecated)
Enter the Amazon product type ID into the CSV file. 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.
Default value: 0 (Unknown)
Permitted import values: Numeric (Amazon product type IDs)
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Multi-Channel » Area: 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.
2.1.15. Amazon product type
Enter the Amazon product type ID into the CSV file.
The product type is the Amazon category under which this item should appear. These product types are used for the new connection to Amazon.
Product types cannot be imported, because they come directly from Amazon. But you have the option to import the values that are assigned to the items.
Permitted import values: String in which all words are capitalised and separated by underscores (Amazon product type IDs)
Example: BAKING_CHOCOLATE
You can find the result of the import in the back end 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.
2.1.16. Amazon FEDAS
FEDAS product group key
Default value: 0
| Permitted import values in CSV file | Result in the back end |
|---|---|
|
No. |
|
Yes. |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Multi-Channel » Section: Amazon » FEDAS
2.1.17. Listing template
Enter the ID of a previously created listing template into the CSV file. This links the listing template to the item. You can find the listing template IDs in the menu Sales Channels » Listings.
Default value: No default value
Permitted import values: Numeric (internal ID)
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Multi-Channel » Area: Listing default settings » Drop-down list: Listing template
2.1.18. Listing category 1 - 2
Enter the eBay category IDs for this item into the CSV file.
Default value: No default value
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Multi-Channel » Area: Listing default settings » Entry field: 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.
2.1.19. Listing store category 1 - 2
Enter the eBay store category for this item into the CSV file.
Default value: No default value
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Multi-Channel » Area: Listing default settings » 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.
2.1.20. Rakuten.de categories
This setting is only relevant if you sell on Rakuten. Here you’ll link the item with a Rakuten category. Enter the category ID into the CSV file.
Default value: No default value
Permitted import values: Numeric (internal ID)
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Multi-Channel » Section: Category link » Entry field: Rakuten.de
2.1.21. Flag 1-2
Do you want to flag the item? Enter the ID of a previously created flag into the CSV file. You can find the flag IDs in the menu Setup » Item » Flags » Tab: Flag 1 and Flag 2
Default value: No default value
Permitted import values: Numeric (internal ID)
2.1.22. Age rating
Enter the item’s age rating into the CSV file.
Default value: 0
| Permitted import values in CSV file | Options in the drop-down list in the back end |
|---|---|
|
Age rating 0 |
|
Age rating 3 |
|
Age rating 6 |
|
Age rating 9 |
|
Age rating 12 |
|
Age rating 14 |
|
Age rating 16 |
|
Age rating 18 |
|
(50) Not flagged |
|
(88) Not required |
|
(99) Unknown |
You can find the result of the import in the back end 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.
2.1.23. Item feedback
Enter an initial rating for the item into the CSV file.
Default value: 0
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Area: Online store » Entry field: Item feedback
Note: When using the item feedback function, the number entered here will be displayed as the item’s initial rating. Every time new feedback is submitted, an average value will be calculated automatically from these numbers. Go to Setup » Client » Settings » Feedback » Tab: Item if you want to change the Maximum rating.
2.1.24. Field 1 - 20
Activates previously created free text fields for the item.
Default value: No default value
Permitted import values: Alpha-numeric
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Fields
2.1.25. Max. order quantity
Enter a value into the CSV file to limit how many copies of the item can be bought at once.
-
0 = The maximum order quantity applies per variation. This quantity is saved in the variation’s tab Settings under the option Max. order quantity.
-
Value greater than 0 = Customers cannot order more than this total quantity. This limit applies to all of the item’s variations. Decimal values are possible, e.g. allowing customers to order products by weight or length. This value takes priority over the maximum order quantity saved within the individual variations.
Default value: 0
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic settings » Entry field: Max. order quantity
2.1.26. Type
Only relevant when creating new items
What sort of item do you want to create? Enter the appropriate item type into the CSV file. This setting can no longer be changed once the item has been created.
Default value: standard
| Permitted import values in CSV file | Result in the back end |
|---|---|
|
Creates a “normal item” or an item bundle. |
|
Creates a multipack item. |
|
Creates an item set. |
2.1.27. Manufacturer name
Who makes this item? Enter the manufacturer name into the CSV file. If the manufacturer data record does not already exist in PlentyONE, then a new manufacturer data record will be created.
Default value: No default value
Permitted import values: Alpha-numeric
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Area: Basic settings » Drop-down list: Manufacturer
2.2. Item sets
2.2.1. Add components (IDs, comma-separated)
Do you want to add components to a set? In your CSV file, enter the IDs and quantity of the items that should be added to the set.
Default value: No default value
Permitted import values: Alpha-numeric
Input format: itemID:quantity,itemID:quantity
Example: 1234:1,1235:1,1236:1
You can find the result of the import in the back end menu: Item » Edit item » [Open set] » Tab: Set » Tab: Settings » Section: Item
2.2.2. Remove components (IDs, comma-separated)
Do you want to remove components from a set? In your CSV file, enter the IDs of the items that should be removed from the set.
Default value: No default value
Permitted import values: Alpha-numeric
Input format: itemID,itemID
Example: 1234,1235,1236
You can find the result of the import in the back end menu: Item » Edit item » [Open set] » Tab: Set » Tab: Settings » Section: Item
2.2.3. Discount
By default, the price of an item set is equivalent to the sum of the individual prices of all set components. However, you can offer a discount on the total price of the set. Enter the discount in % into your CSV file.
Default value: No default value
Permitted import values: Decimal number
You can find the result of the import in the back end menu: Item » Edit item » [Open set] » Tab: Set » Tab: Settings » Section: Other
2.3. Cross-selling
2.3.1. Delete all cross selling links
Do you want to delete all of the cross-selling links from the item data record? Enter your answer into the CSV file.
Default value: 0
| Permitted import values in CSV file | Result in the back end |
|---|---|
|
No. Cross-selling links will not be deleted. |
|
Yes. All of the cross-selling links will be deleted. |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Cross-selling » Tab: Cross-selling items
2.3.2. Add cross-selling links
Do you want to create new cross-selling links? Enter information about the links into the CSV file.
Default value: No default value
Permitted import values: Alpha-numeric
Input format: Item-ID:RelationshipType;Item-ID:RelationshipType;etc.
Example: 1234:Accessory;1235:ReplacementPart;1236:Similar
Available relationship types:
| Relationship type in CSV file | Result in the back end |
|---|---|
Accessory |
Accessory |
ReplacementPart |
Replacement part |
Similar |
Similar |
Bundle |
Item bundle |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Cross-selling » Tab: Cross-selling items
2.3.3. Delete cross-selling links
Do you want to delete some of the cross-selling links from the item data record? Enter the cross-selling links that should be deleted into the CSV file.
Default value: No default value
Permitted import values: Numeric
Input format: ItemID;itemID;etc.
Example: 1234;1235;1236
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Cross-selling » Tab: Cross-selling items
2.4. Item ebay title
2.4.1. Title (comma-separated)
Enter all nine eBay listing titles into the CSV file. Use commas to separate them. This links the listing titles to the item.
Background info: Listings are retrieved on an hourly basis. While being retrieved, the listing is assigned to an item. Listings and items are matched smoothly if the listing was created with PlentyONE or if the item has the same name as the listing title.
If the item name differs, you can enter the listing title. This improves the matching accuracy. This link also makes it possible to import listings that were set up with other tools into PlentyONE and have them automatically assigned to the correct item.
Default value: No default value
Permitted import values: Alpha-numeric
Note: It is not possible to only import some of the nine titles. This is because all of the nine titles are deleted during the import process and then added again.
Note: The import is limited to a maximum of nine titles. If your CSV file includes more than nine titles, then all of the titles over this limit will be ignored.
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Multi-Channel » Section: eBay title
2.5. Item texts
2.5.1. Name 1
This field is mandatory, depending on what you want to do.
Enter a name for the item in your CSV file. This is the item’s default name, which is used in the plentyShop and on marketplaces.
Default value: No default value
Permitted import values: Alpha-numeric
| Also use the drop-down list to select the language. |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Name 1
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.
2.5.2. HTML Title for webshop
Enter the HTML title for your webshop into the CSV file.
Default value: No default value
Permitted import values: Alpha-numeric
| Also use the drop-down lists to select the language and the webstore. |
2.5.3. Name 2
Enter a name for the item in your CSV file. This is an alternative item name that can be used for example for markets.
Default value: No default value
Permitted import values: Alpha-numeric
| Also use the drop-down list to select the language. |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Name 2
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.
2.5.4. Name 3
Enter a name for the item in your CSV file. This is an alternative item name that can be used for example for markets.
Default value: No default value
Permitted import values: Alpha-numeric
| Also use the drop-down list to select the language. |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Name 3
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.
2.5.5. Preview text
Enter a preview text for the item in your CSV file.
Default value: No default value
Permitted import values: Alpha-numeric
| Also use the drop-down list to select the language. |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Preview text
Note: The preview text is a short text which can be displayed in item lists.
2.5.6. Meta description
Enter a meta description for the item into your CSV file.
Default value: No default value
Permitted import values: Alpha-numeric
| Also use the drop-down list to select the language. |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Meta description
Note: The meta description makes it easier for search engines to find the item.
2.5.7. Item text
Enter an item text into the CSV file. The item text is a detailed description, which can be displayed in the item layout in the online store.
Default value: No default value
Permitted import values: Alpha-numeric
| Also use the drop-down list to select the language. |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Item text
2.5.8. Technical data
Enter technical data for the item in your CSV file.
Default value: No default value
Permitted import values: Alpha-numeric
| Also use the drop-down list to select the language. |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Technical data
2.5.9. URL path
Enter a URL path for the item in your CSV file. By default, the URL path consists of the categories and the item name. PlentyONE automatically assigns the path when the item is created. The path is displayed as part of the URL when the item is viewed in the online store.
Default value: No default value
Permitted import values: Alpha-numeric
| Also use the drop-down list to select the language. |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: URL path
2.5.10. Meta keywords
Enter keywords for the item into your CSV file.
Default value: No default value
Permitted import values: Alpha-numeric
| Also use the drop-down list to select the language. |
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Texts » Entry field: Meta keywords
Note: The meta keywords make it easier for search engines to find the item.
2.6. Shipping profile
2.6.1. Shipping profile ID
This field is mandatory, depending on what you want to do.
How should this item be shipped? Enter the shipping profile ID into the CSV file. This links the shipping profile to the item. You can only specify shipping profiles that were already created in PlentyONE. You can find the shipping profile IDs in the menu Setup » Orders » Shipping » Settings » Tab: Shipping profiles.
Background info: Every item must be assigned to at least one shipping profile. Otherwise the shipping costs may not be calculated correctly.
Default value: No default value
Permitted import values: Numeric (internal ID)
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Section: Shipping profiles
2.6.2. Shipping profiles (comma-separated)
How should this item be shipped? Enter multiple shipping profile IDs into the CSV file. Separate them with commas. This links the shipping profiles to the item. You can only specify shipping profiles that were already created in PlentyONE. You can find the shipping profile IDs in the menu Setup » Orders » Shipping » Settings » Tab: Shipping profiles.
Background info: Every item must be assigned to at least one shipping profile. Otherwise the shipping costs may not be calculated correctly.
Default value: No default value
Permitted import values: Numeric (internal ID)
Input format: Profile-ID1,Profile-ID2,etc.
Example: 2,13,7
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Section: Shipping profiles
2.6.3. Delete shipping profile links (profile IDs, comma-separated)
Do you want to delete some of the links? Enter the IDs of all the shipping profiles that should no longer be linked to the item. You can find the shipping profile IDs in the menu Setup » Orders » Shipping » Settings » Tab: Shipping profiles.
Default value: No default value
Permitted import values: Numeric (internal ID)
Input format: Profile-ID1,Profile-ID2,etc.
Example: 2,13,7
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Section: Shipping profiles
2.6.4. Add default shipping profiles (0/1)
You can find the result of the import in the back end menu: Item » Edit item » [Open item] » Tab: Global » Section: Shipping profiles
2.7. Item variations
2.7.1. Item ID
This field is mandatory, depending on what you want to do.
Corresponds to the item ID.
Default value: No default value
Permitted import values: Numeric
2.7.2. Position
Enter a position number for the variation into the CSV file.
Default value: No default value
Permitted import values: Numeric
You can find the result of the import in the back end 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.
2.7.3. Active
Should the variation be activated? Enter your answer into the CSV file.
Default value: 0
| Permitted import values in CSV file | Result in the back end |
|---|---|
|
No. The variation should not be activated |
|
Yes. The variation should be activated |
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: 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.
2.7.4. Variation number
Enter a number for the variation into the CSV file. See the field in a practical example. If you leave this field blank, then PlentyONE will automatically assign the next available variation number. The number will be assigned according to the pattern saved in the menu Setup » Item » Settings.
Default value: No default value
Permitted import values: Alpha-numeric
You can find the result of the import in the back end menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Basic settings » Entry field: Variation No.
2.7.5. Model
Enter a model name for the variation into the CSV file.
Default value: No default value
Permitted import values: Alpha-numeric
You can find the result of the import in the back end menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Basic settings » Entry field: Model
2.7.6. External variation ID
Enter an external variation ID into the CSV file.
Default value: No default value
Permitted import values: Alpha-numeric
You can find the result of the import in the back end 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.
2.7.7. Availability
How long is the variation’s delivery time? Enter the appropriate availability level (1-10) into the CSV file.
Default value: 1
Permitted import values: Numeric (internal ID)
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: Availability and Visibility » Drop-down list: Displayed delivery time
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.
2.7.8. Net purchase price
Enter the net purchase price into the CSV file. Use the same decimal notation as in the import options.
Default value: 0
Permitted import values: Numeric
You can find the result of the import in the back end 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.
2.7.9. Moving average purchase price (net)
Enter the net moving average purchase price into the CSV file. Use the same decimal notation as in the import options.
Default value: 0
Permitted import values: Numeric
You can find the result of the import in the back end 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.
2.7.10. Price calculation
Enter a price calculation’s ID into the CSV file. This applies the price calculation to whichever prices were saved for the variation. You can find the price calculation ID in the menu Setup » Setup » Item » Price calculation » [Open price calculation].
Default value: No default value
Permitted import values: Numeric (internal ID)
You can find the result of the import in the back end menu: Item » Edit item » [Open variation] » Tab: Settings » Section: Sales prices
2.7.11. Price calculation UUID
Enter a price calculation’s UUID into the CSV file. This applies the price calculation to whichever prices were saved for the variation.
Tip: You can copy the price calculation UUID. Open the menu Setup » Item » Price calculation » [Open price calculation]. Click on the UUID in the lower left corner. The UUID is copied to the clipboard.
Import the price calculation UUID last:
Imagine your prices are calculated with the following formula: (PurchasePrice + TransportCosts) * 1.07.
In this case, import the purchase price and transportation costs first and then the price calculation second.
Otherwise PlentyONE won’t have all of the information it needs to correctly calculate the price.
-
Create a mapping, which imports the purchase price and transportation costs.
-
Create another mapping in the same import. Use this one to import the price calculation UUID.
→ The mappings are processed one after the other.
Default value: No default value
Permitted import values: Alpha-numeric
You can find the result of the import in the back end menu: Item » Edit item » [Open variation] » Tab: Settings » Section: Sales prices
|
One price calculation per variation
Only one price calculation can be linked to a variation. Imagine you’ve already linked a price calculation to a variation. Then you link a second price calculation to the same variation. In this case, the second price calculation would overwrite the first one. Both price calculations can not simultaneously be linked to the variation. Nonetheless, it’s still possible to calculate prices differently, e.g. in the Shop and on Amazon. This is done by adding multiple calculation building blocks to your price calculation. |
2.7.12. Stock limitation
Should PlentyONE monitor this product’s stock levels? Enter the appropriate stock limitation setting into the CSV file.
Default value: 1
| Permitted import values in CSV file | Options in the drop-down list in the back end |
|---|---|
|
None = This setting is useful for situations where you could technically count the stock units, but it doesn’t matter whether the stock is negative or not. The product is available, just without any particular stock value. Note: Some marketplaces only consider the stock value that is assigned to the variation. So if you select this setting, then the marketplace might never have an active offer for the product because it might never understand this as a positive stock value. Check how your target marketplaces will interpret the stock limitation setting before you begin selling on them. |
|
To net stock = This is the most commonly used option. It prevents you from accidentally overselling items. The stock is limited to the net stock. This net stock level is transmitted to marketplaces. What does net stock mean? |
|
Do not administer stock for this variation = This setting is useful for situations where it would be very time-consuming to count the stock units. For example, imagine you sell construction supplies and you have millions of copies of a screw. Note: Some marketplaces only consider the stock value that is assigned to the variation. So if you select this setting, then the marketplace might never have an active offer for the product because it might never understand this as a positive stock value. Check how your target marketplaces will interpret the stock limitation setting before you begin selling on them. Note: If this setting is selected, then the variation’s Stock tab will not include the sub-tabs Correction, Stock, Supply and Item movement. |
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: Availability and Visibility » Drop-down list: Stock limitation
2.7.13. Visibility of client: Visible automatically if net stock is positive
Should the variation automatically be visible in the plentyShop when the net stock is positive? Enter your answer into the CSV file.
Note: Both client visibility automatics complement each other and only apply if the option stock limitation is set to To net stock.
Relationship to other settings: Both client visibility automatics have priority over list automatic visibility. We recommend that you either control the visibility with the “client” option or the “list” option. They should not be combined.
Default value: 0
| Permitted import values in CSV file | Result in the back end |
|---|---|
|
No. The option is not activated. |
|
Yes. The option is activated. |
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: Availability and visibility » Option: Client automatic visibility » visible if net stock is positive
2.7.14. Visibility of client: Invisible automatically if net stock is 0 or negative
Should the variation automatically be invisible if it is out of stock? Enter your answer into the CSV file.
Note: Both client visibility automatics complement each other and only apply if the option stock limitation is set to To net stock.
Relationship to other settings: Both client visibility automatics have priority over list automatic visibility. We recommend that you either control the visibility with the “client” option or the “list” option. They should not be combined.
Default value: 0
| Permitted import values in CSV file | Result in the back end |
|---|---|
|
No. The option is not activated. |
|
Yes. The option is activated. |
You can find the result of the import in the back end menu: Item » Items » [Open variation] » Tab: General » Section: Availability and visibility » Option: Client automatic visibility » not visible, if net stock is negative
2.7.15. Availability of online store: Available automatically if net stock is positive
Should the variation automatically be available and purchasable in the plentyShop when it is in stock? Enter your answer into the CSV file.
Note: Both client availability automatics complement each other and only apply if the option stock limitation is set to To net stock.
Default value: 0
| Permitted import values in CSV file | Result in the back end |
|---|---|
|
No. The option is not activated. |
|
Yes. The option is activated. |
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: Availability and Visibility » Option: Client automatic availability » Deliverable if net stock is positive
2.7.16. Availability of online store: Not available automatically if net stock is 0 or negative
Should the variation automatically be unavailable if it is out of stock? Enter your answer into the CSV file.
Note: Both client availability automatics complement each other and only apply if the option stock limitation is set to To net stock.
Default value: 0
| Permitted import values in CSV file | Result in the back end |
|---|---|
|
No. The option is not activated. |
|
Yes. The option is activated. |
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: Availability and Visibility » Option: Client automatic availability » Not deliverable if net stock is negative
2.7.17. Visibility of item list: Visible automatically if net stock is positive
Should the variation be visible in plentyShop item lists when it is in stock? This means, should the variation appear in the categories, search results, store specials, cross-selling lists and lists of last seen items? Enter your answer into the CSV file.
Note: The option*visible in item list if net stock is positive* and not visible in item list if net stock is negative complement each other and only apply if the option stock limitation is set to To net stock.
Relationship to other settings: Both client visibility automatics have priority over the list visibility automatics. We recommend that you either control the visibility with the “client” option or the “list” option. They should not be combined.
Default value: 0
| Permitted import values in CSV file | Result in the back end |
|---|---|
|
No. The option is not activated. |
|
Yes. The option is activated. |
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: Availability and Visibility » Option: List automatic visibility: Visible in item list if net stock is positive
2.7.18. Visibility of item list: Invisible automatically if net stock is 0 or negative
Should the variation be invisible in plentyShop item lists when it is out of stock? Enter your answer into the CSV file.
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 option*visible in item list if net stock is positive* and not visible in item list if net stock is negative complement each other and only apply if the option stock limitation is set to To net stock.
Relationship to other settings: Both client visibility automatics have priority over the list visibility automatics. We recommend that you either control the visibility with the “client” option or the “list” option. They should not be combined.
Default value: 0
| Permitted import values in CSV file | Result in the back end |
|---|---|
|
No. The option is not activated. |
|
Yes. The option is activated. |
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: Availability and Visibility » Option: List automatic visibility: Not visible in item list if net stock is negative
2.7.19. Main warehouse
Enter the ID of the variation’s main warehouse into the CSV file. You can find the warehouse IDs in the menu Setup » Stock » Warehouse » [Open warehouse] » Settings.
Default value: No default value
Permitted import values: Numeric (internal ID)
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: Settings » Drop-down list: Main warehouse
2.7.20. Max. order quantity
Enter a number into the CSV file. This is the maximum quantity that is permitted per order.
Default value: No default value
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: Settings » Field: Maximum 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.
2.7.21. Min. order quantity
Enter a number into the CSV file. This is the minimum quantity that is permitted per order.
Default value: No default value
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: Settings » Field: Minimum order quantity
Note: Decimal values are possible, e.g. allowing customers to order products by weight or length.
2.7.22. Interval order quantity
Enter a number into the CSV file. This specifies which quantity intervals the variation can be ordered in.
Default value: No default value
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Settings » Field: Interval order quantity
Note: Decimal values are possible, e.g. allowing customers to order products by weight or length.
2.7.23. Available until
When is the last day that the variation should be available? Enter the date into the CSV file.
Default value: No default value
Permitted import values: Date
Input format: DD.MM.YYYY
Example: 25.02.2021
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: Availability and Visibility » Field: Available until
2.7.24. Release date
When should the variation become available? Enter the date into the CSV file.
Default value: No default value
Permitted import values: Date
Input format: DD.MM.YYYY
Example: 25.02.2021
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: Settings » Field: Release date
Note: The variation can be visible in the plentyShop before this date, e.g. for preorders.
2.7.25. Name
Enter a name for the variation into the CSV file.
Default value: No default value
Permitted import values: Alpha-numeric
You can find the result of the import in the back end menu: Item » Edit item » [Open variation] » Tab: Settings » Area: Basic settings » Entry field: Variation name
2.7.26. Gross weight in g
Enter the variation’s gross weight into the CSV file. Make sure you enter the weight in grams rather than kilograms. Use the same decimal notation as in the import options.
Default value: 0
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: General » Section: Availability and Visibility » Field: 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.
Item bundles: The gross weight can automatically be calculated based on the bundle components.
2.7.27. Net weight in g
Enter the variation’s net weight into the CSV file. Make sure you enter the weight in grams rather than kilograms. Use the same decimal notation as in the import options.
Default value: 0
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: Product details » Section: Dimensions and content » Field: Net weight in grams
Background info: The net weight is the weight of the variation without packaging.
Item bundles: The gross weight can automatically be calculated based on the bundle components.
2.7.28. Width in mm
Enter the variation’s dimensions into the CSV file. Make sure you enter the dimensions in millimetres.
Default value: 0
Permitted import values: Numeric
Note: Use the same decimal notation as in the import options.
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: Product details » Section: Dimensions and content » Field: Height/Length/Width
2.7.29. Length in mm
Enter the variation’s dimensions into the CSV file. Make sure you enter the dimensions in millimetres.
Default value: 0
Permitted import values: Numeric
Note: Use the same decimal notation as in the import options.
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: Product details » Section: Dimensions and content » Field: Height/Length/Width
2.7.30. Height mm
Enter the variation’s dimensions into the CSV file. Make sure you enter the dimensions in millimetres.
Default value: 0
Permitted import values: Numeric
Note: Use the same decimal notation as in the import options.
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: Product details » Section: Dimensions and content » Field: Height/Length/Width
2.7.31. Extra shipping charge 1
Enter a fee into the CSV file, which should be charged in addition to the normal shipping costs. Such 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.
Default value: 0
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: Shipping » Field: Extra shipping charge 1 or 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.
2.7.32. Extra shipping charge 2
Enter a fee into the CSV file, which should be charged in addition to the normal shipping costs. Such 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.
Default value: 0
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: Shipping » Field: Extra shipping charge 1 or 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.
2.7.33. Units contained
Units contained describes several sales units combined in one package.
Default value: 1
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: Product details » Section: Dimensions and content » Field: Units contained
Note: This value does not influence how the unit price is calculated.
2.7.34. Pallet type
Enter the appropriate pallet type into the CSV file.
| Permitted import values in CSV file | Options in the drop-down list in the back end |
|---|---|
|
Euro pallet |
|
Pallet cage |
|
Single-use pallet |
|
Single-use pallet cage |
|
Quarter pallet |
|
Half pallet |
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: Shipping » Drop-down list: Pallet type
2.7.35. Number of packing units
Enter the number of packing units into the CSV file if the item consists of multiple packages.
Note: Use this mapping field together with Packing unit type.
Default value: No default value
Permitted import values: Numeric (a number between 0 and 20)
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: Shipping » Field: 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.
2.7.36. Packing unit type
Enter the type of packaging into the CSV file if the item consists of multiple packages.
Note: Use this mapping field together with Number of packing units.
Default value: No default value
| Permitted import values in CSV file | Options in the drop-down list in the back end |
|---|---|
|
No packaging |
|
Bale |
|
Dispenser |
|
Coil |
|
Roll pallet |
|
Colli |
|
Container |
|
Bucket |
|
Cask |
|
Bottles |
|
Europool flat pallet |
|
Structural frame |
|
Gas cylinder |
|
Pallet cage |
|
Hobbock |
|
Half pallet |
|
Pallet of food items |
|
Wooden coaster |
|
IBC container |
|
Pitcher |
|
Wicker bottle |
|
Case |
|
Canister |
|
Customer pallet |
|
Cardboard box |
|
Composite packaging |
|
Package |
|
Ring |
|
Roll |
|
Sack |
|
One |
|
Tank |
|
Drum |
|
Crate |
|
Quarter pallet |
|
Other pallets |
|
Bin |
|
Single-use pallet |
|
Foil bag |
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: Shipping » Drop-down list: Packing unit
2.7.37. Net transportation costs
Enter the net transportation costs for the variation into the CSV file. Use the same decimal notation as in the import options.
Default value: 0
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: Pricing » Section: Costs » Transportation costs
Note: This value is used for price calculations and for calculating the acquisition price.
2.7.38. Net storage costs
Enter the net storage costs for the variation into the CSV file. Use the same decimal notation as in the import options.
Default value: 0
Permitted import values: Numeric
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab: Prices » Section: Costs » Storage Costs
2.7.39. Customs
Enter the customs value as a percentage in the CSV file.
Default value: No default value
Permitted import values: Numeric (percentage value)
You can find the result of the import in the back end menu: Item » Items » [Open variation\] » Tab:Pricing » Section: Costs » Customs in %