Store team view. Supplier feeds checked on every catalogue build.

Catalogue and supplier SKU audit

29 variants checked against two supplier feeds

Every store variant is mapped to a supplier SKU, then compared with the supplier's feed for cost, stock, weight and status. The same script writes the Shopify import CSV. Generated 31 Oct 2026, 12:23 UTC.

12 / 29Products / variants
26Variants matched to one feed row
5High: blocks launch
5 + 2Medium + low findings

Findings

SeverityFindingSKUDetailAction
HighDuplicate supplier SKU in feedA-12090-S2 feed rows for A-12090-S with costs $26.00 and $27.50 and stock 18 and 15.Ask the supplier which row is current before syncing cost or stock.
HighMapped SKU missing from feedBB-PEN-808-Panel Puppy Playpen (80 cm) maps to A-31002-80, which is not in the Supplier A feed.Confirm with the supplier whether it is discontinued. Hide the variant if so.
HighMapped SKU missing from feedBB-LEAD-INKWaxed Cotton Rope Lead, 1.5 m (Ink) maps to B-LD-150-INK, which is not in the Supplier B feed.Confirm with the supplier whether it is discontinued. Hide the variant if so.
HighOverselling a discontinued itemBB-BRUSHDeshedding Brush allows orders when out of stock, but the supplier marks B-GR-100 discontinued.Set Continue selling when out of stock to deny.
HighSelling below costBB-BOWL-LPrice $39.95 inc GST is $36.32 ex GST, below the feed cost of $38.00.Raise the price or stop selling this variant.
MediumCost changedBB-CTREE-OATStore cost $119.00, feed cost $125.00.Update Cost per item and review the price.
MediumCost changedBB-CTREE-ASHStore cost $119.00, feed cost $125.00.Update Cost per item and review the price.
MediumCost changedBB-BOWL-LStore cost $19.00, feed cost $38.00.Update Cost per item and review the price.
MediumMissing weight in feedA-40510-12Grain-Free Kangaroo Kibble (12 kg) has no weight in the supplier feed. Store weight is 12300 g.Confirm the shipping weight, because weight-based rates depend on it.
MediumStock differs from feedBB-BED-L-SANDStore 2, feed 5.Sync stock before launch.
LowFeed item not in storeB-LD-150-NVYRope Lead 1.5m (Navy) is in the Supplier B feed but no store variant maps to it.Decide whether to list it, or map it to an existing variant if it was renamed.
LowFeed item not in storeB-TRT-500Roo Jerky Treats 500g (500g) is in the Supplier B feed but no store variant maps to it.Decide whether to list it, or map it to an existing variant if it was renamed.
Store SKUProductVariantSupplier SKUFeedCost ex GST store / feedPrice inc GSTMarginStock store / feed
BB-BED-S-SANDLow-Rise Orthopaedic Dog BedS / SandA-10421-S-SNDMatched$42.00 / $42.00$89.0048%14 / 14
BB-BED-S-CHARLow-Rise Orthopaedic Dog BedS / CharcoalA-10421-S-CHRMatched$42.00 / $42.00$89.0048%9 / 9
BB-BED-M-SANDLow-Rise Orthopaedic Dog BedM / SandA-10421-M-SNDMatched$53.00 / $53.00$109.0047%11 / 11
BB-BED-M-CHARLow-Rise Orthopaedic Dog BedM / CharcoalA-10421-M-CHRMatched$53.00 / $53.00$109.0047%6 / 6
BB-BED-L-SANDLow-Rise Orthopaedic Dog BedL / SandA-10421-L-SNDMatched$68.00 / $68.00$139.0046%2 / 5
BB-BED-L-CHARLow-Rise Orthopaedic Dog BedL / CharcoalA-10421-L-CHRMatched$68.00 / $68.00$139.0046%7 / 7
BB-BED-XL-SANDLow-Rise Orthopaedic Dog BedXL / SandA-10421-XL-SNDMatched$83.00 / $83.00$169.0046%4 / 4
BB-BED-XL-CHARLow-Rise Orthopaedic Dog BedXL / CharcoalA-10421-XL-CHRMatched$83.00 / $83.00$169.0046%0 / 0
BB-CTREE-OATSisal Cat Tree, 150 cmOatA-20877-OATMatched$119.00 / $125.00$229.0043%5 / 5
BB-CTREE-ASHSisal Cat Tree, 150 cmAshA-20877-ASHMatched$119.00 / $125.00$229.0043%0 / 0
BB-PEN-608-Panel Puppy Playpen60 cmA-31002-60Matched$61.00 / $61.00$119.0044%8 / 8
BB-PEN-808-Panel Puppy Playpen80 cmA-31002-80Missing$76.00 / none$149.0044%3 / none
BB-KIB-ROO-3Grain-Free Kangaroo Kibble3 kgA-40510-03Matched$19.50 / $19.50$39.9546%40 / 40
BB-KIB-ROO-12Grain-Free Kangaroo Kibble12 kgA-40510-12Matched$64.00 / $64.00$119.9541%12 / 12
BB-CBED-SCalming Round Cat BedSA-12090-SDuplicate$26.00 / $26.00$59.0052%18 / 18
BB-CBED-MCalming Round Cat BedMA-12090-MMatched$31.00 / $31.00$69.0051%10 / 10
BB-LIT-10Clumping Paper Cat Litter10 LB-LT-010Matched$11.00 / $11.00$24.9552%30 / 30
BB-LIT-20Clumping Paper Cat Litter20 LB-LT-020Matched$20.50 / $20.50$42.9547%16 / 16
BB-LEAD-EUCWaxed Cotton Rope Lead, 1.5 mEucalyptB-LD-150-EUCMatched$14.00 / $14.00$34.9556%22 / 22
BB-LEAD-RSTWaxed Cotton Rope Lead, 1.5 mRustB-LD-150-RSTMatched$14.00 / $14.00$34.9556%3 / 3
BB-LEAD-INKWaxed Cotton Rope Lead, 1.5 mInkB-LD-150-INKMissing$14.00 / none$34.9556%12 / none
BB-BOWL-SStoneware Slow-Feed BowlSB-BW-SMatched$13.00 / $13.00$29.9552%25 / 25
BB-BOWL-LStoneware Slow-Feed BowlLB-BW-LMatched$19.00 / $38.00$39.9548%14 / 14
BB-CKIB-2Chicken and Pumpkin Cat Kibble2 kgB-CK-002Matched$16.00 / $16.00$34.9550%35 / 35
BB-CKIB-6Chicken and Pumpkin Cat Kibble6 kgB-CK-006Matched$39.00 / $39.00$79.9546%9 / 9
BB-BALL-MNatural Rubber Fetch Ball, 3-PackMB-BL-3MMatched$7.00 / $7.00$19.9561%50 / 50
BB-BALL-LNatural Rubber Fetch Ball, 3-PackLB-BL-3LMatched$9.00 / $9.00$24.9560%0 / 0
BB-WANDFeather Wand Cat ToyDefaultB-WD-090Matched$5.00 / $5.00$14.9563%0 / 0
BB-BRUSHDeshedding BrushDefaultB-GR-100Matched$11.00 / $11.00$27.9557%0 / 0

Import status: the CSV uses the column names documented on help.shopify.com (October 2026). It has not been imported into a Shopify store. Supplier SKUs are kept in this map because Shopify's product CSV does not import variant metafields. Inventory quantity in the CSV applies to single-location stores; if each supplier is set up as a Shopify location, stock goes in through the inventory CSV instead.