Technical Reference & Schemas

{
  name: String, slug: String, description: String, price: Number,
  salePrice: Number, category: ObjectId (ref Category), brand: ObjectId (ref Brand),
  gender: enum["Men","Women","Children","Unisex"], occasion: [String],
  images: [{ url: String, public_id: String }],
  variants: [{ size: Number, color: String, colorHex: String, stock: Number, sku: String, images: [...] }],
  rating: { average: Number, count: Number }, isFeatured: Boolean, isNewArrival: Boolean,
  isActive: Boolean, returnDays: Number
}

{
  orderId: String, userId: ObjectId (ref User),
  items: [{ productId: ObjectId, name: String, size: Number, color: String, price: Number, qty: Number }],
  shippingAddress: { fullName: String, phone: String, line1: String, city: String, pin: String },
  pricing: { subtotal: Number, shipping: Number, couponDiscount: Number, total: Number },
  payment: { method: String, status: enum[PENDING, PAID, FAILED, REFUNDED], razorpayOrderId: String, razorpayPaymentId: String },
  status: enum[PLACED, CONFIRMED, PACKED, SHIPPED, OUT_FOR_DELIVERY, DELIVERED, CANCELLED, RETURNED],
  statusHistory: [{ status: String, timestamp: Date, note: String }],
  shipping: { courier: String, trackingNumber: String, deliveryMethod: String },
  refundDetails: { preference: String, upiId: String, method: String, transactionId: String }
}

{
  userId: ObjectId (ref User),
  points: Number (positive for earned, negative for redeemed),
  type: enum["EARNED", "REDEEMED"],
  orderId: ObjectId (ref Order),
  description: String
}

{
  name: String,
  discountType: enum["FLAT", "PERCENTAGE"],
  discountValue: Number,
  startDate: Date,
  endDate: Date,
  productIds: [ObjectId (ref Product)],
  isActive: Boolean
}

{
  userId: ObjectId (ref User),
  items: [{
    productId: ObjectId, name: String, size: Number, color: String, price: Number, quantity: Number, image: String, slug: String
  }],
  emailSent: Boolean,
  updatedAt: Date
}