Stock

1. Stock

Table 1 lists the fields available for exporting 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.

Table 1. Fields for exporting stock
Field	Explanation
averagePrice	Average price
batch	Batch
bestBefore	Expiration date
bundle	Package
itemDescriptionName	Name of the item description
itemFlagOne	Flag 1 of the item
itemFlagTwo	Flag 2 of the item
itemId	The item’s ID
itemManufacturerId	Item manufacturer ID
itemManufacturerName	Name of the item manufacturer
purchasePrice	Purchase price
reordered	Reordered
reservedStock	Reserved stock
stock	Stock
storageLocationId	ID of the storage location
storageLocationName	Storage location name
variationBarcode	EAN code of the variation
variationId	ID of the variation
variationIsActive	The variation is active.
variationModel	Model of the variation
variationName	Name of the variation
variationNumber	Variation number
variationTags	Tags of the variation
warehouseID	ID of the warehouse

2. StockMovement

Table 2 lists the fields available for exporting stock movement data.

Table 2. Fields for exporting stock movements
Field	Explanation
attributeValues	Attribute values
deliveryNoteNumber	delivery note number
entryDate	Date of the stock movement
itemId	Item ID
quantity	Quantity of items included in the stock movement. The leading sign shows if stock was booked in or out. -: Stock was booked out +: Stock was booked in
reasonId	ID of the stock movement reason
reasonString	Name of the stock movement reason
sourceId	Source ID of the stock movement. The source can be an order or incoming items. Thus, the source ID can be an order ID or the ID of incoming items.
sourceTypeId	ID of the source type of a stock movement. The source type refers to the menu or action that triggered the stock movement.
stockProcessId	Process ID of the stock movement. You can see the process ID in the data set of a variation in the Stock movements tab of the variation.
storageLocationName	Storage location name
userId	ID of the user
UserName	Name of the user who booked the stock movement
variationId	ID of the variation included in the stock movement
variationNumber	ID of the selection of attributes
variationTags	Tags of the variation
warehouseId	ID of the warehouse that the stock was booked into our out from.
warehouseName	Name of the warehouse that the stock was booked into our out from.

3. custom_value

Table 3 lists the fields available for exporting custom values.

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

4. date

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

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