I'm working on an online eCommerce project and am having difficulties building the core / index schema. Here is the way we organize our product information in a normalized database.
A product model has many SKUs (called colorways) A SKU has many sizes (called variants) A SKU size has associated inventory (called variant inventory) When we setup our product core we have the following field information Doc * brand * model name * SKU * color name Sample records are as follows * Haynes, Undershirt, 1234, white * Haynes, Undershirt, 1235, grey * Fruit of the Loom, Undershirt, 1236, white * Fruit of the Loom, Underwear, 1237, grey The issue I'm having is I want to add inventory to each size of each SKU for faceting. Example, SKU 1234 has sizes small, medium, large. Size small has 5 in stock, size medium 10, and size large 25. In a normalized data table I would have a separate table just for inventory and related it back to the SKU with a foreign key. How do I store size and inventory information effectively with Solr? -- Steve
