Description
This report provides current inventory levels for a selected product that is lot and/or expiration date tracked. It includes lot number and expiration dates, lot status and quantity per fulfillment center.
Purpose
The purpose of this report is to provide a detailed breakdown of the lot tracked and expiration tracked inventory. The report will only be available if the selected product is enabled for lot tracking and/or FEFO fulfillment.
Please note if you attempt creating the report for a product that is not enabled you will receive an error and no report will be generated.
Documentation
|
Column |
Description |
| DSKU |
Flexport's unique identifier for the product |
| MSKU |
Merchant's unique identifier |
| PRODUCT_NAME |
Name of the SKU in inventory |
| LOT_NUMBER |
Lot number tied to the inventory. This number is provided by the merchant and validated (or captured) during receiving. |
| EXPIRATION_DATE |
Expiration date for the inventory |
| DAYS_UNTIL_EXPIRY |
Number of days left until the inventory expires |
| QUANTITY |
How many units are on-hand |
| WAREHOUSE_ID |
Fulfillment center in which the inventory is located |
| LOT_STATUS |
Status of said lot, can have the following values: |
| SHIPPINGPLAN_ID |
The shipping plan id the inventory was a part of. The units are available for FEFO a day after the inbound shipment is received at the warehouse. |