Purpose
This document aims to articulate the data model for the fabric product type, this will be used to inform the system requirements, inventory management requirements & reporting requirements.
Product Type Assumptions
A fabric can have more than one color A fabric can be sold in multiple cuts
Proposed Structure
Based on the assumptions above, a proposed structure for the product is as follows:
Fabric Product SKU: A unique identifier for the parent product, the fabric Fabric Variant SKU: A unique identifier for the variant of the fabric (e.g. colour) Fabric Option 1: A variable option, such as cut size
Product Variant Data Model
A product variant data model is a structured way to represent the different variations of a product. the diagram below shows the data model for the fabric product where the following assumptions have been made for the purposes of an example:
Fabric Name is Rayon Spandex Rayon Spandex is available in three different colors Blue, Green & Red Each color is available in three different cuts, 1 yard, 2 yards & 3 Yards Requirements by user group:
Bundles:
The ability to create a bundle from any product, variant and option.
Reporting
User:
Ability select Product, vairant, option and quantity.