Change SKUs

We can change a SKU if there are changes to the product sold to you by a manufacturer.


About this task

When you update a SKU, the relationship between the SKU and the variant in the CATENTREL table is updated.


Procedure

  1. Open the Catalogs tool.

  2. From the explorer tree, select a catalog.

  3. Find the SKU we want to change.

  4. To change a product-level SKU in the list view, right-click on the product; then click SKU List. The SKU list displays. To change a category-level SKU, right-click on the category; then click Show Catalog Entries. The catalog entries list displays. To see hidden fields on the list view, right-click; then click Configure Columns. A dialog displays where we can select columns to hide or display. If a product has defining attributes associated with it, the SKU table appends a column to represent that attribute. If the defining attribute has allowed values, the combination box is populated with values that can be selected for the SKU.

  5. To change the SKU, right-click the SKU; then click Open. The Manage SKU tab displays.

  6. Expand the General SKU Information section. Complete the following information: This information is managed in the store default language only.

    Code Type the SKU code, which uniquely identifies the item. This SKU code is based on the parent product code (before attributes). For example, if the product code for a "Ladies' cable-knit sweater" is SKU-12345, then the individual SKU for each attribute would be SKU-12345-1 (Ladies' cable-knit sweater, small, red), SKU-12345-2 (Ladies' cable-knit sweater, medium, red), SKU-12345-3 (Ladies' cable-knit sweater, large, red). Name The name of the catalog entry. This field can be edited in multiple languages. Short description Type a brief description of the category.
    Property Description
    Long description

    Type a detailed description, if applicable. We can enter HTML code in this field. If you choose to specify HTML code, you should receive this source code from your developers. Before you paste HTML code into the field, we must select Source in the editor toolbar. For more information about rich text editors, see Rich text editor (CKEditor).

    Keyword Type one or more keywords, which are separated by a comma and a space that describe the contents of the Web page. Some Internet search engines use these keywords to determine whether your page satisfies a search query. This field can be edited in multiple languages.
    Additional description 1 Type a detailed description of the catalog entry, if applicable. This field is disabled by default and not visible.
    Additional description 2 Type a detailed description of the catalog entry, if applicable. This field is disabled by default and not visible.
    Manufacturer Type the name of the manufacturer or vendor.
    Manufacturer part number Type the part number for the catalog entry, uniquely defined by the manufacturer. This number is different from the code used to define the object in the system.
    Parent product The product to which a SKU belongs. See Moving a catalog entry for an example of how to change the parent category. Product-level SKUs have a parent product, whereas category-level SKUs have a parent category.
    Recurring order item Indicate whether the catalog entry is available for a recurring order.
    Subscription item Indicate whether the catalog entry is a subscription item.

  7. Expand the Publishing section. Complete the following information:

    For purchase This check box indicates whether customers can purchase this catalog entry. This check box is read-only. On special Indicates whether the catalog entry is on special. Announcement date Add the year, month, and day that the catalog entry becomes available to customers. Click the calendar icon to select a date. This is an informational field. Withdrawal date Add the year, month, and day that the catalog entry is removed from the catalog and is unavailable for customers to purchase. Click the calendar icon to select a date. This is an informational field. Availability date Add the year, month, and day that the catalog entry is available to customers for purchase. Click the calendar icon to select a date. This is an informational field. Last date to order Add the final year, month, and day that the catalog entry is available for order. Click the calendar icon to select a date. This is the latest date that a customer can order the catalog entry. For example, a manufacturer can discontinue a product, but because stock still exists, it is still available for order for one month. End of service date Add the year, month, and day when the catalog entry is no longer in service. For example, this date can be the date that a software manufacturer stops providing upgrades for a version of their product. Click the calendar icon to select a date. This is an informational field. Discontinued date Add the year, month, and day when the catalog entry is discontinued. For example, it can be the date that the manufacturer stops producing the product, or the date the store stops selling the product. Click the calendar icon to select a date. It is recommended that this field is used consistently to avoid confusion. This is an informational field.
    Property Description

  8. Expand the Display section. Complete the following information:

    Display to customers Select this check box to indicate that customers can view this category in the storefront. Thumbnail All image files must be placed in the store's defined image directory. Determining the correct image directory and whether you need an absolute or relative path depends on the store's configuration. For example, the WebSphere Commerce starter store images use a relative path that points to the default installation directory under the store name. Use of a relative path is most common. Use of an absolute path is dependent on the initial configuration. Ask a store developer with Site Administrator authority for the correct image directory if we are unsure. Or, if we are using Watson Content Hub, all image files must be stored as an asset in Watson Content Hub. This field can be edited in multiple languages.

    For the Aurora starter store, this path must be to the 160-pixel-wide thumbnail image of this catalog entry, for example:
    images/catalog/apparel/women/womens_dresses_160x160/WD_038_a_blue.jpg
    This path must have a directory with a name containing the following character string: 160x160. The server matches the character string to locate this image and the other catalog entry images in different sizes.

    If you do not define a thumbnail image for the SKU, the image of the parent product is used.

    Full image Type the path to the full-size image and the name of the image, such as images/shirt.jpg. The path can be either a full path, or a relative path from the store directory. Or, if we are using Watson Content Hub, the full path to the full-size image stored in Watson Content Hub. To select a full-size image, click the Edit icon. Then find and select the full-size image that we want to use. The find dialog searches for images in Watson Content Hub and saves the full path in the full image field. If a full-size has already been assigned from the Content tab, the path and image is displayed as read-only, and instead must be updated from the Content tab.

    For the Aurora starter store, this path must be to the 1000-pixel-wide full image of this catalog entry, for example:
    images/catalog/apparel/women/womens_dresses_1000x1000/WD_038_a_blue.jpg
    This path must have a directory with a name containing the following character string: 1000x1000. The server matches the character string to locate other catalog entry images in different sizes. The 1000-pixel-wide full image is not currently used in the Aurora storefront. On the product details page, the 447-pixel-wide image is used as the full image of the product.

    If you do not define a full image for the SKU, the image of the parent product is used.

    Property Description

  9. Expand the Pricing section. Complete the following information:

    List Price An optional field to display the list price. List price is sometimes called MSRP (manufacturer's suggested retail price). This price is intended for catalog display purposes only; it is not typically used as the actual price customers must pay. A store might display a list price above an offer price to show customers that they are getting a better deal with the offer price. One common use of the list price is to display the MSRP (manufacturer's suggested retail price). Your site can choose not to use a list price at all. Offer Price

    The price at which the catalog entry is offered for purchase. Click New to add in a new offer price. Type a Minimum Quantity at which the catalog entry can be offered at this price. The maximum quantity is determined by the minimum quantity of the next range. For example, if the minimum quantity of a catalog entry to be sold at $35.00 is one, and the minimum quantity of the same catalog entry to be sold at $25.00 is 10, then the maximum quantity for the catalog entry to be sold at $35.00 is nine.

    Property Description

    Note: If we are using the extended sites model, the offer price for the catalog asset store is displayed first. Then, the list price and offer price displays for the extended store.

  10. If Watson Content Hub integration is enabled: Click the Content tab to associate content from Watson Content Hub. Content includes catalog objects such as images, and attachments such as videos or articles.

    To associate content from Watson Content Hub:

    1. Search for content by entering a keyword and selecting Find and Add. The search results are displayed in the utilities view.

    2. Drag the object from the search results to the open Content tab.

    3. Select a language for the content.

    4. To use more than one language for the content, copy the object and select the additional language in the next object row.

    5. Optional: Expand the General Information and Assets sections to get more information about the content that we are associating with the catalog entry or business object.

    General Information:

    Language The language that the asset is associated with in Watson Content Hub. For example, United States English. Identifier The unique identifier of the asset in Watson Content Hub. Name The name of the asset in Watson Content Hub. For example, the product or category name. Content Type The content type of the asset in Watson Content Hub. For example, AuroraCatalogEntryImages for products, or AuroraCatalogGroupImages for categories. Description The description of the asset in Watson Content Hub.
    Property Description

    Assets:

    Asset The asset to manage from Watson Content Hub. For example, for catalog entry or category images, the image file is displayed. Asset Name The asset name. For example, for catalog entry images, the asset name might be main_fullimage to represent the full image, or main_thumbnail to represent the thumbnail image. Asset Path The full path to where the asset is stored in Watson Content Hub. Asset MIME Type The MIME Type of the asset. For example, for catalog entry or category images, the MIME Type might be image/jpeg.
    Property Description

  11. Optional: Expand the Custom section. Complete the following information:

    Property Description Field 1 A customized field for the catalog entry data. The entry must be a decimal number such as 5.345. Field 2 A customized field for the catalog entry data. The entry must be a decimal number such as 5.345. Field 3 A customized field for the catalog entry data. The entry must be a whole number such as 5. Field 4 A customized field for the catalog entry data. The entry must be text. Field 5 A customized field for the catalog entry data. The entry must be text.
    Option Description

  12. Click Save; then click Close.


What to do next


Related concepts
Product-level SKUs
Category-level SKUs
Attributes


Related tasks
Manage SKUs
Deleting attributes and predefined values from the attribute dictionary
Deleting attribute values from catalog entries
Deleting attributes from catalog entries