Product Name Conflict in Multi-Store System

[Stivenjs]

When managing multiple stores, attempting to create products with the same name in different stores results in an error stating that the product already exists. Since this is a multi-store system, each store should be able to create products with identical names independently.

Expected Behavior:
Each store should be able to create products with the same name without conflicts, as product uniqueness should be scoped per store rather than globally.

Steps to Reproduce:
Create Store A and Store B.

In Store A, create a product named "Sample Product".

In Store B, try to create a product with the same name ("Sample Product").

The system throws an error stating that the product already exists.

Current Behavior:
The system prevents creating products with the same name, even when they belong to different stores.

Expected Behavior:
Each store should be able to have products with the same name without restrictions.

[Ahmed-M-Osman]

I tried it today and indeed when creating two products with the same "handle" it gives an error, so I created two products with the same name but different handles and it worked.

Below I attached 3 screenshots, one for the products with same name, and the other two are for each product showing unique handles.

I guess it's because the store url doesn't change for each vendor and the fact that the products are all in the same database just with different user_id, and the product url should be unique for every product since it's essentially a single store with multi-vendor.

So if you're adding products you could check if the handle is unique before inserting to the database, but it will require altering the code and stuff, then you either prompt the user to choose different handle or add a unique prefix or something in the background to the handle to make it unique across the database.

Hope this helps.

[IgorKhomenko]

@Ahmed-M-Osman appreciate for the investigation conducted, this is totally right.

To make it work out of the box - it needs to alter the handle generation code in Medusa code, e.g. to add a store name into it. I will see what we can do here