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, PlentyONE checks if the imported data record already exists based on the matching field.
| Mapping field | Explanation |
|---|---|
Item ID |
ID of the item |
Variation ID |
ID of the variation |
Variation number |
Variation number |
Barcode |
Barcode |
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:
-
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 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 » [Open 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 » [Open 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 » [Open 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 » [Open 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 » [Open 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].
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 |
|
|
Incoming items |
|
Incoming items WE |
|
Recognition inventory |
|
Derecognition cancelled producer |
|
Maculation cancelled |
|
Pack failure cancelled |
|
Dispensation claim cancelled |
|
Incoming items (logistic) |
|
Incoming items (import) |
|
Incoming items (reorder) |
|
Outgoing items cancelled |
|
Stock rotation inventory hike |
|
Incoming items (second choice) |
|
Recognition correct |
|
Return expensed |
|
Incoming items picking |
|
Incoming items purchase order |
|
Incoming items warehousing |
|
Incoming items found source |
Reason for the import of negative quantities |
|
|
Outgoing items |
|
Outgoing items WA |
|
Derecognition inventory |
|
Return to producer |
|
Derecognition producer failure |
|
Derecognition maculation |
|
Derecognition pack failure |
|
Derecognition damage |
|
Derecognition dispensation claim |
|
Outgoing items (logistic) |
|
Outgoing items (import) |
|
Stock rotation inventory reduction |
|
Outgoing items (second choice) |
|
Derecognition correct |
|
Derecognition defect (without return) |
|
Outgoing items purchase order |
|
Outbound loss |