Design your model

Design the catalog structure once, properly: attributes, families, variants, categories, reference entities, assets and units.

This is the part that pays back. An hour spent on the model saves weeks of per-product cleanup later, because in a catalog of any size the structure does the work that people otherwise do by hand.

Work through these roughly in order. Each builds on the one before.