Stock

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

1. Matching fields

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

Table 1. Matching fields for stock
Matching 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 stock. 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 stock will be given the default value.

2.1. Warehouse ID

Required field

Enter the ID of the warehouse that contains 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 » Incoming items » [Open incoming items data record] » Tab: Item.

2.2. Quantity

Required field

Enter the quantity of 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 » Incoming items » [Open incoming items data record] » Tab: Item.

2.3. Storage location ID

Required field

Enter the ID of the storage location that contains 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 » Incoming items » [Open incoming items data record] » Tab: Item.

2.4. 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 » [Open incoming items data record] » Tab: Item.

2.5. Batch

Enter the batch of 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 » Incoming items » [Open incoming items data record] » Tab: Item.

2.6. Purchase price

Enter the purchase price of the stock into your CSV file.
Note: When importing negative stock, the purchase price is not overwritten.

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 Item » Edit item » [Open item] » Tab: Stock » Tab: Item movement.

2.7. Reason for stock correction

Enter the reason for the stock correction.

Default value: 300

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 stock correction

301

Stock correction because of BBD

302

Stock correction because of stocktaking

304

Stock correction because of manufacturer error

305

Stock correction because of maculature

306

Stock corrector because of packing error

307

Stock correction because of damage

309

Stock correction (internal offset)

317

Stock correction because of BBD

318

Stock correction because of shipping items to FBA

319

Stock correction because of shipping items to fulfilment service provider

320

Stock correction because of sample for interested parties

321

Stock correction because of sample for customers

322

Stock correction because of sample

323

Stock correction because quality models are booked in

324

Stock correction because quality models are booked out

325

Stock correction because of gift

326

Stock correction because of malfunction (without return)

327

Stock correction because of loss

330

Stock correction because of own use