4.3.1.1 Import in Bulk through Excel

If the cargo data is not maintained in database and the quantity is large, you can import the cargo data in batches through the excel template.

Let's use an example to explain more: add following 12 kinds of goods to the task.

Name	quantity	length（mm）	width（mm）	height（mm）	weight（kg）
A	20	860	950	2020	10
B	15	860	980	2020	8
C	18	980	980	1120	7
D	42	680	600	640	5
E	40	610	600	600	3
F	20	820	710	790	8
G	25	590	520	560	2
H	40	670	550	610	5
I	54	870	855	270	17.7
K	65	890	690	450	21.5
L	60	1500	690	470	24.6
M	40	820	560	340	18.9

Specific steps:

1)Click [Cargo] on the left to enter the cargo interface. First, you should get the import template, click [Get Excel Template] under [Add Cargo] to download the template, open and fill in it.

2)Read the “template description” firstly, and then fill in the template. ①First copy the name, quantity, length, width, height and weight of the goods into the template, which are required items in red. Pay attention to the matching of the units. Note: The size units in the order is mm, therefore we also need to change the units in the template to mm. “Weight” refers to the gross weight of a single carton or box of goods. If the cargo is too light, the “Weight” can be ignored and not filled in, and the system will default to "1".

②Then define the load orientations of the goods. There are six load orientations: stand, stand & rotate, side, side & rotate, lay and lay & rotate. Leave it blank or “1” means allowed such placement method, “0” means not allowed. For example, only stand and stand & rotate are allowed.

"Support others" is to define whether goods can only be stacked by themselves not other goods. Blank or “1” is allowed, “0” is not allowed. "Max stack" refers to the maximum number of layers allowed to be stacked on the goods themselves. No need to fill in if there is no such requirement.

"max overhang ratio" is not required to fill in if there is no such requirement. For detailed explanation, please refer to the help document.

③ Fill in the loading attributes of the cargo: just fill in the required parameters, the ones that are not required can be ignored. Please refer to the help documentation for detailed explanation of each parameter.

If the cargo has a loading requirement that the heavier cargo can not be placed on the lighter cargo, we can use the "stacking order" to satisfy it. The value of "stacking order" indicates the vertical order of the goods. Goods with a higher value of "stacking order" will be placed under the goods with a lower value. The "stacking order" is a relative value, the higher the value, the stronger the load-bearing capacity of the goods, and the more they will be placed below. The default value in system is “10”.

If the goods should be loaded sequentially, we use "loading sequence" to achieve it. The value of the "loading sequence" indicates the order in which the goods are loaded. It is a relative value, the larger the value, the more the goods are loaded first. The default value in system is “0” .

After the template is finished to fill in, save and close it. Go back to the cargo interface, click [Import from Excel] under [Add cargo], find the filled-in template in the dialog box and open it, all cargo data will be imported into this task.