Bulk update order tracking Information

SHOPLINE_All-Plan.jpg

 

When SHOPLINE merchant use different delivery options like home delivery, SF Plus...etc, they will need to update tracking information frequently so that customer can track their parcels' delivery progress easily.

which delivery option can bulk update tracking number:

TW:

  1. Local courier
  2. International courier
  3. Delivery - Others
  4. Custom
  5. Pick-up - 7-11 Pickup (no integration)
  6. Pick-up - Family Mart Pickup (no integration)

HK:

  1. Local courier
  2. International courier
  3. Delivery - Others
  4. Delivery - SF Plus
  5. Pick-up - S.F. Express
  6. Pick-up - HOP!
  7. Pick-up -SF Plus
  8. Custom

There are 8 steps in this article to guide you how to bulk update order tracking information:

  Step 1: Enter bulk update tracking number page

  Step 2: Download Excel sample

  Step 3: Download order report

  Step 4: How to find tracking number, edit courier name and tracking URL

  Step 5: Edit Update status to shipped (Y/N) and Send notification email to customer(Y/N)

  Step 6: Upload Excel file

  Step 7: Modify failure result and re-upload

  Step 8: Verify update success

 

Step 1

Enter order index page and click button "Update tracking no." to enter bulk update page.

 

EN_step1_1.png

_____2017-10-20_16.34.50.png

 

Step 2

Please downland sample: bulk_upload_examle_en.xlsx 

 

_____2017-10-16_11.55.17.png

You can see the excel contains 6 fields:

  1. Order No.: required
  2. Tracking Number: required
  3. Courier Name: optional
  4. Courier Tracking URL: optional
  5. Update Status to Shipped(Y/N): optional
  6. Send Notification Email to Customer(Y/N): optional

 

Rules to follow while filling the excel:

  1. A maximum of 1000 orders can only be uploaded each time
  2. Order number can contain the symbol #. Tracking numbers for integrated order delivery option like 7-11/ Family Mart/ Ezship can't be updated with this function.
  3. Tracking number limit is 30 characters.
  4. Courier name limit is 20 characters.
  5. Courier tracking URL limit is 225 characters.
  6. Update Status to Shipped(Y/N):There is a limit that you must input half-width alphabet Y or N (Chinese/Japanese language input specific).
  7. Send Notification Email to Customer(Y/N):There is a limit that you must input half-width alphabet Y or N (Chinese/Japanese language input specific).
  8. You can update the same ordermany times, if you want to correct the wrong tracking number you previous uploaded, you can update again.
  9. If one excel file include two orders with same order number, then both of them would not be updated. Please confirm which one to keep and update a new file again.

 

Step 3

There are two ways to input the order number:

  1. When there are only a few orders to be updated, download sample and manual input order numbers.
  2. When there are a large number of orders to be updated, download order report and copy order number (no need to remove the symbol #) to sample file and upload.

  

EN_step3_1.png

_____2017-10-20_18.26.32.png

  

Step 4

Logistic partner will create tracking number for every order.

Merchant can show the tracking number to customer and let customer track own package.

For example: SF express website

 

_____2017-10-20_18.42.33.png

 

Input courier Name and URL can help customer track their own order(s) with the link to logistic partner website.

 

_____2017-10-20_18.42.52.png

 

Step 5

You can also update the following:

  1. Update delivery status to shipped.
  2. Send notification e-mail to customer when delivery status is updated to shipped.

These fields are optional, please leave the field blank if you do not want to update anything.

 

Step 6

_____2017-10-23_11.35.13.png___1.png

 

Step 7

If there are errors while importing, will direct to import result page.

You can download the excel for error results, and upload it after modifying with correct data/format.

 

_____2017-10-23_11.32.14.png

 

 

Step 8

If excel content has been updated successfully,  it will direct to order index and show success message.

You can view the changes in each order page.

 

_____2017-10-23_11.35.25.png

Have more questions? Submit a request

Comments