Skip to main content

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, plentymarkets 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:

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


2.2. Quantity

Required field

Enter the quantity of the stock into your CSV file.

Default value: No default value

Permitted import values: Numeric


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


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


2.5. Batch

Enter the batch of the stock into your CSV file.

Default value: No default value

Permitted import values: Numeric


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

To top