Post by darkfall » Tue Jun 13, 2017 4:57 am

when i try to export my products i m getting this error my friends;

Error: Unknown column 'main_category' in 'where clause'
Error No: 1054
SELECT category_id FROM oc_product_to_category WHERE product_id = '20' AND main_category = '1' LIMIT 1

how can i solve this?
and also i can import files successfully, so can anyone share a product template for this tool?
Thank you very much.

Note: if i open this topic in wrong category please excuse me.



Tue May 30, 2017 5:14 pm

Post by IP_CAM » Fri Jun 23, 2017 2:45 am

Well, your trying to use data from a russian ocShop Version, in regular
OC-Versions, that main_category does not exist.

Please don't send me OC Forum Personal Messages, just contact:
OC LIGHT Test Site:
OC V-PRO Test Site:
My Github OC Site:
2'450+ FREE OC Extensions from the World's largest Github OC Repository Archive Site.

User avatar
Legendary Member


Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: No registered users and 4 guests