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.

For Sale: Top URL's, including OpenCart V-Pro installed, like seen here: - -
For Information + URL's offered, please contact me at:
I am NOT available for Custom Support in existing OC Installations!
My Github Repositories:

User avatar
Guru Member


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

Users browsing this forum: No registered users and 4 guests