Order Processing in Bulk

How to access on Fynd Commerce

Processing individual shipments can indeed become time-consuming if there are too many of them. You need an easier way for handling multiple shipments at once. Fynd Commerce provides you with a Bulk Action section to handle multiple orders using Excel or CSV file. This guide provides detailed instructions on performing the following actions in the OMS:

Bulk Cancellation (Full)
Bulk Cancellation (Partial)
Bulk Confirmation (Full)
Bulk Confirmation (Partial)

Each section includes step-by-step guidance, including how to download and prepare the bulk file, what fields to fill, and how to upload the file back into OMS.

1. Bulk Cancellation (Full)

Step 1: Go to Find Commerce > Orders (OMS)

Locate the shipment you wish to cancel.
Navigate to the Bulk Action section.

Step 2: Download the Bulk File

In the Order Processing tab, use the dropdowns to filter by:
- Fulfillment Location
- Shipment Status
- File Type (CSV or XLSX)
Click Advanced Filter to filter by:
- Date Range
- Tags
- Sales Channel
- Delivery Partner
- Payment Methods
- Time to Dispatch
Click Apply Filter and then Download.

Step 3: File Structure and Field Descriptions

Each row represents a shipment. Below are the fields and their descriptions:

Field Name	Description
Order ID	Internal order identifier
Channel Order ID	Order ID from the sales channel
Order Date	Date of order placement
Shipment ID	Internal shipment ID
Channel Shipment ID	Shipment ID from the sales channel
Channel	Sales channel name (e.g., Myntra, Amazon)
Current Status	Current status of the shipment
Next Status	Status you want to update (use `canceled_fynd`)
Seller Identifier	SKU or identifier from seller's catalog
Size	Size of the product (if applicable)
Initial Quantity	Quantity originally ordered
Confirmed Quantity	Quantity to confirm (enter `0` for cancellation)
Cancel Quantity	Quantity to cancel (enter `1` for cancellation)
Defective Product	Enter `1` if product is defective (optional)
Product Not Available	Enter `1` if product is out of stock (optional)
Price Mismatch	Enter `1` if price discrepancy occurred (optional)
Others	Enter `1` if reason doesn't match above (optional)
Cancellation Remarks	Mandatory if 'Others' is selected
Brand Name	Brand of the product
Item Name	Name of the product
Item Code	Internal code for the item
Price	Selling price
Actual Price (MRP/MSRP)	Market retail price
Payment Mode	COD, Prepaid, etc.
Customer Name	Customer's name
Delivery City	Delivery city
Delivery Sector	Leave empty
Customer Number	Customer's phone number
State	Delivery state
Pincode	Delivery pincode
Address	Full delivery address
GSTIN	GST number if available
Store ID	Internal store identifier
Store Name	Name of the fulfilling store
Fulfilling Store Code	Code of the store
Fulfilling Store Priority	Leave empty
Customer Note	Leave empty
Channel Bag ID	Bag ID from channel
Packaging Material	Type of packaging used
Packaging Weight (in grams)	Total packaging weight
Lock Status	System-generated status
Due Date	Date by which it should be dispatched
Shipment Type	Delivery type (normal/express)
Identifiers	Internal reference values
Tag Number	Custom tag if added by user

Step 4: Fill the File for Full Cancellation

Next Status: canceled_fynd
Confirmed Quantity: 0
Cancel Quantity: 1
In one of these columns, enter 1 where applicable: Defective Product, Product Not Available, Price Mismatch, Others
If you choose Others, add a comment in Cancellation Remarks.
Leave the other optional columns blank unless needed.

Step 5: Save and Upload the File

Save the completed file.
Go back to OMS > Bulk Action.
Upload the file.

Step 6: Check Upload Status

Below the upload section, check file status:
- Completed: All shipments processed.
- Partially Completed: Some processed, others failed (e.g., incorrect values, missing reasons).
- Failed: Entire file failed due to format issues, missing values, or invalid statuses.

2. Bulk Cancellation (Partial)

Steps 1-3: Same as Bulk Cancellation (Full)

Step 4: Fill the File for Partial Cancellation

Delete rows for shipments you don’t want to cancel.
For remaining rows:
- Next Status: canceled_fynd
- Confirmed Quantity: 0
- Cancel Quantity: 1
- Fill one reason column (Defective Product, etc.) with 1 as applicable.
- If using Others, add a remark in Cancellation Remarks

Step 5-6: Same as Full Cancellation

3. Bulk Confirmation (Full)

Step 1: Go to OMS > Bulk Action

Step 2: Use the filters to download the shipment file, same as described earlier.

Step 3: Fill the File for Full Confirmation

Next Status: bag_confirmed
Confirmed Quantity: 1
Cancel Quantity: 0
No need to fill cancellation reason fields.

Step 4: Save and Upload

Save the file and upload it using Bulk Action tab.

Step 5: Check Upload Status (as described in Bulk Cancellation)

4. Bulk Confirmation (Partial)

Step 1: Go to OMS > Bulk Action

Step 2: Filter and download the bulk file.

Step 3: Fill the File for Partial Confirmation

For each row you want to confirm:
- Next Status: bag_confirmed
- Confirmed Quantity: 1
- Cancel Quantity: 0
For each row you want to cancel:
- Next Status: canceled_fynd
- Confirmed Quantity: 0
- Cancel Quantity: 1
- Enter 1 in the appropriate reason column:
  - Defective Product
  - Product Not Available
  - Price Mismatch
  - Others (if used, must fill Cancellation Remarks)

Step 4: Save and Upload

Save the updated file and upload via the Bulk Action tab.

Step 5: Check Upload Status

Review the processing result at the bottom of the Bulk Action page:
- Completed
- Partially Completed (with reason for failed rows)
- Failed (if no rows processed)

5. Bulk Customer Invoicing (B2C)

Use this process to update invoice numbers in bulk for multiple confirmed shipments.

Steps to Update Invoice IDs in Bulk

Go to the Bulk Action section in the OMS.
In the Order Processing tab:
- Select the Fulfilment Type
- Set the Status to Confirmed
- Choose the File Type (CSV or XLSX)
- Click Download
Open the downloaded file:
- Each row represents a shipment.
- If a single order contains multiple items, they will share the same Shipment ID.
- All rows with the same Shipment ID should be given the same Invoice Number in the Invoice ID column.
- Orders with different Shipment IDs should have different Invoice Numbers.
After entering the correct Invoice Numbers:
- Save the file
Go back to Bulk Action in OMS:
- Upload the saved file.
If all data is valid, the system will update the Invoice ID for each corresponding shipment.

6. Bulk Business Invoicing (B2B)

Video: Business Bulk Invoicing

7. Generating Invoices and Labels in Bulk

Use this process to generate and download invoices, labels, or both for multiple shipments at once.

Steps to Generate in Bulk

Go to the Bulk Action section in the OMS.
Navigate to the Invoice & Label tab.
Select the following filters:
- Fulfilment Type (based on your store or warehouse)
- Status: set this to To be Packed
- File Type:
  - Choose one: Invoice, Label, or Invoice + Label
  - Then select the format: A4, A6, or POS
Click Initiate Download.

Downloading the File

Scroll down to the section below where your file request appears.
Click the three dots (⋮) on the right side of the file entry to take one of the following actions:
- View Report: This opens a summary showing:
  - Requested On: Date and time of the request
  - Requested By: User who initiated the request
  - Bulk Invoice Status:
    - Total: Total number of invoices or labels requested
    - Success: Number of files successfully generated
    - Failed: Number of files that could not be generated
- Download: Click to download the generated file (Invoice, Label, or both—based on your selected file type).

1. Bulk Cancellation (Full)​

2. Bulk Cancellation (Partial)​

3. Bulk Confirmation (Full)​

4. Bulk Confirmation (Partial)​

5. Bulk Customer Invoicing (B2C)​

6. Bulk Business Invoicing (B2B)​

7. Generating Invoices and Labels in Bulk​