Bulk Upload

Why should I use Bulk Upload Template?

For users that want to create many orders in one click. Its is much faster to key in all the details in Microsoft Excel instead of keying in one by one in the system

Tell me an overview on the steps

Step 1: Download the template in the Multiple Parcel page.
Step 2: Fill in all the details accordingly.
Step 3: Upload the complete .xls template file. (maximum 200 order per upload)
Step 4: System will validate the data. System will show you the error that needs to be fixed and re-upload until success.
Step 5: All orders will be displayed in the cart.
Step 6: You can proceed to checkout after you confirm to make the order.

Well, what are the major FAILS to avoid?

1. Do not modify the template format
2. Always download the latest template format before you fill-up
3. This * symbol is required to fill-up
4. If you are copying from other excel or file, use CTRL + SHIFT + V hack to avoid accidentally pasting the format from source
5. Double check to ensure no missing information
6. Only upload excel(csv/xls/xlsx) file format

Can you tell me in detail what is the requirement for each column?

Column	Rules	Remark
Order Number	Optional	Index order number
Consignee Name	Required	Maximum of 35 characters
Adrdress Line	Required	Maximum of 100 characters
City	Optional	Will be auto filled on if not given
Postal Code	Optional	will be auto filled on if not given
Country	Required	Please use the dropdown options to choose. do not type it by yourself
Email	Optional	Valid email format only
Phone Number	Required	Valid phone number only
Shipment Weight (KG)	Required	Unit of Kilogram (KG)
Parcel Value	Required	Will use default value if not given
Is Insured	Required	Please use the dropdown options to choose. Do not type it by yourself
Insurance Value	Optional	Required if Is Insured is "Yes"
Is COD	Required	Please use the dropdown options to choose. Do not type it by yourself
Cash on Delivery Value	Optional	Required if Is COD is "yes"
Shipment Description	Required	Will use default value if not given
Service Provider	Required	Please use the dropdown options to choose. Do not type it by yourself
Is DropOff	Required	Please use the dropdown options to choose. Do not type it by yourself
Is Notify	Required	Please use the dropdown options to choose. Do not type it by yourself
Commodity ID	Optional	Valid Commodity ID only

**Note: Commodity ID can get from here or in second tab of bulk template

Bulk Upload Guides

Why should I use Bulk Upload Template?

Tell me an overview on the steps

Well, what are the major FAILS to avoid?

Can you tell me in detail what is the requirement for each column?

Power your Ecommerce store with Parcel Daily