People who bought shows duplicate items.

  • Resolved dompl

    (@dompl)


    9 years, 9 months ago

    HI there.

    I need some here please.

    On my shop I have a “People who also bough” facility running.

    The problem I am having is that on this list shows the same product several times.

    Is there a way to show only unique products can be displayed on this list?

    Thank you for your help in advance!

    Dom

    https://wordpress.org/plugins/wp-e-commerce/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Mihai Joldis

    (@misulicus)

    9 years, 9 months ago

    I think thats a plugin that does that.
    You should try and ask the developers of the plugin

    Thread Starter dompl

    (@dompl)

    9 years, 9 months ago

    Hi Mihai,

    Thanks for your reply.

    I can see that this functionality is in the wp e-commerce folder

    wp-content\plugins\wp-e-commerce\wpsc-components\theme-engine-v1\helpers\product.php

    Would that be an independent plugin?

    Thanks!

    Mihai Joldis

    (@misulicus)

    9 years, 9 months ago

    ohh yeah 🙂
    Not exactly sure how to chage it. From what i see in the code it shows products that have been purchased along with the product you are viewing.

    So if someone buys PROD1 and PROD2, when you view PROD2 it will show PROD1 because it was bought at the same time with PROD2

    Try adding in that file on line 720 where you have:
    SELECT” . $wpdb->posts . “.* FROM” . WPSC_TABLE_ALSO_BOUGHT`
    Add DISTINCT after the select

    Thread Starter dompl

    (@dompl)

    9 years, 9 months ago

    Works like a charm, thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘People who bought shows duplicate items.’ is closed to new replies.