Order Status CSV Field Description

  • Updated
Spreadsheet Header Description Example Required
customerAccountNumber Your customers account number that identifies them in your system 123 yes
purchaseOrderNumber The order's PO number ABC123 yes
salesOrderNumber Your internal order number 12345678 yes
status The Status Name (case sensitive)
View Status Categories >>
Shipped yes
expectedShipDate The expected Ship Date
ISO 8601 format
expectedDeliveryDate The expected Delivery Date
ISO 8601 format
qualityProofUrl A HTTP link to the Proof    
additionalExplanation Additional Comments    
issue_id An ID for an outstanding issue 1  
issue_category The PromoStandards category for an issue (case sensitive)
View Issue Categories >>
Art Hold conditional yes
issue_name A descriptive name for the issue    
issue_description The detailed description of the issue    
issue_urgentResponseRequired True/false detailing urgency TRUE yes
issue_responseRequiredBy A date timestamp in UTC specifying the date when a response is need by. ISO 8601 format 2022-05-02T15:00:00  
issue_blockingStatus If this is blocking production    
contact_accountName The name for the contact    
contact_accountNumber If there is a different account number for the contact    
contact_type What kind of contact is this    
contact_attentionTo Attention to a specific person information    
contact_companyName The company name for the contact (could be used for external    
contact_address1 Address line 1    
contact_address2 Address line 2    
contact_address3 Address line 3    
contact_city Address City Gardner  
contact_region Address region    
contact_postalCode A date timestamp in UTC specifying the valid timestamp depicting when the inventory will be available for allocation to sales orders. 66030  
contact_country Country in ISO format US  
contact_email Email address for the contact    
contact_phone Phone Number for the contact    
contact_comments Comments to be directed to the contact    
product_purchaseOrderLineNumber The line on the purchase order this refers to 1  
product_salesOrderLineNumber The line on the sales order (internal) that this refers to 1 yes
product_supplierProductId The suppliers productId for the product ABCD2345 yes
product_supplierPartId The suppliers partId for the product RED  
product_quantityUom The unit of measure (case sensitive)
View unit of measure values >>
EA yes
product_quantityValue The Quantity ordered 1200 yes

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request