1. What is the Order Mapper in eShipz?
The Bulk Order Mapper is a feature in eShipz that allows you to upload multiple orders at once using an Excel file. Instead of creating orders one by one, you can map your Excel columns to eShipz fields and upload all your orders in a single step, saving time and reducing manual effort.
2. Steps to create and Map your own Excel format for Order bulk upload
A. How do I access the Bulk Order Mapper?
Step 1: Log in to your eShipz account.
Step 2: From the left-hand navigation menu, click on Fulfillment.
Step 3: Click on Orders.
Step 4: Click on the Create Order button.
Step 5: Click on bulk and then click on Manage Mapper.
Step 6: The Bulk Order Mapper page will now open.
B. How do I prepare my Excel file for upload?
Before uploading, make sure your Excel file is correctly formatted:
Step 1: Verify that the following details are included for each order: Order id, Shipper and Consignee address, payment type, product name, order value.
Step 2: Ensure the country name exactly matches the country name used in eShipz (including the country code, state code etc).
Step 3: Save your Excel file in the correct format (.xlsx or .csv as supported by eShipz).
Step 4: Double-check for any blank rows, missing values, or formatting inconsistencies before uploading.
Note: Incorrect or mismatched country names may result in upload failures or data errors.
C. How do I upload my Excel file?
Once your file is ready, follow these steps to upload it:
Step 1: On the Manage Mapper page, click on the Upload excel file button.
Step 2: Browse your device and select the prepared Excel file.
Step 3: The file will be uploaded and its columns will be displayed for mapping on left hand side.
Step 4: Proceed to the column mapping step.
D. How do I map my Excel columns to eShipz fields?
Column mapping ensures eShipz correctly reads and processes your data. Follow these steps:
Step 1: After uploading your file, the system will display your Excel columns alongside eShipz required fields.
Step 2: Match each column in your Excel file with the corresponding eShipz field (e.g., map your 'Customer Name' column to 'Consignee Name' in eShipz).
Step 3: Ensure all mandatory fields are mapped correctly.
Step 4: Once all fields are mapped, click Save to store the mapping.
Note: Incorrect mapping may cause errors during order processing. Always verify each field match before saving.
3. How do I edit or modify an existing mapper?
If you need to update or change your mapping, follow these steps:
Step 1: Click on edit icon corresponding to that mapper
Step 2: Re-upload your Excel file by clicking upload file on the Manage Mapper page.
Step 4: Once all edits are done, click Save to update the mapper.
Note: Re-uploading the file will allow you to modify the mapping without losing your previous configuration.
Note: Incorrect mapping or mismatched country names may result in errors during upload. Always verify the format and field names before submitting the file.