[5.x]: Reordering of disabled variants

[i-just]

What happened?

We also have a different problem when I move an disabled variant:

And save the page with "ctrl" + "s" the whole layout of variants changes:

In the first image, we initially had two disabled products stacked above each other, with our moved variant positioned below them. However, after saving the page, the arrangement changed. Now, either:

• Two enabled variants have moved up, or
• Our moved variant has shifted down, now paired with another disabled variant.

Originally posted by @WHITE-developer in #16103

Craft CMS version

5.5.0.1

Craft Commerce version

5.2.4

PHP version

8.3

Operating system and version

ddev

Database type and version

mysql 8.0

Image driver and version

No response

Installed plugins and versions

[linear]

PT-2311 [5.x]: Reordering of disabled variants

[WHITE-developer]

Some additional info:

Occasionally, variants cannot be moved up to a new position down works fine but up sometimes won't work. In the attached video, you can see the following behavior:

The first variant I moved up successfully retained its new position after saving.
However, when I attempted to move another variant up, it reverted to its original position after saving.

Steps to Reproduce:

1. Open the variants.
2. Move one variant to a new position and save.
3. Move another variant to a different position and save.
4. Observe whether the second variant retains its position.

Expected Behavior:

• All moved variants should retain their new positions after saving.

Actual Behavior:

• While some variants stay in their new positions, others revert to their original positions after saving.

Attachments:

When there is nothing happening on screen I'm saving the page

Sorting_issue.mp4

[lukeholder]

@WHITE-developer we have a potential fix for this on this PR: #3779

We are just testing it a little more before including it in a release.