Here is my situation, my company buy product with no brand and sell them in its own brand.
We have 2 websites and 2 brands, some products exist in both of our brand with different name.
Example : product A of brand A named BrandA Product Premium and the same product on the other site is named BrandB Product Super.
But on both website the url-key is the same (the name of the product in the default view) so on site1 I have :
http://www.site1.com/brand-a-product-premium.html that is very good.
On site2 I have http://www.site2.com/brand-a-product-premium.html If you type in the correct url : http://www.site2.com/brand-b-product-super.html you are redirected to the bad url.
I can correct this by creating a custom url_rewrite, but there are thousands of product in this case, so I may have done something wrong and there should be a better solution for this.
May I have some help ?
Best regards.