Forums

menu

Forum

Is it possible to change the formula/threshold of what determines low stock for a single product using the WMS adapter's built in function?
Author
Thread
Is it possible to change the formula/threshold of what determines low stock for a single product using the WMS adapter's built in function?
Author Darren Smith
October 23 2017 @ 03:14 PM
Thread In a TOTECS project that is connected to the Datapel Warehouse Management System using the Connector software, is it possible to change the formula/threshold of what determines low stock for a single product, using the WMS adapter's built in function?


TOTECS - Ecommerce Services Coordinator
Comments
Rowan Drew
October 23 2017 @ 04:27 PM
TOTECS Software Development Manager
Within the Connector's Datapel Warehouse Management System adaptor, the Products data export has a number of fields that control different aspect of stock availability.

In the WMS adaptor's data export the column labelled "Out Of Stock Indicator Level" is mapped to the standards "stockNoneQuantity" field. This field determines what the stock quantity of product needs to be at to be considered out stock.
In the export the column labelled "Low Stock Indicator Level" is mapped to the standard's "stockLowQuantity" field. This field determines what the stock quantity of product needs to be at to be considered low in stock. If the product's available stock quantity is greater than the number set in this field then the product is considered to be high in stock.
In the export the column labelled "Avialable Stock Quantity Level" is mapped to the standards "stockQuantity". This field determines the quantity of stock that is available for the product.

For each of these product fields if you wish to configure them based on custom calculations or factors then you need in the data export fields you need to turn on the "Set Custom Field" checkbox for each field, then in the "Custom Data Field Definition" field set a SQL column clause that determines how the quantity is calculated for each.

Comment has been marked as the answer

Hello! Register or login to become part of the discussion