Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2007
    Posts
    15
    Plugin Contributions
    0

    Default 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

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: v1.5.5]
    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!

  3. #3
    Join Date
    Apr 2007
    Posts
    15
    Plugin Contributions
    0

    Default Thanks but...

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

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: v1.5.5]
    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!

  5. #5
    Join Date
    Apr 2007
    Posts
    15
    Plugin Contributions
    0

    Default Ok thank you!

    I will try it, thanks.

    And by the way, nice avatar ;)

  6. #6
    Join Date
    Feb 2007
    Location
    Leicester UK
    Posts
    219
    Plugin Contributions
    0

    Default Re: Ok thank you!

    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.

  7. #7
    Join Date
    Apr 2007
    Posts
    15
    Plugin Contributions
    0

    Default Re: Ok thank you!

    Quote Originally Posted by spbennett View Post
    In Admin > Customers > Orders delete all your fake orders.
    Deleting only fake orders have worked, it was easier than I thought, thanks!

 

 

Similar Threads

  1. Replies: 3
    Last Post: 15 Feb 2013, 03:17 PM
  2. v150 How do I edit Product Listing "Price", "Qty." and Product Info Move "details"?
    By schobook in forum Templates, Stylesheets, Page Layout
    Replies: 9
    Last Post: 18 Jan 2013, 01:02 AM
  3. "Also Purchased" Not Displaying on Product Info Page
    By nlcabrera in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 30 Sep 2010, 11:31 PM
  4. Possible to set the "also bought" and "specials" to nofollow?
    By shrimp-gumbo-mmmhhh in forum General Questions
    Replies: 2
    Last Post: 10 May 2010, 01:40 PM
  5. Replies: 1
    Last Post: 1 Apr 2010, 10:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR