Changing SKUs

You 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 you 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 you can select columns to hide or display.
    If a product has defining attributes that are 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.
    PropertyDescription
    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.
    Long description

    Type a detailed description, if applicable. You 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, you 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 that is 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:
    PropertyDescription
    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 your 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.
  8. Expand the Display section. Complete the following information:
    PropertyDescription
    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 your store's configuration. For example, the HCL 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 your initial configuration. Ask a store developer with Site Administrator authority for the correct image directory if you are unsure. 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.jpgThis path must have a directory with a name that contains 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 your store directory.

    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.jpgThis path must have a directory with a name that contains 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.

  9. Expand the Pricing section. Complete the following information:
    PropertyDescription
    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.

    Note: If you 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. Optional: Expand the Custom section. Complete the following information:
    OptionDescription
    Property Description
    Field 1 A customized field for your catalog entry data. The entry must be a decimal number such as 5.345.
    Field 2 A customized field for your catalog entry data. The entry must be a decimal number such as 5.345.
    Field 3 A customized field for your catalog entry data. The entry must be a whole number such as 5.
    Field 4 A customized field for your catalog entry data. The entry must be text.
    Field 5 A customized field for your catalog entry data. The entry must be text.
  11. Click Save; then click Close.

What to do next