Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


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  

georgesjeandenis
Starting Member

Canada
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]

g3nnin
VP-CART Super User

209 Posts
Posted - July 01 2009 :  13:15:00  Show Profile  Reply with Quote
Hi,

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

carfin
VP-CART 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.

Regards,

Carrol
www.deanston-electrical.co.uk
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty