Laravel 8 · REST API · Gift & Premium E-Commerce

Product SKU Management System

Auto-generated, structured SKUs for Standard, Gift, and Premium products — with dedicated catalogues, inventory tracking, and full CRUD API.

JWL Category
PRM Type
CAR Brand
GLD Colour
STD Size
00001 Sequence
10
Categories
15
Brands
30
Total Products
12
Standard
10
Gift
8
Premium
14
API Routes
Product Types

Three catalogues, one system

📦

Standard

Everyday products across Electronics, Clothing, Furniture, and Beauty. Full inventory and pricing management.

TYPE = STD
  • Stock quantity & low-stock alerts
  • Cost price & margin calculation
  • Weight & dimensions tracking
  • Active / Inactive / Discontinued status
🎁

Gift

Curated gift sets with wrapping options, personalised message templates, and seasonal availability windows.

TYPE = GFT
  • Gift wrapping with add-on price
  • Personalised message templates
  • Seasonal availability window
  • Packaging type (ribbon-box, velvet-pouch…)
💎

Premium

Luxury goods from Cartier, Rolex, Louis Vuitton, and Chanel — with tier classification, limited edition tracking, and certificates of authenticity.

TYPE = PRM
  • Tiers: Gold / Platinum / Diamond
  • Limited edition with qty tracking
  • Certificate of authenticity reference
  • Luxury materials list
Live SKU Examples

30 products, auto-generated SKUs

# SKU Type Product Price
1ELC-STD-APL-SLV-STD-00001STDApple MacBook Air M2 — Silver$1,299.00
2ELC-STD-APL-BLK-STD-00001STDApple MacBook Air M2 — Midnight$1,499.00
3ELC-STD-SMG-BLK-STD-00001STDSamsung 65" QLED 4K Smart TV$1,799.99
4ELC-STD-SNY-BLK-STD-00001STDSony WH-1000XM5 Headphones$349.99
5CLT-STD-NIK-BLK-LG-00001STDNike Air Max 90 — Black/Large$120.00
6CLT-STD-ADI-WHT-MD-00001STDAdidas Ultraboost 22 — White/Med$180.00
7BTY-STD-DYS-BLK-STD-00001STDDyson Supersonic — Black/Nickel$429.99
8FRN-STD-IKA-OAK-STD-00001STDIKEA KALLAX Shelf Unit — Oak$89.99
13GFT-GFT-HMK-GLD-STD-00001GFTHallmark Premium Gift Box — Gold$89.99
15ACC-GFT-TFF-BLU-SM-00001GFTTiffany & Co. Blue Gift Pouch — S$295.00
17GFT-GFT-GDV-GLD-MD-00001GFTGodiva Chocolate Gift Box — 24pc$49.99
19HMD-GFT-YNK-RED-SM-00001GFTYankee Candle — Christmas Eve Set$34.99
21BTY-GFT-CHL-GLD-STD-00001GFTChanel N°5 Gift Set — 100ml$199.00
23JWL-PRM-CAR-GLD-STD-00001PRMCartier Love Bracelet — 18K Gold$6,900.00
25BAG-PRM-LVT-BLK-STD-00001PRMLouis Vuitton Neverfull MM$2,050.00
27WAT-PRM-ROL-SLV-STD-00001PRMRolex Oyster Perpetual 41 ★ LE$7,550.00
29BTY-PRM-CHL-CLS-STD-00001PRMChanel N°5 Grand Extrait 200ml ★$4,800.00
30ACC-PRM-TFF-PLT-STD-00001PRMTiffany Diamond Solitaire Ring$12,500.00

★ Limited Edition

API Reference

14 routes · Base URL /api

All endpoints return paginated JSON. SKUs are auto-generated on POST and regenerated on PUT when variant fields change.

MethodURIDescription
GET/api/productsList all products — filter by type, tier, brand, status, search
POST/api/productsCreate product — SKU auto-generated
GET/api/products/{id}Single product with full detail
PUT/api/products/{id}Update — SKU regenerated if variant changes
DELETE/api/products/{id}Soft-delete (sequence never reused)
GET/api/products/{id}/skuInspect & validate SKU segments
POST/api/sku/previewPreview a SKU for any combination without saving
GET/api/giftsGift catalogue — filter seasonal, wrappable
GET/api/gifts/{id}Single gift product
GET/api/gifts/catalogue/seasonalOnly seasonally-available gift products
GET/api/gifts/catalogue/wrappableOnly gift-wrappable products
GET/api/premiumPremium catalogue — filter by tier, limited edition
GET/api/premium/{id}Single premium product
GET/api/premium/catalogue/tiersTier summary — counts & price ranges