If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / Reset the "Also purchased" module in "product info"

Reset the "Also purchased" module in "product info"

Locked

Started by char3 on 6 Jul 2007, 3:01 PM · Views: 2,785

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
6 Jul 2007, 3:01 PM
#1
char3 avatar

char3

New Zenner

Join Date:
Apr 2007
Posts:
15
Plugin Contributions:
0

Reset the "Also purchased" module in "product info"

Hi, I don't know in wich post have to write this so I think this is the place

Since I'm working on my store, I had done many fake buyings to see if all was working well. Now in product info page appears the module "Customers who bought this product also purchased..."

I don't want to delete it, I want to reset the counters (or whatever it is) because the products appearing on it doesn't fit with anything with the original product.

So whith this fix this module will begin to work properly with customers actions.

Sorry about my grammar I hope you will understand it :P

7 Jul 2007, 4:11 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Reset the "Also purchased" module in "product info"

The Also Purchased is based on all of the orders created ...

You would have to customize the select statement for this in:
/includes/classes/db/mysql/define_queries.php

And alter what date period to look at to start it anew ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

7 Jul 2007, 11:37 AM
#3
char3 avatar

char3

New Zenner

Join Date:
Apr 2007
Posts:
15
Plugin Contributions:
0

Re: Reset the "Also purchased" module in "product info"

...what if I delete my customers (Many of them not real)? Should I delete any other table?

7 Jul 2007, 3:50 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Reset the "Also purchased" module in "product info"

If you delete customers via the Admin that should clean up the associated tables for you ...

NOTE: this does not delete order table information

Look at the file:
/admin/customers.php

search for:
deleteconfirm

And you can see the tables that will be cleaned out when a customer is deleted ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

7 Jul 2007, 7:07 PM
#5
char3 avatar

char3

New Zenner

Join Date:
Apr 2007
Posts:
15
Plugin Contributions:
0

Re: Reset the "Also purchased" module in "product info"

I will try it, thanks.

And by the way, nice avatar ;)

8 Jul 2007, 8:43 AM
#6
spbennett avatar

spbennett

Zen Follower

Join Date:
Feb 2007
Location:
Leicester UK
Posts:
230
Plugin Contributions:
0

Re: Reset the "Also purchased" module in "product info"

In Admin > Customers > Orders delete all your fake orders.

In Admin > Customers > Customers delete all your fake customers.

If you do it in this order, all order history will be deleted and the also purchased sidebox will show only orders from real customers that weren't deleted.

8 Jul 2007, 3:42 PM
#7
char3 avatar

char3

New Zenner

Join Date:
Apr 2007
Posts:
15
Plugin Contributions:
0

Re: Reset the "Also purchased" module in "product info"

spbennett:

In Admin > Customers > Orders delete all your fake orders.

Deleting only fake orders have worked, it was easier than I thought, thanks!