VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Add-ons for VP-ASP
 need help on figuring which tables
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

2 Posts

Posted - June 30 2009 :  10:26:52  Show Profile  Visit georgesjeandenis's Homepage  Reply with Quote
Can somebody please help me? I am new at this.
I need to find out which tables are used with the "tmp_topsellers.htm". There are so many of them.
Any hint would greatly be appreciated.

[email protected]

VP-ASP Super User

209 Posts

Posted - July 01 2009 :  13:15:00  Show Profile  Reply with Quote

Are you referring to the code under "[...]" characters? I believe they are retrieved from the records of products table.
Go to Top of Page

VP-ASP Expert

United Kingdom
948 Posts

Posted - July 02 2009 :  04:00:27  Show Profile  Reply with Quote
The template tmp_topsellers.htm only displays fields from the products table.
However the routine which collects the information to find the top selling products uses the oitems table (total sales of a product) and the orders table (check if order was processed) it then uses the catalogids of the products to get the relevant information from the products table to display in the template.


Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000