How do I move the dispatched orders in a bulk quantity to the delivered orders list through an Excel sheet?
To move the dispatched orders in a bulk quantity to the delivered orders list through an Excel sheet, do the following:
- Log in to the 'Anywhere Commerce Control Panel' by using your User Name (Email Address) and Password.
- You will be navigated to the Dashboard page.
- Click the
icon. The Orders & Leads section will be displayed as shown in the figure.
- Click Bulk Operations and select Bulk Operations. You will be navigated to the Bulk Operations > Perform Bulk Operations page.
- Select Dispatch to Deliver from the Order Queue drop-down.
- You have two options for downloading the required Excel sheet.
- 1. You can download the required Excel template from this page, fill the respective data, and upload.
- 2. You can directly upload the updated BulkDeliver.xlsx which is downloaded with the required order data through the Dispatched Orders page. Please refer: Export Bulk Deliver
- To download the required Excel template, select Dispatch to Deliver from the Order Queue drop-down, and click Download Template. The BulkDeliver.xlsx will be downloaded. Update the BulkDeliver.xlsx with relevant data.
- Select Dispatch to Deliver from the Order Queue drop-down.
- Click Browse. You will be displayed an Open dialog box.
- Note: In the case of the 'Chrome', the Open dialog box will be displayed. In the case of 'Mozilla Firefox, the File Upload dialog box will be displayed.
- Select the updated BulkDeliver.xlsx file from the stored location 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
- Click Upload. The file will be uploaded and the status of the upload will be updated under the Task History section in runtime.
- A 'task id' will be created for each Excel upload and separate 'job ids' will be created for each order within each task.
- You can find the detailed information of the upload such as the 'task id, task name, created date, last updated, the total number of rows, processed rows, failed rows, and task status' under the 'Task History' section.
- In the case of any failures in the upload, you can find a
icon against the task.
- You can navigate to the Error Logs Summary page by clicking that
icon. Read the error messages, rectify the data accordingly and upload the Excel again.
- Emails will be automatically triggered after uploading the Excel for successful orders.