Help & Resource Center

Counterpoint Dynamic Products

While Counterpoint is the "source of truth" for the product integration, you may occasionally find a website-only product sneaks onto a web order. If this product has a SKU that does not exist in Counterpoint, the Modern Retail integration will throw an error of "No SKU found". But what happens if that product does not have a SKU at all, coming through as NO_SKU?
 
The Counterpoint integration has a solution for this; the article below outlines the Counterpoint Dynamic Product feature.

What Dynamic Products Do

The Dynamic Product feature uses an existing Counterpoint item as a template for new item creation.

When an e-commerce order is being imported into Counterpoint and an order line item is not found in Counterpoint, the Dynamic Product feature can be used to create a new item in Counterpoint. It creates a permanent template SKU that will be applied to all items that come across an order as NO_SKU.

When the Dynamic Product feature is enabled, the CP Integrator will use the order line item SKU, description, and price to create the new item. Below are the parameters for the Dynamic Product:

  • The order line item SKU can not exceed 20 alphanumeric characters 
  • All other item fields will be taken from the existing Counterpoint item that has been defined as the item template 
  • The template item can be of type (ITEM_TYP) Inventory, Non-Inventory or Service
    • NOTE: If the item template field ITEM_TYP is equal to "I" (Inventory), the CP Integrator will create an inventory record for each inventory location listed in the CP Integrator configuration with an inventory quantity of zero. The sale of the first newly created item will result in a negative inventory
  • An item type of Discount is not allowed for use as a template
  • Gridded items are not supported
  • The Counterpoint eCommerce checkbox must remain unchecked on this template SKU

Dynamic Product Field Names


The following is a list of Counterpoint item table (IM_ITEM) field names that will be used for new item creation:

ITEM_TYP
TRK_METH
STAT
IS_TXBL
QTY_DECS
PRC_DECS
STK_UNIT
IS_WEIGHED
PREF_UNIT
PROMPT_FOR_PRC
PROMPT_FOR_COST
PROMPT_FOR_DESCR
WARR_UNIT_1
WARR_UNIT_2
SER_NO_REQ_FOR_SAL
PRC_1
IS_ECOMM_ITEM
ECOMM_LST_PUB_STAT
ECOMM_TXBL_1
ECOMM_TXBL_2
ECOMM_TXBL_3
ECOMM_NEW
ECOMM_ON_SPECL
ECOMM_CHRG_FRT
IS_FOOD_STMP_ITEM
PROMPT_FOR_UNIT
PROMPT_FOR_CUSTOM_FLDS
IS_ADM_TKT
IS_BOM_PAR
IS_KIT_PAR
ITEM_IS_MISC
IS_DISCNTBL
ECOMM_DISC_ON_SAL
ECOMM_ITEM_IS_DISCNTBL
CATEG_COD
SUBCAT_COD ACCT_COD
ATTR_COD_1
ATTR_COD_2
ATTR_COD_3
ATTR_COD_4
ATTR_COD_5
ATTR_COD_6
PROF_ALPHA_1
PROF_ALPHA_2
PROF_ALPHA_3
PROF_ALPHA_4
PROF_ALPHA_5
PROF_COD_1
PROF_COD_2
PROF_COD_3
PROF_COD_4
PROF_COD_5
PROF_DAT_1
PROF_DAT_2
PROF_DAT_3
PROF_DAT_4
PROF_DAT_5
PROF_NO_1
PROF_NO_2
PROF_NO_3
PROF_NO_4
PROF_NO_5
ADDL_DESCR_1
ADDL_DESCR_2
ADDL_DESCR_3

 

If the above item fields have values, the values will be used when creating a new item.

If you are interested in adding this feature to your integration, please ask your project manager for more information or submit a Support Request in the Admin Panel.