• This interface facilitates you to upload the shipments in bulk quantity through an Excel sheet.

  • This interface is suitable for the merchants who are not using the picklists functionality.

  • All you need to do is to download the default format for bulk book shipment, update the shipment information and upload that file.

  • Each upload will be listed under the 'Task History' section with the upload status and other relevant data.

How do I book the shipments in bulk quantity through an Excel sheet?


To book shipment for bulk orders that are processed through the picklists, do the following:

  • Log in to the 'Anywhere Commerce Control Panel' by using your User Name (Email Address) and Password.


 Import Shipment

  • You will be navigated to the Dashboard page.


 Import Shipment

  • Click the  Import Shipment icon. The Orders & Leads section will be displayed as shown in the figure.


 Import Shipment

  • Click Book Shipment and select Import Shipment. You will be navigated to the Import Shipment page.


 Import Shipment

  • To download the default format for bulk book shipment, click the 'click here' link. The 'BulkBookshipment.xlsx' file will be downloaded.
  • To open the Excel, double-click the 'BulkBookshipment.xlsx' file. It will be opened as shown in the figure.


 Import Shipment

  • There are two sheets here, namely, Bulk Shipments and Description.
  • To know what to be filled in each column of the 'Bulk Shipments' sheet, click the 'Description' sheet. It will be displayed as shown in the figure.


 Import Shipment

  • Refer the definitions of each column and enter the relevant data in the 'Bulk Shipments' sheet as mentioned below:
    • OrderID: Enter Order ID of the products to be shipped.
    • Shipment booked date: Enter shipment booked date in DD-MMM-YYYY format.
      • Note: The shipment booked date should not be older than one month from the current date.
    • Courier/Logistics Provider Code: Enter the code of the logistics provider. The codes of the logistics providers are mentioned below. In the case of a custom provider, enter 'CUSTOM'.
    • Custom Provider Name: Enter the name of the custom logistic provider (if any).
      • Note:
        • When the courier/logistics provider code is ‘CUSTOM’, the 'Custom Provider Name' is mandatory.
        • When a valid logistics provider code is specified, the 'Custom Provider Name' should be blank.
    • AWB No: Enter the Air Way Bill number.
      • Note:
        • When courier/logistics provider code is ‘CUSTOM’, the AWB No. is mandatory.
        • When a valid logistics provider code is specified, the AWB No. should be blank.
    • SKU/Variant SKU: Enter the SKU of the product to be shipped. In the case of a variant product, enter the variant SKU.
    • Quantity: Enter the quantity to be shipped. Quantity shouldn’t be blank when SKU/Variant SKU is specified. Quantity is mandatory when SKU/variant SKU is specified.
    • Length: Enter the length of the package as a positive integer
    • Breadth: Enter the breadth of the package as a positive integer
    • Height: Enter the height of the package as a positive integer
    • Package Weight: Enter the weight of the package as a positive integer/decimal
    • Logistics Provider Name Logistics –> Provider Codes
      • Bluedart –> BlueDartAPI
      • Delhivery –> Delhivery
      • EcomExpress –> EcomExpress
      • Fedex –> Fedex
      • GoJavas –> Gojavas
      • OnlineExpress –> OnlineExpress
      • SpeedPost –> Speedpost
      • XpressBees –> XpressBees
      • Your Custom Provider –> CUSTOM
  • Save the Excel in a suitable location.
  • To upload the Excel, click Browse. An Open dialog box will be displayed.


 Import Shipment

  • Select the updated 'BulkBookshipment.xlsx' file and click Open.
  • The dialog box will be closed and the name of the selected file will be displayed in the Upload a file text box.


 Import Shipment

  • Click Upload. The file will be uploaded and each upload will be listed under the 'Task History' section in run-time with the upload status and other relevant data.


 Import Shipment

  • You can view the file that you have uploaded by clicking its  Import Shipment icon under the Action column.
  • You can also delete the 'uploaded task record' from Task History section by clicking the respective  Import Shipment icon under the Action column.
  • In the case of any upload failures due to validations or exceptions, you can find the  Import Shipment icon under the Action column. To view the 'log summary' of a failed upload, click the respective  Import Shipment icon under the Action column. You will be navigated to the Error Logs Summary page.


 Import Shipment

  • Review the error logs, update the respective data and upload the file again.