I recently worked with a client who had over 1,200 products, about 200 of which were Variation Products (products with multiple options such as size and color). This database has dozens of product attributes that serve purchasable variations as well as attribute filtering, along with the typical category and tag taxonomies. I was challenged with…