Post by spt5304 » Sat Sep 22, 2018 1:42 am

I'm just trying to find the transaction data of each customers specifically the list of all items that they purchased at one time.
I can't seem to find a table in mysql that stores all this historical transaction information.

Please suggest.
I'm new to opencart



Sat Sep 22, 2018 1:25 am

Post by straightlight » Sat Sep 22, 2018 8:56 pm

As a new forum user, please read the forum rules. No OC version posted. Normally, it would be in the admin - > customers - > customers page. The transaction tab from each customers should show you the details.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.

F. Rules:

- viewtopic.php?f=176&t=200480
- viewtopic.php?f=176&t=200804


Legendary Member


Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by thekrotek » Sun Sep 23, 2018 12:43 am

It's not clear, what do you mean under "purchased at one time". You mean, order products? They can be found on order info page, for example.

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

User avatar
Expert Member


Sun Jul 03, 2016 12:24 am

Who is online

Users browsing this forum: No registered users and 24 guests