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.
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 |
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 |
Last updated