Sample made from invented data
Sample: two-store catalog cleanup for Larkfield Linen Co. (invented business and data)
Two stores' product exports checked for missing fields, bad barcodes, and price or stock differences, with proposed fixes.
Everything in this sample is invented: the business, the people, the numbers and the contact details. It was produced by the same code a pilot uses, then checked by the quality checks listed at the end. In a pilot, a person reviews the output before it goes to you.
What went in (all invented)
- 16 rows from Online storefront and 17 rows from Marketplace listing export
- Rules: titles up to 255 characters in Online storefront and 200 in Marketplace listing export; descriptions of at least 50 characters; GTIN required in Marketplace listing export; brand required in Marketplace listing export; prices must match to the cent
- 5 prices given as text (such as "$26.00") read as numbers
- 1 SKU with extra spaces or lowercase letters matched after cleaning
The sample output
Summary
33 product rows: 16 in Online storefront and 17 in Marketplace listing export, covering 17 SKUs. Online storefront is the source of truth.
13 issues by product, 5 cross-store differences and 10 proposed changes for you to review and apply yourself in your own stores.
2 SKUs in one store only.
Amber does not change either store. Nothing is changed until you change it yourself. The sheet is for review: it is not a ready-made import file for either store.
Issues by product
| Store | SKU | Issue | Detail |
|---|---|---|---|
| Marketplace listing export | LL-100 | SKU needed cleaning | "ll-100 " is matched as LL-100 |
| Marketplace listing export | LL-110 | Color name not standard | "white"; the standard form is White |
| Marketplace listing export | LL-120 | Invalid GTIN | 2004817001324 ends in 4, but its check digit should be 6 |
| Marketplace listing export | LL-130 | Title too long | 210 characters; Marketplace listing export allows 200 |
| Online storefront | LL-150-L | Size name not standard | "Large"; the standard form is L |
| Marketplace listing export | LL-150-XL | Size name not standard | "X-Large"; the standard form is XL |
| Marketplace listing export | LL-160 | No images | at least 1 image is needed |
| Marketplace listing export | LL-170 | Description too short | 19 characters; at least 50 needed |
| Marketplace listing export | LL-190 | Missing GTIN | required in Marketplace listing export |
| Marketplace listing export | LL-200 | Duplicate SKU | 2 rows use it (rows 28, 29); only the first is compared across stores |
| Marketplace listing export | LL-220 | Invalid GTIN | 20048170O2316 contains letters (a GTIN is digits only) |
| Marketplace listing export | LL-220 | Size name not standard | "Medium"; the standard form is M |
| Marketplace listing export | LL-240 | Missing brand | required in Marketplace listing export |
Checked: at least 1 image, descriptions of at least 50 characters, title limits, required GTINs and brands, GTIN check digits, duplicate SKUs and variant names.
Cross-store differences
| SKU | Field | Online storefront | Marketplace listing export |
|---|---|---|---|
| LL-101 | Price | $24.00 | $26.00 |
| LL-120 | GTIN | 2004817001326 | 2004817001324 |
| LL-140 | Color | Navy | Navy Blue |
| LL-210 | Inventory (check whether intended) | 40 | 12 |
| LL-220 | GTIN | 2004817002316 | 20048170O2316 |
Inventory differences are for information: channels often hold back stock on purpose, so check whether each one is intended.
Proposed changes (you review and apply them yourself)
| Store | SKU | Field | Current | Proposed | Reason |
|---|---|---|---|---|---|
| Marketplace listing export | LL-100 | SKU | "ll-100 " | LL-100 | Same SKU without extra spaces, in capitals |
| Marketplace listing export | LL-101 | Price | $26.00 | 24.00 | Match Online storefront (source of truth) |
| Marketplace listing export | LL-110 | Color | white | White | Standard capitals |
| Marketplace listing export | LL-120 | GTIN | 2004817001324 | 2004817001326 | Match Online storefront (source of truth); the current code is not a valid GTIN |
| Marketplace listing export | LL-140 | Color | Navy Blue | Navy | Match Online storefront (source of truth) |
| Online storefront | LL-150-L | Size | Large | L | Standard size name |
| Marketplace listing export | LL-150-XL | Size | X-Large | XL | Standard size name |
| Marketplace listing export | LL-220 | Size | Medium | M | Standard size name |
| Marketplace listing export | LL-220 | GTIN | 20048170O2316 | 2004817002316 | Match Online storefront (source of truth); the current code is not a valid GTIN |
| Marketplace listing export | LL-240 | Brand | (empty) | Larkfield | Match Online storefront (source of truth) |
A change that resolves a difference between the stores goes to Marketplace listing export, because Online storefront is the source of truth. Standard size names and capitals can apply to either store. Nothing is imported until you import it.
SKUs in one store only
- LL-180 (Linen Sheet Set, Queen - White): only in Online storefront
- LL-190 (Larkfield Linen Duvet Cover, King, Sand): only in Marketplace listing export
List each one in the other store, or confirm it is meant to sell in one place only.
Quality checks run on this sample
11 of 11 QA checks passed. Direct cost of producing it: $0.00 (no paid service was used).
- Passed: The GTIN check accepts valid invented codes (8, 12, 13 and 14 digits, leading zeros kept) and rejects a wrong check digit, letters and wrong lengths
- Passed: Every issue names a store and a SKU
- Passed: Changes that resolve a difference between stores target only Marketplace listing export, never the source of truth, and inventory is never changed
- Passed: Every GTIN that fails the check is listed as an issue
- Passed: The summary's counts equal the rows in each section
- Passed: Nothing says a listing was updated, applied or imported
- Passed: No claims of guarantees, certification, compliance, affiliation or unmeasured results
- Passed: Nothing says a message was sent (Amber drafts; a person sends)
- Passed: Every section of messages is labelled as drafts
- Passed: No empty section without a note saying why
- Passed: Every stage of the demo completed
Ask about the Product Catalog Cleanup and Cross-Store Check pilot · All ten pilot services