How to clean up product data before moving an online store to a new system

Moving an online store to a new system is usually described as a platform project, but the painful part is product data. I have seen migrations slow down because the catalog had duplicate SKUs, old supplier codes, inconsistent variant names, missing images, and descriptions copied from three different eras of the business. The new system was fine. The data going into it was not. Before importing…