django.md

Direct-to-consumer brands: inventory manager using Django

Summary

A inventory manager blueprint for direct-to-consumer brands built with Django on Ample. Domain schema: products (sku, name, collection, price, active): product catalog; stock_movements (sku, warehouse, delta, reason, moved_at): fulfillment stock; orders (order_no, channel, status, placed_at): orders with status transitions; order_lines (order_no, sku, qty, unit_price): order contents; events (seq, record_type, record_id, kind, at): application-owned history written in the same transaction. Public information: product catalog and collections, shipping and returns policy, brand story. Kept out of scope until handling is reviewed: customer contact and payment details, discount codes tied to individuals. Checkout and payment are handled by your commerce provider; only catalog, stock and order status are modeled here. Technical basis verified on Django: an optimistic version check and an event row written in the same transaction, a stale update rejected, and a history query over the application-owned events (history=2 conflict=rejected).

Infrastructure requirements

Prerequisites

Exact tested configuration

Steps

  1. Model the direct-to-consumer brands domain. Create the tables products, stock_movements, orders, order_lines, events. Product catalog lives in products; keep the sensitive classes (customer contact and payment details, discount codes tied to individuals) out of this schema.

  2. Workflow step 1. Model SKUs and stock movements; derive stock from movements

  3. Workflow step 2. Apply movements transactionally with an optimistic version check on the SKU

  4. Workflow step 3. Record an event per movement for history

  5. Workflow step 4. Deploy and verify history and rejected stale updates

  6. Deploy. Run the synchronous deploy once and read the result. Re-running with no change is a no-op.

    ample deploy . --name <app-name> --public --start "python3 run.py" --env S3_ENDPOINT=... --env S3_REGION=... --env S3_BUCKET=... --env S3_ACCESS_KEY_ID=... --env S3_SECRET_ACCESS_KEY=...
    
  7. Verify. Run the pattern self-test(s) from the example (/p/transactional-workflows) and your own acceptance checks for the direct-to-consumer brands workflow.

    ample logs <deployment_id> --kind build
    

Tested examples

Success checks

Limitations

Cost estimate

Estimated 10.00 USD per month (size prices from pricing.toml at build revision a1b8c38919e59cd035ebabaced73cf84ece24371).

Always-on monthly price of the tested sizes; apps and databases auto-pause when idle. Buckets are allocation-priced per quota and not included.

Verification evidence