Problem: Duplicate products were being displayed when using the productspage shortcode on a Page.
Solution*: Remove any duplicate product_id rows in the wp_wpsc_product_order table in phpMyAdmin.
*This solution worked in my case. It may not work in every situation.
Running:
WordPress 3.0.1
WP e-Commerce 3.7.6.7
Graphic designer since before the Internet. Started with newspaper paste-up; then art director for advertising agency in Reno, NV; and now freelancer designing marketing materials, print-on-demand t-shirt art, websites, and social media graphics.
Add Noindex To WooCommerce Products: Solution: Smashing Magazine’s Custom Fields Hacks For WordPress Use hack #8: “Disable Search Engine Indexing For Individual Posts” Add Custom Fields code to Child Theme’s header.php Add Custom Field to each WooCommerce product Share this post: Share on X (Twitter) Share on Facebook Share on LinkedIn Share on Email
Categories vs Tags – SEO Best Practices for Sorting your Content – WPBeginner The Right Way to Use Categories and Tags in WordPress to Boost SEO – ManageWP Writing & Editing Posts > Categories vs. Tags – WordPress Share this post: Share on X (Twitter) Share on Facebook Share on LinkedIn Share on Email
Problem: Changing “name and date-based” permalinks to “name-based” permalinks breaks all of my site’s old links. Changing: https://www.designparc.com/2008/08/08/post-title/ To: https://www.designparc.com/post-title/ breaks the former date-based connection. Solution: Rick Beckman’s “How to Update Your WordPress Permalinks Without Causing Link Rot” article Add RedirectMatch call to .htaccess file so that old “name and date-based” permalinks will seamlessly redirect to “name-based” permalinks….
1. Register a new menu in WordPress admin Use WordPress’s register_nav_menus to register the menu so it appears in Appearance > Menus > Menu Locations. Place the below PHP code in Code Snippets plugin: Important: In the Code Snippet plugin, right below the PHP code, make sure and choose Run snippet everywhere. Otherwise the newly-registered…
Goal: Custom Widget colors, text and rounded corners: Title: dark-blue background; bold, white font. Body: medium-blue background; rounded top-left/right corners. NOTE: these are only initial customizations. More is required. Solution: Add the following CSS to Child Theme stylesheet. Share this post: Share on X (Twitter) Share on Facebook Share on LinkedIn Share on Email
Goal: Add Social Media Widget‘s social media icons into Header area Solution: Replace WP Twenty Eleven’s search box with a Widget area, but still display the search box when no Widget is used. Reference (from WP Tuts Plus): Creating a Simple Child Theme Using Twenty Eleven includes instructions on how to add a widget to…
After searching for days, this one was the one that actually worked! Thanks for posting it!
One quick question, after deleting the duplicates in the php, how long does it take to show up on the normal site? When I am logged in, the duplicate products are gone but when I am not logged in they are still there. I deleted them in the php about two hours ago and I wasn’t sure if it took a lot longer to take effect.
I appreciate your time!
Zach, the effect should be immediate. It may be that my instructions are for different versions of WordPress and WP e-Commerce than you have. Also, you mentioned “deleting the duplicates in the php”; however, my solution requires altering the MySQL database: “Remove any duplicate product_id rows in the wp_wpsc_product_order table in phpMyAdmin.”
I hope that helps.
I have to ask, did you uninstall and then reinstall the WP e-Commerce plugin at any point in time? This is the problem I’m having and I want to ensure this does not bite me again in the future. I suspect this is why this happed to me, but haven’t spent time confirming. Nor do I really care as long as it gets resolved.
Hey Paul, good question. I did not uninstall/reinstall WP e-Commerce at any time while editing of my database via phpMyAdmin. This solution worked for me, but your setup may be ever-so-slightly different and not work out. I hope this helps.
I’ve read elsewhere that this is supposed to work, only problem is that my database doesn’t have that table. The only table with ‘product’ in it is wp_wpsc_product_rating…
Am I looking in the wrong place or something?
Hi Angus,
I remember at the time I was running WordPress 3.0.1 and WP e-Commerce 3.7.6. Since then, WP e-Commerce has updated many times, and they’re always changing things. I just looked at a recent version of WP e-Commerce’s tables and you’re right, there’s definitely no table named “wp_wpsc_product_order” anymore. You also must be using a recent version and that’s why neither of us is seeing that table anymore.
It’s been a while since I’ve dug deep into WP e-Commerce and I’ve recently moved on to playing with eShop (http://wordpress.org/extend/plugins/eshop/).
Sorry I didn’t have an answer for you, Angus.
This solution will work almost every time. This issue occurs when I try to rearrange product by dragging product, after that I refresh the database and see new entries with new order..
In short, sort ASC
wp_wpsc_product_order by product_id and order_id. remove duplicated product_id where order_id is old or less than (because changes made assigns new order_id, so old id was for old order). Beware of deleting non-duplicate record.