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

Great – glad you found it useful!

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.

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 – https://www.leewillis.co.uk/) – I’ll take a look at all of them and try and work them in.

Thanks

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