stock

Use the stock format to export stock data. During the import, the stock is corrected, meaning that the stock is changed to reflect the imported value. This is necessary for stocktaking.

Catalogue for export

Are you already familiar with the catalogue for exporting data formats? Catalogues are gradually replacing the old format types of the Elastic Export and offer you more usage and configuration options. Get all the essential information about catalogue functionalities on the manual page Catalogues: standard formats.

1. Item

Table 1 lists the fields available for exporting item data.

Table 1. Fields for exporting item data
Field	Explanation
flagOne	ID of the first item flag
flagTwo	ID of the second item flag
id	ID of the item
variationTag	Tags of the variation

2. ItemDescription

Table 2 lists the fields available for exporting item texts.

Table 2. Fields for exporting item texts
Field	Explanation
name	Name 1 of the item

3. Manufacturer

Table 3 lists the fields available for exporting manufacturer data.

Table 3. Fields for exporting manufacturer data
Field	Explanation
id	ID of the item manufacturer
name	Name of the item manufacturer

4. Stock

Table 4 lists the fields available for exporting stock data.

Table 4. Fields for exporting stock data
Field	Explanation
averagePurchasePrice	Average purchase price
averageSale	Average sale
reordered	Reordered quantity
reservedStock	Reserved stock
stockNet	Net stock
stockPhysical	Physical stock
warehousePriority	Priority of the warehouse

5. StockBatchBestBeforeDate

Table 5 lists the fields available for exporting batch numbers and best before dates.

Table 5. Fields for exporting batch numbers and best before dates
Field	Explanation
batch	Batch
bestBeforeDate	Best before date

6. StockStorageLocation

Table 6 lists the fields available for exporting storage location data.

Table 6. Fields for exporting storage location data
Field	Explanation
storageLocationId	ID of the storage location
storageLocationName	Name of the storage location

7. Variation

Table 7 lists the fields available for exporting variation data.

Table 7. Fields for exporting variation data
Field	Explanation
hasCalculatedBundleMovingAveragePrice	Indicates whether the moving average purchase price (net) is automatically calculated based on the individual components. 1 = Automatic calculation is activated. Empty field = Automatic calculation is not activated.
hasCalculatedBundleNetWeight	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.
hasCalculatedBundlePurchasePrice	Indicates whether the net purchase price is automatically calculated based on the individual components. 1 = Automatic calculation is activated. Empty field = Automatic calculation is not activated.
hasCalculatedBundleWeight	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.
id	ID of the variation
isActive	Variation is active 1 = Yes
model	Model of the variation
name	Name of the variation
number	Number of the variation
purchasePrice	Purchase price

8. VariationBarcode

Table 8 lists the fields available for exporting barcodes.

Table 8. Fields for exporting barcodes
Field	Explanation
code	Barcode of the variation

9. Warehouse

Table 9 lists the fields available for exporting warehouse data.

Table 9. Fields for exporting warehouse data
Field	Explanation
id	ID of the warehouse
name	Name of the warehouse

10. custom_value

Table 10 lists the fields available for exporting custom values.

Table 10. Fields for exporting custom values
Field	Explanation
custom_value	Own value for export

11. date

Table 11 lists the field available for exporting the current date. For further information, refer to this page.

Table 11. Field for exporting the current date
Field	Explanation
date	Current date