Best Products Purchased

[Sierrab]

I have been testing the site in the PayPal Sandbox and am ready to go live. I want to clean up the db so that it tracks real sales from now on.

 

I have been able to delete all the Orders and related info, but when I view Best Products Sold in Admin, there is still a list of products that have been sold, even though no orders show when I select that in Admin.

 

Where in the db is this info stored, I have looked at all the tables but cannot seem to locate it?

 

Steve

[M-Pro]

There is a 'products_ordered' field in the product table. The best sellers box does a select on the products table by descending products_ordered .

 

A simple sql from your mysqladmin

 

update products set products_ordered = 0

 

will set all products to a quantity of zero

 

M-Pro

[Sierrab]

There is a 'products_ordered' field in the product table. The best sellers box does a select on the products table by descending products_ordered .

 

A simple sql from your mysqladmin

 

update products set products_ordered = 0

 

will set all products to a quantity of zero

 

M-Pro

<{POST_SNAPBACK}>

Perfect Thank You...Now all I need is some customers!!

 

Steve