Updating SKU attributes from UI

Overview

Now users can update the SKU attributes mentioned below in product masters from the UI screen. This is particularly useful when there is a change in product metadata.

The following SKU attributes can be updated:

Barcode
isUOM
isVirtual
isSerialCoderequired

However, it's important to note that the system will run necessary validations when users upload a file to update these attributes from the UI screen. If the necessary validations are not passed by the user input file, the system will fail the request. For more details about these validations, please refer to Implementation details section.

Implementation details

SKU attribute details that can be updated by users

Product Barcode: Users can modify or change the scannable entity present physically on a product at any given point of time and update it in the product masters.
isUOM attribute: This attribute allows users to define if a product is available in different Units of Measurement (UOMs) within the system.
isVirtual attribute: Users can use this attribute to indicate whether a product should be bundled with other products and if its inventory should be synced with external systems.
isSerialCoderequired attribute: This attribute allows users to specify if external serial codes should be allowed for this particular product, which helps ease inwarding process.

Validations/Checkpoints required

Update Product Barcode

To update a Product Barcode, make sure:

There are no free inventories present in OMS; all available inventory should be outwarded from system and re-inwarded using new barcode.
No open orders exist; orders should not have status as "CANCELLED", "COMPLETED", or "HOPPED".

Update `isUOM` attribute

To update the isUOM attribute, please ensure:

To update a product's isUOM attribute to TRUE, ensure:

There is no type of inventory (QC pass/fail, Available for sale, lost, recycle etc.) existing in system.
There are no Outward Orders in OPEN state ("CANCELLED", "COMPLETED", or "HOPPED").
The Product should not be defined as a virtual SKU in the system.
The Product is not a part of UOM (Unit of Measurement) definition
.The Product is not defined as a manufacturable SKU in the system

To update a product's isUOM attribute to FALSE, ensure:

No UOM defintion should exist in the system.
There is no type of inventory (QC pass/fail, Available for sale, lost, recycle etc.) existing in system.
There are no Outward Orders in OPEN state ("CANCELLED", "COMPLETED", or "HOPPED").

Update `isVirtual` attribute

To update a product's isVirtual attribute to TRUE, ensure:

There is no type of inventory (QC pass/fail, Available for sale, lost, recycle etc.) existing in system.
There are no Outward Orders in OPEN state ("CANCELLED", "COMPLETED", or "HOPPED").
The Product SKU itself is not a child SKU of any other virtual SKU defined in the system.
The SKU is not a UOM (Unit of Measurement) SKU.

To update a product's isVirtual attribute to FALSE, ensure:

There is no type of inventory (QC pass/fail, Available for sale, lost, recycle etc.) existing in system.
There are no Outward Orders in OPEN state ("CANCELLED", "COMPLETED", or "HOPPED").
There should be no virtual SKU defintion existing in system

Update `isSerialCoderequired` attribute

To update isSerialCoderequired attribute, ensure below:

There is no type of inventory (QC pass/fail, Available for sale, lost, recycle etc.) existing in system.
There are no Outward Orders in OPEN state ("CANCELLED", "COMPLETED", or "HOPPED").

Change in system behavior after the update

After updating these attributes from the UI screen as per the given guidelines and passing all necessary validations, there will be changes observed in all the transactions related to Inward/Outward of orders, inventory sync and operational processes on products (Cycle count, Sorting, Picking, Packing etc).

User manual

Curious to know how to perform this activity quickly? Refer to this section for step-by-step instructions on how to update any of these attributes mapped to a SKU using UI. Simply follow these simple steps!

Steps:

Navigate to Product Settings Category in OMS module
Go to Products screen, navigate to Edit tab.
Navigate to SKU properties and select the attribute checkbox which you like to update.
Download the csv template file, update it with the modified values and upload it back.

Woah, it’s done! The changes are already reflected in the system if you have received a success message on UI.

Fig 1: Products screen to update SKU properties