# Product & Inventory Entities {#product--inventory-entities}


Entities for products, variants, categories, types, options, warehouses, and merchants.


## Product {#product}


| Column              | Type    | Description          |
| ------------------- | ------- | -------------------- |
| `name`              | string  | Product name         |
| `code`              | string  | SKU/product code     |
| `description`       | string? | Description          |
| `enabled`           | boolean | Availability status  |
| `imageUrl`          | string? | Product image        |
| `featuredImageId`   | UUID?   | FK to featured image |
| `productTypeId`     | UUID?   | FK to product type   |
| `productCategoryId` | UUID?   | FK to category       |

**Relations:** `variants` (OneToMany), `category` (ManyToOne), `type` (ManyToOne), `options` (ManyToMany), `tags` (ManyToMany), `translations` (OneToMany)


## ProductVariant {#productvariant}


| Column                   | Type    | Description         |
| ------------------------ | ------- | ------------------- |
| `taxes`                  | number? | Tax rate            |
| `notes`                  | string? | Notes               |
| `quantity`               | number  | Stock quantity      |
| `billingInvoicingPolicy` | enum?   | Invoicing policy    |
| `internalReference`      | string? | Internal ref number |
| `enabled`                | boolean | Is available        |
| `productId`              | UUID    | FK to product       |
| `imageId`                | UUID?   | FK to image asset   |

**Relations:** `price` (OneToOne ProductVariantPrice), `settings` (OneToMany ProductSetting)


## ProductCategory {#productcategory}


| Column         | Type      | Description     |
| -------------- | --------- | --------------- |
| `imageUrl`     | string?   | Category image  |
| `translations` | OneToMany | Localized names |


## ProductType {#producttype}


| Column         | Type      | Description     |
| -------------- | --------- | --------------- |
| `icon`         | string?   | Type icon       |
| `translations` | OneToMany | Localized names |


## ProductOption / ProductOptionGroup {#productoption--productoptiongroup}


Multi-level product options (e.g., Size → Small/Medium/Large).

| Column    | Type   | Description        |
| --------- | ------ | ------------------ |
| `name`    | string | Option name        |
| `code`    | string | Option code        |
| `groupId` | UUID?  | FK to option group |


## Warehouse {#warehouse}


| Column        | Type    | Description    |
| ------------- | ------- | -------------- |
| `name`        | string  | Warehouse name |
| `code`        | string  | Warehouse code |
| `email`       | string? | Contact email  |
| `description` | string? | Description    |
| `active`      | boolean | Active status  |
| `logo`        | string? | Logo image URL |

**Relations:** `products` (OneToMany WarehouseProduct), `contact` (ManyToOne Contact), `tags` (ManyToMany Tag)


## Merchant {#merchant}


| Column        | Type    | Description      |
| ------------- | ------- | ---------------- |
| `name`        | string  | Merchant name    |
| `code`        | string  | Merchant code    |
| `email`       | string? | Contact email    |
| `phone`       | string? | Phone number     |
| `description` | string? | Description      |
| `active`      | boolean | Active status    |
| `currency`    | string  | Default currency |
| `logo`        | string? | Logo URL         |

**Relations:** `contact` (ManyToOne Contact), `tags` (ManyToMany Tag), `warehouses` (ManyToMany Warehouse)


## Related Pages {#related-pages}


- [Product Endpoints](https://sourcey-gauzy.pages.dev/api/product-endpoints/index.md) — API reference
- [Warehouse Endpoints](https://sourcey-gauzy.pages.dev/api/warehouse-endpoints/index.md) — warehouse API
- [Products & Inventory](https://sourcey-gauzy.pages.dev/features/products-and-inventory/index.md) — feature guide