osCommerce Community Support Forums

malkie1000

Aug 21 2008, 03:06 PM

I'm at a new phase of my os commerce site and want to zero out the reports to track the popularity of the revamped products list. How do you clear/ zero out the orders to date, products purchased and products viewed to date reports in the report module?

malkie

diy

Aug 21 2008, 04:40 PM

QUOTE (malkie1000 @ Aug 21 2008, 04:06 PM)

I'm at a new phase of my os commerce site and want to zero out the reports to track the popularity of the revamped products list. How do you clear/ zero out the orders to date, products purchased and products viewed to date reports in the report module?

malkie

Products views is a part of table products description in the database

CODE

INSERT INTO `products_description` (`products_id`, `language_id`, `products_name`, `products_description`, `products_url`, `products_viewed`)

So you should redump your products description with the last value set to zero

again products ordered is a part of products table

CODE

INSERT INTO `products` (`products_id`, `products_quantity`, `products_model`, `products_image`, `products_price`, `products_date_added`, `products_last_modified`, `products_date_available`, `products_weight`, `products_status`, `products_tax_class_id`, `manufacturers_id`, `products_ordered`)

So again you should redump the info of the table with the last value set to zero

if you have time to spare try it first on a TEST database and backup the original one

malkie1000

Aug 21 2008, 04:49 PM

QUOTE (diy @ Aug 21 2008, 05:40 PM)

Products views is a part of table products description in the database

CODE

INSERT INTO `products_description` (`products_id`, `language_id`, `products_name`, `products_description`, `products_url`, `products_viewed`)

So you should redump your products description with the last value set to zero

again products ordered is a part of products table

CODE

INSERT INTO `products` (`products_id`, `products_quantity`, `products_model`, `products_image`, `products_price`, `products_date_added`, `products_last_modified`, `products_date_available`, `products_weight`, `products_status`, `products_tax_class_id`, `manufacturers_id`, `products_ordered`)

So again you should redump the info of the table with the last value set to zero

if you have time to spare try it first on a TEST database and backup the original one

Thank you very much

malkie1000

Aug 21 2008, 04:49 PM

Thanks very much

eww

Aug 23 2008, 08:20 AM

that's too much work.
try this instead: http://addons.oscommerce.com/info/2246