Import Sales Orders

Facilitate users to upload sales orders.

Orders are auto imported in HotWax Commerce through scheduled services.

Usage:

• Download sample file and input required data in the given fields in predefined format.

• Upload the updated CSV file to create or update sales order or any item values in OMS, under Order Management menu.

• Check the status is updated as Finished in the Result Section.

Refer to the table for CSV field details.

CSV Fields	Descriptions	Required Fields
Order Id	HotWax Commerce Order Identification value	Optional
External-id	Shopify Order Identification value	Mandatory
Order-identification	Shopify Order Identification from the shopify view order page URL	Optional
Product-store-id	Product Store Identification value	Mandatory
External-product-store-id	Shopify Product Store Identification value	Optional
Item-status-id	Item Status Id Note: Status Types as Created, Approved or Completed or Canceled	Mandatory
Facility-id	HotWax Commerce Facility Identification value	Optional
External-facility-id	Facility Identification in external system value	Optional
Placing-facility-id	HotWax Commerce Identification of facility where order is placed	Optional
External-placing-facility-id	External Facility Identification where order is placed	Optional
Customer-id	Customer’s Identification value	Optional
Customer-external-id	Shopify Customer’s Identification value	Optional
First-name	Customer’s first name	Mandatory
Last-name	Customer’s last name	Mandatory
Address-line-1	Customer’s shipping address	Mandatory
Address-line-2	Customer’s shipping address	Mandatory
City	Customer’s shipping city	Mandatory
Postal-code	Customer’s shipping area code	Mandatory
State	Customer’s shipping code	Mandatory
Country	Customer’s shipping country	Mandatory
Phone	Customer’s Phone number	Mandatory
Email	Customer’s Email Id	Mandatory
Order-date	Order Placed Date in MM/DD/YYYY format	Mandatory
Product-id	HotWax Commerce Product Identification value	Optional
Product-id-value	Universal Product Identification value	Mandatory
Item-external-id	Identification of the item in external system	Optional
Quantity	Ordered item Quantity	Mandatory
Unit-price	Unit Price of Item	Optional
Unit-list-price	List Price of Item	Mandatory
Item-total-discount	Discount amount	Mandatory if any
Grand-total	Order Total amount after discount	Mandatory
Payment-method	Payment method identification	Mandatory
Shipping-charges	Shipping-charges value	Mandatory if any
Shipping-tax	Tax amount on shipping	Mandatory if any
Item-total-tax	Total tax on Order amount	Mandatory if any
Shipment-method-type-id	Shipping Method Type Identification	Mandatory
Carrier-party-id	Carrier Party Identification value	Mandatory if any
Sales-channel-code	Sales Channel Identification value	Mandatory