HCL Commerce Version 9.1.11.0 or later

.CSV file for Orders

The HCL Commerce Marketplace provides a .CSV file for Orders. This file contains all the information related to orders placed in the storefront.

This .CSV template contains information such as Order ID, Create date, Status, Part Number, Email ID, Phone number, Address etc. See the sample .CSV file for more information.

Marketplace Operators, Marketplace Sellers and Marketplace Administrators can download and view the .CSV file but only Marketplace Operators and Marketplace Sellers can update and upload the .CSV file.

Marketplace Operators or Marketplace Sellers can download the .CSV file and update the following details:
  1. Status - The .CSV file uses different letters to specify the status. The following table shows the letters with descriptions that are used to specify the status:
    Table 1. Order Status
    Order Status Description
    S Shipped
    X Cancelled
    M On-hold
    R Confirmed
    C Ready for processing
    • On-hold orders can be cancelled. (Change the status from M to X )
    • Ready for processing orders can be confirmed. (Change the status from C to R)
    • Ready for processing orders can be cancelled. (Change the status from C to X)
    • Confirmed orders can be shipped. (Change the status from R to S)
      Note: It is mandatory to update the shipmentTrackingNumber and shippedDate.
    Note: You can change the order status from the Order landing page as well.
  2. Shipping details of the shipped items can be edited from the .CSV file.
    Note: Upload order items and update the shipmentTrackingNumber and shippedDate in the .CSV file.