from sqlmodel import SQLModel, Field from typing import Optional from enum import Enum class OrderStatus(str, Enum): RECEIVED = "Received_From_Stripe" MAPPED = "Mapped_To_Source_SKU" DRAFTED = "Source_Order_Drafted" AWAITING_PAYMENT_HITL = "AWAITING_PAYMENT_HITL" PAID = "Paid" REFUND_PROCESSING = "Refund_Processing" AWAITING_SHIPMENT = "Awaiting_Shipment" SHIPPED = "Shipped" FAILED = "Failed_With_Alert" class CustomerOrder(SQLModel, table=True): __tablename__ = "customer_orders" id: str = Field(primary_key=True, description="Unique order ID") customer_email: str stripe_session_id: str shopify_order_id: str amount_usd: float source_platform: str = Field(default="1688", description="Source platform for the order (e.g., 1688, AliExpress)") shipping_address: Optional[str] = Field(default=None, description="JSON string of shipping address") tracking_number: Optional[str] = Field(default=None) status: OrderStatus = Field(default=OrderStatus.RECEIVED) # Extended fields from previous iteration, kept for compatibility and logic shopify_sku: Optional[str] = Field(default=None, description="SKU purchased on Shopify") quantity: int = Field(default=1, description="Quantity purchased") mapped_1688_supplier_id: Optional[str] = Field(default=None, description="Mapped Supplier ID") mapped_1688_variant_id: Optional[str] = Field(default=None, description="Mapped Variant ID") cj_order_id: Optional[str] = Field(default=None, description="CJ Dropshipping Order ID")