Import Pack Type and Barcode via Excel File

Step-by-Step Guide

To begin, navigate to the Products screen.
The Import button is on the right hand side of the screen. Click this button and select Bulk Import Pack Type and Barcode

You are now on the Bulk Import Pack Type and Barcode page. If you need to, download the Excel template file via the Download button.

File preparation guidelines/information:

This import document can be used to import pack type and barcode to products that have already been created.
Green-colored fields are required and cannot be left blank; gray-colored fields are optional and can be filled only when needed.
Do not alter the names of the columns, as the columns' distinct headers enable the system to match the Excel data with Logiwa's fields
The Glossary sheet contains information about countries and some of the list values.
When the file is imported, please wait a few seconds, then click on the Refresh List button to see the results of your import.
Click the 3-Dot icon to see the import details. You can view lines that failed to import along with the failure reason.

Creation Rules:

The entered package type must have been previously created under the data setup.
If hierarchical is true, the UOMs for the same product and client must be multiples of each other when sent, and the quantity should be identical. If hierarchical is false, there is no need for this check.
For a new package type, UOM quantity cannot be entered as 1.
For records with the same client, SKU and pack type; weight unit, weight, dimension unit, length, width, height, volume unit, volume, use item's own box for shipping, use this shipping box only should be identical. Otherwise, the system gives an error.
To enter multiple barcodes, they should be separated by commas and written in the UPC line.
If there was a hierarchical pack type before, new hierarchical addition will not be allowed.
In one product, there can only be one pack type with the same name.

Edit Rules:

If Hierarchical is true, for the same product and client, UOM quantities must be multiples of each other.
For new pack types, UOM quantity cannot be 1.
If an error occurs, the process will be canceled based on SKU and client.
If "Use Item's Own Box for Shipping" is not provided, set it to false.
If there was a previous hierarchy, a new hierarchical pack type cannot be added.
For irregular pack types, only the name check is sufficient.
Only one pack type with the same name is allowed per product.
Multiple barcodes can be entered using a comma (",").
The "Deleted" column at the end is used to delete the pack type in the relevant line.

Editable Fields in All Conditions

Fill in the template according to these requirements and save it.
Once it's ready, upload the Excel file from the Bulk Import Pack Type and Barcode screen. You can either drag and drop your file into the blank space in the center or select Browse to find the file from local storage.

After you select the file, you should see it listed under file icon. Click the Upload button to continue.

After the file uploads your products, another screen will load with the information you've imported. This is an opportunity to make sure your data matches with the fields in Logiwa.
The Matched column will display a green check if Logiwa Fields and File Column Headers match for each column. Otherwise, a red X will indicate a mismatch.
The Preview Data column shows the initial 3 rows of your data as a sample.
If there is a mismatch between Logiwa and the excel file's columns, you can select which Logiwa field corresponds to your file's column by pressing Choose Field and then selecting from the dropdown menu.
As long as the field has not already been used, it can be selected.
Once an unused Logiwa field is selected, the Matched column will change to a check mark.

Make sure each section is matched to a Logiwa field, then press the Import button in the bottom right corner to finalize the process.

You will be directed to the upload screen and a message will show that your import was completed.

You can also click the Actions menu to access links to Details or Download Original File.

Selecting Details will take you to a sidebar that summarizes the upload with more information. If you had errors, this will give more information on the issue.