Cancel Sales Orders Items
Allow users to bulk cancel sales orders in HotWax Commerce.
Orders are generally cancelled if upcoming inventory is no longer expected.
Only the order manager is able to perform bulk order cancellation.
MDM stands for Master Data Manager.
EXIM stands for Export Import.
To cancel sales order items in bulk:
Navigate to: Hamburger Menu > MDM > EXIM > Imports > Order management > Cancel sales order items.
Download the sample template CSV and fill it out with the required details.
Click Choose file and select the CSV from your system.
Click Upload.
To verify the uploaded data:
Pick a random data from the uploaded CSV.
Navigate to: Hamburger Menu > Find Orders Page.
Search the data.
Verify the status.
Refer to the table for CSV field details:
| Fields | Descriptions | Required |
|---|---|---|
Order-id | HC Order Identification value | Optional |
Order-external-id | Shopify Order Identification value | Mandatory |
Product-id | HC Product Identification value | Optional |
Product-sku | Universal Product Identification value | Mandatory |
Quantity | Quantity to be canceled | Mandatory |
Reason | Reason for cancellation (ReasonId) | Mandatory |
Reason field accepts reasonId in value.
Refer the table for rejection reasons:
| Reason Description | ReasonId |
|---|---|
CSR Delete Line | CSR_DLT_LINE |
Fraudulent order | FROUD_ORDER |
Item auto cancellation – unfillable | AUTO_CNCL_UNFILLBL |
Order placed for wrong item/color/size | WRNG_ITM_CLR_SIZE |
Preorder – can’t fill | PREORDR_CANT_FILL |
Review – Suspect Fraud | RVW_SUSPECT_FRD |
Review – suspect PayPal Fraud | RVW_SUS_PAYPAL_FRD |
Ship Date Delayed | SHIP_DATE_DELAY |
Test Order | TEST_ORDER |
Cancelled and Replaced | CNCLD_RPLCD |
Customer Request – Cancel | CST_RQST_CNCL |
Did not want to risk paying a return fee | NO_RISK_RTRN_FEE |
Failed Capture | FAILED_CPTR |
Found Better Price | BETTER_PRICE |
Found Free Shipping Elsewhere | FREE_SHIP_ELSEWHR |
Found in a store | FOUND_IN_STORE |
Last updated