Just started working at a company that uses Magento (I believe it's a version 2.2). I'm familiar with some other eCommerce platforms, but have little experience in Magento.
This company updates products individually / manually currently, and I'm transitioning to csv uploads. When I export, there are about 4000 SKUs where there is one instance / row of the SKU (great), but there are about 1000 SKUs where there are 2 rows with the same SKU. One row has the variable "store_view_code" as blank (this is the same as the 4000 products that only have one row), and the second instance, has the "store_view_code" set to "default", and there is very little if any additional data in these rows.
How do I eliminate these duplicates (the ones with the "default" store_view_code)? And how do I prevent products from being added with this "default" store_view_code in the future?
More info... If I bulk upload data on one of the items that only exists as a 1 row instance, it creates a second second instance with the store_view_code set to default.
