Post by jcusters » Fri Jan 29, 2016 7:00 pm

Hi,

I run several SQL queries in phpmyadmin to check/analyse data. Now I store these queries in notepad. I'm looking for an OC 2.0 admin extension to store these query definitions. Some kind of custom reports based on plain SQL. Does anybody know which extension (free or paid) to use? Thanks in advance for your help.

Regards,
Jeroen

Newbie

Posts

Joined
Tue Jun 11, 2013 3:41 am

Post by IP_CAM » Sat Jan 30, 2016 2:33 am

Do you mean something like this ?
http://www.openshop.li/

look at the page bottom...
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by jcusters » Mon Feb 01, 2016 4:37 pm

No, I mean a report tool in OC admin where you can create custom reports based on SQL.

For example: find products without SEO keyword
select x from y where (real sql is blocked in forum)

When I run this in phpadmin I see a list (id, name) of the products with these criteria.

Newbie

Posts

Joined
Tue Jun 11, 2013 3:41 am
Who is online

Users browsing this forum: No registered users and 48 guests