Excel Batch Import
When the order contains many cargo types, you can batch import cargo data via a fixed Excel template.
For example, here is how to batch import the nine cargo items in the table below.
| Cargo | Quantity | Length (mm) | Width (mm) | Height (mm) | Weight (kg) |
|---|---|---|---|---|---|
| SYD500R | 10 | 860 | 950 | 2020 | 10 |
| SYQ500R | 10 | 860 | 980 | 2020 | 8 |
| SYW900RH | 1 | 980 | 980 | 1120 | 7 |
| SYT15-15L | 42 | 680 | 600 | 640 | 5 |
| SYT15-11LK | 52 | 610 | 600 | 600 | 3 |
| SYT18-18LK | 10 | 820 | 710 | 790 | 8 |
| SYT12-12L | 12 | 590 | 520 | 560 | 2 |
| SYQ315R | 16 | 670 | 550 | 610 | 5 |
Specific steps:
1) On the Cargo interface, click Add cargo → Get Excel import template, download the template and save it to your computer.
2) The downloaded Excel template opens automatically. Read the instructions, delete them and begin filling in the template.
① Copy and paste in the cargo name, quantity, length/width/height and weight — these are required. Note: the order uses mm as the size unit, so the template's length unit should also be set to mm. Weight refers to the gross weight per item; if cargo is light, you can omit it — the system uses "1" by default.
② Fill in the cargo placement methods. There are six: stand, stand horizontal rotation; side, side horizontal rotation; lay, lay horizontal rotation. Leave blank or enter 1 to allow; enter 0 to disallow. For example, allow only stand and stand horizontal rotation. "Allow other cargo on top" defines whether the cargo can only be stacked with itself and cannot bear other types of cargo. Leave blank or enter 1 to allow; enter 0 to disallow.
"Stacking layers" is the maximum number of layers the cargo can be stacked with itself. Leave blank if no requirement.
"Overhang ratio" — leave blank if no requirement. See the online help for details.
③ Fill in cargo loading attributes: fill only the needed parameters; ignore others. See the online help for details on each parameter.
If cargo has a "heavy below, light on top" loading requirement, use "Load-bearing level". The load-bearing level represents the cargo's bearing capability; cargo with a higher load-bearing level is placed below cargo with a lower level. It is a relative value: the larger the value, the stronger the bearing capability, and the more the item goes on the bottom. The system default is 10.
If cargo has a loading-sequence requirement, use "Spatial sequence". The spatial sequence represents loading order; it is a relative value: the larger the value, the earlier the item is loaded. The system default is 0.
3) After filling in, save and close, then return to the software. On the Cargo interface, click Add cargo → Import from Excel, locate the completed template in the popup, and click Open — all cargo data are then imported into the software.
