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.
Frontpage-Slideshow Feature Slideshow Front Slider WP Nivo Slider WordPress NextGEN Gallery JJ NextGen JQuery Slider (to work w/ NextGEN Gallery) Playing around with the above sliders to produce a Home page image slider. Share this post: Share on Twitter Share on Facebook Share on LinkedIn Share on Email
NOTE: This form does not have any Form Validation. Read full article: http://dreamweaverspot.com/adobe-dreamweaver-tutorial-contact-forms-asp/ Share this post: Share on Twitter Share on Facebook Share on LinkedIn Share on Email
Problem: Client is confused by grey-colored Georgia font when they write a Page or Post in the WordPress admin. Plus, the grey Georgia font doesn’t match what they see on the front-end of their site, which is Arial. Frankly, I don’t blame them. Solution: Change CSS in editor-style.css: wp-content/themes/twentyten/editor-style.css Line: 12 I changed my color…
Zen Cart version: 1.3.9h Problem: Media Manager *Assign to Products* doesn’t work (ie: it doesn’t actually assign the media to the product, you just keep getting sent to the Admin main page). Solution: Edit your /admin/includes/init_includes/init_sessions.php file On line 40 you’ll see a line that starts like this: if (strpos ( $PHP_SELF, FILENAME_PRODUCTS_PRICE_MANAGER ) ===…
The initial goal was to override a WordPress plugin’s image slider pagination thumbnails for desktop and mobile. I didn’t even know the plugin was using Vue.js. A lot of learning along the way about Vue instances, components, data, methods, and prototype. Still haven’t yet reached the goal of overriding the plugin’s Vue.js v2 settings, but…
Child Theme for WooThemes Canvas requires both style.css and custom.css files, as well as with functions.php. Read full article: How to Setup and Use a WooThemes Canvas Child Theme Share this post: Share on Twitter Share on Facebook Share on LinkedIn Share on Email
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.