WordPress.org

1. mulewagon
   Member
   Posted 3 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!

   http://wordpress.org/extend/plugins/wp-e-commerce-xml-sitemap/

2. Lee Willis (leewillis77)
   Member
   Posted 3 years ago #
   

   Great - glad you found it useful!

3. danlawson
   Member
   Posted 3 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 (leewillis77)
   Member
   Posted 3 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.

   Thanks

5. Lee Willis (leewillis77)
   Member
   Posted 3 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.