Adding Custom Reports in Admin

[ericet]

Hello,

I got this script below for my site:
http://www.battery-warehouse.ca/inventory.php

Since, I'm an SQL Programmer (Oracle mainly) I would to create other scripts that would generate different types of reports. The one above works but anyone can point to it and execute it. I would like this and other reports to be available on from the Admin section of ZenCart.

Things I want to build would be sales reports by country and a bunch of others ones. But I would like a menu item in the Admin section to do this.

What is the easiest way to do this?

Thanks!
Eric

[HeyIts007]

Hey, can you please post an example php reporting script. I want to learn how to write custom queries in ZenCart.

I want to return all products in the products table. I then want to populate an array with the product name, price and image name.

Yes I would like to make a simple product slide show.

Thanks

[ericet]

Hi,

Well my inventory script link on my site works. Just click on it to see the results. What else do you need?

Eric