I want to completely wipe my inventory and upload my new import_products.xls. I tried doing this in the refresh mode and it added all my new ones and just put discontinued next to the old ones. I want everything completely wiped. Is that possible?
The Product Cleanup feature (Products/Cleanup in the Order Management System) is designed to remove unwanted products. You may delete Discontinued products, non-Normal products, or all products that have not been ordered.