Today we’ll look at a bug (yeah another one) in WP e-Commerce that deals with ajax product sorting. The short story is that if you use the drag and drop sorting of products while viewing all categories you’re screwed. Yeah that’s right you’ll get duplicate products and not all of the products will show up.

While this is annoying it’s not all that hard to fix. Jump into PHP MyAdmin and the wpsc_products_order table and remove all products with a category id of 0. Refresh your site and you’re fixed.

No don’t use the product like you thought you could. If you want to read some more about the ‘fun’ WP e-Commerce brings to a project I wrote a bit about it. I also took a stab at making a WP e-Commerce theme that sucks less.

Watch the video for full instructions.

[podcast format=”video”]http://blip.tv/file/get/Curtismchale-WPECommerceDragAndDropSortingBug641.mov[/podcast]

Links

4 responses to “WP e-Commerce Drag and Drop Sorting Bug”

  1. Angus Avatar
    Angus

    I’ve read elsewhere that this is supposed to work, only problem is that my database doesn’t have a table called wpwpscproduct_order.

    Am I looking in the wrong place or something?

    1. curtismchale Avatar
      curtismchale

      Not sure really without seeing your database. That was for an older version of the software and they have moved to using Custom Post Types so that most likely changed a bunch of database stuff. I haven’t dug back in to the database since the change so I’m not sure what tables are still there or gone

  2. carmen Avatar

    Same problem here with the newer version…pls help!!!!

    1. curtismchale Avatar
      curtismchale

      Sorry I don’t use this crappy piece of broken software anymore. Try WooCommerce for something that doesn’t suck.