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
- 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
-
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:
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