Post by sbsjr13 » Fri Mar 18, 2016 2:29 am

I am running version 2.31 and I cannot do an export due to having customer group pricing extension. As each product has about a dozen prices depending on wholesaler level. I am getting this error:

Unknown column 'cg.name' in 'field list' SQL=SELECT ps.*, cg.name FROM `xxxx_mijoshop_product_special` ps LEFT JOIN `xxxx_mijoshop_customer_group` cg ON cg.customer_group_id=ps.customer_group_id WHERE ps.product_id BETWEEN 37 AND 3812 ORDER BY ps.product_id, name, ps.priority

Any solutions for this already? or what route should I take to fix it?

New member

Posts

Joined
Wed Sep 16, 2015 8:02 pm

Post by sbsjr13 » Fri Mar 18, 2016 2:39 am

Oh ya I also have product tabs extension that i could use that data also in an export..

New member

Posts

Joined
Wed Sep 16, 2015 8:02 pm
Who is online

Users browsing this forum: No registered users and 3 guests