How do I do a Standard Product Import in Clarus WMS?

How do I do a Standard Product Import in Clarus WMS?

Quickly add multiple products to Clarus WMS by uploading a spreadsheet. 

The Standard Product Import feature in Clarus WMS lets you add many products at once by uploading a spreadsheet. This guide will help you understand what information you need and how to import your products correctly.



Step-by-Step Guide

1. Prepare Your Spreadsheet

You need to fill in product details in the first row of your spreadsheet. Here are the fields you can use:

Notes

Field: Code, Type: String, Mandatory? Yes, Description: Unique code for the product.

Field: Description, Type: String, Mandatory? Yes, Description: A short description of the product.

Field: Long Description, Type: String, Mandatory? Yes, Description: A detailed description of the product.

Field: External System Reference, Type: String, Mandatory? No, Description: Any external reference for the product.

Field: Weight Per Item, Type: String, Mandatory? No, Description: The weight of each product item.

Field: Height Per Item, Type: String, Mandatory? No, Description: The height of each product item.

Field: Width Per Item, Type: String, Mandatory? No, Description: The width of each product item.

Field: Length Per Item, Type: String, Mandatory? No, Description: The length of each product item.

Field: Value Per Item, Type: String, Mandatory? No, Description: The value of each product item.

Field: Stop, Type: String, Mandatory? No, Description: Used to stop the product from being used.

Field: Obsolete, Type: String, Mandatory? No, Description: Marks whether the product is no longer used.

Field: Is New Product, Type: String, Mandatory? No, Description: Indicates if this is a newly added product.

Field: Barcode, Type: String, Mandatory? Recommended, Description: The product barcode, useful for scanning.



2. Fill in the Required Information

The Code, Description, and Long Description fields are essential and must be filled for every product. Other fields, such as External System Reference, Weight, Height, Width, Length, Value, and Barcode, are optional but can be very helpful for tracking and scanning your products.

AlertREMEMBER: It is highly recommended to include the Barcode for easy product scanning, even though it is not strictly necessary.


3. Save and Upload Your Spreadsheet

Once you have finished preparing your spreadsheet:

First, save the file in a CSV file format.

Next, upload the file into Clarus WMS using the import function. You can find more details on how to use the import function "">here.

Finally, you can check if your file has successfully completed or failed by looking at the ""Event Logs"" screen. This will show you the status of your upload.


FAQs

Is the barcode essential for import?

No, the barcode is not mandatory for import, but it is strongly recommended to include it for easier product scanning.

What happens if I miss mandatory fields?

If any mandatory fields (Code, Description, or Long Description) are missing for a product, the import will fail for that specific product.

Can I update existing products through import?

Yes, you can update existing products. Use the Is New Product field to indicate whether the product is new or already in your system.

What format should the import file be?

The import file should typically be in CSV or Excel format.

Where can I find the template file?

The product import template file is attached below, this is a blank template which you can use for any product import.


    • Related Articles

    • How do I do a standard pre-receipt import in Clarus WMS?

      Pre-Receipt Import Feature The Standard Pre-Receipt Import feature in Clarus WMS allows you to quickly add pre-receipts to the system by uploading a spreadsheet. This guide explains the required fields and the process for a successful import. ...

    • How do I perform a standard order import via SFTP in Clarus WMS?

      Standard Order Import via SFTP This feature lets you quickly add orders to the system using SFTP, which is a secure way to transfer files. You'll use your unique Clarus WMS address to do this efficiently. Step-by-Step Guide 1. Prepare the Order ...

    • Standard Role in Clarus WMS

      Standard User Permissions in Clarus WMS Standard users have wide-ranging access to Clarus WMS, allowing them to view and manage various system features. This guide explains what standard users can do within the platform. Step-by-Step Guide 1. Access ...

    • How do I change account assignments for products via SFTP?

      Updating Product Accounts Using the Standard Import File This guide explains how to use the standard product account assignment import file to update multiple product accounts simultaneously, whether you're assigning new accounts or unassigning ...

    • How do I manage mixed pallets in Clarus WMS?

      How to Handle Mixed Pallets You can now create or receive mixed pallets in Clarus WMS using the group numbers feature. This lets you assign different stock lines to a single storage unit reference, whether for the same or different products. ...