How to Create and Map your own Excel format for Order/Shipment Bulk Upload?

How to Create and Map your own Excel format for Order/Shipment Bulk Upload?

eShipz allows you to upload your own Excel file format for shipment processing. To ensure successful data import, you need to map your Excel columns to the required fields defined by eShipz.

Step 1: Hover over Excel Upload-> Click Shipments/Orders



Step 2: Under Manage Excel Mapping->Click add/edit excel


Step 3: Mapping - 
1. Prepare and Upload Your Excel File
  1. Ensure your Excel sheet is formatted and includes all necessary details like consignee name, address, pincode, country, etc. and click on select file to upload.


2. Map Your Excel Columns
  1. Match each column in your Excel file with eShipz’s required fields.
  2. This mapping ensures that the platform correctly reads and processes your data.


3. Select a Saved Mapper 
  1. From the dropdown menu, select your predefined mapper (if already saved) and click Save once you have mapped all the fields.

Step 4: Edit/Modify the fields
To modify the fields, re upload the same file and make the necessary changes and click Save.

Step 5:
a. Upload Your File
  1. Once the mapping is done, upload your Excel file to the system.
b. Country Field Validation
  1. Ensure that the country name mentioned in your Excel file exactly matches the country name used in eShipz (including the country code, if applicable).
This prevents data mismatches or upload failures.

You have successfully Mapped your own Excel.

Note: Incorrect mapping or mismatched country names may result in errors during upload. Always verify the format and field names before submitting the file.

    • Related Articles

    • How to do Bulk Orders or Bulk Shipments Excel Upload?

      If you wish to upload Shipments in bulk - Step 1 : Login to eShipz account Step 2 : Click on the Excel option in the Menu bar Step 3 : To upload Shipments, Click on Shipments Step 4 : There are 2 options here - upload excel file and excel ...

    • How to do bulk warehouse upload?

      Step 1: Login to your eShipz Account Step 2: Dashboard > Click on Settings > Click on bulk warehouse upload Step 3: Download the Excel file template Step 4: Fill all the required details & upload the file Step 5: Bulk Warehouse address for the ...

    • How to create a Reverse shipment?

      Method-1 Step-1: Sign in to eshipz account Step-2: Go to dashboard and click on the "Orders" Step-3: Under "Orders" section, select "Shipped Orders" Step-4: Choose the specific order for which you want to create a reverse shipment Step-5: On the ...

    • How to create shipment for CSB 4 & 5?

      CSB4 - Shipment Creation To cater to the new csb4 requirements, eShipz has come up with a CSB4 checkbox in the Create Shipment page that would enable user to enter additional data required for processing csb4 shipments. Enhancements Bank Account ...

    • How to create shipment & generate AWB?

      This Video guide will help you in how to create shipment & generate AWB with eShipz a multi platform solutions for businesses. Step 1. Sign into your eShipz account Step 2. Go to the dashboard and click on create shipment Step 3. Under create ...