Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Best Products Purchased


Sierrab

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

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

 

Steve

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...