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

Booking in items to standard storage location not possible when using suggested storage location

If a variation has been connected to a suggested storage location, booking in items to the standard storage location is not possible anymore.

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 import, 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


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.


2.4. Warehouse ID

Required field

Enter the warehouse ID into your CSV file.

Default value: No default value

Permitted import values: Numeric


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


2.8. Batch

Enter the batch into your CSV file.

Default value: No default value

Permitted import values: Numeric


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


2.11. Reason for incoming items

Enter the reason for incoming items.

Default value: 100 (positive quantities); 200 (negative quantities)

Permitted import values: Numeric

You can find the result of the import in the back end menu Item » Edit item » [open item] » tab: Stock » tab: Item movement.


Permitted import values in CSV file Reason for incoming items

Reason for the import of positive quantities

100

Incoming items

101

Incoming items WE

102

Recognition inventory

104

Derecognition cancelled producer

106

Maculation cancelled

107

Pack failure cancelled

108

Dispensation claim cancelled

109

Incoming items (logistic)

110

Incoming items (import)

112

Incoming items (reorder)

113

Outgoing items cancelled

114

Stock rotation inventory hike

115

Incoming items (second choice)

116

Recognition correct

150

Return expensed

171

Incoming items picking

180

Incoming items purchase order

181

Incoming items warehousing

182

Incoming items found source

Reason for the import of negative quantities

200

Outgoing items

201

Outgoing items WA

202

Derecognition inventory

203

Return to producer

204

Derecognition producer failure

205

Derecognition maculation

206

Derecognition pack failure

207

Derecognition damage

208

Derecognition dispensation claim

209

Outgoing items (logistic)

210

Outgoing items (import)

214

Stock rotation inventory reduction

215

Outgoing items (second choice)

216

Derecognition correct

226

Derecognition defect (without return)

280

Outgoing items purchase order

281

Outbound loss

To top