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

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


2.6. Purchase price

Enter the purchase price of the stock into your CSV file.

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.


To top