Developer forum

Forum » Dynamicweb 9.0 Upgrade issues » Variant sort order issues

Variant sort order issues

E-mail notifications
Peter Leleulya
Reply
Posted on 02/09/2019 08:44:51

Hi there,

I have an application running on 9.7.

I entered a product with variants.
In the CMS list display and in the GetLoop("VariantOptions") output the list is ordered by variantId in stead of the sortorder.

This results in:

VO1
VO11
VO2
VO3
VO4
etc.

Obviously I want the VO11 to be after VO10 and not after VO1 ...

In both the CMS and the template output there seemt to be nothing I can do about it.
The variantoptionsloop output does not respect and does not contain a sort value as set in SETTINGS > ECOMMERCE > PRODUCT CATALOG > VARIANTS.

The last one is an issue obviously ...
What can I do?

 

 

Add: Also when I retrieve the product via the API and use the product.VariantCombinations they have the wrong order and no sorting value to use ....


Replies

 
Toe Tet Linn
Posted on 03/09/2019 13:11:38
Reply

Hello Peter Leleulya,

You can sort "Variants Value" at "Setting > Ecommerce > Product Catalogue > Variants". It will affect when you use GetLoop("VariantOptions") to get sorted variant value. Please refer to my loom video. I think, it will be useful for you.

Thanks

Toetet

https://www.loom.com/share/fb77776885b0427dad2fecfcc2d77380

 

 

 
Peter Leleulya
Posted on 03/09/2019 13:16:35
Reply

Hi Toetet,

As I mentioned I've set the sorting at settings > ecommerce > product catalogue > variants.
And the database has the correct fields, but for me it doesn't work ... it stays sorted by variant id somehow ...

 

I've added 3 print screens.
 

  1. Variant sorted, variant with VO11 is on page 2 of 2.
  2. List view in CMS, VO11 is between VO1 and VO2, so sorted by variant id in stead of sort order
  3. Database value of table EcomVariantsOptions

Outputs have the wrong sorting too ..

 

 

Kind regards,

Peter

VariantSorting_1.PNG VariantSorting_2.PNG VariantSorting_3.PNG
 
Peter Leleulya
Posted on 03/09/2019 13:33:17
Reply

By the way Toetet,

In your movie the CMS sorting is: BLUE - RED - GREY - GREEN

While the frontend shows: RED - BLUE - GREEN - GREY

 

And the CMS layout is completely different.
You have orange variant buttons, while I have black and-white ones.
You have sortable columns while mine are not sortable ...

Are you sure you are demonstrating in 9.7 ?

 

See attachments

Greetz, 

Peter

BLUE-RED-GREY-GREEN.PNG RED-BLUE-GREEN-GREY.PNG
 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Posted on 06/09/2019 02:10:33
Reply

Hi all,

I've tested the issue on DW 9.7.0 and see sort order in 'VariantOptions' and 'VariantAvailableOptions' loops follows to one set in definition of the variant group but it's now not applied for product variant combinations in backend list and 'VariantCombination' loop(proof). New TFS 68990 has been submitted against the issue, will be fixed on an upcoming release. Thanks.

BR, Oleg QA  

 

You must be logged in to post in the forum