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

  1. mulewagon
    Posted 6 years ago #

    My xml sitemap wasn't showing my WP e-Commerce products. This plugin fixed it! Since I chose e-Commerce for the WordPress SEO features, that's a really important fix. Thanks, Lee!


  2. Lee Willis
    Posted 6 years ago #

    Great - glad you found it useful!

  3. danlawson
    Posted 6 years ago #

    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.

  4. Lee Willis
    Posted 6 years ago #

    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.


  5. Lee Willis
    Posted 6 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic