elainewpq

Hi @kapmi. The plugin I am using now, is PPOM – Product Addon & Fields for Woocommerce. Its free, works in a very similar way, and can be added to categories.

Hope it helps you.

I deleted the plugin and found an alternative one.

When the plugin is activated I get this error message on my front-end for each product that has extra product associations.

WordPress database error: [Unknown column ‘product_association’ in ‘where clause’]

SELECT blocks.id FROM wpdh_yith_wapo_blocks as blocks WHERE ( visibility = 1 ) AND ( id IN ( SELECT id FROM wpdh_yith_wapo_blocks WHERE vendor_id IN (‘0’) ) ) AND ( ( id IN ( SELECT id FROM wpdh_yith_wapo_blocks WHERE product_association = ‘all’ ) OR id IN ( SELECT DISTINCT(id) FROM wpdh_yith_wapo_blocks as i1 JOIN wpdh_yith_wapo_blocks_assoc as a1 on a1.rule_id = i1.id WHERE product_association = ‘products’ AND ( type = ‘product’ AND object = ‘3191’ ) OR ( type = ‘category’ AND object IN (’18’, ’62’, ’24’) ) ) ) AND ( id IN ( SELECT id FROM wpdh_yith_wapo_blocks WHERE user_association IN ( ‘all’, ‘logged_users’ ) ) OR id IN ( SELECT DISTINCT(id) FROM wpdh_yith_wapo_blocks as i2 JOIN wpdh_yith_wapo_blocks_assoc as a2 on a2.rule_id = i2.id WHERE user_association = ‘user_roles’ AND ( type = ‘user_role’ AND object IN (‘administrator’) ) ) OR id IN ( SELECT DISTINCT(id) FROM wpdh_yith_wapo_blocks as i3 JOIN wpdh_yith_wapo_blocks_assoc as a3 on a3.rule_id = i3.id WHERE user_association = ‘membership’ AND ( type = ‘membership’ AND object IN (‘0’) ) ) ) ) AND ( id NOT IN ( SELECT DISTINCT(rule_id) FROM wpdh_yith_wapo_blocks as i4 JOIN wpdh_yith_wapo_blocks_assoc as a4 on a4.rule_id = i4.id WHERE exclude_products = 1 AND type = ‘excluded_product’ AND object = ‘3191’ ) AND id NOT IN ( SELECT DISTINCT(rule_id) FROM wpdh_yith_wapo_blocks as i5 JOIN wpdh_yith_wapo_blocks_assoc as a5 on a5.rule_id = i5.id WHERE exclude_products = 1 AND type = ‘excluded_category’ AND object IN (’18’, ’62’, ’24’) ) AND id NOT IN ( SELECT DISTINCT(rule_id) FROM wpdh_yith_wapo_blocks as i6 JOIN wpdh_yith_wapo_blocks_assoc as a6 on a6.rule_id = i6.id WHERE exclude_users = 1 AND type = ‘excluded_user_role’ AND object IN (‘administrator’) ) ) ORDER BY priority

Hi, thank you for your reply. I tried this on a staging site, and it didn’t make any difference. Still having the same issue.

Hi,

Yes I have successfully completed transactions myself.

THanks