But somehow someone changed the store view to default while editing the products and now we ended up with products with same sku but in a different view with different details. CSV looks like below:
Now, for these reason..everytime we put in a special price in the advanced pricing - we have to put that in both the views which is causing human error and costing time.
I tried to delete only the default store view sku via csv and both admin panel. From the admin panel it deletes the entire product - having to recreate that again. From CSV it shows success but doesn't have any impact at all.
As we now have many products like these are products customers have already placed an order for - I was wondering if someone can give me an idea on how to delete only the products in default store view without having to delete the entire product.