That's a relief. You really had me going there for a moment... So I got off the phone with Pushkar, he said he's trying to figure out a way to keep on top of order status while managing the volume of orders and the trickle of parts coming in. I suggested a check list on the shop floor as that gets worked on, and EOD update an internal spreadsheet of current orders. Just a few fields like frame, motor, assembly to keep it from becoming too much of a burden. Simple color-coded statuses easy to read at a glance, 'not started', 'started not complete' (this should only be applicable for a stage that can't be completed before EOD), 'complete', or 'delayed' - perhaps a status specifically for frame painting 'sent for painting' or 'returned from painting'. If a field gets updated, then an automatic email goes out to the email attached to the order "order #1234
frame status updated
sent for painting" and a landing page where users could enter their order number and email address to see the status of their order as Team WW would see it on their internal sheet.
Dates can be attached to fields so if there is a delay on parts or the frame is off for painting, and they have an expected return date, they can attach the date to that status field and if the date passes without them updating that field, it will highlight it for them in a different color so that they know that the last ETA that customer was given has passed and they have not yet been updated. Something like the attached sheet on their end. The shop floor check list could be a more granular, simple paper & pencil check list for assembly so if assembly is started but incomplete, they can know at a glance what stage the assembly is on. This checklist could be visible to the customer when they look up their order as just a checklist with red or green boxes. Since most orders arrive in bulk (I would assume they are also going directly through QBP or other distributors for components) they could have the order status check landing page have important announcements in there. An example of this is if they are awaiting a critical component, show the cutoff order # for current outstanding orders that are covered by remaining stock & ETA -
"Awaiting controllers, orders <#1234 are covered by current stock, next batch ETA 12/12"
Updating the important announcements would be again an EOD task for a crew member along with the order stasuses, more than likely not something that would need to be done daily, but as orders arrive or dates pass. This may be debatable but a log of the previous update would also be helpful for customers to see what changed and to show that WW is staying on top of regular updates.
WW view of order tracker
@pushkar for visibility
Possible detail assembly checklist for customer's order lookup - this may be more than necessary but follows the spirit of what you'd see on the shop floor check list. Different rows just show different examples, whatever is written in the field for IN PROGRESS items is what is slated to be worked on next or is currently being worked on. A more easily manageable way to convery this information is just to have whoever does the EOD updates look at the shop floor checklist for the bike and add a short note of it's current state. Any delays or the overall stage of the bike would be conveyed from the above sheet, so notes would really only need "brake bleed, QA next" or "drive train alignment, brake bleed next" - in the event of something being delayed just note the next step the bike will go to once the delay is cleared "shock delay ETA 12/20, chain install/drivetrain adjustment next" (some things cannot be completed until others, which is where displaying a full check list to the customer can help convey that even though the bike is waiting on the shock for chain length & drivetrain adjustment, brakes are have already been installed and bled)
Also it seems that controllers are what they're waiting on, not motors. When I get back after this weekend from travelling I'm just going to mount my backup M620 and go riding while I bide my time, this is no way to burn calories. Felt good to vent though!