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 Darren Smith
October 23 2017 @ 03:14 PM
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
TOTECS - Ecommerce Services Coordinator
Hello! Register or login to become part of the discussion
October 23 2017 @ 04:27 PM
TOTECS Software Development Manager
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.