4.3.1.2 Import through Order Form Mode

If the size of the goods will not change in different orders, you can maintain the commonly used goods data in the cargo database to avoid repeating input. When designing the plan, you only need to enter the name, quantity and required parameters of the goods according to the order, and the information that has been maintained in the database such as the size, loading orientations, and stacking order of the goods will be automatically captured.

Specific steps are as follows: 1) Maintain the cargo data to the database. On the left side of the homepage, click [Cargo Management] to enter the cargo database. There are two ways of [Directly Add] and [Import from Excel].

①[Directly Add]: When there are fewer types of goods, you can add them one by one.

Click [Directly Add] and edit the basic properties of the cargo (name, size, stacking order, etc.) and placement constraint (load orientations, max stack, etc.) in the pop-up box. The name of the goods must be unique, and finally click [save].

② [Import from Excel]: When there are many types of goods, you can use excel to import in batches.

First click [Get Excel Template] to download the template and save it to a location on your computer;

Then fill in the import template. When finished, return to the website and click [Import from Excel], and find the filled-in template, click [open], then the cargo information will be added to the database. Template filling instructions:

  • The name of the goods must be unique and cannot be duplicated. If there is a duplicate name, the software will automatically recognize and prompt the number of repeated lines.

  • Pay attention to the conversion of units.

  • The “weight” column cannot be blank. If it is light cargo and the specific weight is not clear, you can fill in “1”.

  • All six load orientations are allowed in the template by default, that is, random placement. The not allowed orientations should set to “0”. The allowed placement method should set to 1 or leave it blank.

  • Stacking order: The stacking order can be set according to the “gross weight of a single box” or “density” of the goods, which can make the heavier goods not upon the lighter goods. The stacking order is a relative value, and the larger the value, the stronger the load-bearing capacity , and the lower it will be placed.

    2) After the cargo information is added to the database, return to the [Task] page. Click [Get Excel Template] under [Add Cargo] to download the template.

3) In the opened template, copy the name and quantity of the required goods, and then set the required parameters according to the loading requirements (the parameters already defined in the database do not need to be set).

3)After filling in the template, save and close it. Back to the cargo interface, click [Import (Order Form Mode)] under [Add Cargo], find the filled-in template in the pop-up box, and click [Open]. LoadMaster will automatically grab the information of the corresponding goods in the database based on the name of the goods, and then the goods are added into this task.

Last updated