The Product Attribute Category Rules Extension allows products to be automatically assigned to Magento Categories based on an item filter.


  • If uploading products to multiple websites this mod allows you to define different rules for each Magento website
  • The "Refresh" checkbox will force all the items in the Product/Category View to be repopulated based on all the rules defined for that specific website






  • The Item filter will allow you to filter on ANY field from the Item table in CounterPoint
    • Example: Category = CASUAL; Subcategory = CASUALBOOT
  • The Magento Category lookup table must be populated using the EXACT Magento Category Name as it appears on the website
    • For example if we want to assign items to the Rubber Boots category as seen below we would setup the Magento Category value in CounterPoint as:
      • Men's>Outdoor>Rubber Boots
      • Note: The > symbol is the level separator between categories





The Product/Categories View will allow you to easily see all the Magento Categories an Item # is assigned to for a specific Magento website





Note: Every time an eCommerce item is added or changed on the Item table in CounterPoint this table will be updated based on the Product Attribute Category Rules defined


Note: For Performance Reasons the default trigger for identifying when a new record should be added or updated on the "CPMagento - Product/Categories View" has been limited to only look for changes to the following fields for eCommerce Items.


  • Category
  • Sub-category
  • Profile Code 1
  • Profile Code 2
  • Profile Code 3
  • Profile Code 4
  • Profile Code 5
  • Item Attribute Code 1
  • Item Attribute Code 2
  • Item Attribute Code 3
  • Item Attribute Code 4
  • Item Attribute Code 5
  • Item Attribute Code 6



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

To add additional fields to this list the following trigger on the item table can be modified: USR_IM_ITEM_ASSIGN_MAG_CATEG

--This was added for performance reasons. If any other fields are being filtered on in the rule assignment, they will need to be added here.
    IF(NOT (UPDATE(CATEG_COD) OR UPDATE(SUBCAT_COD) OR UPDATE(PROF_COD_1) OR UPDATE(PROF_COD_2) OR UPDATE(PROF_COD_3) OR UPDATE(PROF_COD_4) OR UPDATE(PROF_COD_5)
        OR UPDATE(ATTR_COD_1) OR UPDATE(ATTR_COD_2) OR UPDATE(ATTR_COD_3) OR UPDATE(ATTR_COD_4) OR UPDATE(ATTR_COD_5) OR UPDATE(ATTR_COD_6)))
        RETURN