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.
