Skip to main content

stockMovement

Use the stockMovement format to export stock movements.

1. StockMovements

[table-fields-Item] lists the fields available for exporting data about stock movements.

Table 1. Fields for exporting stock movements
Field Explanation

attributeValues

Attribute values

createdAt

Timestamp of the stock movement, as it is displayed in the variation’s Stock movement tab.

id

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.

itemId

Item ID

processRowId

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.

processRowType

ID of the source type of a stock movement. The source type refers to the menu or action that triggered the stock movement.

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

reason

ID of the stock movement reason

reasonString

Name of the stock movement reason

storageLocationName

Storage location name

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.

2. User

Table 2 lists the fields available for exporting user data.

Table 2. Fields for exporting user data
Field Explanation

id

ID of the user who booked the stock movement

user

Name of the user who booked the stock movement

3. Variation

Table 3 lists the fields available for exporting variation data.

Table 3. 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 included in the stock movement

number

Variation number

variationTag

Variation tags

4. custom_value

Table 4 lists the fields available for exporting custom values.

Table 4. Fields for exporting custom values
Field Explanation

custom_value

Own value for export

5. date

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

Table 5. Field for exporting the current date
Field Explanation

date

Current date

To top