Page tree
Skip to end of metadata
Go to start of metadata

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.


  • Web Enabled Checkbox: This is checked by default. If it is un-checked, the product will be "disabled" in magento. Disabled products will not be accessible from the front end but will still appear in the admin list of products.

  • Allow Backorder Checkbox: If checked, a customer will be able to purchase the item when it is out of stock. They will be notified that it is on backorder.

  • Always In Stock Checkbox: If checked, the item will always be available for purchase on your site regardless of the quantity in stock. The customer will not be notified that it is out of stock or on backorder. This is ideal for items that you manufacture yourself or know you will be able to obtain and ship out quickly.

  • Web Archive Checkbox: This field is for items that you no longer wish to sell on your website. The item will remain on the website, however it will be permanently out of stock and customers will only be able to navigate to it via a direct URL. This is a better alternative to deleting the item, because any links to the item will still redirect to your store instead of leading to a broken page. 

  • Sell Stocking Unit & Sell Unit 1-5: These fields will all be checked by default. They define which units are available for purchase online. If you uncheck one, that unit will not be given as an option for the product.

    • Note: These are only relevant if you have "Multiple Units" selected in Ecommerce Control. 
  • Minimum Sale Quantity: This determines the minimum quantity of a single item that a customer must have in their shopping cart in order for them to purchase it. If left blank, the customer only needs to have a quantity of one for the item to purchase it. 

  • Out Of Stock Quantity: This field defines when the item will be set as "out of stock." If left blank, it will be out of stock when the item's inventory reaches the out of stock quantity configured in Magento. If you put an amount in this field, the item will not be available for purchase once the stock quantity reaches that amount.

    • Note: This is a per item override for the global Qty for Item's Status to Become Out of Stock setting in Magento Configuration > Inventory > Product Stock Options (default: 0)
  • Visibility: This field defines how the item will be visible on the website. Items have a default visibility set depending on the type of item it is.
    • Note: This setting should not need to be changed.
  • Downloadable Fields: These fields help you to configure downloadable items. Checking the box will make the item sync to Magento as a Downloadable Product. The download limit is the maximum number of times a user can download the product. The file is the download link, and the sample is a smaller part of the download that the user can preview before purchasing.

  • Parent Attributes & Child Values: This section allows you to create a parent-child relationship between two or more items. It works similar to a Gridded Item. To set up an item as a parent, you would check the "Parent Item" checkbox and select at least one "Parent Attribute." The parent attributes are different options that you can have for an item, such as size and color (similar to Grid dimensions.) On the other hand, if you want to make the item a child, you must first have another item that is set up as it was just explained. Once that is complete, you select the parent item in the "Parent Item Number" field. Next, you have to match up all of the Parent Attributes with Child Values. For example, The parent might have "Color" for Attribute 1 and "Size" for Attribute 2, while the child item may have something like "Red" for Child Value 1 and "Medium" for Child Value 2. These items will sync to Magento in a similar manner to Items with a Grid.

    • You can read more about setting this relationship here.


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