SEO that generates enquiries - Guaranteed

WP eCommerce Variation Ordering Fix

A simple WordPress plugin that allows you to order your product variation in WP eCommerce

For those of you who are frustrated with not being able to order your product variations in WP eCommerce, this plugin provides a simple solution allowing you to drag and drop your variations in the order that you want.

We had the plugin developed specifically for version 3.8.7.1 of WP eCommerce. It may work with other versions, but please be aware that we have not tested it on any other version. So please, use best practices and do a full backup of your Word Press site before installing.

The plugin is installed the same way as any other normal plugin for Word Press…

  • Click on Plugins
  • Click on Add New
  • Browse to the location of the plugin on your computer and select it
  • Click on Install Now
  • Click on Activate

You should now have another option under the Products heading called Variation Order. To use…

  • Click on Variation Ordering
  • Click on the name of the variation that you would like to order
  • Drag and drop the variations in the order that you want them
  • Click on Update

We hope this helps you out, as you are probably as frustrated with the situation as we were. Hopefully WP eCommerce will incorporate this functionality into a future update, but until then, enjoy our plugin. If you’re grateful for the plugin and feel like chipin in a few dollars for the development cost of it, please help us out and hit the donate button.




Thanks for helping out.

 

Here’s the link to download the plugin…

WP eCommerce Variation Ordering Fix Plugin

If you do install the plugin on other versions of WP eCommerce and have success or failure, please make a comment below so that others get the heads up on it. Thanks very much.

48 Responses

  1. You da man MAN!!!

    Thanks for this. I really appreciate it. This was exactly what I needed. I am going to add a back link from my site yours.

    Thanks again.

    Sincerely,

  2. Hi. Doesn’t seem to work as documented with 3.8.7.4.

    After dragging and dropping a variation set’s element, and pressing “Update”, it goes back to the original order.

    Hope that helps. Thanks for this though. Just wish it was working with the latest version. That’ll be nice to know if anyone else running this plugin with that version of WP e-Commerce have the same issue.

    1. @ Sherwin
      Thanks for the advice. Yeah we’re running 3.8.7.1 – when we update, we’ll no doubt have to update the plugin.

  3. Yeah, we’re running 3.8.7.1 also, and it doesn’t keep the order. It reverts back to the alphabetical order. Any ideas on how to get it to work?

  4. Fantastic for making a plugin for exactly this as variations have been the bane of my life with WPEC. However for me here in West Lakes it does not seem to work… 😉
    I see it is in the next WPEC update, however… would you care to take a look into the file I have on a client site to see why it is not working as I hoped?

    1. @Ciaran
      Yes, it is only tested on 3.8.7.1 – we will be updating it to current version in a couple weeks and will either update the plugin to work with latest version of WPEC or switch to using the new one they have apparently implemented.

  5. Hi James,

    I have installed the beta version of the latest WPEC 3.8.8, and can confirm it works fairly bug free. Is that the update that you have sent them? If so, it works fantastic.

  6. No, I haven’t sent it to them.

    Am just glad they’ve incorporated the facility into the main plugin!

  7. Hi

    Great plugin – wish I had found it earlier.

    Further to ordering ‘variations’ I need to order the full ‘sets’. Currently sets seem to be alphabetical, but I need them in a specific order. Is there e plugin to order the full sets or does anyone know of a way to do this?

    Best

    Glennyboy

    1. @Glennyboy
      If all goes well, we’ll be updating the plugin in a few weeks to allow the ordering of the sets as well.
      Cheers
      James

  8. Hello James,

    Thank you for a great plugin!

    I found a bug and have posted a fix. It is not supporting custom DB prefix’s. We change all our prefix from “wp_” to something custom for extra security 😉

    http://getshopped.org/forums/topic/3-8-7-variation-order/#post-257325

    Thank you very much for your support and sharing with the community.
    =-)

    The fix as posted on the link above

    variation-ordering.php
    Change:

    $wpdb->update(“wp_term_sorting”,array(“order”=>$vl),array(“term_id”=>$id));

    To:

    $wpdb->update($wpdb->prefix . “term_sorting”,array(“order”=>$vl),array(“term_id”=>$id));

    Change:

    $wpdb->insert(“wp_term_sorting”,array(“order”=>$vl,”term_id”=>$id));

    To:

    $wpdb->insert($wpdb->prefix . “term_sorting”,array(“order”=>$vl,”term_id”=>$id));

  9. Pingback: Re-ordering variations on single product page wp-ecommerce | Clear As Mud
  10. Not working with 3.8.7.6.2. The ordering is not saved after you hit UPDATE. Not sure why WPEC does not have this natively. I need the NONE option always at the top.

    1. Looks like we’ll definitately get the plugin updated soon, but my programmer is away at the moment. Hang in there and we’ll get it updated as soon as we can.

  11. I do not see anything in the Variation order screen
    WordPress 3.31
    WP e-Commerce 3.8.7.6.2

    1. Strange. Assume your variations are setup properly with sets and options?
      It’s working fine for me on 3.3.1 & 3.8.7.6.2 – although I was on 3.8.7.1 when we first installed the variation ordering and then upgraded to 3.8.7.6.2. Not sure if that makes a difference.

  12. do you have a plugin that allows different images to be shown for each product variation?
    thanks

    1. @adem
      Sorry no we don’t. Nice idea though…
      If you made one, I guess that since product variations can be applied to any product, it would need to be implemented at the product level so you could assign different images. Which shouldn’t be too difficult as you can currently set different values like stock level and cost for each variation.

  13. Thanks so much for developing this – it’s well worth $20 to make a client happy. Just installed it on WP 3.3.2 and WPEC 3.8.8.1

  14. it doesn’t work with WP 3.4.1 and 3.8.8 🙁

    could please submit more help .

    thank you

  15. Great plugin! If it only worked with 3.8.8 … It seems like after they implementet the sorting feature in version 3.8.8 (which still does not work if you have enough variations to span over two pages and is certainly not as easy as this plugin) the plugin does not work. I can move the variations, but they will move back in their original position after hitting “Update”.

    If there is anyway to get this plugin to work for 3.8.8 I would be much interested! Thanks a lot for your work anyhow. 🙂

  16. Hi,
    Thank you for great plugin.

    It does work for me on WordPress version 3.5.1 and WPEC 3.8.9.5 with some small tweaks

    You just need to replace all “wp_term_sorting” with $wpdb->prefix.”term_sorting”

  17. I am having trouble with the WP e Commerce 3.8.12.1 and WP 3.6.1 the drag and drop that comes with e commerce was reverting back when i left the page.

    So i found your plugin and tried it, pressed update and variations reverted back.

    Updated “wp_term_sorting” with $wpdb->prefix.”term_sorting” and still having the same problem.

    Is there any solution, or something I am missing?

    1. Hi Jerry,

      Sorry but we haven’t updated/tested the plugin fix with the latest versions of WP or eCommerce. I’ll send a message to the programmer to see if he’s interested in continuing support for it.

  18. This would be awesome James, just because i also have so many variations and sub-variations that span over multiple pages in WPEC. It is good having it all broken down as in your plug-in. Any help would be appreciated.

    1. Hi Jerry,
      I’ve spoken to my programmer who is most likely going to take over control of the plugin and support/update it himself. He’ll probably charge a nominal fee for it but at least it will be reliable then. I’ll post here once he’sdone something about it.

  19. Hi – It didn’t work out of the box. Turned out to be because I use a prefix other than wp_ in the database. Lines 89, 91 and 93 are incorrectly coded to assume the prefix is wp_, correcting those lines to substitute “.$wpdb->prefix.” for wp_ fixes the problem and it works fine.

    Thanks!

  20. Thank you very much!
    We have number of variations and it is particularly important that they are in a certain order.
    First time in our history they are now, thanks to this plugin.

    WP 3.9.1
    WPEC 3.8.12.1

    Next: I’m going to donate!