Help & Resource Center

Counterpoint Dynamic Products

Question

Please tell me more about the “Dynamic Products” feature as it sounds like it will solve a lot of problems for us.
I want to understand what it can do and what it can’t (limitations). I want to fully understand what this would look like in Counterpoint after Modern Retail has pushed this product in. How it would look in item file, ticket reports, etc.?
Thanks.

Answer

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

When an ecommerce 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.

When the Dynamic Product feature is enabled, the CP Integrator will used the order line item SKU, description and price to create the new item. The order line item SKU maximum length can not be greater than 20 alphanumeric characters. All the 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. An item type of Discount is not allowed for use as a template. Also, the Dynamic Product feature will only create Normal items. Gridded items are not supported.

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.

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.

Please let us know if you need anything else by submitting a Support Request in the Admin Panel.  Thank you.