How to Clear the reports data

[webcomm_man]

Hi,

 

I have been testing the store before it going live. It has created lot of data for report in items viewed. ordered etc.. Now I want to clear the reports as the store has gone live.

 

How can I do it?

 

webcomm_man

[email protected]

[♥Monika in Germany]

Hi,

 

I have been testing the store before it going live. It has created lot of data for report in items viewed. ordered etc.. Now I want to clear the reports as the store has gone live.

 

How can I do it?

 

webcomm_man

[email protected]

open phpmyadmin and run two updates, one is for products table for the ordered products, one in products description for the viewed products (report stores it separetely for each language)

 

update products set  products_ordered = '0';
update products_description set  products_viewed = '0';

 

As a general tip, in the install folder of osCommerce you find the database file oscommerce.sql

This is your best friend when you want to find column names, configuration key parameters or even IDs for a special country fast ... just search in this file.

[webcomm_man]

Thanks Monika. I appreciate this.

 

I would like to work on some enhancements in my store. Some of the enhancements I need are:

 

1. Processing Gift Certificates.

2. Offering discount on an item if purchased with another item.

 

How to go about it. I would like to collaborate with other programmers

 

WebComm_Man

[♥Monika in Germany]

Thanks Monika. I appreciate this.

 

I would like to work on some enhancements in my store. Some of the enhancements I need are:

 

1. Processing Gift Certificates.

2. Offering discount on an item if purchased with another item.

 

How to go about it. I would like to collaborate with other programmers

 

WebComm_Man

both have already been coded and work fine ... you find them in the contribution section

 

I use CCGV(trad) by vger for gift voucher, and have not used but know it's good 2gether discount contrib by boxtel

 

http://www.oscommerce.com/community/contri...earch,CCGV+trad

http://www.oscommerce.com/community/contri.../search,2gether

[webcomm_man]

both have already been coded and work fine ... you find them in the contribution section

 

I use CCGV(trad) by vger for gift voucher, and have not used but know it's good 2gether discount contrib by boxtel

 

http://www.oscommerce.com/community/contri...earch,CCGV+trad

http://www.oscommerce.com/community/contri.../search,2gether

 

 

Thanks Monika. I would look at them - WebComm_Man(Canada)