Skip to main content

Orders

This page explains the matching and mapping fields that you can use while importing Orders. This page serves purely as a reference and it assumes that you already have a basic understanding of the import tool.

Practical example: Order items

You can find further information about importing and updating order items in the practical example Order items.

1. Fields for order matching

Table 1 explains the fields that are available for matching order data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 1. Matching fields for importing orders
Setting Explanation

Orders

Which column of your CSV file lists the order IDs? Choose this column here. Optionally, you can decide if you want to define whether you have listed Order IDs or External order IDs.
This option is useful if you want to update existing orders.

Background info: Every new order automatically receives an ID, which cannot be changed. The ID is used to uniquely identify the order. Because the ID is unique, it’s a good way to check whether the imported order already exists in plentymarkets.

Package

Which column of your CSV file lists the shipping package IDs? Choose this column here.

Order item

Which column of your CSV file lists the order items? Choose this column here. Then select whether your CSV file contains Order item IDs, External item IDs or External token IDs.

Table 2. Supplement data
Setting Explanation

Variation

Which column of your CSV file lists the variation IDs? Choose this column here. Then select whether your CSV file contains Marketplace SKUs, External variation IDs, Variation numbers, Manufacturer variation number, Barcode: GTIN 13, Barcode: GTIN 128, Barcode: UPC* or Barcode: ISBN.
If you choose this matching field, the information stored in the system about this variation is loaded and added to the order. This, data is supplemented.

Creating new orders with the import and required fields in the mapping area

If you want to create new orders with the import, leave the fields in the Matching area empty. But note the required fields marked in the Mapping area. These are only relevant for the creation of new orders. If you want to update existing orders, you don’t have to fill in all the required fields.

2. Fields for order mapping

This chapter explains the fields that are available for mapping order data. Use these fields to specify which column of your file corresponds to which data field in your system.

Basic procedure:

  1. In your CSV file: Enter a valid import value into a column.

  2. In plentymarkets: Assign this column to the appropriate mapping field.

  3. 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 order will be given the default value.

2.1. Order

2.1.1. Type ID

Required field

What kind of order is it? Enter the corresponding ID into your CSV file.
The different order types are represented numerically by an ID in the import. When you enter the ID, the system knows which kind of order type it is.

Default value: No default value

Permitted import values: Numeric

Permitted import values in CSV file

Result in the back end

1

Order

2

Delivery order

3

Return

4

Credit note

5

Warranty

6

Repair

7

Offer

8

Advance order

9

Multi-order

10

Multi credit note

11

Redistribution

12

Reorder

2.1.2. Status ID

Which status do you want to assign the order? Enter this status into your CSV file.
28 order statuses are set in the system but you can define additional statuses. Available for this are 19 statuses with 4 decimal places each. Go to the Setup » Orders » Status menu to edit the statuses. For more information go to the section Using the order status of the manual.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Settings » field: Status as well as in the order overview.

2.1.3. Owner ID

To which owner should the order be assigned? Enter the owner ID into your CSV file.
You can find the owner IDs in the back end menu Setup » Settings » User » Accounts. Make sure that the assigned owner has the required user rights for the are Orders.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Settings » field: Owner as well as in the order overview.

2.1.4. Referrer ID

Which referrer should be assigned to the order? Enter the ID of the referrer into your CSV file.
Referrers are stored in the system with IDs. Some referrers are not editable. You can manually add referrers. You can find referrers in the menu Setup » Orders » Order referrer.

Default value: The default referrer set in the order settings

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Settings » field: Referrer as well as in the order overview.

2.1.5. PlentyID

Required field

Which client applies to the order? Enter the plentyID of the client into your CSV file.
You can find the plentyID of the client in the Setup » Client » [Select client] » Settings menu.

Default value: No default value

Permitted import values: Numeric

2.1.6. Location ID

Which location applies to the order? Enter the ID of the location into your CSV file.
You can find the location IDs in the Setup » Client » [Select client] » Locations menu.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Settings » field: Location as well as in the order overview.

2.1.7. Parent order ID

Do you want to import or update orders which have higher-ranking orders? If this is the case, enter the IDs of the parent orders into your CSV file.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end for example in the order view as well as in the menu Orders » Edit orders. IDs of parent orders are displayed with an arrow there.

2.2. Order item

2.2.1. Type

Required field

Of which type is the order item? Enter the ID of the order item type into your CSV file.
The order item types represent different cost positions of an order. The costs involved can be negative or positive. If you don’t enter the ID into the column, you can create your own mapping.

Default value: No default value

Permitted import values: Numeric

Permitted import values in CSV file

Result in the back end

1

Variation

2

Item bundle

3

Bundle component

4

Promotional coupon

5

Gift card

6

Shipping costs

7

Payment surcharge

8

Gift wrap

9

Unassigned variation

10

Deposit

11

Order
This order items type can be found in multi-orders, for example.

12

Reorder

2.2.2. Referrer

Which referrer should be assigned to the order item? Enter the ID of the referrer into your CSV file.
Referrers are stored in the system with IDs. Some referrers are not editable. You can manually add referrers. You can find referrers in the menu Setup » Orders » Order referrer.

Default value: The default referrer set in the order settings

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Settings » field: Referrer as well as in the order overview.

2.2.3. Name

Required field

Which name does the order item have? Enter the name into your CSV file.
It is assumed by default that the name is entered in the system language. You can assign names to items in the Item » [open item] » item tab: Texts » Field: Name menu.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the order items table in the back end menu Orders » Edit orders » [open order] » tab: Overview or in the order overview.

2.2.4. Attribute value

Which attribute value does the order item have? Enter the name of the attribute value into your CSV file.
It is assumed by default that the attribute value is entered in the system language. Attributes can be colours or sizes, for example. You can add new attributes in the Setup » Item » Attributes menu. You can find more information about this in the section Attributes of the manual.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the order items table in the back end menu Orders » Edit orders » [open order] » tab: Overview or in the order overview.

2.2.5. VAT rate

Which VAT rate does the order item have? Enter this VAT rate into your CSV file.
Enter the percentage value of the VAT rate without the percentage sign. Whether the rate has to be entered separated by commas or points depends on the setting in the Matching of the import.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Overview as well as in the order overview.

2.2.6. VAT value

Which VAT value does the order item have? Enter the amount into your CSV file.

The VAT amount for the quantity 1 is expected by default. Whether the amount has to be entered separated by commas or points depends on the setting in the Matching of the import.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Overview.

2.2.7. Quantity

Required field

In which quantity is the order item added to the order? Enter the quantity into your CSV file.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Overview as well as in the order overview.

2.2.8. Variation ID

Enter the ID of the variation into your CSV file. You can find the ID for example in the overview table in the Item » Edit item menu.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the order items table in the back end menu Orders » Edit orders » [open order] » tab: Overview or in the order overview.

2.2.9. Position

Enter the position of the order item into your CSV file. The position reflects the sorting of the order items in the order.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the order items table in the back end menu Orders » Edit orders » [open order] » tab: Overview or in the order overview.

2.2.10. Currency

Required field

In which currency is the order? Enter the currency into your CSV file.
You can find an overview of the currencies and their ISO codes that are available in plentymarkets in the section Currencies in the manual.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Overview » field: Currency as well as in the order overview.

2.2.11. Exchange rate

Enter the exchange rate of the order currency into the default currency into your CSV file.
You can find the default currency in the Setup » Orders » Payment » Currencies menu.

Default value: If no exchange rate is entered, the exchange rate set in the Setup » Orders » Payment » Currencies menu is taken.

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Settings » field: Exchange rate.

2.2.12. Purchase price

Which purchase price does the order item have? Enter the price for the quantity 1 into your CSV file.
Whether the price has to be entered separated by commas or points depends on the setting in the Matching of the import.

Default value: No default value

Permitted import values: Numeric

The purchase price is not displayed in the order. But the purchase price enables the calculation of the profit margin which you can find in the Orders » Edit orders » [open order] » tab: Overview » field: Return on sale net menu.

2.2.13. Gross price

Which gross price does the order item have? Enter the price for the quantity 1 into your CSV file.
Whether the price has to be entered separated by commas or points depends on the setting in the Matching of the import.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu in the order items table in the Orders » Edit orders menu.The total gross value is displayed in the Orders » Edit orders » tab: Overview » field: Gross value of items menu.

2.2.14. Net price

Which net price does the order item have? Enter the price for the quantity 1 into your CSV file.
Whether the price has to be entered separated by commas or points depends on the setting in the Matching of the import.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu in the order items table in the Orders » Edit orders menu.The total net value is displayed in the Orders » Edit orders » tab: Overview » field: Net value of items menu.

2.2.15. Surcharge

Is there a surcharge for the order item? Then enter this surcharge for the quantity 1 into your CSV file.
Whether the surcharge has to be entered separated by commas or points depends on the setting in the Matching of the import.

Default value: No default value

Permitted import values: Numeric

2.2.16. Discount

Is there a discount for the order item? Then enter this discount for the quantity 1 into your CSV file.
Whether the discount has to be entered separated by commas or points depends on the setting in the Matching of the import.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu in the order items table in the Orders » Edit orders menu.

2.2.17. Percentual discount

Is there a percentual discount for the order item? Then enter this percentual discount into your CSV file.
Whether the discount has to be entered separated by commas or points depends on the setting in the Matching of the import.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu in the order items table in the Orders » Edit orders menu.

2.3. Order item properties

2.3.1. Value

Which properties does the order item have? Enter the value into your CSV file and then select in the mapping the corresponding property type.
You can enter several property types. You have to add a column to your CSV file for every property type and then select the corresponding mapping.

Default value: No default value

Permitted import values: Alpha-numeric

Available property types:

  • Warehouse

  • Weight

  • Width

  • Length

  • Height

  • External token ID

  • External item ID

  • Coupon code

  • Coupon type

  • Unit

  • External shipping item ID

  • Return reason

  • Item status

  • External order item ID

Own property types for order items can be created via the Interface  or via REST. However, they are not displayed in the UI.

2.4. Order note

2.4.1. Text

Is there an order note for the order? Enter the text that should be assigned to the order into your 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 Orders » Edit orders » [open order] » tab: Overview » field: Order note

2.5. Address relation

2.5.1. Address ID

There already is an existing address for this contact? Enter the ID of the address into your CSV file and define in the mapping whether it is the Invoice address or the Delivery address.
You can find the address ID in the menu CRM » Contacts » [open contact] » area: Details » field: addresses, for example. If you want to import a new address, use the mapping fields for Address.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Overview » fields: Invoice address or delivery address as well as in the order overview.

2.6. Order property

2.6.1. Value

Which order properties does the order have? Enter the value into your CSV file and then select in the mapping the corresponding property type.
You can enter several property types. You have to add a column to your CSV file for every property type and then select the corresponding mapping.

Default value: No default value

Permitted import values: Alpha-numeric

Available property types:

  • Warehouse

  • Shipping profile

  • Payment method

  • Payment status

  • External shipping profile

  • Document language

  • External order ID

  • Customer sign

  • Dunning level

  • Seller account

  • Flag

  • Document number

  • Sales tax identification number

Own property types for orders can be created via the Interface  oder per REST .

2.7. Order date

2.7.1. Date

You want to assign a specific date to the order? Enter the date in the format you set in the Matching into your CSV file and select in the mapping which date type it is.

Default value: No default value

Permitted import values: Numeric

Available date types:

  • Deleted on

  • Created on

  • Paid on

  • Last update

  • Outgoing items booked on

  • Returned date

  • Payment due date

  • Estimated shipping date

  • Estimated delivery date

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Overview » field: Input as well as in the order overview.

2.8. Order relation

2.8.1. Reference ID

Do you want to assign a specific relation to the order? Enter the ID of the reference into your CSV file.

Default value: No default value

Permitted import values: Numeric

Selection in mapping

Explanation

Contact - Sender

The ID you have to enter is the ID of an existing contact. This contact is then taken the sender of the order. You can find the ID of the contact in the back end in the overview table of the CRM » Contacts menu.

Contact - Receiver

The ID you have to enter is the ID of an existing contact. This contact is then taken the receiver of the order. You can find the ID of the contact in the back end in the overview table of the CRM » Contacts menu.

Account - Sender

The ID you have to enter is the ID of an existing account. This account is then taken as the sender of the order. You can find the ID of the account in the back end when you click on Edit in the Account area in the CRM » Contacts menu. The ID of the account is displayed in the header of the opened window.

Account - Receiver

The ID you have to enter is the ID of an existing account. This account is then taken as the receiver of the order. You can find the ID of the account in the back end when you click on Edit in the Account area in the CRM » Contacts menu. The ID of the account is displayed in the header of the opened window.

Warehouse - Sender

The ID you have to enter is the ID of an existing warehouse. This warehouse is then taken as the sender of the order. You can find the ID of a warehouse in the back end menu Setup » Stock » Warehouse » [select warehouse] » Settings.

Warehouse - Receiver

The ID you have to enter is the ID of an existing warehouse. This warehouse is then taken as the receiver of the order. You can find the ID of a warehouse in the back end menu Setup » Stock » Warehouse » [select warehouse] » Settings.

2.9. Address

Do you want to assign a new address to the order? Then use the mapping fields in this area and enter the corresponding values into your CSV file. You have to select for each of the mapping fields whether it is the Invoice address or the Delivery address.
If you want to assign an already existing address use the mapping fields Address ID.

2.9.1. Name 1 (Company)

Enter the company name of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.2. Name 2 (First name)

Enter the first name of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.3. Name 3 (Last name)

Enter the last name of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.4. Name 4 (Additional)

Enter the additional names of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.5. Address 1 (Street)

Enter the street of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.6. Address 2 (House number)

Enter the house number of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.7. Address 3 (Additional)

Enter additional address information of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.8. Address 4 (Free)

Enter free address information of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.9. Postcode

Enter the postcode of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.10. Town

Enter the town of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.11. Country ID

Enter the country ID of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.
The ID of the delivery country is expected by default. You can find the country IDs in the menu Setup » Orders » Shipping » Settings » Tab: Countries of delivery.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.12. State ID

Enter the state ID of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.
List of all countries for which states/provinces are available, including the IDs of the states/provinces: link:PDF file including a list of states and provinces

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.13. VAT number

Enter the VAT number of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.14. Telephone

Enter the telephone number of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.9.15. Email

Enter the Email of the contact you want to assign to the order into your CSV file. Select in the mapping whether this is the Invoice address or the Delivery address.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Customer.

2.10. Shipping package

Do you want to add shipping information to the order? Then use the mapping fields in this area and enter the corresponding values into your CSV file. You have to select for each mapping field in this area what kind of shipping package it is.
You can set up a shipping package in the Setup » Orders » Shipping » Shipping packages menu. You can find more information on shipping packages in the section Creating a shipping package in the manual.

2.10.1. Weight (g)

Enter the weight of the package in gram into your CSV file. Select in the mapping what kind of shipping package it is.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Overview » field: Weight as well as in the order overview table.

2.10.2. Package number

Enter the package number of the package into your CSV file. You can enter more than one package number in one row by dividing them by comma or you add them with one package number per row. Select in the mapping what kind of shipping package it is.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Orders » Edit orders » [open order] » tab: Settings » field: Package number.

2.10.3. Return package number

Enter the return package number of the package into your CSV file. You can enter more than one return package number in one row by dividing them by comma or you add them with one return package number per row. Select in the mapping what kind of shipping package it is.
You can find the return package numbers in the back end menu Orders » Shipping centre » tab: Returns.

Default value: No default value

Permitted import values: Alpha-numeric

2.10.4. Packing unit type

Enter the ID of the Packing unit type into your CSV file. Select in the mapping what kind of shipping package it is.

Default value: No default value

Permitted import values: Numeric

Permitted import values in CSV file

Result in the back end

0

No packaging

1

Bale

2

Dispenser

3

Coil

4

Roll pallet

5

Colli

6

Container

7

Bucket

8

Cask

9

Bottles

10

European flat pallet

11

Structural frame

12

Gas cylinder

13

Pallet cage

14

Hobbock

15

Half pallet

16

Pallet of food items

17

Wooden coaster

18

IBC container

19

Pitcher

20

Wicker bottle

21

Case

22

Canister

23

Customer pallet

24

Cardboard box

25

Composite packaging

26

Package

27

Ring

28

Role

29

Sack

30

Piece

31

Tank

32

Drum

34

Crate

35

Quarter pallet

36

Other pallets

37

Bin

38

One-way pallet

39

Foil bag

2.10.5. Pallet ID

Enter the pallet ID into your CSV file. Select in the mapping what kind of shipping package it is.
You can find the pallet ID in the back end menu Orders » Package content.

Default value: No default value

Permitted import values: Numeric

2.10.6. Is closed

Decide, whether the shipping package is closed or nor. Select in the mapping what kind of shipping package it is.

Default value: No default value

Permitted import values in CSV file Explanation

0

The shipping package is still open. Changes can still be made.

1

The shipping package is closed. Changes cannot be made.

To top