Commerce5 includes multiple forms in Counterpoint that identify items that have a duplicate website name.


It is CRITICAL from a website SEO perspective and an online shopping experience that ALL eCommerce products have a unique website name.


Commerce5 allows for the following item fields to be used as the product name on the website.

  • Long Description
  • Additional Description 1
  • Additional Description 2
  • Additional Description 3
  • Website Name (Custom Field added by Commerce5)
    • USR_WEB_NAME


Depending on which field you are using for the product name on the website there is a corresponding item clean-up form. Only the form corresponding to the field you are using as the product name needs to be used for data cleanup. For example, if you were using Additional Description 3 as the product name for your products on the website, only Items with Duplicate Additional Description 3 would need to be addressed.


For products with duplicate names, it is recommended to modify one or all of the duplicates to make the names unique. If the character limit on the field makes this difficult, consider using the custom Web Name field, which has no character limit.



Commerce5 > Item Cleanup > Items with Duplicate Web Name

Commerce5 > Item Cleanup > Items with Duplicate Long Description


Commerce5 > Item Cleanup > Items with Duplicate Additional Description 1


Commerce5 > Item Cleanup > Items with Duplicate Additional Description 2


Commerce5 > Item Cleanup > Items with Duplicate Additional Description 3


**********************************************************************************

Optional Duplicate Website Name Error Checking


AFTER the items with duplicate website names have been cleaned up in Counterpoint there are optional Item triggers attached to this KB article that can be installed by your NCR Partner which will prevent items from being created in Counterpoint with a duplicate website name moving forward. This is a great way to help keep the item database clean and notify staff when they are creating a new eCommerce item that there is already another item in Counterpoint that has the same website name.


Optional SQL Triggers

  • USR_IM_ITEM_DUP_ADDL_LONG_DESCR.sql
    • Checks for items that have a duplicate Long Description
  • USR_IM_ITEM_DUP_ADDL_DESCR_1.sql
    • Checks for items that have a duplicate Additional Description 1
  • USR_IM_ITEM_DUP_ADDL_DESCR_2.sql
    • Checks for items that have a duplicate Additional Description 2
  • USR_IM_ITEM_DUP_ADDL_DESCR_3.sql
    • Checks for items that have a duplicate Additional Description 3
  • USR_IM_ITEM_DUP_USR_WEB_NAME.sql
    • Checks for items that have a duplicate Website Name (USR_WEB_NAME)

.