Product and Category Extraction via MySQL using PHPMYADMIN

Quote

Post by phat64mower » Mon Nov 02, 2020 8:26 pm

Hi Guys,

I have successfully extracted all of the products from our store using PHPMYADMIN.
However what I am unable to see is which categories each respective product is listed in.

We are currently running version 2.0.2.1

How do we do this?
Can anybody please help?

TIA
phat64mower
Newbie
Posts
15
Joined
Fri Jan 09, 2015 9:30 pm
Top

Re: Product and Category Extraction via MySQL using PHPMYADMIN

Quote

Post by straightlight » Mon Nov 02, 2020 8:34 pm

I have successfully extracted all of the products from our store using PHPMYADMIN.
How? Which way did you used to extract all the products? More information is needed.
Last edited by straightlight on Mon Nov 02, 2020 8:45 pm, edited 1 time in total.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22380
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top

Re: Product and Category Extraction via MySQL using PHPMYADMIN

Quote

Post by thekrotek » Mon Nov 02, 2020 8:44 pm

Check product_to_category table.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com

User avatar
thekrotek
Expert Member
Posts
4378
Joined
Sun Jul 03, 2016 12:24 am
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: Bing [Bot], darkhorse and 68 guests