Stop 8 of 8 · Weekly
Omar's week
Three routines on a timer, the 300 SKU catalog pass handed to Cowork, and one month of exports turned into flows and a reorder.
The three jobs that repeat
Three things in this course happen on the same schedule with the same files every time, which makes them routines rather than chats. Write each one once, give it a day and a time, and read the output rather than assembling it.
Monday 7:30, weekly: the sales digest. Last week's orders against the week before, top and bottom handles, return rate, and anything unusual.
Daily 8:00: the ticket batch. The queue from stop 5, sorted into four buckets, with drafts for the policy bucket only.
First of the month, 9:00: the reorder table. Inventory plus 60 days of sales plus the supplier lead times, flagged rows only, cash line left for Omar to fill.
Open the orders export attached to my Sunday email to myself. Compare last week to the week before: units, net revenue after discounts and refunds, and the five handles that moved most in each direction. Add return rate for any handle with ten or more units. Then give me three flags, one line each, of things I should look at today. Under 150 words. Do not estimate any cost or margin, and do not include customer names.
Read the store inbox since 8am yesterday. Sort every customer message into four buckets: answered by policy, needs an order lookup, needs a decision from me, spam. Draft the policy bucket replies in my store Project voice, four sentences each, quoting the policy file, saved as drafts and sent to nobody. For the decision bucket write one line each on what the decision is. Never promise a delivery date.
From the inventory export and the last 60 days of orders in my exports folder, plus the supplier lead time PDF, build the reorder table by variant: units on hand, weekly rate, weeks of cover, lead time with its page number, and reorder units for eight weeks of cover. Include only rows where cover is below lead time plus two. Leave every cost column blank and email me the table so I can add my costs.
The catalog pass, handed over
The 300 SKU rewrite from stop 1 is not a chat. It is twelve batches of twenty five, each one audited, rewritten, flagged and saved as a CSV, and it takes an afternoon of clicking that nobody has. That is what Cowork is for: hand over the whole errand with the files, watch the first batch, then let it work through the rest while you are on the packing bench.
Work through the products export in my catalog folder in batches of 25 handles, starting with the product type that had the most gaps in my audit. For each batch, rewrite the description and SEO Description in my store Project voice, keep Handle and Title unchanged, and save the result as an import-ready CSV named by batch number. Wherever a fabric, care or fit fact is not in my files, write a bracketed placeholder. After every batch, give me a one line summary and the list of placeholders. Ask me before you touch anything in Shopify.
Approve the first batch step by step. Read the placeholders before you loosen anything.
Capstone
The week on one line each
| You want to | Do this |
|---|---|
| Fix 300 product pages | Products export, audit, batches of twenty five, import five first |
| Know what actually earned | Orders export plus your cost list, blanks for missing costs |
| Write next month's email | Top twenty handles into the four flows prompt |
| Clear the morning queue | Four buckets, drafts for the policy bucket only |
| Decide what to reorder | Inventory plus 60 days plus the supplier PDF, per size |
| Stop repeating a correction | One sentence added to the store Project instructions |