4.3.1.1 Import in Bulk through Excel
Last updated
Last updated
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.
