A Catalog has multiple nodes and each Node can have multiple SKUs. Similarly, a SKU has multiple attributes and each of these attributes can have multiple UoMs. If you need to convert an existing UoM value to a different UoM value for a single Attribute, you can still go ahead and change it manually. However, in most cases, due to any customer requirements, you might need to make bulk updates to UoM values across 1 or all SKUs in a node which will be tedious.
For example, you need to change a UoM from inches to cm. If you need to change it manually, you first need to know the conversion formula, that is, cm = 2.54* in. You then need to find out the correct value for the UoM based on the entries which will be very tedious, especially for multiple updates.
Thus, using this feature, you can directly convert UoM values for selected or all SKUs in a node as the formulas are stored in the database.
Let us understand how to convert UoM values.
To convert UoM values:
Select the node containing the SKUs and then click the Convert UoM Values
icon. The following options are displayed.
Select a SKU and then click Convert Values to Different UoM For Selected SKUs to convert values for selected SKUs.
OR
Click Convert Values to Different UoM For All SKUs to convert values for all SKUs of the selected node.
For example, let us consider the first option for selected SKUs.
The following screen appears.
Figure 153: Convert values to different UoMs for selected SKUs
Only those attributes that have been defined in the Schema for the selected SKU having UoM values, that is, common schema attributes are displayed on the left-hand side of the screen. If the attributes are not defined in the schema, they will not be displayed here. Also, it is possible that a schema attribute defined does not consist of UoM values. However, it will still be displayed in the list as it is defined in the schema. However, if you select those attributes for conversion, a message is displayed as shown below. Also, if the SKU attribute selected for UoM conversion has been locked as explained in section Locking Attribute Values for a SKU, you cannot change the values of such attributes.
|
Select the attribute. For example, let us select Strap Width. The following screen is displayed on the right-side of the screen.
Figure 154: Select attribute for value conversion
Enter the Base UoM, that is, the UoM that needs to be converted. Let us say for Strap Width. we need to change the value from mm to cm. So, the Base UoM will be mm.
NOTE | If you select an invalid UoM for conversion such as year to month which does not exist, that is, there is no such conversion, an error is displayed as follows. |
Based on the base UoM selected, the Target UoM will automatically populate a list of UoMs that can be converted based on the UoMs defined in the schema as shown below.
Let us select cm as the Target UoM. As soon as you select the Target UoM, the following fields are populated as shown below.
Enter the No. of Decimal Places After Conversion, that is, the number of decimal places needed in the value derived after conversion.
The Conversion Rule that will be applied while converting the UoM value from mm to cm is displayed.
There are a couple of scenarios for UoM conversion. If the target UoM, that is, cm already exists as a UoM for Strap Width, then there could be duplicate UoM values. Hence, while converting, you can choose whether you want to overwrite the existing value / ignore existing value / add new values.
Similarly, you can decide whether you want to keep/delete the base UoM after successful conversion, that is, mm in this case.
The following table describes the various scenarios available while converting UoM values and the resulting values that will be saved based on the combination chosen. As mentioned already, let us consider Base UoM as mm and Target UoM as cm.
Table 16: UoM Conversion Scenario
Scenario | Target UoM | Base UoM | Existing value | Resultant Value | Comments |
|---|---|---|---|---|---|
1 | Overwrite | Keep | 20 mm | 20 mm, 2 cm | No existing value with "cm" is found, so the converted cm value (2 cm) is simply added. The base UoM value (20 mm) is kept. |
2 | Overwrite | Keep | 20 mm, 4 cm | 20 mm, 2 cm | All the existing values with "cm" (4 cm) are removed and replaced with the newly converted cm value (2 cm). The base UoM value (20 mm) is kept. |
3 | Overwrite | Keep | 20 mm, 4 cm, 6 cm | 20 mm, 2 cm | All the existing values with "cm" (4 cm, 6 cm) are removed and replaced with the newly converted cm value (2 cm). The base UoM value (20 mm) is kept. |
4 | Overwrite | Delete | 20 mm | 2 cm | No existing value with "cm" is found, so the converted cm value (2 cm) is simply added. The base UoM value (20 mm) is deleted. |
5 | Overwrite | Delete | 20 mm, 4 cm | 2 cm | All the existing values with "cm" (4 cm) are removed and replaced with the newly converted cm value (2 cm). The base UoM value (20 mm) is deleted. |
6 | Overwrite | Delete | 20 mm, 4 cm, 6 cm | 2 cm | All the existing values with "cm" (4 cm, 6 cm) are removed and replaced with the newly converted cm value (2 cm). The base UoM value (20 mm) is deleted. |
7 | Add new | Keep | 20 mm | 20 mm, 2 cm | No check is performed to find the existing value with "cm", and the converted cm value (2 cm) is simply added. The base UoM value (20 mm) is kept. |
8 | Add new | Keep | 20 mm, 4 cm | 20 mm, 4 cm, 2 cm | No check is performed to find the existing value with "cm", and the converted cm value (2 cm) is simply added. The base UoM value (20 mm) is kept, along with the other "cm" value (4 cm). |
9 | Add new | Keep | 20 mm, 4 cm, 6 cm | 20 mm, 4 cm, 6 cm, 2 cm | No check is performed to find the existing value with "cm", and the converted cm value (2 cm) is simply added. The base UoM value (20 mm) is kept, along with the other "cm" values (4 cm, 6 cm). |
10 | Add new | Delete | 20 mm | 2 cm | No check is performed to find the existing value with "cm", and the converted cm value (2 cm) is simply added. The base UoM value (20 mm) is deleted. |
11 | Add new | Delete | 20 mm, 4 cm | 4 cm, 2 cm | No check is performed to find the existing value with "cm", and the converted cm value (2 cm) is simply added. The base UoM value (20 mm) is deleted, but the other "cm" value (4 cm) is kept. |
12 | Add new | Delete | 20 mm, 4 cm, 6 cm | 4 cm, 6 cm, 2 cm | No check is performed to find the existing value with "cm", and the converted cm value (2 cm) is simply added. The base UoM value (20 mm) is deleted, but the other "cm" values (4 cm, 6 cm) are kept. |
In case of Ignore existing values: If any value with target UoM IS NOT found, then normal conversion takes place. If a value with target UoM IS found, the entire conversion is not carried out; that is, no new values, no deletions, no changes. | |||||
13 | Ignore | Keep | 20 mm | 20 mm, 2 cm | No existing value with "cm" is found, so the converted cm value (2 cm) is simply added. The base UoM value (20 mm) is kept. |
14 | Ignore | Keep | 20 mm, 4 cm | 20 mm, 4 cm | Since an existing value (4 cm) with "cm" is found, no conversion is done. No changes to anything. |
15 | Ignore | Keep | 20 mm, 4 cm, 6 cm | 20 mm, 4 cm, 6 cm | Since an existing value (4 cm, 6 cm) with "cm" is found, no conversion is done. No changes to anything. |
16 | Ignore | Delete | 20 mm | 2 cm | No existing value with "cm" is found, so the converted cm value (2 cm) is simply added. The base UoM value (20 mm) is deleted. |
17 | Ignore | Delete | 20 mm, 4 cm | 20 mm, 4 cm | Since an existing value (4 cm) with "cm" is found, no conversion is done. No changes to anything. |
18 | Ignore | Delete | 20 mm, 4 cm, 6 cm | 20 mm, 4 cm, 6 cm | Since an existing value (4 cm, 6 cm) with "cm" is found, no conversion is done. No changes to anything. |
NOTE | By default, Ignore Existing Values and Keep is selected. |
Based on the scenarios mentioned in the above table, select the necessary options.
For example, let us keep the base UoM and overwrite the target UoM. In case of Strap Width, the current value is 20 mm as shown below.
Figure 157: View converted UoM values
Click Overwrite Existing Values and Keep as mentioned in scenario 1 in Table 16: UoM Conversion Scenario.
Click Convert UoM and the UoM is converted successfully and a message is displayed as shown below.
Figure 158: UoM conversion success message
You can also view the details in the SKU view as shown below. Hover the mouse on the Show Complete Details link and the details are displayed.
Since there was only 1 value 20 mm and no existing value with cm, the converted value 2 cm got added to the existing value and as we chose to keep the base UoM, 20 mm is also retained.
Similarly, you can perform the same operation for all SKUs of a node using the conversion scenarios mentioned, as needed.