Inventory and Orders
Overview
Inventory and Orders are tables that store and display information about the warehouse items/SKUs and orders for picking. Think of it as a database that matches the data from the WMS.
How does it work?
Syncware uses a 3rd party software called OneSchema to handle efficiently .csv (Comma separated values) and .xlsx (Excel) files.
(The information sent to OneSchema is kept safe and confidential and is deleted regularly).
What format does Syncware accepts?
Inventory
The allowable headers for the inventory are:
Header Name | Required | Additional Information |
---|---|---|
Date and Time (Inbound) | Yes | DD/MM/YYYYTHH:MM |
SKU Name | Yes | Name or ID |
SKU ID | Yes | ID or Number |
SKU Weight | Yes | Accept different units |
Slot ID | Yes | ID or Number |
Units Per Pallet | Yes | Number |
Slot Coordinates | Yes | Numbers in tuple |
Product Category | Yes | Name |
Unit Price | No | Price per unit |
SKU Quantity | Yes | Number |
Supplier Name | Yes | Name or ID |
Orders
The allowable headers for the orders are:
Variable Name | Header Name | Additional Information |
---|---|---|
To | Yes | Location |
Date | Yes | DD/MM/YYYY |
From | Yes | Location |
Time | Yes | HH:MM |
Weight | Yes | Accepts different units |
Quantity | Yes | Number |
Customer ID | Yes | Name or Number |
Operator Name | Yes | Name |
Deliver By Date | Yes | DD/MM/YYYY (Has to be older that the Date field) |
Deliver By Time | Yes | HH:MM |
Order ID (Inbound) | Yes | Name, ID or Number |
Updated over 1 year ago