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
Anyplugin that makes my job easier in handling ecommerce is definitely most appreciated.
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,
Thanks Shawn, appreciate the link!
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.
@ 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.
Thanks for this plugin, And do you khow to make one of variations for default?
@Denis Creative
Sorry mate, no we didn’t implement a function to set a default variation.
Just wondered if you’d consider contributing this into the core plugin?
@Lee
Yes 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?
@Zane
Not 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… 😉
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?
Ahh … just seen that it is not working with the latest version of WPEC…
@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.
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.
No, I haven’t sent it to them.
Am just glad they’ve incorporated the facility into the main plugin!
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
@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
Love you man!! Amazing plugin just what I was looking for!!!!
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));
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.
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.
I do not see anything in the Variation order screen
WordPress 3.31
WP e-Commerce 3.8.7.6.2
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.
All working well for me – WP 3.3.2 and WP-eCommerce 3.8.8
Great job!! Thanks
do you have a plugin that allows different images to be shown for each product variation?
thanks
@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.
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
Thanks Lynn!!!
Thank you, this is awesome. donation sent. and i hardly EVER donate for things.
@deweydb
Thanks 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
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. 🙂
Simple, useful, doing its job perfectly. Great work!
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”
Thanks Dinwebb!
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?
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.
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.
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.
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!
This is not working on the size options 🙁 I wanted to show Extra Small – Small – Medium – Large – Extra L & XXL
Here’s the page a proof that the plugin is not working
http://www.fixmygolfswing.com.au/rhythm-set-1
Does anyone has this same issue? Please help.
Thank you
This is not working on the size options 🙁 I wanted to show Extra Small – Small – Medium – Large – Extra L & XXL
Here’s the page a proof that the plugin is not working
http://www.fixmygolfswing.com.au/rhythm-set-1
Does anyone has this same issue? Please help.
Thank you
Looks like you got it working ok?
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!
Glad it helped you out. Thanks very much for the donation!!
Hi i am glad to use your plugin it helped me a lot.
even saved it for future use. We deal in wordpress websites.