CP-Commerce adds a new tab to the Item form in CounterPoint. It looks like this:

Below is an explanation of what each of these fields do.



Database Columns

The following tables outline the names of the database fields for each, as well as their default values.

The default values listed below are what we define at the time of the initial sync install - they can be changed depending on client's needs, and may not completely match up with your specific Counterpoint instance.


General Stocking Info
FieldDatabase Column NameDefault Value
Web Enabled

USR_CPC_IS_ENABLED

'Y'
Allow Backorder

USR_CPC_ALLOW_BACKORDER

'N'
Always In StockUSR_CPC_ALWAYS_IN_STOCK'N'
Web Archive

USR_CPC_WEB_ARCHIVE

'N'



Alt Unit Availability
FieldDatabase Column NameDefault Value
Sell Stocking UnitUSR_CPC_ALLOW_STK_UNIT'Y'
Sell Unit 1USR_CPC_ALLOW_ALT_1'Y'
Sell Unit 2USR_CPC_ALLOW_ALT_2'Y'
Sell Unit 3USR_CPC_ALLOW_ALT_3'Y'
Sell Unit 4USR_CPC_ALLOW_ALT_4'Y'
Sell Unit 5USR_CPC_ALLOW_ALT_5'Y'



Minimum Quantities
FieldDatabase Column NameDefault Value
Minimum Sale QuantityUSR_CPC_MIN_SALE_QTY
Out of Stock QuantityUSR_CPC_MIN_QTY



Downloadable Fields
FieldDatabase Column NameDefault Value
DownloadableUSR_CPC_IS_DOWNLOADABLE'N'
Download LimitUSR_CPC_DOWNLOADABLE_LIMIT0
Download FileUSR_CPC_DOWNLOADABLE_LINK_PATH
Download SampleUSR_CPC_DOWNLOADABLE_SAMPLE_PATH



Parent Relationship Fields
FieldDatabase Column NameDefault Value
Parent ItemUSR_CPC_IS_PARENT'N'
Parent Attribute 1USR_CPC_CONFIG_ATTR_1
Parent Attribute 2USR_CPC_CONFIG_ATTR_2
Parent Attribute 3USR_CPC_CONFIG_ATTR_3
Parent Attribute 4USR_CPC_CONFIG_ATTR_4
Parent Attribute 5USR_CPC_CONFIG_ATTR_5
Parent Attribute 6USR_CPC_CONFIG_ATTR_6


Child Relationship Fields
FieldDatabase Column NameDefault Value
Parent Item NumberUSR_CPC_PARENT_ITEM_NO
Child Value 1USR_CPC_CONFIG_VAL_1
Child Value 2USR_CPC_CONFIG_VAL_2
Child Value 3USR_CPC_CONFIG_VAL_3
Child Value 4USR_CPC_CONFIG_VAL_4
Child Value 5USR_CPC_CONFIG_VAL_5
Child Value 6USR_CPC_CONFIG_VAL_6