VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: RuggeroSB on September 10, 2012, 13:39:18 PM

Title: Sort Order of Products & Child Products
Post by: RuggeroSB on September 10, 2012, 13:39:18 PM
Running VM 2.0.10, Joomla 2.5.6, PHP 5.3.15

After reviewing the UI and the code, I've made the following determinations regarding ordering:


The easy sorting of products of all kinds, be it parents or children, I would think is something that should be standard for any ecommerce platform, let alone one of Virtuemart's magnitude.

So, either somebody will (please) tell me that my observations are completely wrong and I've missed something entirely (I really hope that's true), or there's a major problem with ordering of products, both with manual ordering of parents and the fact that child products cannot be ordered at all.
Title: Re: Sort Order of Products & Child Products
Post by: blackrat999 on September 11, 2012, 16:38:16 PM
Nope you are right - its a dogs dinner that is all over the web - looking forward to a fix on this !!
Title: Re: Sort Order of Products & Child Products
Post by: RuggeroSB on September 11, 2012, 16:43:13 PM
Quote from: blackrat999 on September 11, 2012, 16:38:16 PM
Nope you are right - its a dogs dinner that is all over the web - looking forward to a fix on this !!
Agreed - a terrible mess that's hard to explain away to clients! And God-forbid you do Step 1b on several hundred products and then accidentally do Step 1a (see my OP for steps I'm talking about) - you can then kiss your all your hard ordering work goodbye!
Title: Re: Sort Order of Products & Child Products
Post by: RuggeroSB on September 12, 2012, 16:04:05 PM
Bump. Somebody should address this issue. I've looked around the VM forum and noticed this issue raised many times with no response.

If this is not where bugs should be reported and addressed, then somebody in the know please let me know where they should be reported where it will get the required attention (although this forum is called "Virtuemart 2 Development and bug reports", so I would think this is the right place).
Title: Re: Sort Order of Products & Child Products
Post by: wpompen on October 05, 2012, 17:09:32 PM
RuggeroSB, I totally agree! I'm struggling with this since I migrated to VM2 over a month ago, there's no turning back to VM1 since I dicovered it too late.
Otherwise it probably would have been smarter to wait ;-) I'm surprised that this seems to be neglected by the devs and hope to see it fixed soon, until then it's a p in th a...
Title: Re: Sort Order of Products & Child Products
Post by: RuggeroSB on October 05, 2012, 18:47:41 PM
Well, it only gets better I'm afraid: If you try to reorder the shopper fields, that breaks too! If you use the arrows, you get some error about permissions and if you try using the numbers it's totally futile.

I have yet to find a single list view on VM2 who's reorder function works as it should!
Title: Re: Sort Order of Child Products already a problem for 6 years!
Post by: blans on October 08, 2012, 10:19:35 AM
Dear Dev Guys,

We have all been very patient on this subject but I think it's now time to shed some light on why this issue has not been solved yet.

Already beginning of last year I posted about this problem but I simply cannot believe more features were added before solving this basic E-commerce functionality.
Not to mention the whole reason me and a lot of others have still not updated our webshops to VM2 is the complexity of setting up a simple parent/child list in VM2 and get it to work.

Ordering child items in a drop down list (not solved since 2006!) - http://forum.virtuemart.net/index.php?topic=81241.msg267720#msg267720 (http://forum.virtuemart.net/index.php?topic=81241.msg267720#msg267720)
Stockable variants: sorting order of child products in dropdown box - https://forum.virtuemart.net/index.php?topic=108097.0 (https://forum.virtuemart.net/index.php?topic=108097.0)
How to Order (List Order) your Child Products - http://forum.virtuemart.net/index.php?topic=107423.0 (http://forum.virtuemart.net/index.php?topic=107423.0)
Product Display Dropdown Order - http://forum.virtuemart.net/index.php?topic=104180.0 (http://forum.virtuemart.net/index.php?topic=104180.0)

We all want T-Shirts --> T-Shirt XS - €9,95 | T-Shirts S - €9,95 | T- Shirt M - €9,95 etc....

Ordered from XS to XL !!!

Title: Re: Sort Order of Products & Child Products
Post by: Jimmie on October 12, 2012, 22:07:56 PM
I keep it simple.... me too.  I am searching for two days now. And many people have this problem. What is the solution? Can't be that hard to program. I donate € 50,- if a decent solution is posted next week  ;)
Regards, Jimmie
Title: Re: Sort Order of Products & Child Products
Post by: wpompen on October 13, 2012, 12:45:54 PM
I'm with you guys! Fix this already, I'll gladly donate also!

(... however that should not be the reason to finally get the job done)
Title: Re: Sort Order of Products & Child Products
Post by: afon on October 15, 2012, 01:13:33 AM
Yes will be very nice and helpful... when you fix it

here also a other one http://forum.virtuemart.net/index.php?topic=108333.0 (http://forum.virtuemart.net/index.php?topic=108333.0)

Thanks!
Title: Re: Sort Order of Products & Child Products
Post by: blans on October 15, 2012, 13:48:11 PM
Thanks guys for the support. It also shows the importance of this problem.

The support for J1.5 has ended so people using J1.5 and VM 1.9 are in the corner here. What to do...?

I would like to rebuild the website on J2.5 and VM2 but then this issue need to be fixed. I don't want to rebuild on J2.5 and VM 1.9.

We also have an external developer waiting for my "go" with a VM - Navision coupling.

But this aside I'm also just flabbergasted why this issue has still not been resolved and why there is no feedback from the devteam.

Title: Re: Sort Order of Products & Child Products
Post by: RuggeroSB on October 15, 2012, 14:00:08 PM
I can't believe this issue is simply being ignored! There's a clear need for this to be sorted out as a matter of priority - there are dozens of IGNORED POSTS on this very topic all over the forum!

Ignoring the problem is not going to make it go away! Some sort of response from the powers-that-be, apart from being good manners, would be appreciated.
Title: Re: Sort Order of Products & Child Products
Post by: blans on October 15, 2012, 14:43:15 PM
I agree with RuggeroSB,

It's not so much this problem that's worrying me but more so is the continuity of Virtuemart with this attitude of the devteam.

On the OpenCart forum you are scolded when even mentioning a possible improvement in security matters or anything else. On the Magento forum you are simply not answered at all.

Here I always loved the community and the great feedback that you receive, A bit dependent on the same people, but great.

Now it's becoming very worrying to see where it's going... Please assure us that we are not moving towards the OpenCart or Magento model but stay user focused...
This situation is exactly why so many turn away from Opensource and also what I was warned for so many times before picking up Mambo years ago and again when implementing Virtuemart for a commercial website/shop for a rock solid but innovative company.

Joomla / Virtuemart but also the businesses that use these tools have grown. This means we are dependent of the continuity of Virtuemart. Having some insight into the status of a problem like this seems therefor very justified.
Title: Re: Sort Order of Products & Child Products
Post by: CE WebDesign München on October 23, 2012, 17:37:54 PM
hi,
this worked for me, please test:
http://forum.virtuemart.net/index.php?topic=108844.msg365111#msg365111
Title: Re: Sort Order of Products & Child Products
Post by: RuggeroSB on October 23, 2012, 23:51:35 PM
Quote from: gogo123 on October 23, 2012, 17:37:54 PM
hi,
this worked for me, please test:
http://forum.virtuemart.net/index.php?topic=108844.msg365111#msg365111
Credit to Umbobabo for fixing ONE of the nuances/bugs identified, but that doesn't solve all the other sort issues.


Additionally, this code doesn't appear 2 have been added to the main repository, basically rednering it useless if you update VM.

How long are we just going to be ignored one has to wonder? Well, I've moved on - I've purchased an alternative. At least that way I know I'll get support and won't simply be ignored. Time is money and this is just beyond ridiculous now.
Title: Re: Sort Order of Products & Child Products
Post by: KooTjoo on October 24, 2012, 19:05:53 PM
I totally agree, it can't be that difficult to achieve this. The child product ordering is essential. Please inform if a solution is on the way. It is better to get a negative response than no response at all.

KooTjoo
Title: Re: Sort Order of Products & Child Products
Post by: PolishedGeek on October 25, 2012, 05:25:58 AM
Hello -

I can offer a viable workaround for many custom field frustrations, as long as you don't need parent/child products. We created a new extension was built for a much larger purpose, but it can also easily solve many custom field challenges like the inability to sort options in a dropdown list however you like.

A client recently came to us a few months ago with a challenge: Enable VM2 to handle interdependent custom fields, including database lookups outside of VM2, with conditional fields and cross-field validation. This client needed to sell a bespoke tailored product that requires almost 40 (yes forty!) custom option choices.

As you can imagine - this type of complex custom field setup simply can't be done in standard VM2 without some serious hacking. And to the best of my knowledge, you can't really do it in any other Joomla eCommerce extension either.

So being the stubborn Geeks that we are, :) we finally found a way to make it happen - with NO hack!

We created an extension  to seamlessly integrate a completely custom Crosstec Breezing Form into the custom field area of a VirtueMart 2 product. Because BreezingForms is a fully featured form development component, this means that you can do all those great things you expect from best selling form design software,  then use that form as the way to capture product options and attributes for a VM2 product.

And of course, because you are using a form design component, you can control the ordering of dropdown options and other product selection fields almost any way you want.

If you think this sounds like it might help you, here's a link to our documentation to learn more: http://docs.polishedgeek.com/wiki/display/BFCUSTOM . There's a also a YouTube video there that explains it a bit more.

You also can learn about what you can do with the form component by Crosstec here: Crosstec BreezingForms http://crosstec.de/en/extensions/joomla-forms-download.html 


P.S.
Please note that while this integration CAN adjust product prices, it only tracks stock at a product level. It does NOT track stock by each individual form option answer. So it's not an alternative to parent/child products if you need to track stock in detail by options/attributes.  From reviewing the thread here, it sounds like it could help several people with their VM2 custom field problems. 

P.P.S. - I hope this post is acceptable here in this forum because it offers a specific solution to VM2 challenges posted. If this is not acceptable,  I will be happy to remove the post. Just let me know.  Thanks!


Title: Re: Sort Order of Products & Child Products
Post by: onnj on October 25, 2012, 05:51:13 AM
Same here Im wondering how will it be solve http://forum.virtuemart.net/index.php?topic=109165.0 haha. . . Please solve the issue VirtueMart Please???
Title: Re: Sort Order of Products & Child Products
Post by: KooTjoo on October 25, 2012, 10:35:38 AM
QuoteP.S.
Please note that while this integration CAN adjust product prices, it only tracks stock at a product level. It does NOT track stock by each individual form option answer. So it's not an alternative to parent/child products if you need to track stock in detail by options/attributes.  From reviewing the thread here, it sounds like it could help several people with their VM2 custom field problems.

And unfortunately this is exactly what I need: stock control at attribute level. Shame because I use Breezing Forms a lot and love it!

KooTjoo
Title: Re: Sort Order of Products & Child Products
Post by: KooTjoo on October 25, 2012, 14:13:47 PM
The only way to achieve this (what I have found out so far) is:

Change it directly in the database.

In the virtuemart_product_customfields table change the custom_param

Title: Re: Sort Order of Products & Child Products
Post by: RuggeroSB on October 25, 2012, 17:36:52 PM
Quote from: KooTjoo on October 25, 2012, 14:13:47 PM
The only way to achieve this (what I have found out so far) is:

Change it directly in the database.

In the virtuemart_product_customfields table change the custom_param
Sure - those who know how can. Try telling that to a "dumb" end user! Besides that's not a solution, just a workaround, and not a pretty one at that.
Title: Re: Sort Order of Products & Child Products
Post by: KooTjoo on October 25, 2012, 17:39:37 PM
QuoteSure - those who know how can. Try telling that to a "dumb" end user! Besides, that's not a solution.

I know it is not a solution, but I don't see other option.
Title: Re: Sort Order of Products & Child Products
Post by: RuggeroSB on October 25, 2012, 17:41:41 PM
Quote from: KooTjoo on October 25, 2012, 17:39:37 PM
I know it is not a solution, but I don't see other option.
I agree - that's exactly the problem!
Title: Re: Sort Order of Products & Child Products
Post by: KooTjoo on October 25, 2012, 20:11:49 PM
Thought I had "solved" it with the changes in the database. But Virtuemart doesn't like that and as soon as you save the product again in VM, VM rearranges it back to how it was.

Does anybody know if the developers even know that this is a big problem?
Title: Re: Sort Order of Products & Child Products
Post by: blans on October 29, 2012, 14:50:25 PM
You bet they do... Since I already mentioned this in 2006! http://forum.virtuemart.net/index.php?topic=81241.msg267720#msg267720 (http://forum.virtuemart.net/index.php?topic=81241.msg267720#msg267720)

We don't need instant solutions but a simple short reply to this thread would be nice.

We are trying to stay civilized on this forum but it seems the boiling-point of some members here is already reached on this topic.

Can Dev Team please respond to the status of the Ordering problems in Virtuemart...
Title: Re: Sort Order of Products & Child Products
Post by: togglewa on November 26, 2012, 11:39:37 AM
G'day, The solution that worked for me.. while not the best.. we still have to use what we have to make what we have :D

I'm using Virtuemart 2.0.14 but I'm sure it'll work on any 2.0.x

Find file and edit: /administrator/components/com_virtuemart/models/products.php

Then Search for: $q .= ' GROUP BY `virtuemart_product_id` ORDER BY ordering DESC';

Then replace it with the following:
         $q .= ' GROUP BY `virtuemart_product_id` ORDER BY product_name';
//         $q .= ' GROUP BY `virtuemart_product_id` ORDER BY ordering DESC';

Now you can change 'product_name' with any of the following filters:
'product_name', '`p`.created_on', '`p`.product_sku', 'product_s_desc', 'product_desc', 'category_name', 'category_description', 'mf_name', 'product_price', 'product_special', 'product_sales', 'product_availability', 'product_available_date', 'product_height', 'product_width', 'product_length', 'product_lwh_uom', 'product_weight', 'product_weight_uom', 'product_in_stock', 'low_stock_notification', '`p`.modified_on', 'product_unit', 'product_packaging', '`p`.virtuemart_product_id', 'ordering'

Hope it helps someone.. with the inbetween flight times to the solution ;)

Peace
Title: Re: Sort Order of Products & Child Products
Post by: Henrik Holm Nielsen on November 27, 2012, 10:58:24 AM
Quote from: togglewa on November 26, 2012, 11:39:37 AM
G'day, The solution that worked for me.. while not the best.. we still have to use what we have to make what we have :D

I'm using Virtuemart 2.0.14 but I'm sure it'll work on any 2.0.x

Find file and edit: /administrator/components/com_virtuemart/models/products.php

Then Search for: $q .= ' GROUP BY `virtuemart_product_id` ORDER BY ordering DESC';

Then replace it with the following:
         $q .= ' GROUP BY `virtuemart_product_id` ORDER BY product_name';
//         $q .= ' GROUP BY `virtuemart_product_id` ORDER BY ordering DESC';

Now you can change 'product_name' with any of the following filters:
'product_name', '`p`.created_on', '`p`.product_sku', 'product_s_desc', 'product_desc', 'category_name', 'category_description', 'mf_name', 'product_price', 'product_special', 'product_sales', 'product_availability', 'product_available_date', 'product_height', 'product_width', 'product_length', 'product_lwh_uom', 'product_weight', 'product_weight_uom', 'product_in_stock', 'low_stock_notification', '`p`.modified_on', 'product_unit', 'product_packaging', '`p`.virtuemart_product_id', 'ordering'

Hope it helps someone.. with the inbetween flight times to the solution ;)

Peace

Touchdown  - worked for me!
Ofcourse not a longterm solution, but good enough for me to progress while waiting for a permanent solution to this one!

J2.5.8 and VM2.0.14:)

Thanx mate!
Title: Re: Sort Order of Products & Child Products
Post by: RuggeroSB on November 27, 2012, 15:09:33 PM
@togglewa thanks for your workaround in regards to sorting products, but like you and others have said it's hardly a solution. It certainly doesn't fix broken UI interfaces, and custom ordering still does not work since either they don't exist or youi can't change them!

Furthermore, this does not solve all the other sort options which do not work in the rest of the application.

Interesting to note this issue is still being ignored, despite all the attention given to it.
Title: Re: Sort Order of Products & Child Products
Post by: AISweb on December 13, 2012, 02:32:47 AM
What a mess. We have lots of child products set up and this is going to take time and money to hack the database to reorder them.
(On a related issue, we've given up any hope of having Stock levels per attribute, e.g. red size 10 is in stock, blue size 10 is sold out etc)

What's happened to VM support ?

RuggeroSB, what was the alternative that you purchased ?
Have used VM on dozens of sites, but we're not going to use it again.
Really looks like support has stopped and the once mighty VirtueMart is fading away now.
Title: Re: Sort Order of Products & Child Products
Post by: Milbo on December 18, 2012, 03:43:45 AM
AISweb, it is really strange what you expect. It never was different. Look how much valerie , bytelord, jenkinhill, jjk and me are answering. Stocklevel per attribute is there, with various ways. Why no one of you use the stockable plugin, which is working fine with 2.0.14.

and please look here http://forum.virtuemart.net/index.php?topic=108844.msg373255#msg373255

and why the hell you guys scream and damn here instead of just writing a pn? There are every day dozens of new threads and posts. Checking the forum is a fulltime job, who should do it? If no one of the team is answering a serious problem, than it is 100% that we busy, with coding, bug fixing, writing for vm.
Title: Re: Sort Order of Products & Child Products
Post by: AISweb on December 18, 2012, 04:58:41 AM
Hi Milbo, firstly, thanks to you and the other guys for all your hard work.

You can see why there are frustrated users, this thread took 3 months to get a reply from a dev.

You ask what I would want ? I want to be able to pay an annual subscription to you so that you can employ some help and provide an enhanced support service.

I'm not saying VM should be a paid-for product, but that there is an option to join as a Pro member or something like that.
Title: Re: Sort Order of Products & Child Products
Post by: Milbo on December 18, 2012, 22:08:07 PM
Hello AISweb,
thanks for your thank. Yes I see that you guys are frustrated and it hurts me, guys, really. VirtueMart is my life and thats not just a phrase.

I work since the last 3 years fulltime for VirtueMart. I exactly created what you purpose. We found a company and earn now money directly with the core, but not really a lot. Our daily bread we get due http://extensions.virtuemart.net/. So if you want to support us, just buy every year, for every shop one extension. I like that more than a donation (we have to pay for both taxes, for donations in anycase, most people can use the shop taxfree).

I coordinate the core development and do it almost fulltime. Of course we had to create some extensions to be able to feed our families, so core development was slowed down a bit. But almost all of my extensions needed changes in the core, which are good for all 3rd party developers. They will see that the new customfield plugins will be a fun compared to the stuff we have in 2.0.16. We also gained some big players, which create 200 stores in a row or really big stores with 100k products already and we plan more than a million products.

But why we did not answer here? because we just overlooked it. We have a lot moderators and they are adviced to tell me threads with unsolved problems. It can happen very fast that a thread is on the third page even answered a day before. I check usually only the first page, because I should not answer all the time in the forum. It is impossible to write things like multiprices if you can only work 2 hours a day, spending the other 10 in the forum.

And VirtueMart is a project, it is still not a company. Often the people create the solutions themself, check the last release notes http://forum.virtuemart.net/index.php?topic=110743.0 and the credits. So instead of doing everything ourself, we hope that the community also takes part, that is the idea of opensource and a public project. So and how does this sound: "There are 5 people lamenting that something for an investment of 500 euro is not there, they want to make their living with it, their customers want to make their living with it, but 5 people dont have the idea to pay 500 euro for that feature and just spent it. "
There are other people, paying 200 euro that we integrate the mass reference to the core. Of course this speeds up development. If you think a bit about it and agree, I am happy. finally think about it, how much it is worth to change the ordering of some dropdowns. If you have less than 5 items in the dropdown the difference is almost nothing. How much things the shopowner to earn more?

Often they think they need this and that,.. a carousel,.. but studies showed that they should invest the energy in more important things. Like SEO, or performance.

The name of the company is on purpose not virtuemart, because I want to make clear that the project and the company are different things. The company just keeps the trademark and has even written in the constitution that it must support and protect virtuemart.

That means that all people here, except valerie and me are not payed to answer here or to create fixes. All the others do that because they like it. Of course there can be a financial gain to be moderator, because it is easier to get jobs. But not all of them are interested in this. JJK for example is just a shopowner who likes our community. So in the moment someone is lamenting about the community, he should ask himself what he is doing for the community. No one had the idea to write a pn to me asking what we could do?

and to underline:
I stand for the free princip. The core will always stay free.

and back to topic.
I fear I deleted the ordering of products in the table. I had no idea for what we could use it and it confused a lot devs, because of course we have the ordering of products related to a category. But not for it self. So we must add an ordering for the product itself, which is then working, if there is a parent id set.

Not a big deal, but I wont be able to write it for 2.0.16, because we wanna release tomorrow, birthday of vm2,.. 1 year released now.
Title: Re: Sort Order of Products & Child Products
Post by: clanessa on December 20, 2012, 18:54:27 PM
i've posted a possible solution waiting for the fix

http://forum.virtuemart.net/index.php?topic=111300.0
Title: Re: Sort Order of Products & Child Products
Post by: blans on January 09, 2013, 18:36:48 PM
Dear Milbo,

I will make my reply very simple. All we want is for VM2 to work. As you can read from the many, many posts here there are three main frustrations. In order of importance...

1. We earn our bread (and feed our children) with webshops running on Virtuemart!!! This means it's time for Virtuemart (and the devteam) to take responsibility. The timing of developing VM2 with J!2.5 means we feel hands choking our throats more and more... What to do? Wait for solutions, switch to an alternative, fixing and patching ourselves? And when we massively post these problems on this forum and get no reply this is not showing responsibility.

2. Getting your webshop to work in VM2 with stockable children (that every webshop needs!) is for many of us impossible. As a usability engineer I'm trained to swallow my pride when I designed something that no one can use but I myself find very easy to use. It doesn't matter what I think, it matters what my users think! Yeah... It's VM's birthday. While you are celebrating and showing off the new 2.0.16 we are still not able to build a solid webshop with VM2. I am working on a VM2 version of our webshop, I can't get it to work and there are many of these posts on this forum.

3. Maybe you think SEO is more important as a sortable childrens list and maybe it is. However a webshop with t-shirts M, XS, XXL, S, L simply looks cheap and means a loss of income. It's like the car dealer telling me the enginehood is not really necessary and/or a priority and my car will run just as fine without it. I'm sure it will but try to sell it to someone else...

In the last 3 months I have extensively tested Opencart and CS-Cart as an alternative for VM. I must admit both grabbed me mainly because I was able to set up a webshop in a day. However Virtuemart outperforms them both but only if it stops adding more features and makes it's core purpose it's core business again.

We love Virtuemart and most of us have been using it since it's birth. However we have grown up and so have our businesses. I have spoken and seen many VM users switching to alternatives the last months. If you DEV guys misted that (I cannot believe that but ok) then I will send you a PM now to read this post.

We are very anxious to see a version with improved stockable children. Either as real children (with it's own page and url) and/or as checkable options. As long as we can understand and it just works.

P.s. I have bought several extensions so I guess I'm entitled to write this post. This subject also smells like a conflict of interest. We want as little as possible extensions for the continuity but your income comes from these extensions. It would benefit devteam if I would need an extension to do things that should be covered by the core. But that's another discussion...




Title: Re: Sort Order of Products & Child Products
Post by: Milbo on January 09, 2013, 19:04:51 PM
Quote from: blans on January 09, 2013, 18:36:48 PM
Dear Milbo,

I will make my reply very simple. All we want is for VM2 to work. As you can read from the many, many posts here there are three main frustrations. In order of importance...

1. We earn our bread (and feed our children) with webshops running on Virtuemart!!! This means it's time for Virtuemart (and the devteam) to take responsibility. The timing of developing VM2 with J!2.5 means we feel hands choking our throats more and more... What to do? Wait for solutions, switch to an alternative, fixing and patching ourselves? And when we massively post these problems on this forum and get no reply this is not showing responsibility.

lol, thank you for ignoring the work we did last weeks.

There are 2 methods to create stockable childs. It works since september. You can use the stockable plugin or the dynamic child variants. A lot people use it. I know for example one guy he is older tahn 60 years, he is not a professional, he is a musician and he is using the dynamic childs. BHOOMM. Sorry but if he gets it to work without help, ...

Did you read this? http://forum.virtuemart.net/index.php?topic=110743.msg375646#msg375646

I wrote last 6 weeks around 500 posts. Does not help, people think the same, yeh, nice. this is really motivating

and yes to stay in the picture of a car. For me it looks like that someone says "wuhhah,.. the whole car is not working, because I cannot change the rear mirror with a server motor as I am used to, I have todo it by hand, gentle,. the car is completly shit, I cannot drive with it."
Title: Re: Sort Order of Products & Child Products
Post by: blans on January 09, 2013, 23:45:51 PM
Milbo,

Thank you for commenting and I apologize for my harsh comments. I think we are both frustrated which makes us comment maybe harder then we should.

My main frustration however comes from having tried so many times to make a simple parent with stockable children ever since VM2 started and every time there was a problem for which someone thought he had a solution which in turn didn't work out. There are also too many posts on this subject making it very hard to find a good guide on how to properly set up a stockable childlist. Besides that seeing so many (much more experienced) VM users having the same frustrations tells me more then one guitar playing grandpa that does get it.

I am however sensitive to your comments and will for certain try again this time.

Please, please don't let my frustration temper your enthusiasm to improve Virtuemart. Virtuemart is responsible for over 40% of our annual turnover and has done this with minimal costs other then my time. However it's strength is the market potential between Magento and Opencart and it's ability to allow one webshop manager to maintain a companies webshop without the need for an external IT company but with enough power to fulfill all of higher managements online needs. That balance was perfect with VM1 so please keep VM2 from getting to complicated.
I had to fight hard to get our company to use VM where there were many voices towards Magento. VM1 silenced them all and proved to be more then capable of successfully handling our online sales. The significant changes however in VM2 and the timing with J!2.5 were a bit to much and made me and many others pretty nervous on how to achieve the same things with an already good running webshop and less time to step into the learning curve again.

But your direct words and commitment sure have a positive effect and I will put in some more efforts and await anxiously what the upcoming VM versions will bring.

Thank you again although we are still not on the same frequency on the importance of the sorting of the child list.  ;)
Title: Re: Sort Order of Products & Child Products
Post by: Milbo on January 11, 2013, 10:40:58 AM
Why you do not enhance vm2 for the feature, sortable childs? the ordering field must be added to the product itself and then go ahead.
Title: Re: Sort Order of Products & Child Products
Post by: blans on January 13, 2013, 22:15:32 PM
I'm sorry but I don't understand. Do you mean I should hire someone to do this? Or can I do this easily already.

QuoteI fear I deleted the ordering of products in the table. I had no idea for what we could use it and it confused a lot devs, because of course we have the ordering of products related to a category. But not for it self. So we must add an ordering for the product itself, which is then working, if there is a parent id set.

Not a big deal, but I wont be able to write it for 2.0.16

I think I would better just wait for you to develop child ordering in the next version then. Like you state a simple added column with ordering would do. The parent now already shows at Custom Fields - Custom Field Type - Value,  where I can select Product SKU. If I could select Ordering there and that would work (SKU selecting now doesn't work) then that would be sufficient.





Title: Re: Sort Order of Products & Child Products
Post by: Milbo on January 14, 2013, 23:36:49 PM
the dropdown is meant for a feature later, that the dropdown takes just shows the different skus, length and even other attributes defined as customfields, that is the idea.
Title: Re: Sort Order of Products & Child Products
Post by: muguet on March 25, 2013, 15:10:03 PM
hi guys,

Ihave been reading around for the past hour, my eyes are rolling backwards: it there a fix to the "sorting variants in the dropdown menu" yet or not?
I tried the couple of hacks to be applied in the product.php file and it didn't work.
Hints anyone?? VM2.0.20b

thank you!
Title: Re: Sort Order of Products & Child Products
Post by: Milbo on March 25, 2013, 17:38:24 PM
It is now native in vm2.0.18 imho, or maybe 2.0.20.

Just enter the parent product. On the first tab you have a list of the childs, there is an ordering... write it manualy (yeh dragdrop comes later), then store the whole parent. Done.
Title: Re: Sort Order of Products & Child Products
Post by: smird on March 25, 2013, 20:04:32 PM
Dear Milbo,

Maybe I am wrong, but I think that Stockable variants Custom filed does not work right. I have described it in a few threads without any answers or comments, so I hope you will see it here.
I have already tried it on new installation on Joomla 2.5.9 and VM 2.0.20b with sample data. The bug is still there.

I will try to give all details for you to check, that it really does not work.

1) Create new custom field 'Plug-ins' and 'Stockable variant'. Add few values.
2) In Configuration in part 'Action when a Product is Out of Stock' choose 'Displays 'Notify Me' instead of 'Add To Cart' button'
2) Create product.
3) Create 2 childs to it.
4) Set 'In stock' of childs to 1.
5) Now try to order 1 item of child product.
6) Then return to product and order 1 item of same child again.

What happend? Yes, you have put same item again to cart (already twice), while there are only one item shall be available.


Can you help me with this issue? Or maybe I am doing smth wrong?

Thanks in advance!
Title: Re: Sort Order of Products & Child Products
Post by: muguet on March 26, 2013, 13:02:27 PM
Hi Milbo,

yes I noticed that, but it doesn't seem to be working.

I had a parent product with already 7 children (shoes and its different sizes). Then I had to add one more child, which is the smallest size available. The ordering is correct as I see it first (with number 1) and all the other sizes are following. But in reality the smallest size (19) is at the end of the drop down list: http://www.ankle-biters.com/products/toddler-shoes/boys-toddler-shoes/racing-deep-blue-detail

The only thing I can notice is that from the first tab (product information) they are correctly ordered, but in the tab "Custom Fields" the size "19" is still at the end. Not sure if that means anything.

:'(

[attachment cleanup by admin]
Title: Re: Sort Order of Products & Child Products
Post by: muguet on March 27, 2013, 10:56:32 AM
hi Milbo, any news for me?
Title: Re: Sort Order of Products & Child Products
Post by: raetser on April 15, 2013, 16:09:01 PM
Milbo,

I am sorry man, but this really is not working. I am also creating child products and the sorting only works on the admin product page. No use at all...
I am a .net developer, not php, and I don't want to dive into all the code but how on earth can anyone make a decent web shop with this if a bunch of stuff isn't working?
I am setting up a fashion shop, and I just cannot get the sizes to render properly sorted.

Can someone please let me know how to do this, tried about everything... Ihqave seen that he takes the order in which it was saved in the sutom_param field of the product_customfields table, but it gets overwritten if you save the product.

As far as I can see, not a good setup at all this Virtuemart (or maybe Joomla alltogether) Setting up a producty with child products in 3 different languages takes AGES!

Sorry, but I am getting a little frustrated here...

Erwin
Title: Re: Sort Order of Products & Child Products
Post by: Milbo on April 15, 2013, 22:38:10 PM
For me it works in the Frontend (FE) as anonymous. Be aware I am not talking about the stockable plugin. I am talking about the dynamic child variants. But by theory the stockable plugin should work the same way. So please explain which one of them you are actually using. Btw, the stockable plugin and the dynamic child plugin maybe merged later, cause they do 90% the same and the goal is to have one plugin for it, but both are written by different developers. I did not write the stockable, so I cant say atm. Write a pm to openglobal.
Title: Re: Sort Order of Products & Child Products
Post by: muguet on April 16, 2013, 07:37:31 AM
I am using stockable variants, so...I am confused. You say it should work but it doesn't....are you able to give me direct support with this?
Cheers
Title: Re: Sort Order of Products & Child Products
Post by: leFlea on April 16, 2013, 08:17:55 AM
@raetser, patience man. It's not as if you're paying the people here get what you need. We are indeed sometimes frustrated, but that tone has no place in an open source community.
Title: Re: Sort Order of Products & Child Products
Post by: blans on May 15, 2013, 14:06:36 PM
@leFlea, I don't see any problem with his "tone". Reatser has a very solid point, one that I have already mentioned in 2006 for gods sake.

And the "not paying the people" argument is the best way to scare people away of stepping into VM.

After using VM since the Mambo era we are now moving on to Magento.

I will still keep an eye on VM but the whole children sorting issue and the crazy growth in functions and errors has made us switch.

I loved it until VM2 came out.
Title: Re: Sort Order of Products & Child Products
Post by: mbrando on May 17, 2013, 23:20:45 PM
Hi,

I wanted to post here and say this thread helped. I noted the child ordering was available in the parent. I'm working with over 32,000 items and was able to automate the this by importing the data with the field pordering set in a serial fashion for children of the parent with parent being zero. I am using CSVI Pro to import.

Now my children are in my set order.

- Mike
Title: Re: Sort Order of Products & Child Products
Post by: muguet on May 18, 2013, 14:19:34 PM
good for you mbrando, at least someone has some satisfation here.
I am starting to think that raetser is not all wrong. Without being rude, but I have to say that if you all guys that work on VM2 keep on then disappearing when stuff doesn't work for one reason or another then I am just questioning myself...why do you even do it in the first place?
This is not my first "bug" with VM2,...the more I use it the more I realize that it's just too flimsy, and when I try to find an answer in the forum there are either
1. 10000 people are waiting for the same answer (that never arrives) and the black hole is still there sometimes for YEARS
or
2. 10000 people are waiting for the same answer but at the same time some found the solution by hiring someone else. So If I have to count all the people I hired so far to fix basic (and ok also not basic) issues,...well...then again, what's the point of all this open source project if it cannot be sustained? Start charging a one-off fee and provide for some assistance, wouldn't it be more functional??
So now that I am all setup with this humongous amount of data (not to mention the learning curve -not all of us are born developers-) I am finding myself thinking "well, I might just see how painful is to migrate to another e-commerce solution because this is not getting any easier".
Is this what you guys want from all the users?
I am not saying I am not thankful for the job you do, but just don't leave people in the dark (let's call it "dark") justifying yourselves with "it's for free what do you expect" because pisses people off.