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.
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:
|Parcel Content *||required||Please use the dropdown options to choose. Do not type it by yourself.|
|Content Description||Will 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) *||required||3 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 Name||Maximum of 35 characters. Will use Sender Name in your default pickup address if not given.|
|Sender Alt Contact||Phone number without leading zero (i.e. 18765432 instead of 018765432) will be fixed automatically.|
|Sender Email||Maximum of 35 characters. Only valid email format. Will use Sender Email in your default pickup address if not given.|
|Sender Email||Maximum of 35 characters. Will use Sender Company in your default pickup address if not given.|
|Sender Address||Maximum of 140 characters. Will use Sender Address in your default pickup address if not given.|
|Sender Postcode||Maximum of 35 characters. Will use Sender Postcode in your default pickup address if not given.|
|Sender City||Maximum of 35 characters. Will be autofilled if not given.|
|Sender State||Maximum of 35 characters. Will be autofilled if not given.|
|Receiver Name *||required||Maximum of 35 characters.|
|Receiver Phone *||required||Phone number without leading zero (i.e. 18765432 instead of 018765432) will be fixed automatically.|
|Receiver Alt Phone||Phone number without leading zero (i.e. 18765432 instead of 018765432) will be fixed automatically.|
|Receiver Email||Valid email format only|
|Receiver Company||Maximum of 35 characters.|
|Receiver Address*||Maximum of 140 characters.|
|Receiver Postcode *||Valid Malaysia Postcode only|
|Receiver City||Will be autofilled on if not given|
|Receiver State||Will be autofilled if not given|
|Receiver Country||Please use the dropdown options to choose. Do not type it by yourself.|
|Courier *||required||Please 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!