dropshop / src /models /customer_order.py
github-actions[bot]
Automated deployment from GitHub Actions: a9d5a91de63ad7224bafe6039fb2b7479388fbf4
0a8c81b
Raw History Blame Contribute Delete
1.58 kB
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")