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

[Adameddy26]

Note

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

[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.

[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.

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.