Order statuses: from wanted to sold
A typical chain: wanted order → confirmed (CONF) → shipped → received into the warehouse → placed in stores → sold. The quantity may fall at each step.
Formula
Step loss = previous step quantity − this step quantity; end-to-end yield = sold ÷ wanted
How to read
Build the report on one key (SKU) across all steps. A gap between shipped and received shows logistics or receiving problems, between received and placed a delay in allocation.