The Inventory page shows an overview of all the items in your inventory, across all warehouses. It features a table that allows you to sort by Item name, Product ID, SKU ID, Available stock, and amount In-transit and a search field to make finding items easy.
The Import button at the top of the page allows you to upload inventory information in a CSV file. Clicking the button opens the Import CSV file modal. It is highly recommended that you download the template file to use as a guide. Not following the parameters in the guide will result in errors.
Any CSV file you upload must match the following headers and corresponding data formats with no blank spaces, returns, line breaks, or other characters:
SKU - Unique identifier for the product or item
Total Quantity - The total amount of product
Reserved Quantity - For first upload, this must be zero "0". For subsequent updates, use the reserved number from the inventory item details page
Location ID - Warehouse ID
Type - This can be either "Stock" or “Transit” if the inventory is in transit
Channel ID - The channel ID must be either "12" (USA Web) or "13" (Canada Web)
Transit Ref - The transit reference number
Transit Order Date - The transit order date in UTC Format (yyyy-mm-ddThh:mm:ss.sssZ). This date must be prior to the Transit Stock Date
Transit Stock Date - The transit stock date in UTC Format (yyyy-mm-ddThh:mm:ss.sssZ)
Note: Inventory cannot be updated manually in Copilot at this time. Inventory must be added through .CSV file import.
Click on an item in the table on the main Inventory screen to view additional information, like the amount of the item in reserve or in-transit. Use the Select Warehouse drop-down menu to view the available, reserved, and in-transit numbers for the product by specific warehouse facility.
Last update: Apr 20, 2022