Inventory CSV Field Description

  • Updated
Spreadsheet Header Description Example Required
productId The product id 123 REQUIRED
partId The part id 123456 REQUIRED
replenishmentLeadTime Time to replenish buy to order or made to order 3 Optional
attributeSelection A string describing the attribute of the product other than size and color   Optional
fobId The Id of the FOB Point 1 REQUIRED
quantityValue The quantity value (no commas) 10000 REQUIRED
quantityUom The unit of measure 
View unit of measure values >>
EA REQUIRED
futureAvailability1_quantityValue Future net available inventory quantity for the part/inventory location combination indicating goods on order or future quantity at manufactured goods. 250 Optional
futureAvailability1_availableOn A date timestamp in UTC specifying the valid timestamp depicting when the inventory will be available for allocation to sales orders. 05/01/2022 Optional
futureAvailability2_quantityValue Future net available inventory quantity for the part/inventory location combination indicating goods on order or future quantity at manufactured goods. 250 Optional
futureAvailability2_availableOn A date timestamp in UTC specifying the valid timestamp depicting when the inventory will be available for allocation to sales orders. 05/01/2022 Optional
buyToOrder Indicates that the supplier purchases this product to order. "TRUE" or "FALSE" Optional
manufacturedItem Indicates that the supplier produces this part according to demand. "TRUE" or "FALSE" REQUIRED

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request