[Inventory] Products duplicated and not sorted alphabetically

[BethanOFN]

Description

Users who use the inventory have contacted us because the inventory tool no longer displays Products in alphabetical order. For users with large inventories, this makes using the tool frustrating. This lack of sorting is evident on both the old UI and the new UI. Some products are also duplicated, despite only one product existing (see below). This is especially confusing and makes the inventory unusable, in the words of the user, as the inventory is therefore flooded with duplicates.

Expected Behavior

When accessing the inventory, products should be sorted alphabetically to make managing the inventory simpler. Each single product should appear in the inventory once.

Actual Behaviour

There is no sorting applied. Some products are duplicated.

Steps to Reproduce

1. Go to Inventory

2. Observe that products are not shown in alphabetical order (all enterprises)

3. Observe that some products are duplicated (e.g. product 'Lettuce, Batavia - UK (org)' id=213045, under Cambridge Food Hub id=201177)
   

4. Any changes made to either duplicate product are replicated on the other duplicate.

5. Observe in the Products list that only one product exists for 'Lettuce, Batavia - UK (org)'

Animated Gif/Screenshot

Example of other duplicated products:

Workaround

Searching for product

Severity

bug-s3 - Users are finding this frustrating and are confused why the products are now shown in a random order. I have checked other user's inventories and confirmed that the issue is not unique to Cambridge Food Hub for product duplication.

Your Environment

• Version used: UK prod - lack of sorting and duplication evident in both new and old UI
• Browser name and version: Firefox and Chrome, both up to date.
• Operating System and version (desktop or mobile):

Possible Fix

Revert to alphabetical sorting of products