Skip to main content

Incoming items

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

With syncs of the type Incoming items you can import and book positive and negative incoming items into the item stock overview. The imported incoming items that are displayed in the Stock movements tab can also be found in the menu under Stock » Incoming items.

Automatically generated delivery note number

Via the import, you cannot transmit a delivery note number. For all imported incoming items, a delivery note number is generated automatically.

1. Matching fields

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

Table 1. Matching fields for incoming items
Mapping field Explanation

Item ID

ID of the item

Variation ID

ID of the variation

Variation number

Variation number

Barcode

Barcode
Note: Make sure that you have entered the code for the barcode in the Settings tab of the Item » Edit item menu. Moreover, in the matching of the sync, the name of the barcode (e.g. GTIN 13) has to be selected in the Barcode matching field on the right.

2. Mapping fields

This chapter explains the fields that are available for mapping incoming items. 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 incoming items data record will be given the default value.

2.1. Stock

Required field

Enter the stock 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 Stock » Stocks » open variation » tab: Stock » tab: Stock.


2.2. Storage location ID

Required field

Enter the storage location ID 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 Stock » Incoming items » perform search » select incoming items data record » tab: Item.


2.3. Purchase price

Enter the purchase price into your CSV file. The purchase price refers to the net price.

Default value: No default value

Permitted import values: Numeric; use the same decimal notation as in the import options.

You can find the result of the import in the back end menu Stock » Incoming items » perform search » select incoming items data record » tab: Item.


2.4. Warehouse ID

Required field

Enter the warehouse ID 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 Stock » Incoming items » perform search » select incoming items data record » tab: Item.


2.5. Delivered on

Enter the delivery date into your CSV file.

Default value: No default value

Permitted import values: Date in the format dd.mm.yyyy

You can find the result of the import in the back end menu Stock » Incoming items » perform search.


2.6. Currency

Enter the currency into your CSV file.

Default value: Euro

Permitted import values: Alphanumeric (internal ID)

You can find the result of the import in the back end menu Stock » Stocks » open variation » tab: Stock » tab: Incoming items.


2.7. Best before

Enter the best before date of the item into your CSV file.

Default value: No default value

Permitted import values: Date in the format dd.mm.yyyy

You can find the result of the import in the back end menu Stock » Incoming items » perform search » select incoming items data record » tab: Item.


2.8. Batch

Enter the batch 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 Stock » Incoming items » perform search » select incoming items data record » tab: Item.


2.9. Supplier ID

Enter the supplier ID into your CSV file.

Default value: No default value

Permitted import values: Numeric


2.10. Delivery note number

Enter the delivery note number 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 Stock » Incoming items » perform search.


To top