WP eCommerce Variation Ordering Fix
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.

Anyplugin that makes my job easier in handling ecommerce is definitely most appreciated.
December 4th, 2011 at 1:09 amYou 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,
December 8th, 2011 at 1:59 pmHi. 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.
December 12th, 2011 at 10:40 amThanks Shawn, appreciate the link!
December 12th, 2011 at 12:41 pm@ Sherwin
December 12th, 2011 at 12:43 pmThanks for the advice. Yeah we’re running 3.8.7.1 – when we update, we’ll no doubt have to update the plugin.
Thanks for this plugin, And do you khow to make one of variations for default?
December 14th, 2011 at 4:58 amJust wondered if you’d consider contributing this into the core plugin?
December 14th, 2011 at 5:34 am@Denis Creative
December 14th, 2011 at 6:57 amSorry mate, no we didn’t implement a function to set a default variation.
@Lee
December 14th, 2011 at 7:05 amYes we’d consider it. Not sure who to contact…
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?
December 16th, 2011 at 11:54 pm@Zane
December 19th, 2011 at 8:17 amNot sure why it’s not working for you.
However, it looks like they’ve finally release a version which includes variation ordering… http://getshopped.org/getshopped-news/wp-e-commerce-plugin-3-8-8-beta-ready-for-consumption/
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…
January 5th, 2012 at 9:27 pmI 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?
Ahh … just seen that it is not working with the latest version of WPEC…
January 5th, 2012 at 9:28 pm@Ciaran
January 6th, 2012 at 7:46 amYes, 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.
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.
January 6th, 2012 at 3:53 pmNo, I haven’t sent it to them.
Am just glad they’ve incorporated the facility into the main plugin!
January 8th, 2012 at 9:07 pmHi
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
January 25th, 2012 at 9:39 pm@Glennyboy
January 26th, 2012 at 7:22 amIf all goes well, we’ll be updating the plugin in a few weeks to allow the ordering of the sets as well.
Cheers
James
Love you man!! Amazing plugin just what I was looking for!!!!
February 21st, 2012 at 6:13 amHello 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));
February 29th, 2012 at 5:48 am[...] http://www.getseenonline.com.au/wp-ecommerce-variation-ordering-fix.html [...]
March 6th, 2012 at 9:25 amNot 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.
March 12th, 2012 at 10:18 pmLooks 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.
March 13th, 2012 at 9:50 amI do not see anything in the Variation order screen
March 31st, 2012 at 12:36 pmWordPress 3.31
WP e-Commerce 3.8.7.6.2
Strange. Assume your variations are setup properly with sets and options?
April 2nd, 2012 at 8:21 amIt’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.
All working well for me – WP 3.3.2 and WP-eCommerce 3.8.8
Great job!! Thanks
May 18th, 2012 at 8:27 pmdo you have a plugin that allows different images to be shown for each product variation?
May 23rd, 2012 at 12:31 amthanks
@adem
May 23rd, 2012 at 8:04 amSorry 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.
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
June 1st, 2012 at 9:13 amThanks Lynn!!!
June 1st, 2012 at 10:53 amThank you, this is awesome. donation sent. and i hardly EVER donate for things.
September 20th, 2012 at 7:45 am@deweydb
September 20th, 2012 at 10:28 amThanks mate, donation received.
Glad it helped you out!
it doesn’t work with WP 3.4.1 and 3.8.8
could please submit more help .
thank you
October 3rd, 2012 at 9:34 amGreat 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.
October 4th, 2012 at 10:22 pmSimple, useful, doing its job perfectly. Great work!
March 14th, 2013 at 11:20 am