Module 02: Map your ecommerce workflows
To map ecommerce workflows, write down every repeat task for one normal week before you choose any tool.
One week of honest notes tells you more than a software demo about what to automate first.
Quick answer
To map ecommerce workflows, list every repeat task for one normal week, with who does it, how often, how long it takes, which systems it touches and what decision it involves. Then score each task on frequency, rule clarity, reversibility, data readiness and account risk, and automate the highest scorers first.
Lesson 2 of 8 in our free AI automation guide. Read it in about 10 minutes, then work through the checklist at the end.
What goes in a map of your ecommerce workflows?
One row per repeat task, with seven columns:
| Task | Who does it | How often a week | Minutes each | Systems touched | Decision involved | Written rule? |
|---|---|---|---|---|---|---|
| Reply to "where is my order?" | Support | 400 | 3 | Helpdesk, Shopify, carrier | None if on time; refund or resend if lost | Partly |
| Update stock on Walmart after a 3PL receipt | Ops | 2 | 20 | 3PL portal, Walmart | None | No |
| Approve a refund over $100 | Founder | 15 | 5 | Shopify, helpdesk | Yes | Yes |
(Illustrative · sample figures.)
Do it for one normal week, not a peak week. Ask everyone who touches the store, including contractors.
How do you size each task?
Weekly hours = times a week x minutes each / 60. In the sample above, order-status replies take 20 hours a week. Write the number down; you will measure the same way after any change.
How do you score what to automate?
Five questions, scored 0 (no) to 2 (yes):
| Question | 2 points | 0 points |
|---|---|---|
| Does it happen often? | Daily | Monthly |
| Can you write the rule? | Yes, in one sentence | "It depends" |
| Can it be undone? | Tag, alert, draft | Refund, live price, submitted appeal |
| Is the data ready? | One agreed source | Systems disagree |
| Low account risk? | No customer or marketplace effect | Affects cancellations, policy or promises |
Score 8 to 10: automate now with rules. Score 5 to 7: fix the data or write the rule first, or use AI drafts with a reviewer. Score 4 or less: keep it human for now.
Here is the scoring applied to the three sample tasks above (illustrative · sample figures):
| Task | Often | Rule | Undo | Data | Risk | Score | Decision |
|---|---|---|---|---|---|---|---|
| Reply to "where is my order?" | 2 | 1 | 2 | 1 | 1 | 7 | Send tracking updates by rule now; add AI drafts once tracking data reaches the helpdesk |
| Update Walmart stock after a 3PL receipt | 1 | 2 | 1 | 1 | 1 | 6 | Agree on the put-away count first (Module 03), then automate the sync |
| Approve a refund over $100 | 2 | 2 | 0 | 2 | 1 | 7 | Keep a person approving; automate only the alert that a request is waiting |
Notice that none of the three is a pure AI job. The quickest win is a rule, and two of the three need data fixed before anything else.
What does the map show that you did not expect?
Usually three things: one person (often the founder) is the hidden system for a dozen tasks; the same data is typed into two or three systems; and the biggest time sinks are rule-based tasks nobody wrote down. ChannelEngine, a channel software vendor, says the ecommerce teams in its 2025 survey of US and European leaders spend an average of 36% of their week, "nearly two full working days," on manual updates (vendor estimate, ChannelEngine, Oct 7, 2025; checked Oct 20, 2026). Your own map is the number that counts.
Where automation stops
Let AI do the busywork. Three actions always wait for a person:
- 01Price changes outside the limits you set.
A pricing mistake can sell your stock at a loss in minutes.
- 02Refunds above a set amount.
Small ones can be automatic. Big ones get a second look.
- 03Anything touching account health.
Appeals and policy replies are written and checked by people.
Key takeaways
- Map one normal week, every person, every repeat task.
- Size each task in hours a week with the same formula you will use after.
- Score on frequency, rule clarity, reversibility, data and risk.
- The highest scorers are usually rules, not AI.
Do this now
- Copy the seven-column table into a sheet.
- Ask everyone to log repeat tasks for five working days.
- Calculate weekly hours for each task.
- Score each task and circle the top three.
- Write the one-sentence rule for each of the three.
Tool for this lesson: A shared spreadsheet; then Shopify Flow, Zapier or Make for the first rules.
Ecom Relays is not paid by and not affiliated with any tool listed. We name widely used tools so you know your options. Amazon, Walmart and Shopify are trademarks of their owners; Ecom Relays is not affiliated with them.
Most new stores take months to find steady sales, and some never do. Inventory, platform fees, freight and ad spend are paid by you. Automation saves time on repeat work. It does not create demand for a product.
A note on AI claims: the FTC has warned businesses not to exaggerate what their AI can do (FTC business guidance, "Keep your AI claims in check," Feb 27, 2023). We describe each tool from its own documentation, label vendor figures as vendor estimates and never say that AI will produce sales for you. AI here means software that drafts, sorts, checks and alerts. People still own the decisions.
The problem this lesson fixes
- In owners' words:
"The founder is the operations system."
- Cause:
the rules live in one person's head, so every task waits for them.
- Fix:
map the work, write the rules down and automate the highest scorers. If you want help, the 14-Day Ops Foundation writes the SOPs and routing rules with you, and Ops Desk runs the daily work afterwards. Related: when the founder is the operations system.
- Measure:
founder hours a week on repeat tasks, before and after.
Talk it through with a real person
Book a free 30-minute session with an ops lead. Bring one workflow you want off your plate, and we will tell you plainly whether to automate it, how and where it should stop. A real person replies within one business hour, 9am to 6pm US Central, Monday to Friday. No pitch deck.
A written plan within 3 business days. No sales call required.
Free
Ask a real expert. Free.
A real person replies within one business hour, 9am to 6pm US Central, Monday to Friday.
Request received.
That did not send.
You can reach an ops lead directly, and nothing you typed is lost.
How long does mapping take?
About a week of light logging and an hour to score. Ask each person to add a line whenever they do something they have done before, rather than trying to remember at the end of the week. Short notes in a shared sheet are enough.
What if every task "depends"?
Then write policies first. Rules need decisions made in advance: the refund limit, the late-order response, the reorder point. Each "it depends" usually hides two or three questions you can answer once and write down, after which the task often scores high enough to automate.
Should I include tasks I do rarely?
List them, but they rarely score high enough to automate. A monthly task that takes an hour costs 12 hours a year; a daily task that takes 10 minutes costs about 60. Rare tasks are better handled with a written checklist than with a workflow nobody remembers how to fix.
What if the founder does most tasks?
That is common, and it is often the main finding. Start with the founder's rule-based tasks, because those free the most valuable hours. Then write down the decisions only the founder makes, so they can be delegated with clear limits rather than handed over all at once.
Do I need software for mapping?
No. A sheet is enough, with the seven columns above and one row per task. Software can come later, once you know which tasks matter and which systems they touch. Share the sheet with everyone who touches the store, including contractors, so tasks done outside the core team are not missed.
Sources4 sources
- 01help.shopify.comchecked Oct 20, 2026Primary
- 02zapier.comchecked Oct 20, 2026Primary
- 03ftc.govchecked Oct 20, 2026Primary
- 04channelengine.comchecked Oct 20, 2026Primary
Free and ungated. No sign-up wall. Ecom Relays is not a course or coaching program. We do not sell stores and we never promise income.
Next step
Ask a real expert. Free.
A real person replies within one business hour, 9am to 6pm US Central, Monday to Friday.