Skip to main content

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.

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

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 variatione

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

To top