With PHP-eSeller, If you have items in category / subcategory and you wish to analyse the items sold per categtory / subcategory, then one method is to use a SQL View and export the data to a spreadsheet.
A SQL View is like a query in MS Access. It is a combinations of a number of tables which gives you a much more convenient display.
However, Views are only supported on mySQL version 5 and above so you need to be using that version.
To create a view, go to your PHPMyAdmin interface on your server, go to the database where PHP-eSeller tables are located and in a SQL query box copy the following text :
CREATE VIEW fullsalesdetails AS
FROM ipn_tblsaleshistory INNER JOIN
((ipn_tblmaincategory INNER JOIN ipn_tblitems ON ipn_tblmaincategory.recid = ipn_tblitems.maincat_id)
INNER JOIN ipn_tblsubcategory ON ipn_tblitems.subcat_id = ipn_tblsubcategory.recid)
ON ipn_tblsaleshistory.item_id = ipn_tblitems.recid
WITH CHECK OPTION;
This will create a view called “fullsalesdetails” Note that this assumes that when the tables were created there was no prefix used for the table name.
You can then look at this view in the same way as any table, and you can even query the view. So you could do something like :
Select * FROM fullsalesdetails WHERE payment_date > "2008-05-01"