stylish - functional - affordable - successful

Problem/Solution WP Ecommerce Duplicate Products


Duplicate products were being displayed when using the productspage shortcode on a Page.

The Cause:

This tends to happen if you use the drag and drop sorting of products while viewing all categories. That’s right, you’ll get duplicate products and sometimes not all of the products will show up too.


While this is annoying it’s quite easy to fix. Go into PHP MyAdmin and the wp_wpsc_product_order table and remove all products with a category id of 0. Refresh your site and it’s fixed.

If there is still an issue after removing the category id of 0, then remove any duplicate product_id rows in the wp_wpsc_product_order table too.

PLEASE NOTE: It’s always a good idea to take a backup before making any alterations.


Elizabeth Richardson currently lives on The Gold Coast Of Australia and is a mother, teacher, business developer, author of the International Best Seller 500 Confessions, founder of The Appreciation Space and Get Rid Of Bad Habits - for good! As a teacher she helped many small business owners get started with Build Your Own Websites Classes in South Gippsland and on The Gold Coast. These days Elizabeth enjoys a life of total luxury but still plays as a writer, professional photographer and web designer. Her passion for living, loving and laughing, remains at the forefront of her focus.

Recommended Website Hosting

Get Occasional Email Updates

Enter your email address:

Delivered by FeedBurner

See What Our Sponsor Has To Offer