I have a question regarding product updates. Every 6 months, we receive massive spreadsheets with products from our supplier. Some of these suppliers alter product names and some do not even include SKUs for simple products. Hence, I have to manually create products SKUs for the missing ones.
When I receive the new product sets, I have to update all the products and so it becomes difficult since I cannot match the SKUs. Note that in the new product sets, old products are also included. My boss is always worried about losing the url connected to the former product when the update is made.
Has anyone faced a similar situation and if so, what has been your approach to solving this?
Can it be that I am missing something as well?