Name three different types of carts
personal cart, default cart, group cart, bundle cart, context cart
which two endpoints are called during checkout?
CreateOrderFromCart, ProcessOrder
What is the max number of times an order can be adjusted?
25
Name 3 ways to view the contents of an order given an order ID
What are two slack channels to monitor for incidents?
#doordash-is-down, #eng-oncall
When do carts get deleted? (name at least two scenarios)
After checkout, 30 days after creation, user deletes cart explicitly
What are the order operation codes for checkout, adjustment, cancellation?
100, 2000, 3000
What is a stale order?
An order that has not been transmitted for 30 min AFTER its quoted delivery time.
What is the difference between the consumer order and order tables?
Consumer Order is the permanent data representation of order while the Order table with 90days TTL stores how data looks at every state when processing order at our Order State Machine.
How can you run order-service integration tests?
locally with devbox, github CI
What is the max number of carts a user can have?
500
PERSIST, PROCESSED_SUCCESS
What are the three most common Order Protocols?
Point of Sale (~80%)
Tablet (~15%)
Email (~1%)
when are order lifecycle events sent?
After each state in the order state machine
name 3 members of order-service team who have pets
abhishek, jatin, ivan, ivy, maggie, xiaoming, others?
which 3 endpoints in order-gateway have the highest qps
GetOrderedItemsForConsumerByStores, GetConsumerOrdersWithDetailsByConsumerId, GetOrderedStoresForConsumer
What happens if the revert/cancellation flow in the OrderStateMachine fails?
Failed orders are added to failed_order_index table
Name 3 of the 4 terminal states in the order transmission state machine?
PickedUp, Cancelled, Stale, TerminalConfirmed
Which state in the Order table can you find deliveryResult in?
OrderTransmission (data is stored one state ahead)
Who is the longest tenured member of order platform team?
Cesare
Which cart lifecycle status is missing in this list?
[active, submitted, submitted_delete_item_blocked, closed, unavailable]
submitted_item_limit_met
How many jobs are in the fetchDataDependencies step of createOrderFromCart?
90
What is the transmission supervisor?
Backup method for order transmission.
The supervisor is cron cadence pod (1 per cell) that runs every 3-5mins that looks at the store_order_transmission table and transmits orders that haven’t been transmitted yet but should be.
Which two snowflake tables can you join to find bundle orders that were confirmed by the store before getting cancelled?
ORDER_DATA.PUBLIC.FLINK_INGEST_ORDER_CART,
ORDER_TRANSMISSION.PUBLIC.MAINDB_STORE_ORDER_TRANSMISSION
If you have a 99.9% SLO with 200% burn rate, what error rate will you see and how many days will it take for you to exhaust your budget?
0.2%, 15 days