Skip to main content

Exporting stocks

This manual page contains information on the export format Stocks, which you can use in order to export stock data from your plentymarkets system by using catalogues. If you are not familiar with the usage of catalogues yet, refer to the manual page Managing catalogues first. There you will find out how to create and manage catalogues.

No export to marketplaces

The export format Stocks is a so-called standard format, which you can use to export data, but not to transfer data to a marketplace.

1. Available data fields

The following table lists all available data fields of the export format Stocks as well as an explanation on the meaning of these fields.

Table 1. Data fields for stocks
Data field Explanation

Item

Item ID

ID of the item

Flag 1

ID of item flag 1

Flag 2

ID of item flag 2

Variation tag

Tag of the variation

Manufacturer

Manufacturer ID

ID of the manufacturer

Manufacturer name

Name of the manufacturer

Batch / BBD

Batch

Batch of the variation

BBD

Best before date of the variation

Stock

Physical stock

Physical stock

Reserved stock

Reserved stock

Net stock

Net stock

Reordered quantity

Quantity of the reordered stock

Warehouse priority

The warehouse’s priority

Average purchase price

Average purchase price

Average sale

Average sale

Storage location

Storage location ID

ID of the storage location

Storage location name

Name of the storage location

Variation barcode

Variation barcode

Barcode of the variation

Item description

Item name

The item’s name 1

Variation

Variation ID

ID of the variation

Is active

The variation is active (1 = yes)

Variation number

Variation number

Model

Model of the variation

Purchase price

Purchase price of the variation

Price calculation UUID

The price calculation’s UUID. The ID is automatically generated when the calculation is created. This ID cannot be changed.
Tip: Do you want to copy the UUID? To do so, open the price calculation and click on the UUID in the lower left corner. The UUID is copied to the clipboard.

Variation name

Name of the variation

Customs tariff number

The variation’s customs tariff number

Has calculated bundle weight

Indicates whether the gross weight is automatically calculated based on the individual components.
1 = Automatic calculation is activated.
Empty field = Automatic calculation is not activated.

Has calculated bundle net weight

Indicates whether the net weight is automatically calculated based on the individual components.
1 = Automatic calculation is activated.
Empty field = Automatic calculation is not activated.

Has calculated bundle purchase price

Indicates whether the purchase price is automatically calculated based on the individual components.
1 = Automatic calculation is activated.
Empty field = Automatic calculation is not activated.

Has calculated bundle moving average price

Indicates whether the moving average price is automatically calculated based on the individual components.
1 = Automatic calculation is activated.
Empty field = Automatic calculation is not activated.

Warehouse

Warehouse ID

ID of the warehouse

Storage location quantity

Quantity of the stock that is available on the storage location

Warehouse name

Warehouse name

2. Adding filters

In order to only export specific stock data, you can select filters and thus narrow down the data. How to add filters is described in this chapter.

2.1. Available filters

The following table lists all available filters for the export format Stocks and gives an explanation on the usage of the respective filter. You may also select several filters and for example filter by stock from a specific warehouse and a specific flag.

Table 2. Filters for stocks
Filter Explanation

Active

Filters by active or inactive variations.

Flag 1

Filters by the flag 1 that is saved on the variation.

Flag 2

Filters by the flag 2 that is saved on the variation.

Date

Filters by a particular date that you can select via the calendar.
Thus, this filter allows you to export stock that existed at a specific date.

Manufacturer

Filters by manufacturer.

Warehouse

Filters by variations from the selected warehouse.
Note: If you don’t select a warehouse, the stock from the warehouse with the lowest ID is selected automatically.

Group by

Allows to group by warehouse. The variation’s stock is shown per warehouse (not per storage location, BBD or batch).

Hide empty stock entries

Hide stock 0 entries after defined time period

Hides all stock entries of 0 that have exceeded the defined time period.

Hide all stock 0 entries

Hides all stock entries of 0.

To top