inventory-count icon indicating copy to clipboard operation
inventory-count copied to clipboard

Duplicate Product Records Created When Same Bulk Count File Is Uploaded Multiple Times

Open Adameddy26 opened this issue 1 year ago • 3 comments

Note

Screenshot from 2024-09-19 15-31-50

We have this description text present on UI but this is useful only when user is trying to upload the CSV having duplicate records of products. This message doesn't cover the case where the file with unique records is uploaded multiple times.

Current behavior

Each upload of the same bulk count file results in duplicate product records being created for a count.

Expected behavior

The system should recognize that the same bulk count file has been uploaded and prevent duplicate product records from being created.

Steps to reproduce the issue

Navigate to the 'Bulk Count' page. Upload a bulk count file with product records. Without making any changes, upload the same file again. Observe that the product records are created as duplicates for the count mentioned in CSV.

Environment details

App version : v2.1.0 App environment : UAT

Additional information

https://jam.dev/c/e3074243-7893-494b-a1ed-7aae1f986872 https://jam.dev/c/95872c2b-49ba-4677-b99c-f4eab3aa2f0d

Adameddy26 avatar Sep 19 '24 09:09 Adameddy26

I believe this is expected behavior, because user is not giving unique id, system will always create new count. If that is the scenario you're talking about, then please close the ticket.

dt2patel avatar Oct 12 '24 03:10 dt2patel

I believe this is expected behavior, because user is not giving unique id, system will always create new count. If that is the scenario you're talking about, then please close the ticket.

Let’s assume a CSV file has been created with 3 records, where the count name is TEST, the facility ID is STORE_14, and the SKUs are SKU1, SKU2, and SKU3. If the same file is uploaded again via bulk upload, or if a count with the same name and facility ID is created manually (without bulk upload), the system may result in a successful upload, but the count could end up containing duplicate products.

Adameddy26 avatar Oct 17 '24 06:10 Adameddy26

Fix is to add UUID to count names from app side to avoid count de duplication

dt2patel avatar Feb 27 '25 07:02 dt2patel