In addition to creating locations one by one, you can also upload your products locations in bulk, saving you a significant amount of time.


Import Products via Excel File Steps

Screen Path: Inventory → Products

From the Inventory section, select the Products tab. The Products page will display with the Import button on the right hand side of the screen. Click this button and select Bulk Import Products.

You are now on the Bulk Import Products page. You can download the Excel template file via the Download button.

Once it's downloaded, open the template. You will see some sample data to give you an idea of how to fill out the file. Please make sure to delete this data before uploading it.

Template Guidelines

  1.  Fields marked in green are required and cannot be empty.

  2. SKU is the key field for a product, it should be unique for every product line.

  3. Every Excel column should have a header. If a column has no header, data will not be imported.

  4. You can import an image for your products by adding a URL. Multi-images should be separated with a comma. Max 5 image links can be added for a product. Image URL types should be jpg, jpeg, gif or png.

  5. If you add an extra column with a header to your file, you should match it with a MyLogiwa column later.

  6. If the Pack Type, Product Group or Product Type you write in those columns are not yet recorded to MyLogiwa, new ones will be created upon upload.

  7. If you have a file to track products that you always use, you can also use your own file. However, you'll have to do some additional work to match the columns with the fields used in MyLogiwa.
            

Once you've filled in your template, you can click the icon in the middle of the screen to choose the file from your device or drag and drop your file into this section.

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 MyLogiwa.

If the column headers come from MyLogiwa's template, they will be automatically matched. You'll see a checkmark next to these sections.

If you are using so special column headers, these will not automatically match with MyLogiwa fields. You will see these kind of columns marked with an X.

An unmatched field can match with a MyLogiwa field that is not already in use. Fields that are unavailable will be grayed out. Click the Choose Field area and select the field that you want to use.

If every option is grayed out, it means that you've already linked every MyLogiwa field.

When you are sure you have linked all fields, click the Import button to start the upload process. 

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

You can now check the status of your import. The bottom of the screen will display the history of your imports with the following information:

  • Status: This will say if your import was Successful or Failed

  • Row Count: This names how many rows were in your import.

  • Success Count: Count of successfully imported rows

  • Error count: Count of rows that were not imported due to errors

  • Uploaded By: User that uploaded the data

  • Upload Date: The date and time the file was uploaded

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.

After the importing is completed, MyLogiwa will send an email with a summary of the upload. This email will list the import's total imported rows and how many rows succeeded or ran into errors during the import process.


What's Next?

Do you want to learn how to import shipment order?

Couldn’t Find What You Were Looking For?

Write to our support team: mysupport@logiwa.com
Or go to our Help Center and search more documents!


Did this answer your question?