Category Patterns

Knectar_Select_Store_Category

Handy for finding stores that categories belong to.

• store_id
• category_id
• parent_id ID of one category that owns category_id. If there are several parents only first is exported. NULL if no parent.

Knectar_Select_Store_Category_Name

Same as Knectar_Select_Store_Category but also exports a name.

• store_id
• category_id
• parent_id
• category_name

Knectar_Select_Store_Category_Duoname

Same as Knectar_Select_Store_Category_Name but exports the parent's name too.

• store_id
• category_id
• parent_id
• category_name
• parent_category_name

Knectar_Select_Store_Category_Trioname

Same as Knectar_Select_Store_Category_Duoname but exports grand-parent's ID and name.

• store_id
• category_id
• parent_id
• grandparent_id
• category_name
• parent_category_name
• grandparent_category_name

Knectar_Select_Store_Category_Product

Lists all products per store. Similar to Knectar_Select_Store_Category but not all categories are certain to be included.

• store_id
• product_id
• category_id
• parent_id

Knectar_Select_Store_Category_Product_Name

Like Knectar_Select_Store_Category_Product with names exported.

• store_id
• product_id
• category_id
• parent_id
• product_name
• category_name

Knectar_Select_Store_Category_Product_Duoname

Same as Knectar_Select_Store_Category_Product_Name but exports parent category's name too.

• store_id
• product_id
• category_id
• parent_id
• product_name
• category_name
• parent_category_name

Knectar_Select_Store_Category_Product_Trioname

Same as Knectar_Select_Store_Category_Product_Duoname but exports grand-parent category's ID and name.

• store_id
• product_id
• category_id
• parent_id
• grandparent_id
• product_name
• category_name
• parent_category_name
• grandparent_category_name