User Applications Overview
Order Management System Adminstration
Order Management System Adminstration
  • Introduction
  • Order Management
    • Sales Orders Page
      • Search Sales Orders
      • Export CSV
    • Sales Order View Page
      • Manage Auto-Cancel Date
      • Cancel Sales Order
      • Update Shipping Information
      • Edit Sales Order
      • Release Items
      • Reject Items
      • Ship Items
      • Associate Items to PO
      • Move Items to Parking
      • References
      • Communications
      • Refresh Sales Order
    • Sales Returns
      • Create Return Page
        • Create Order Returns
      • Find Sales Return Page
        • Search Sales Returns
        • Filter Sales Returns
        • Export CSV
        • Sales Return View Page
          • Cancel Sales Return
          • Edit Sales Return
          • Reject Sales Returns
          • References
          • Communications
    • Filter Purchase Orders
  • Relationship
    • Create Employee
    • View Employee
      • Search Employee
    • Employee Profile Detail
  • Product Information Management (PIM)
    • Products Page
      • Search Products
      • Filter Products
      • Export CSV
      • Manage Inventory Configuration
      • View Inventory Computation
    • Product View Page
      • Update Product Information
      • View Product Inventory
    • Category Management
      • Categories Page
        • Search Categories
      • Category View Page
        • Search Products in Category
        • Add or Remove Products
        • Show Old
        • View Decision Reason
  • Warehouse
    • Facilities Management
      • Facilities Page
        • Search Products
        • Filter Products
        • Sell Online Preference
        • View Order limit Computation
      • Facility View Page
        • Update Facility Information
    • Inventory Management
      • Inventory Page
        • Search Products
        • Filter Products
        • View Inventory Overview
      • Product Inventory View Page
        • View Product Inventory at Facility
        • Record Variance
        • View and Edit Inventory Configuration
          • Overview Section
          • Global Settings Section
          • Inventory Configurations Section
            • Add Facility
            • Edit Facility Configuration
  • Procurement
    • Purchase Order
      • Search Purchase Orders
      • Filter Purchase Orders
      • Export CSV
    • Purchase Order View Page
      • Update Purchase Order
        • Sync Date with SO
        • Allocate Sales Orders
        • Review Allocations
        • Remove Allocations
  • MDM (Master Data Management)
    • Stores
      • Product Store Page
      • View Product Store Page
        • Company Details
        • Edit Store Configurations
        • Product Store Facility
        • Change Brokering Configuration
    • EXIM
      • EXIM Page
        • Import CSV
          • Cancel Sales Orders Items
          • Create and Update Store Employee
          • Reset inventory
          • Import Sales Orders
          • Purchase Order
          • Update Safety Stock
          • Update Order Item Parking Facilities
          • Import Product Category Member
          • Update Carrier Postal Code
          • Add or Update Facility information
          • Update Facility Locations
          • Import Inventory
          • Update Shipment
          • Replace Product in Existing Orders
          • Closed Purchase Order
  • Shopify
    • Create Shopify Shop
      • Create Shopify Shop Page
Powered by GitBook
On this page

Was this helpful?

  1. MDM (Master Data Management)
  2. EXIM
  3. EXIM Page
  4. Import CSV

Cancel Sales Orders Items

Allow users to bulk cancel sales orders in HotWax Commerce.

PreviousImport CSVNextCreate and Update Store Employee

Last updated 1 year ago

Was this helpful?

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:

  1. Navigate to: Hamburger Menu > MDM > EXIM > Imports > Order management > Cancel sales order items.

  2. Download the sample template CSV and fill it out with the required details.

  3. Click Choose file and select the CSV from your system.

  4. Click Upload.

  5. Check the status is updated as Finished in the .

To verify the uploaded data:

  1. Pick a random data from the uploaded CSV.

  2. Navigate to: Hamburger Menu > Find Orders Page.

  3. Search the data.

  4. 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

Result Section
Video: Cancel sales order items in bulk