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 NameRequiredAdditional Information
Date and Time (Inbound)YesDD/MM/YYYYTHH:MM
SKU NameYesName or ID
SKU IDYesID or Number
SKU WeightYesAccept different units
Slot IDYesID or Number
Units Per PalletYesNumber
Slot CoordinatesYesNumbers in tuple
Product CategoryYesName
Unit PriceNoPrice per unit
SKU QuantityYesNumber
Supplier NameYesName or ID
Orders

The allowable headers for the orders are:

Variable NameHeader NameAdditional Information
ToYesLocation
DateYesDD/MM/YYYY
FromYesLocation
TimeYesHH:MM
WeightYesAccepts different units
QuantityYesNumber
Customer IDYesName or Number
Operator NameYesName
Deliver By DateYesDD/MM/YYYY (Has to be older that the Date field)
Deliver By TimeYesHH:MM
Order ID (Inbound)YesName, ID or Number