Bulk Upload Guides

Quick primer on how to use our bulk upload template.



Welcome to a write up on how to properly use our Bulk Upload template!

Like most of people previously arrived here, you should have a lot of questions after your bulk upload file got rejected multiple times by our new validation engine.

So, lets do a little bit of question-and-answer session to explain this new Bulk Upload template.

Lets go:

Why should I use Bulk Upload Template?

For heavy ecommerce user that manage more than 10 shipment at a time with majority of the shipment are around the same variation of product, it is much faster to key in all the details in Microsoft Excel instead of key in one by one in the system.

In fact, you can upload up to 100 shipment details for this new version! (previous version only up to 50 shipment)

Tell me an overview on the steps

Step 1: Download the template in .xls format.

Step 2: Fill in all the details accordingly.

Step 3: Upload the complete .xls template file.

Step 4: System will validate the data. You may need to change some of the details and re-upload until success.

Step 5: All shipment will be ready in your cart. You can proceed to checkout.

Well, what are the major FAILS to avoid?

First: DO NOT CHANGE Anything in line 1 (title) and line 2 (column header). Your shipment details will get corrupted in an unexpected ways.

Second: DO NOT ADD, REMOVE or REARRANGE the column. Again: your shipment details will get mutated in an unexpected ways

Third: ONLY UPLOAD EXCEL (.xls) file.

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

Get ready, this gonna be a long one:

Column Rules Remarks
Parcel Content *requiredPlease use the dropdown options to choose. Do not type it by yourself.
Content DescriptionWill use default content description in your default settings if not given.
Value of goods (RM)Will use default content value in your default settings if not given.
Weight (Kg) *required3 decimal number from 0.001 up to 30.000, unit of Kilogram (KG).
Collection Date *Either in YYYY-MM-DD format (i.e. 2019-12-13) on in D/M/YYYY format (i.e. 13/12/2019). Only accept business days with maximum of 7 day in future from current date. Do not worry, system will give you a list of valid dates to choose from if your given date is invalid.
Sender NameMaximum of 35 characters. Will use Sender Name in your default pickup address if not given.
Sender Alt ContactPhone number without leading zero (i.e. 18765432 instead of 018765432) will be fixed automatically.
Sender EmailMaximum of 35 characters. Only valid email format. Will use Sender Email in your default pickup address if not given.
Sender EmailMaximum of 35 characters. Will use Sender Company in your default pickup address if not given.
Sender AddressMaximum of 140 characters. Will use Sender Address in your default pickup address if not given.
Sender PostcodeMaximum of 35 characters. Will use Sender Postcode in your default pickup address if not given.
Sender CityMaximum of 35 characters. Will be autofilled if not given.
Sender StateMaximum of 35 characters. Will be autofilled if not given.
Receiver Name *requiredMaximum of 35 characters.
Receiver Phone *requiredPhone number without leading zero (i.e. 18765432 instead of 018765432) will be fixed automatically.
Receiver Alt PhonePhone number without leading zero (i.e. 18765432 instead of 018765432) will be fixed automatically.
Receiver EmailValid email format only
Receiver CompanyMaximum of 35 characters.
Receiver Address*Maximum of 140 characters.
Receiver Postcode *Valid Malaysia Postcode only
Receiver CityWill be autofilled on if not given
Receiver StateWill be autofilled if not given
Receiver CountryPlease use the dropdown options to choose. Do not type it by yourself.
Courier *requiredPlease use the dropdown options to choose. Do not type it by yourself.

Wow, that was a lot to take. Anything else?

Well, in general: as long as you have no intention to abuse the system it should be fine. Do not worry to try. Our server is robust enough to not get exploded upon wrong upload details :-D.

Lastly: if you are used to previous excel template, we hope this new engine will be a better experience for you in the end. Hang a bit while learning this new template. It will be better at the end.

Ok, i`ve got to go to try it now!

Godspeed!

Copyright © 2019 by MyParcelAsia Sdn Bhd. All Rights Reserved.
Follow us: Facebook | Instagram | Twitter