Adding Attributes / Attribute Values in SKU using Astro

Prev Next

Each SKU has multiple attributes and each of these attributes will have values. The Astro feature in SKU enables you to add attributes as well as Attribute Values to SKUs by providing recommendations based on the data available in the CKB repository. In the case of SKUs which are imported, it is possible that attributes have missing values or you need to add more attributes. Using this feature, you can map the recommended attributes / attribute values in the existing SKU as suitable.

Based on the information present in the PCC SKU, the matching algorithm will look for matches in the CKB repository. For the PCC SKU, the Attribute meta tags MANUFACTURER NAME, MANUFACTURER PART NUMBER, UPC and BRAND NAME are used to identify the attributes which will be used to perform the matching logic.

  • MN Match, that is, Manufacturer Name match – This will look for an exact match or a match to an alias during the matching process

  • MPN Match, that is, Manufacturer Part Number match – Here, all white space and special characters in the MPN are removed from both the PCC and CKB SKU before matching.

  • UPC Match – Here, all leading zeros from both the PCC and CKB SKU are removed before matching

Based on the matches found, the results are displayed. Thus, this process helps with the overall SKU build process. Using details like UPC, MN, MPN, brand and so on, the SKU can be curated.

The SKU attribute recommendation option will appear while editing SKUs as mentioned in section Editing SKUs as well as while populating attribute values for SKU as explained in section Authoring SKUs.

Let us assume that a Catalog on Mechanical Products & Tools related products is created and it consists of various nodes such as Floor Tile, Sheets and Rods and so on. Let us edit SKUs present in the Vinyl Tile Node to add attributes as well as attribute values.

Graphical user interface, application  Description automatically generated

To add attributes / attribute values in SKU using Astro:

  1. Select the SKUs to be edited and then click the Edit SKUs icon. The following options are displayed.

Graphical user interface, application  Description automatically generated

  1. Click Edit SKU(s). The following screen appears.

Graphical user interface, application  Description automatically generated

In this case, 2 SKUs are selected.

  1. Click the Astro icon next to the SKU to be edited and the following screen appears.

A screenshot of a computer  Description automatically generated

The screen is divided into 2 parts:

  • The top part is the existing SKU attribute information selected for editing

  • The bottom part is the attribute / attribute value recommendations given by CKB for the selected SKU based on the matches found

Both the top and bottom sections will show the exact data and the attributes will be aligned.

A list of attributes displayed will be common in the entire screen. In the case of the top part of the screen, it will show all attribute values present for the SKU attributes that exist for the SKU and the bottom part will show the attributes as well as the attribute values that can be added to the existing SKU.

Also, in this case, there are 3 sets of recommendations which means the value sets will change based on the manufacturer here.

Graphical user interface, text, application  Description automatically generated

Attribute Values

There are 2 options available in case of attribute values. You can copy the recommended value to the same existing SKU attribute or to some other SKU attribute. For example, a value needs to be added to an attribute Finish / Coating as shown below.

Graphical user interface, application  Description automatically generated

NOTE

In the SKU selected for editing, you will see that some attributes appear as grayed out and some are not. In this case, Finish / Coating is not grayed out which means that this attribute is present either in the attribute master or in the Schema for that SKU.

The attributes which are grayed out are not present in both the master and schema. Hence, this attribute first needs to be added before copying any value to it.

  1. Click the icon next to the value for Finish / Coating in the recommended section and the value is added to the selected SKU as shown below.

Graphical user interface, application  Description automatically generated

The value is now updated as shown below.

A screenshot of a computer  Description automatically generated

  1. Click the Remove Value icon next to the value added to remove it any time.

Similarly, you can also copy the value to another attribute by selecting the attribute from the list. For example, a value present in the field Overall Length is more suitable to be added in attribute Length.

  1. Click the Add this value to any eligible attribute icon next to the value to be added to another SKU attribute as shown below.

A screenshot of a computer  Description automatically generated

The following list is displayed to select the attribute to which this value should be added.

NOTE

All attributes present in the master list as well as schema and SKU attributes will be listed in the drop-down list.

Table  Description automatically generated

Select the attribute to which the value needs to be copied. In this case, Length. You can also search for that attribute. The value is copied as shown below.

Graphical user interface, application, Teams  Description automatically generated

The value is now populated in the selected attribute.

Graphical user interface  Description automatically generated

Thus, you can populate the recommended attribute value to the same or any other actual SKU attribute, as needed.

If there are multiple attribute values for an attribute being recommended, you can either select a specific attribute value to be copied by clicking the icon next to the value or if all values are to be added, select the checkbox next to Value(s) and all values will be copied.

A screenshot of a computer  Description automatically generated

Attributes

There are 2 options available to add attributes:

  • You can add existing attributes from the attribute master / attribute group which are not present for the SKU selected or add a new attribute altogether.

  • Another option is to add recommended attributes which are not present for the selected SKU, if applicable.

To add existing attributes from the attribute master / attribute group or a new attribute

  1. Click Add Attributes and the options are displayed as shown below.

Graphical user interface, application  Description automatically generated

Case 1: Add existing attributes from the Attribute Master

  1. Click From Attribute Master List to add attributes from the master list and the following is displayed.

Graphical user interface, table  Description automatically generated

A list of all attributes from the attribute master list is displayed. You can scroll through the list and select the required attribute.

  1. Select the attribute to be added and then click Next. Details about the attribute selected are displayed.

Graphical user interface, application, Word  Description automatically generated

  1. Select Include in Schema and Include LoV(s) in Schema option if you need to add this as a schema attribute. However, you can select Include LoV(s) in Schema only if Include in Schema is selected.

  2. Double-click the List of Value(s) column to add new values or modify existing values as needed.

Graphical user interface, application  Description automatically generated

  1. Click Submit and the attribute is now added along with the values, if present.

Graphical user interface  Description automatically generated

  1. Click the Remove this attribute from SKU icon to remove the attribute added. You can also remove the value by clicking the Remove Valueicon next to the value.

Case 2: Add existing attributes from the Attribute Group

  1. Click From Attribute Group(s) to add attributes from the attribute group and the following is displayed.

Graphical user interface, application, table, Excel  Description automatically generated

A list of Attribute Groups created for the catalog is displayed. You can select the attributes from the attribute group to be added.

  1. Select the attribute to be added and follow steps 9,10,11 and 12 as mentioned in Case 1 for attributes from the master list.

Case 3: Add a new attribute

  1. Click New Attributes to add a new attribute which is not available in the attribute master or attribute group and the following is displayed.

Graphical user interface, text, application  Description automatically generated

The information to be added for an attribute is divided into 2 panels.

Attribute Information – This is the first panel.

  1. Click the arrow next to the Attribute and the following information to be added is displayed.

Graphical user interface, application  Description automatically generated

NOTE

The attribute name should be unique. If a duplicate attribute is created, a warning message is displayed as shown below.

Graphical user interface, application  Description automatically generated

  1. Enter the Attribute Name. For example Tile Type. Also, you can enter the Attribute Customer ID. However, this is optional.

  2. Click Add More to add multiple attributes as shown below.

Graphical user interface, application, Teams  Description automatically generated

  1. Click the newly added attribute to add details as shown below.

Graphical user interface, application  Description automatically generated

  1. Click the Remove Attribute icon next to the attribute to remove any of the attributes. added.

    Attribute Properties - This is the second panel. All the properties of the attribute can be set here.

  2. Select the Data Type for the attribute from the drop-down list.

Turn on the toggle to allow multiple UoMs as well as LoVs. Enter the UoMs and LoVs as needed.

Following is a sample.

Graphical user interface, application  Description automatically generated

Refer section Adding Attributes for more details on the attribute properties.

  1. Click Next and the attribute is added to the master list as well as the following is displayed.

Graphical user interface, text, application, Word  Description automatically generated

  1. Select Include in Schema and Include LoV(s) in Schema option if you need to add this as a schema attribute. However, you can select Include LoV(s) in Schema only if Include in Schema is selected.

    You can also add new / edit existing attribute values here.

  2. Click Submit and the attribute is now added along with the values, if present.

Graphical user interface  Description automatically generated

To add the recommended attribute to the actual SKU

Based on the CKB recommendations, there could be attributes which are relevant for the SKU and can be added directly to the SKU. Let us add an attribute, Trim Length (Inch) which is recommended and not present in the actual SKU.

NOTE

All recommended attributes which are not present in the actual SKU will be highlighted in a grey color as shown below.

Graphical user interface  Description automatically generated

  1. Click the Add this attribute to SKU  icon next to the Trim Length (Inch) attribute to be added to the selected SKU and the following dialog box appears.

Graphical user interface, text, application  Description automatically generated

There are 3 options available here while adding the attribute:

  • No value – This option will add the attribute without the value. In this case, the value for Trim Length (Inch) attribute 1 will not be added. Select this if you only need to add the attribute without the value.

  • Selected recommended value(s) – This option will add the attribute along with the selected values. This is useful in cases where the recommended attribute has multiple values and you need to add only selected values.

  • All recommended value(s) – This option will add the attribute along with all the recommended values. Select this to add the attribute along with all the values recommended.

Let us add the attribute using the 1st option ‘No value’.

  1. Select No value and turn on the toggle to Yes if this attribute should be included in schema. By default,  Include in Schema is set to No.

  2. Select the Attribute Data Type to be assigned for the attribute being added from the drop-down list as shown below.

Graphical user interface, text, application, chat or text message  Description automatically generated

You can also include this attribute in the Attribute Group, if required.

In the Include in Attribute Group field, select the downward arrow to view the list of attribute groups available.

Graphical user interface, text, application, chat or text message  Description automatically generated

Select the attribute group from the list and the attribute will be added to that group.

  1. Click Add and the attribute is added to the SKU as well as the attribute master.

Graphical user interface, application  Description automatically generated

The attribute is added without the value as selected.

A screenshot of a computer  Description automatically generated

Since the SKU has multiple attributes, you can always search for an attribute instead of scrolling through the list.

  1. Click the Search an Attribute field and a list of all available attributes is displayed in the drop-down list.

Graphical user interface, application  Description automatically generated

Select the attribute to be located and the cursor will be navigated to that attribute.

After selecting the attributes and attribute values to be added, these need to be added to the actual SKU.

  1. Click Add To SKU as shown below.

A screenshot of a computer  Description automatically generated

A list of all the attributes and attribute value related changes made to the SKU is displayed.

Graphical user interface, table  Description automatically generated

The Modification(s) column clearly states the changes that will be made to the SKU after submitting the changes.

In case of a new attribute being added, the column states ‘New Attribute will be added’ as shown below.

A white rectangular object with a black border  Description automatically generated with medium confidence

In case of a new attribute value being added, the column states ‘Attribute Value(s) will be added from Astro’ in green color along with the value mentioned in the Value(s) column as shown below.

A screenshot of a calendar  Description automatically generated

  1. Click Submit after verifying all the changes and the SKU attribute as well as values will be added successfully to the SKU.

Since we are editing the SKU, after making all the changes, the Edit SKU screen appears. You can make further changes to the other SKUs as needed.

Graphical user interface, application  Description automatically generated

  1. Click Edit SKU and the SKU is updated with the changes. In case of any validation failures, follow the steps 24 to 27 as mentioned in section Adding SKUs to a Node.

However, if the review mode is turned on for user action Review user actions of updates to SKU attribute while adding/editing a hierarchy, any changes in the SKU attribute value cannot be done directly using CKB while Editing SKUs and while populating attribute values for SKU as explained in section Authoring SKUs as it will be assigned to a reviewer as explained here.