order status — 3 Technical Articles

Jul 5, 2021 · Backend Development

Mastering E‑Commerce Order Systems: Architecture, Statuses, and Reverse Flows

This article explains the essential architecture of e‑commerce order systems, details forward and after‑sale order statuses, outlines discount allocation, order splitting rules, and describes both forward and reverse order processing flows for robust backend design.

Order Managementdiscount allocatione-commerce backend

0 likes · 12 min read

Mastering E‑Commerce Order Systems: Architecture, Statuses, and Reverse Flows

ITFLY8 Architecture Home

Sep 26, 2019 · Databases

Designing Effective Order Status Fields: Best Practices and Schema Choices

This article examines common disputes in designing an order status column, analyzes business actions and state transitions, proposes a concise set of core statuses, discusses dictionary representation options, and recommends using VARCHAR2 with a numeric enum for scalable, maintainable database design.

EnumSQLe-commerce

0 likes · 18 min read

Designing Effective Order Status Fields: Best Practices and Schema Choices

ITFLY8 Architecture Home

Jul 27, 2018 · Databases

Designing Optimal Order Status Fields: Best Practices for Database Schemas

This article analyzes common disagreements in designing an order status field for e‑commerce systems, explores business state modeling, evaluates dictionary representations, recommends using varchar2 with a separate dictionary table, and provides a comprehensive set of status values and their handling guidelines.

Backend Developmentdatabase designe-commerce

0 likes · 19 min read

Designing Optimal Order Status Fields: Best Practices for Database Schemas