Create order status dashboard on Wordpress/Woo website using Trello card data
Project Goal:
Create a order status widget or page on my Wordpress website that customers can use to view their order status. The order status is equal to the title of the Trello list in which the order Trello card is currently located.
I would prefer to use some combination of Zapier functions (Zaps/Tables/Interfaces) and Trello automations to accomplish this so we can make minor improvements ourselves in the future.
Background:
Halk Marine manufactures marine products. We take orders through our Woocommerce site as well as manual quoting. These orders automatically create new Trello cards on a project board when they are received, and then progress through the Trello lists as they go through various stages of manufacturing.
E-commerce sites are usually limited to order status updates like "Processing" "Shipped" "Delivered" etc. However, many of our products take a few weeks to be custom manufactured and we get bombarded with calls/emails asking for order updates which are time consuming to answer. I would like the customer to be able to look up their order by their order number or email, and see how it's progressing through manufacturing.
Our typical status flow would be: Order Received - Creating Drawings & Design - Drawing Revisions - Material Ordering - Scheduling for Production - CNC Machining - Forming - Fabrication - Powdercoating/Finishing - Assembly/Testing - Shipping.