For TWINOAKS
Seventy-five characters.
Independent work. Not commissioned or endorsed by TWINOAKS, Publicis Groupe or any retailer. Lakeshift Coffee Co. is an invented brand. The retailer rules are real, cited and were last checked on October 10, 2026.
On July 27, 2026 Amazon cut product titles to 75 characters and began rewriting titles that run over. Walmart, Kroger and Target each use a different rule. Copy written once and pasted four times now fails somewhere.
This page is me doing that job on one product, start to finish. Every count on it is measured live.
The work
The six jobs
- Job 1 Know the rules The posting Be the subject expert on retailer requirements and page trends. Read job 1
- Job 2 Audit the listing The posting Audit client brands and competitors; give prioritized content-update recommendations. Read job 2
-
Job 3
Write from facts
The posting Turn product information and claims into content; write titles, highlights, bullets, below-the-fold.
Read job 3
-
Job 4
Adapt per shelf
The posting Message hierarchies that hold across PDP elements, variations and retailers.
Read job 4
-
Job 5
Brief the images
The posting Write image-carousel messaging and briefs for creative.
Read job 5
-
Job 6
Ship and verify
The posting Content moves through production, deployment, monitoring and optimization; QC for accuracy and compliance.
Read job 6
Application · Specialist, eCommerce · TWINOAKS · Troy, MI
Mousa Batarseh · Warren, Michigan · twenty minutes from your Troy office
Lakeshift Day Shift Medium Roast Ground Coffee, 100% Arabica, 12 oz
Scroll to see where every word went. Job 3 · Write from facts
The short version
If you have two minutes.
This page is long. These four findings are the whole story in short: each one is a result from the work, and its link takes you to the part of the page that proves it.
- 174 to 67 One title, every word accounted for. See the proof
- 16 to 89 The listing as found, then the rewrite, on my 14-check rubric. See the proof
- 67, 100, 46, held The same product on Amazon, Walmart, Kroger and Target. See the proof
- Six states Drafted to Verified live, with the check that usually gets skipped. See the proof
Where this job sits
Where this job sits.
The posting asks for someone to audit client brands on Amazon, Walmart, Kroger and Target, write their product pages, adapt them to each retailer, brief creative, and get the content live and checked. Here is that chain, and where the specialist stands in it.
The brand.
A brand sends what it knows: a spec sheet, a roast log, pack artwork. That is the raw material. Nothing on a product page should say more than this.
The specialist.
Audits what is live, writes from the facts, adapts the copy to each retailer's rules, briefs the images, checks everything, sends it, and compares what went live with what was sent. Six jobs. This page is one chapter per job.
The retailers.
Each one has its own limits and its own door: Vendor Central or Seller Central, Supplier One, Syndigo or Salsify for Kroger and Target. The retailer can rewrite what you send.
The shopper, and now the assistant.
A person reading the page, and increasingly a shopping assistant reading it for them. Both need the same thing: facts in the right fields.
Why the brand is invented.
I cannot use a TWINOAKS client's product, and I will not audit a real brand's live pages from the outside. So I made Lakeshift Coffee Co.: three roasts, two forms, six SKUs, nineteen facts, each with a source. Every claim on this page can be traced to that sheet.
Brand
- Spec sheet
- Roast log
- Pack artwork
Stand-in for a client's product
Specialist This job
- Audit
- Write
- Adapt
- Brief
- Check
- Verify
Retailer doors
- Vendor Central / Seller Central
- Supplier One
- Syndigo · Salsify · 1WorldSync
Four shelves
- Amazon
- Walmart
- Kroger
- Target
Shopper
- A person
- A shopping assistant
Prefer to listen? Sixty-eight seconds, in my own voice.
Loading the video…
The video did not load. The transcript is below. Open the video on its own
Transcript
Until this summer, most Amazon product titles could run to 200 characters.
On July 27, the limit became 75. Titles that run over get rewritten by Amazon.
So every word has to earn its place. Some move to the new highlights field. One becomes an image. Some were never facts, and they go.
The same story then has to fit Walmart, Kroger and Target, each with its own rules. Where I can't verify a rule, I hold the draft.
I wrote one Amazon title pattern for all six coffees: three roasts, ground and whole bean. Five fit under 75 characters. The sixth ran one over, so I cut the word 'Bag' from all six to keep them consistent.
Then it is checked, tracked from draft to live, and compared with what the retailer actually published.
I'm applying for Specialist, eCommerce at TWINOAKS. The work is on the page.
Job 1 · Know the rules
Four shelves, four rulebooks.
Amazon allows 75 characters and rewrites titles that run over. Walmart allows 150. Kroger asks for about 100, no commas, no size. Target keeps its rules behind a login, so I hold it.
Amazon: 75.
75 characters including spaces, all categories except media, from July 27, 2026. Titles that run over get rewritten by Amazon. The words that no longer fit have a new home: Item Highlights, 125 characters.
Walmart: 150.
Up to 150 characters, with no all caps, no promotional claims and no repeated keywords. Key features run 80 characters each, and the description needs at least 150 words.
Kroger: about 100.
Brand, descriptor, variable, product name. Ideally 100 characters or less, title case, no commas, no size or count. It is a guideline, not a hard stop, from Kroger's PDP Guidelines of July 2025.
Target: held.
Target's current title, bullet and description rules sit inside its vendor and Target Plus portals. The one public checklist carries no date. I do not guess a number, so the Target draft is held until someone reads the rule in the portal.
Every rule has a date.
A rule older than 90 days gets re-checked before I rely on it. Last checked October 10, 2026. The full register, with every source, is on the rules page.
Amazon
Walmart
Kroger
Target
Published: the retailer publishes it. Guide: a retailer recommendation. Portal: behind a login, verify there.
In the workbook Rule Register, Limits
On a live account I would add each client's category templates to the register, because that is where the bullet and attribute limits actually live.
Job 2 · Audit the listing
The listing as found.
A title written for a 200-character limit, three bullets with an emoji and a guarantee Amazon restricts, a 33-word description, two images, six SKUs as six separate listings. Sixteen out of a hundred on my rubric.
Title.
174 characters for a 75-character field. It ends in '!' and says 'Coffee' five times.
Bullets.
Three bullets: one emoji, one money-back guarantee, and 'best' with nothing behind it. Amazon restricts the first two.
Description.
33 words about the people who started the brand and none about the coffee: no roast, no grind, no origin, no roast date.
Images.
Two images. Neither shows the grind, the yield or the roast date, which are three of the nine things a shopper asks.
Variations.
Six SKUs listed as six separate pages, each titled a different way. A shopper cannot switch roast or form on one page.
Scored, then rewritten.
Five areas, weighted. As found: 16 out of 100, Needs work. The draft rewrite: 89, Strong. Two checks are still short in the draft: the images are briefed but not produced, and the A+ layout needs Brand Registry.
What to fix first.
Shopper impact × evidence ÷ effort. The title pattern and the bullets come first. The carousel matters a lot to shoppers, but it costs photography and sign-off, so it ranks after the fixes that cost nothing.
Modeled listing · fictional brand
- Image 1
- Image 2
- Empty slot
- Empty slot
- Empty slot
- Empty slot
- Empty slot
2 of 7 image slots used
Lakeshift Coffee Day Shift Medium Roast Ground Coffee 12 oz Bag, Premium Gourmet 100% Arabica Coffee, Smooth & Bold Flavor, Best Coffee for Drip Coffee Makers, Fresh Roasted!
Roast Day Shift · other roasts are separate listings
- PREMIUM QUALITY ☕ Our gourmet coffee is made from the best beans for the best taste!!
- GREAT FOR ANY TIME OF DAY - Perfect morning, noon or night
- SATISFACTION GUARANTEED or your money back
Lakeshift Coffee Co. was founded by coffee lovers who believe everyone deserves a great cup. We are passionate about quality and it shows in every bag. Try it today and taste the difference.
As found16Needs work
toDraft rewrite89Strong
-
Rule compliance · 25
Needs workStrong
-
Accuracy and claims · 20
Needs workStrong
-
Shopper questions · 25
Needs workStrong
-
Story consistency · 15
Needs workStrong
-
Depth · 15
Needs workNeeds work
As found Draft rewrite
- 1Rewrite all six titles to one 75-character pattern9
- 2Replace the three bullets with five written from product facts9
- 3Fill the new Item Highlights field6
My rubric: 14 checks in five areas weighted 25, 20, 25, 15 and 15, scored 0 to 2. It measures content condition, not sales, and it is not an industry metric. The second score is for a draft that has not been published.
All 7 recommendations, ranked
Priority = shopper impact × evidence ÷ effort
| Rank | Recommendation | Impact | Evidence | Effort | Priority | Why |
|---|---|---|---|---|---|---|
| 1 | Rewrite all six titles to one 75-character pattern | 3 | 3 | 1 | 9 | A published rule. Amazon rewrites titles that are over the limit. |
| 2 | Replace the three bullets with five written from product facts | 3 | 3 | 1 | 9 | Removes an emoji and a guarantee that Amazon restricts. Needs: Claims sign-off |
| 3 | Fill the new Item Highlights field | 2 | 3 | 1 | 6 | A published field with 125 searchable characters that the listing leaves empty. |
| 4 | Build the seven-image carousel | 3 | 2 | 3 | 2 | Eight of the nine shopper questions name an image as one of the places they get answered. Needs: Photography, brand sign-off |
| 5 | Group the six listings into one variation family | 2 | 2 | 2 | 2 | Lets a shopper switch roast and form on one page. Needs: Confirm the variation theme in the category template |
| 6 | Add a five-module A+ layout | 2 | 1 | 3 | 0.67 | No measured data for this brand yet, so this is a hypothesis. Needs: Brand Registry, carousel assets |
| 7 | Open a Brand Store | 1 | 1 | 3 | 0.33 | Useful once the lineup grows. Low priority at six SKUs. Needs: Brand Registry, A+ assets |
In the workbook Audit Scorecard, Priorities
On a live account The same rubric runs on the client's brand and two or three competitors, so the priorities are relative to the shelf, not to a perfect page.
Job 3 · Write from facts
Start from what is true. Then cut.
Nineteen facts, six of them with conditions. One promise. Seven messages in a fixed order. Then the old 174-character title goes through the cut and comes out at 67, and every word has a destination.
The fact sheet.
Every fact has a status and a source. SPEC can be used as written. BASIS only with its basis next to it. TASTE needs the brand's sign-off. HOLD waits for legal. NO is never said.
A number with its working.
F14 34 cups is a calculation: 340 grams divided by 10 grams a cup. It can only appear with that basis next to it.
A claim on hold.
F18 'Stays fresh longer' is held until there is shelf-life data. The copy uses a fact instead: the roast date is on the bag.
A claim not made.
F16 No certifications are held, so there is no organic or fair trade language anywhere. If a shopper asks, the answer is that it is not certified.
| ID | Fact | Value | Status |
|---|---|---|---|
| F01 | Brand | Lakeshift Coffee Co. | SPEC |
| F02 | Line name | Day Shift | SPEC |
| F03 | Roast level | Medium, 3 on the roaster's 1 to 5 scale | SPEC |
| F04 | Coffee species | 100% Arabica | SPEC |
| F05 | Origins | Colombia and Guatemala | SPEC |
| F06 | Form | Ground, medium grind | SPEC |
| F07 | Suited brewers | Automatic drip machines and pour-over brewers | SPEC |
| F08 | Net weight | 12 oz (340 g) | SPEC |
| F09 | Tasting notes | Milk chocolate, toasted almond, orange zest | TASTE |
| F10 | Roasted and packed | Grand Rapids, Michigan | SPEC |
| F11 | Roast date | Stamped on the back of every bag | SPEC |
| F12 | Bag | Resealable zipper, one-way valve | SPEC |
| F13 | Brew guide on pack | 2 level tablespoons (about 10 g) per 6 fl oz of water | SPEC |
| F14 | Yield | About 34 six-ounce cups per bag | BASIS |
| F15 | Ingredients | Coffee | SPEC |
| F16 | Certifications | None held | NO |
| F17 | Caffeine | Not tested | NO |
| F18 | Freshness duration | Not tested | HOLD |
| F19 | Country-of-origin wording | Not approved | HOLD |
One promise
A balanced medium roast, ground and ready for your drip machine, with the roast date on every bag.
The title cut
As found · 174
As found: Lakeshift Coffee Day Shift Medium Roast Ground Coffee 12 oz Bag, Premium Gourmet 100% Arabica Coffee, Smooth & Bold Flavor, Best Coffee for Drip Coffee Makers, Fresh Roasted!
Title · limit 75
1Lakeshift 3Day Shift 4Medium Roast 5Ground Coffee, 9100% Arabica, 612 oz
Lakeshift Day Shift Medium Roast Ground Coffee, 100% Arabica, 12 oz
Item Highlights · limit 125
11Milk chocolate, toasted almond and orange zest notes. 13Ground for drip and pour-over. 14Roast date stamped on every bag.
Image 5
Roast date on every bag.
A claim that becomes a picture: the stamp itself.
Cut
2Coffee 7Bag, 8Premium Gourmet 10Coffee, 12Best Coffee
The name stays.
Six parts are the product's name: brand, line, roast, form, species and size. They land in the Title, and '12 oz' moves to the end.
True, but not the name.
Three parts move to Item Highlights and get rewritten as facts: tasting notes instead of 'Smooth & Bold', the brewers instead of 'Drip Coffee Makers', the roast date instead of 'Fresh Roasted!'.
Never facts.
Five parts fall out: 'Coffee' for the fourth and fifth time, 'Bag', 'Premium Gourmet' and 'Best Coffee'.
One becomes a picture.
The roast date is also the headline of image 5, because a stamp you can see is better proof than a sentence. The title is 67 characters. It passes.
Where each part of the old title went, and why · 14
| # | Part of the old title | Goes to | Reason |
|---|---|---|---|
| 1 | Lakeshift | Title | The brand name leads. My convention; confirm against the category style guide. |
| 2 | Coffee | Cut | The word appears five times. Amazon's January 2025 rule allows a word twice. |
| 3 | Day Shift | Title | The product's name. |
| 4 | Medium Roast | Title | Answers 'how dark is it'. |
| 5 | Ground Coffee | Title | Answers 'ground or whole bean'. |
| 6 | 12 oz | Title | Size helps a shopper pick the right listing. It moves to the end of the title. |
| 7 | Bag | Cut | Dropped so all six variations fit one pattern. |
| 8 | Premium Gourmet | Cut | No fact behind it. |
| 9 | 100% Arabica | Title | A supplier-spec fact. |
| 10 | Coffee | Cut | Repeat. |
| 11 | Smooth & Bold Flavor | Item Highlights, rewritten | Two opposite words. Replaced by the roaster's tasting notes. Now: “Milk chocolate, toasted almond and orange zest notes.” |
| 12 | Best Coffee | Cut | A superlative nobody can prove. |
| 13 | for Drip Coffee Makers | Item Highlights, rewritten | True and useful, but not part of the name. Now: “Ground for drip and pour-over.” |
| 14 | Fresh Roasted! | Item Highlights and image 5, rewritten | Replaced by a fact a shopper can check. A copy also becomes the headline of image 5. The '!' is not allowed in titles. Now: “Roast date stamped on every bag.” |
The old title was not wrong for its time. It was written to fill a field. The new limit forces a choice, and the choice is easier with a fact sheet: anything that is not a fact goes, and anything that is a fact but not the name of the product moves to a field where it has room.
The Amazon copy · LS-DS-G12
Lakeshift Day Shift Medium Roast Ground Coffee, 100% Arabica, 12 oz
Milk chocolate, toasted almond and orange zest notes. Ground for drip and pour-over. Roast date stamped on every bag.
Bullets · 5
No verified public limit. Check the category template.
Balanced medium roast: Day Shift sits at 3 on our 1 to 5 roast scale, with tasting notes of milk chocolate, toasted almond and orange zest.
Ground for drip and pour-over: A medium grind for automatic drip machines and pour-over brewers, so you can brew it straight from the bag.
Roast date on every bag: Each bag is stamped with the day it was roasted, so you can check how fresh it is before you open it.
About 34 cups per bag: A 12 oz (340 g) bag makes about 34 six-ounce cups at the brew guide on the pack, 2 level tablespoons for every 6 fl oz of water.
Colombia and Guatemala, roasted in Michigan: 100% Arabica coffee, roasted and packed in Grand Rapids. The bag zips shut between brews.
Held back
Stays fresh longerNeeds shelf-life data and legal sign-off.Strong, bold, extra kickCaffeine has not been tested. No strength words.Organic, fair tradeNo certification is held.Made in USAA regulated claim. The copy says where it is roasted and packed.Best, premium, gourmetNot facts.
In the workbook Product Truth, Message Hierarchy, Copy Matrix
On a live account The fact sheet comes from the client's spec sheets and claims guidance, and the HOLD column is where legal review is tracked.
Job 4 · Adapt per shelf
Same story, four shelves.
The story does not change. What changes is how much room it gets and what each retailer allows: 67 characters on Amazon, 100 on Walmart, 46 on Kroger, and a held draft for Target.
One promise
A balanced medium roast, ground and ready for your drip machine, with the roast date on every bag.
Showing: Amazon
- 1 What it isF02, F03, F06, F08
- 2 What it tastes likeF09
- 3 It fits how you brewF06, F07
- 4 You can see how fresh it isF11
- 5 What you getF12, F14
- 6 Where it comes fromF04, F05, F10
- 7 Find your roastF03
Amazon
Carries 7 of 7 messages
Tightest title. So I wrote for this shelf first.
Lakeshift Day Shift Medium Roast Ground Coffee, 100% Arabica, 12 oz
Milk chocolate, toasted almond and orange zest notes. Ground for drip and pour-over. Roast date stamped on every bag.
Bullets · 5
- Balanced medium roast: Day Shift sits at 3 on our 1 to 5 roast scale, with tasting notes of milk chocolate, toasted almond and orange zest.
- Ground for drip and pour-over: A medium grind for automatic drip machines and pour-over brewers, so you can brew it straight from the bag.
- Roast date on every bag: Each bag is stamped with the day it was roasted, so you can check how fresh it is before you open it.
- About 34 cups per bag: A 12 oz (340 g) bag makes about 34 six-ounce cups at the brew guide on the pack, 2 level tablespoons for every 6 fl oz of water.
- Colombia and Guatemala, roasted in Michigan: 100% Arabica coffee, roasted and packed in Grand Rapids. The bag zips shut between brews.
Title: 1 · Item Highlights: 2, 3, 4 · Bullets: 2, 3, 4, 5, 6 · Images: 1, 2, 3, 4, 5, 6, 7
Walmart
Carries 7 of 7 messages
More room in the title, so origin and the resealable bag come back.
I left out '100%' because Walmart bans special characters without listing them. I would confirm that against the item template.
Lakeshift Day Shift Medium Roast Ground Coffee, Colombia and Guatemala Arabica, 12 oz Resealable Bag
Key features · 7 · 80 characters each, longest 77
Medium roast, 3 on our 1 to 5 roast scale
Tasting notes of milk chocolate, toasted almond and orange zest
Ground for automatic drip machines and pour-over brewers
Roast date stamped on every bag
About 34 six-ounce cups per bag at the brew guide on the pack
Arabica coffee from Colombia and Guatemala, roasted in Grand Rapids, Michigan
Resealable zipper bag with a one-way valve
Description · 171 words
Day Shift is the middle of the Lakeshift lineup, a medium roast for people who want one coffee that works all day. We roast Arabica coffee from Colombia and Guatemala to 3 on our 1 to 5 scale, far enough for body and not so far that the roast covers the coffee. In the cup, expect milk chocolate and toasted almond with a little orange zest at the finish. This bag is ground to a medium grind for automatic drip machines and pour-over brewers, so there is nothing to grind and nothing to guess. Use 2 level tablespoons for every 6 fluid ounces of water, the same guide printed on the pack, and a 12 ounce bag makes about 34 cups. Every bag is stamped with the day it was roasted in Grand Rapids, Michigan, so you can check how fresh it is before you open it. The zipper closes the bag between brews. If you like a brighter cup, try Early Shift. If you like it darker, try Night Shift.
171 words · minimum 150 PASS
Title: 1, 6 · Key features: 2, 3, 4, 5, 6 · Description: 1, 2, 3, 4, 5, 6, 7
Kroger
Carries 6 of 7 messages
No commas and no size in the title, so the title is just the name.
Kroger content goes live in a day or two without pre-review. QA has to be finished before it is sent.
Lakeshift Day Shift Medium Roast Ground Coffee
Day Shift is a balanced medium roast with notes of milk chocolate, toasted almond and orange zest. It is ground for drip machines and pour-over brewers, and every bag is stamped with its roast date so you can see how fresh it is. One 12 oz bag makes about 34 six-ounce cups at the brew guide on the pack.
Bullets · 6
- Medium roast, 3 on our 1 to 5 roast scale
- Notes of milk chocolate, toasted almond and orange zest
- Ground for drip machines and pour-over brewers
- Roast date stamped on every bag
- About 34 six-ounce cups per 12 oz bag at the brew guide on the pack
- Arabica coffee from Colombia and Guatemala, roasted in Grand Rapids, Michigan
Six image slots: image 6 folds into image 5, the lineup image stays.
Title: 1 · Marketing message: 2, 3, 4, 5 · Bullets: 2, 3, 4, 5, 6
Target
HELDCarries 1 of 7 messages
Target's current rules are inside its portals. The only public checklist I found has no date. So this is a draft, and it stays a draft until someone with access confirms the rules.
Lakeshift Day Shift Medium Roast Ground Coffee - 12oz
Enhanced content goes through a content provider.
Title (held draft): 1
It fit five. The sixth was one character over.
One pattern for six SKUs.
Pattern 1 ends in '12 oz Bag'. Five titles pass. Early Shift Whole Bean is 76 characters: one over.
Fixed once, for all six.
I took 'Bag' out of all six titles. The longest is now 72, and the pattern holds for every SKU.
-
LS-ES-G12 Early Shift · Ground
Lakeshift Early Shift Light Roast Ground Coffee, 100% Arabica, 12 oz
-
LS-ES-W12 Early Shift · Whole Bean
Lakeshift Early Shift Light Roast Whole Bean Coffee, 100% Arabica, 12 oz
-
LS-DS-G12 Day Shift · Ground
Lakeshift Day Shift Medium Roast Ground Coffee, 100% Arabica, 12 oz
-
LS-DS-W12 Day Shift · Whole Bean
Lakeshift Day Shift Medium Roast Whole Bean Coffee, 100% Arabica, 12 oz
-
LS-NS-G12 Night Shift · Ground
Lakeshift Night Shift Dark Roast Ground Coffee, 100% Arabica, 12 oz
-
LS-NS-W12 Night Shift · Whole Bean
Lakeshift Night Shift Dark Roast Whole Bean Coffee, 100% Arabica, 12 oz
I could have shortened one title. I changed all six instead, because a shopper comparing roasts should see the same shape every time.
| Retailer | Pattern | Longest | Limit |
|---|---|---|---|
| Walmart | Brand Line Roast Form Coffee, Colombia and Guatemala Arabica, 12 oz Resealable Bag | 105 | 150 |
| Kroger | Brand Line Roast Form Coffee (no commas, no size) | 51 | 100 |
Roast and form attribute values must match each retailer's own template, word for word.
In the workbook Copy Matrix, Variations
On a live account The pattern is agreed with the brand once, then every new SKU is built from it, so a launch of twelve flavors is the same work as a launch of one.
Job 5 · Brief the images
Seven images, one job each.
Eight of the nine shopper questions get at least part of their answer from an image. Each frame has one job, a headline under 50 characters, the facts it may use, a claims flag and alt text.
-
Layout sketch, not final art
-
Layout sketch, not final art
Medium roast. Chocolate, almond, a little orange.
3 on our 1 to 5 roast scale.
-
Layout sketch, not final art
Ground for drip and pour-over.
Medium grind. Brew it straight from the bag.
-
Layout sketch, not final art
About 34 cups a bag.
At 2 level tablespoons per 6 fl oz of water, the guide on the pack.
-
Layout sketch, not final art
Roast date on every bag.
Stamped on the back. The zipper closes it between brews.
Colombia and Guatemala. Roasted in Grand Rapids.
-
Layout sketch, not final art
Colombia and Guatemala. Roasted in Grand Rapids.
100% Arabica coffee.
-
Layout sketch, not final art
Three shifts. Pick yours.
Early Shift light. Day Shift medium. Night Shift dark.
Below the fold · five modules
Brand Store · four pages
- Home The lineup by roast.
- Find your roast Three questions to a shift.
- Brew guides Drip, pour-over, French press for whole bean.
- About the roaster Grand Rapids, origins, roast dates.
Low priority at six SKUs. A+ Content and Brand Stores need the brand to be in Amazon Brand Registry. Premium A+ eligibility has reportedly changed this year; I would confirm it in Seller Central before planning for it.
In the workbook Carousel Brief
On a live account This brief goes to the creative team with the fact IDs attached, so a designer can check any line on an image against the sheet.
Job 6 · Ship and verify
Drafted is not live.
Six states, each with an owner and a check. The last one, comparing the live page with what was submitted, is the one that gets skipped. Amazon rewrites over-length titles and Walmart's content team can override supplier copy. If nobody compares the two, nobody knows.
Drafted.
- Owner Specialist
- Leaves this state when Copy and brief written from the fact sheet.
- Check Every field inside its limit on the Copy Matrix.
Approved.
- Owner Account lead and client
- Leaves this state when Brand and claims sign-off recorded.
- Check The twelve QA checks pass for this retailer.
Submitted.
- Owner Specialist
- Leaves this state when Sent through the retailer portal or the content provider.
- Check Submission ID and date logged on the tracker.
Accepted.
- Owner Retailer
- Leaves this state when The retailer has taken the content without errors.
- Check No rejection or attribute error in the feed report.
Published.
- Owner Retailer
- Leaves this state when The content shows on the live page.
- Check Live page opened and dated.
Verified live.
- Owner Specialist
- Leaves this state when The live page matches what was submitted.
- Check Field-by-field compare on the Monitoring Log: MATCH or DRIFT.
What drift looks like.
A day after publishing, the Early Shift Whole Bean title on Amazon came back without '100% Arabica'. That is DRIFT. The action: raise it with the account lead, confirm which version the brand wants, resubmit. This row is a modeled example.
And now the assistants.
Amazon's assistant is now Alexa for Shopping, Walmart has Sparky, Kroger launched its own this summer, and Target sells through third-party assistants. None of them has told brands how it uses product content, so I keep to what a brand can control.
- 1DraftedSpecialist
- 2ApprovedAccount lead and client
- 3SubmittedSpecialist
- 4AcceptedRetailer
- 5PublishedRetailer
- 6Verified liveSpecialist
Submitted
Lakeshift Early Shift Light Roast Whole Bean Coffee, 100% Arabica, 12 oz
Live on page
Lakeshift Early Shift Light Roast Whole Bean Coffee(missing: 100% Arabica) 12 oz
Modeled example of drift. Raise with the account lead, confirm which version the brand wants, resubmit.
Brand can submit
- Titles
- Item Highlights
- Bullets and key features
- Attributes
- Images
- Enhanced content
- Answers to questions
Retailer controls
- Page template
- Page markup and structured data
- Ranking
- Rewrites of submitted copy
- How its assistant uses content
Owned site can add
- schema.org Product markup that matches the visible page
- FAQ content
- The same product names as every retailer
Twelve checks before Approved
12 checks, by type
Accuracy
- Q01 Every sentence traces to a fact ID on the Product Truth sheet
- Q02 No claim marked HOLD or NO appears anywhere, including image text
- Q03 Calculated claims carry their basis in the same field or image
Compliance
- Q04 Each field is inside the retailer limit on the Copy Matrix
- Q05 No restricted characters, emojis, all-caps words or guarantee language
- Q06 No word appears more than twice in a title
Consistency
- Q07 Line name, roast and form are spelled identically in every field and retailer
- Q08 All six variation titles follow the same pattern and all pass the limit
- Q09 Image headline text matches the approved carousel brief word for word
Proofing
- Q10 Spelling, grammar and units checked by a second reader
- Q11 Alt text written for every image
Currency
- Q12 Rule Register dates are inside 90 days, or the rule has been re-checked
The question test
Nine questions, three runs each, on one product, before and after a content change. It shows whether an assistant can find the facts. It does not measure ranking, and no retailer has published guidance for brands on this that I could find.
9 questions and their correct answers
| Question | Correct answer, from the fact sheet |
|---|---|
| Q1 Is this ground or whole bean? | Ground, medium grind. |
| Q2 How dark is it? Will it taste bitter? | Medium roast, 3 on a 1 to 5 scale. Notes of milk chocolate, toasted almond and orange zest. |
| Q3 Will it work in my coffee maker? | Yes for automatic drip machines and pour-over brewers. |
| Q4 How many cups will I get? | About 34 six-ounce cups at 2 tablespoons per 6 fl oz. |
| Q5 How fresh will it be when it arrives? | The roast date is stamped on every bag. |
| Q6 Where is the coffee from, and who roasts it? | Arabica coffee from Colombia and Guatemala, roasted in Grand Rapids, Michigan. |
| Q7 Does the bag close again? | Yes. The bag has a zipper. |
| Q8 Is it organic or fair trade? | No certifications are held. The correct answer is that it is not certified. |
| Q9 Which Lakeshift roast is right for me? | Early Shift is light, Day Shift is medium, Night Shift is dark. |
The before and after columns are empty until the test is run on a live page. The Product markup sample and method notes are on the sources page.
In the workbook QA Checklist, Launch Tracker, Monitoring Log, Assistant Question Test
On a live account The tracker is the weekly status for the account lead: what is waiting, on whom, and for how long.
The working file
One source, sixteen sheets.
Everything above comes from the same source as this workbook. Change a title, a rule or a pattern in the file and the checks update. The formulas are explained sheet by sheet on the workbook page.
View only. The file itself is not offered for download.
Copy Matrix · titles and highlights
Variations · one pattern, six titles
Runs in your browser; the file does the same with formulas.
| A | E | F | G | |
|---|---|---|---|---|
| 12 | SKU | Amazon title, draft 1 | Chars | Status |
| 13 | LS-ES-G12 | Lakeshift Early Shift Light Roast Ground Coffee, 100% Arabica, 12 oz BagVariations!E13=$B$4&" "&B13&" "&C13&" Roast "&D13&" Coffee"&$B$5Builds the title from the pattern: brand, line, roast, form, then the suffix typed in the yellow cell. | 72Variations!F13=LEN(E13)Counts the characters in the title built on this row. | PASSVariations!G13=IF(F13<=$B$8,"PASS","OVER by "&(F13-$B$8))Compares this SKU's title with the retailer's limit and says by how much it misses. |
| 14 | LS-ES-W12 | Lakeshift Early Shift Light Roast Whole Bean Coffee, 100% Arabica, 12 oz BagVariations!E14=$B$4&" "&B14&" "&C14&" Roast "&D14&" Coffee"&$B$5Builds the title from the pattern: brand, line, roast, form, then the suffix typed in the yellow cell. | 76Variations!F14=LEN(E14)Counts the characters in the title built on this row. | OVER by 1Variations!G14=IF(F14<=$B$8,"PASS","OVER by "&(F14-$B$8))Compares this SKU's title with the retailer's limit and says by how much it misses. |
| 15 | LS-DS-G12 | Lakeshift Day Shift Medium Roast Ground Coffee, 100% Arabica, 12 oz BagVariations!E15=$B$4&" "&B15&" "&C15&" Roast "&D15&" Coffee"&$B$5Builds the title from the pattern: brand, line, roast, form, then the suffix typed in the yellow cell. | 71Variations!F15=LEN(E15)Counts the characters in the title built on this row. | PASSVariations!G15=IF(F15<=$B$8,"PASS","OVER by "&(F15-$B$8))Compares this SKU's title with the retailer's limit and says by how much it misses. |
| 16 | LS-DS-W12 | Lakeshift Day Shift Medium Roast Whole Bean Coffee, 100% Arabica, 12 oz BagVariations!E16=$B$4&" "&B16&" "&C16&" Roast "&D16&" Coffee"&$B$5Builds the title from the pattern: brand, line, roast, form, then the suffix typed in the yellow cell. | 75Variations!F16=LEN(E16)Counts the characters in the title built on this row. | PASSVariations!G16=IF(F16<=$B$8,"PASS","OVER by "&(F16-$B$8))Compares this SKU's title with the retailer's limit and says by how much it misses. |
| 17 | LS-NS-G12 | Lakeshift Night Shift Dark Roast Ground Coffee, 100% Arabica, 12 oz BagVariations!E17=$B$4&" "&B17&" "&C17&" Roast "&D17&" Coffee"&$B$5Builds the title from the pattern: brand, line, roast, form, then the suffix typed in the yellow cell. | 71Variations!F17=LEN(E17)Counts the characters in the title built on this row. | PASSVariations!G17=IF(F17<=$B$8,"PASS","OVER by "&(F17-$B$8))Compares this SKU's title with the retailer's limit and says by how much it misses. |
| 18 | LS-NS-W12 | Lakeshift Night Shift Dark Roast Whole Bean Coffee, 100% Arabica, 12 oz BagVariations!E18=$B$4&" "&B18&" "&C18&" Roast "&D18&" Coffee"&$B$5Builds the title from the pattern: brand, line, roast, form, then the suffix typed in the yellow cell. | 75Variations!F18=LEN(E18)Counts the characters in the title built on this row. | PASSVariations!G18=IF(F18<=$B$8,"PASS","OVER by "&(F18-$B$8))Compares this SKU's title with the retailer's limit and says by how much it misses. |
Launch Tracker · summary
I live in Warren, Michigan, about twenty minutes from the Troy office on the posting.
Who is applying
What is mine, and what is new.
For nearly five years at Universal Wholesale I built and ran two storefronts and a catalog of more than 14,000 SKUs: product information, imagery, collections, search metadata and platform migrations. At Wild Bill's Tobacco I managed the wholesale e-commerce catalog and built campaign pages with marketing and merchandising. In September 2026 I audited 21 Michigan storefronts against 29 checks for my own benchmark, ShelfMark.
I have not yet submitted content through Vendor Central, Seller Central or a syndication platform, and I have not worked in an agency. What I have done is manage a lot of product data carefully, and this page is how I would prepare content so that submitting it is the easy part.
| The role asks for | Evidence | Type |
|---|---|---|
| E-commerce experience in retail and wholesale | Universal Wholesale (2019–2024): two storefronts, a catalog of 14,000+ SKUs. Wild Bill's Tobacco (2024–2025): the wholesale e-commerce catalog. | Direct |
| Product information at scale | Imports, attributes, collections, imagery, pricing and descriptions across WooCommerce and Shopify. | Direct |
| Working with marketing and merchandising | Seasonal and promotional campaign pages at Wild Bill's Tobacco. | Direct |
| Digital shelf audit with a rubric | ShelfMark: 21 storefronts, 29 checks, 609 observations. Storefront level, not PDP copy. | Shown, independent |
| PDP copy, retailer rules, briefs, QA, tracking | This page and its workbook. | Shown here |
| Agency work; submitting through Vendor Central, Seller Central, Supplier One or a syndication platform | None yet. | Gap |
- PortfolioAll my work in one place
- ShelfMarkMichigan storefront benchmark
- Universal WholesaleCase study
- United TextileShopify storefront
Also: product-line pages with spec sheets for K-WAV, a direct-view LED display manufacturer in Wixom, MI (the site now redirects to the rebranded Total LED, which launched after my work).