Icon

WMS : SKU Creation Process Document

© LLAMA LOGISOL PVT LTD 2025. All rights reserved. This document and the WMS software described herein are proprietary products of © LLAMA LOGISOL PVT LTD and are protected by copyright law. No part of this document or software may be reproduced, transmitted, or used in any form or by any means without prior written permission from © LLAMA LOGISOL PVT LTD 2025.

By Shipsy

1. Mandatory Fields

The following fields are required for SKU creation:

  1. SKU Code: Unique identifier for the product

  2. SKU Description: Detailed description of the product

  3. TEST: Custom mandatory fields can be added as per necessity

2. Field Groups and Descriptions

2.1 Basic Product Information

  1. SKU Type: Classification of the SKU

  2. SKU Class/Group/Category/Sub-Category: Hierarchical classification for organizing products

  3. Brand: Manufacturer or brand name

  4. SKU Reference: Additional reference number or code

2.2 Physical Attributes

  1. Size Type/Size: Product size classification and specific size

  2. Dimensions: Length, Breadth, Height (in cm)

  3. Weight: Product weight in kg

  4. Color: Product color

  5. Style Name: Style or variant identifier

2.3 Inventory Controls

  1. Min/Max Norm Quantity: Minimum and maximum stocking levels

  2. Put Zone: Designated storage area in the warehouse

  3. Load Unit Handling: Whether special handling is required

  4. UOM (Unit of Measure): Standard unit for the product (pieces, kg, liters, etc.)

2.4 Pricing Information

  1. Cost Price: Purchase cost of the item

  2. Price: Selling price

  3. MRP: Maximum Retail Price

2.5 Taxation & Accounting

  1. TAX Name: Applicable tax category

  2. HSN Code: Harmonized System Nomenclature code for tax classification

  3. GL Code: General Ledger code for accounting purposes

  4. Invoice Group: Grouping for invoice purposes

2.6 Product Tracking

  1. Batch Based: Enable this flag if the product needs to be tracked by batches. This is important for products where lot tracking is required for quality or regulatory purposes.

  2. Serialized: Enable if each unit needs a unique serial number

  3. Barcode/EAN Number: Product identification codes

2.7 Quality & Compliance

  1. QC Required: Whether quality check is needed

  2. Scan for Picking: Scanning requirements during picking process

  3. Product Shelf Life: Total shelf life in days

  4. Customer Shelf Life: Shelf life guaranteed to customer

  5. Minimum Shelf Life: Minimum acceptable shelf life

2.8 Status Controls

  1. Status: Whether the SKU is active or inactive

  2. Block For PO: Whether purchasing is blocked

  3. Receipt Tolerance: Acceptable variance in received quantities

3. Special Considerations

  1. Batch Tracking: Enable the "Batch Based" flag for:

    • Products with expiration dates

    • Items requiring traceability

    • Regulated products requiring lot control

    • Products where quality may vary between production runs

  2. Mandatory Field Completion: Ensure all fields marked with an asterisk (*) are completed before submission. Custom mandatory fields can be added based on requirement.

  3. Image URL: Include product images when available for better visual identification.

  4. Unique Identifiers: Ensure SKU Code is unique across the system to prevent duplicates.

Here we can see the Navigation to the SKU Master in UI.

1
Click on "Masters" and select "SKU Master".
Step #1: Click on "Masters" and select "SKU Master".
2
Click on "+ Add SKU"
Step #2: Click on "+ Add SKU"
3
Enter all the mandatory details of the SKU. The description about these fields are mentioned above.
Step #3: Enter all the mandatory details of the SKU. The description about these fields are mentioned above.
4
Batch Enabling - If the items are batch based.
Step #4: Batch Enabling - If the items are batch based.
5
Click on "Add" button for saving the SKU created.
Step #5: Click on "Add" button for saving the SKU created.

SKU Creation using UPLOAD forms ( Bulk Upload)

6
Select "Uploads" from "Extras"
Step #6: Select "Uploads" from "Extras"
7
Choose the "SKU" upload form from the dropdown in "Uploads" page.
Step #7: Choose the "SKU" upload form from the dropdown in "Uploads" page.
8
Download the SKU upload format Excel file which will have the columns to fill the SKU details.
Step #8: Download the SKU upload format Excel file which will have the columns to fill the SKU details.
9
Open the downloaded SKU upload form to fill the details.
Step #9: Open the downloaded SKU upload form to fill the details.
10
The necessary details can be added in the csv file. Save the file before uploading.
Step #10: The necessary details can be added in the csv file. Save the file before uploading.

  1. Now navigate back to "Uploads" page.

  2. Ensure the "SKU" form is chosen in the dropdown.

11
Now Click on "Choose" to upload the csv file with SKU details. It will be reflected in "SKU Master" Page.
Step #11: Now Click on "Choose" to upload the csv file with SKU details. It will be reflected in "SKU Master" Page.
12
Select the SKU upload form with saved details.
Step #12: Select the SKU upload form with saved details.
13
Click on the Upload File icon for the selected form to be validated by WMS.
Step #13: Click on the Upload File icon for the selected form to be validated by WMS.
14
Status of the Upload form can be seen.
Step #14: Status of the Upload form can be seen.

Uploads Status :

1. Completed - Successfully uploaded the file, and can see the details in Location Master.
2. Invalid - Check if the format of the uploaded file, matches the selected Form in the dropdown.
3. Failed - Download the Failed file by clicking on it. This file shows the reasons for failure in the last column of the file. Do not use this same file to upload, change the details in file uploaded earlier or download new excel file and try again.

15
Navigate back to "Masters" -> "SKU Master" to check if the uploaded SKUs are reflected here.
Step #15: Navigate back to "Masters" -> "SKU Master" to check if the uploaded SKUs are reflected here.

© LLAMA LOGISOL PVT LTD 2025. All rights reserved. This document and the WMS software described herein are proprietary products of © LLAMA LOGISOL PVT LTD and are protected by copyright law. No part of this document or software may be reproduced, transmitted, or used in any form or by any means without prior written permission from © LLAMA LOGISOL PVT LTD 2025.