About Services Tools Blog Contact us

Shopping Catalogue Product Files

A scheduled job rebuilds the Google Merchant Center and Meta product files with current images and style codes, and checks product codes, local stock and sales reporting.

  • E-commerce Integrations
  • Footwear retail
  • Scheduled worker
  • Productised
  • Cloud
  • 2026

The problem

The feeds kept showing old pictures and style codes in different formats, and someone had to clean the file before Meta would accept it. Invalid product codes and a blocked upload then took styles out of Google Ads. Conversion figures were also copied across by hand.

What it does

The job reads the OpenCart shop and writes one file for Google Merchant Center and one for the Meta catalogue, with the latest images and style codes in a single format. It reports invalid product codes, a blocked upload and sale lines that should stop spending. Paid orders then go back to Google Ads as sales, with the size that sold.

Outcomes

  • Google Ads and OpenCart use the same style code format.
  • When a new picture is published, the old one is replaced in the feeds.
  • A blocked file is reported before products drop out of the Google Ads account.
  • Reported sales include the size that sold, so bidding can follow real demand.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Feed health

Styles
0
Broken images
0
Bad identifiers
0
Odd style code
0
Shopping and social catalogue Before the publisher runs
StyleCodeStockHealth
Harbour Court loaferCW-441214Ready
Marsh Lane bootDL-22086Broken image
Chapel Walk trainerhs11803Odd code Invalid id
River Path sandalCW-090411Broken image
Mill Court brogueOM-33018Invalid id
Station Road derbyDL-55102Stop spend
Orchard Gate chelseaHS-77445Invalid id
Quarry Hill runnerOM-66204Overseas £18.50
Lantern slipCW-88129Ready
Cobble derbyHS-22907Ready

Publisher

What this run will fix

New frames replace two broken images. hs1180 is reshaped, then held back with two other invalid identifiers.

Feeds are still on yesterday’s pictures

Conversions

Paid orders with the size that sold
OrderStyleSize soldValueStatus
48219Harbour Court loaferUK 8£129Sent
48226Marsh Lane bootUK 8.5£159Sent
48231Quarry Hill runnerUK 10£89Sent
48240Cobble derbyUK 7£110Sent
Batch is ready

How it works

  1. Build the Google Merchant Center file and the Meta catalogue file from the OpenCart catalogue.
  2. Remove fields the Meta catalogue rejects and write style codes in one format.
  3. Swap in the latest generated images and add local stock and overseas shipping where they exist.
  4. Flag invalid product codes, a blocked upload and sale lines that should stop spending.
  5. Send paid orders back to Google Ads as sales, with the size that sold.
  6. List Google Search Console errors so search stops showing the old shop after a catalogue change.

Pipeline

flowchart LR
  A["OpenCart catalogue"] --> B["Build feeds"]
  B --> C["Clean codes"]
  C --> D["Attach images"]
  D --> E["Health report"]
  F["Paid orders"] --> G["Conversions"]