WordPress.org

Support

Support » Plugins and Hacks » [Plugin: WP Shopping Cart XML Sitemap] Soved a big probem for me!

[Plugin: WP Shopping Cart XML Sitemap] Soved a big probem for me!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Lee Willis

    @leewillis77

    Great – glad you found it useful!

    danlawson

    @danlawson

    Thanks for this Lee, It has been very useful.

    I have made a couple changes to the latest version to filter only active products/ categories and to include the product list pages also.

    SELECT  c.id, UNIX_TIMESTAMP(p.date_added) as dt
    FROM wp_wpsc_product_categories c,
    wp_wpsc_item_category_assoc cp,
    wp_wpsc_product_list p
    WHERE c.id = cp.category_id
    AND cp.product_id = p.id
    AND c.active = 1
    GROUP BY c.id
    ORDER BY c.id

    Thanks again.

    Lee Willis

    @leewillis77

    Hi Dan.

    Thanks for the revised SQL to pick up only active categories. If you send me the other changes (Either here – on via the contact form on my blog – http://www.leewillis.co.uk/) – I’ll take a look at all of them and try and work them in.

    Thanks

    Lee Willis

    @leewillis77

    I’ve also modded it to only pick up active products – but not sure what you mean about including the product list pages also?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: WP Shopping Cart XML Sitemap] Soved a big probem for me!’ is closed to new replies.
Skip to toolbar