About Services Tools Blog Contact us

Affiliate Product Feed Sync

A scheduled update that keeps Awin offers under size-guide pages, with prices, stock and buy links refreshed from the retailer's product list.

  • E-commerce Integrations
  • Footwear retail
  • Scheduled worker
  • Product
  • Hybrid
  • 2026

The problem

Size pages had no products on them, and matching an offer meant a manual pass through the Awin catalogue. Once an offer was on a page, its name, price and buy link went stale as soon as the feed changed.

What it does

A background tool downloads the Awin product list and adds or updates each product by the list's own ID, so a repeat run updates a product instead of duplicating it. Offers that match a brand already on the size guide show under the size table. The next run replaces prices and removes anything that has left the list.

Outcomes

  • Size pages show offers without a manual catalogue pass.
  • Prices and stock follow the feed.
  • Products that leave the feed disappear on the next run.
  • A brand that appears in the feed can open a page instead of being skipped.

Simplified mockup

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

Hartley Court size page

Chelsea boot · men Content page
UKEUFoot mm
741260
842268
943276
1044285
1145294
1246302
Offers under the size table None yet

No current offer. The page stays as content only until a feed row matches Hartley Court.

hartley_court_feed.csv · 3 rows · pulled 02:10

Import
Nightly file is ready

Feed column map

Saved
Columns
Feed columnShop field
brandBrand
nameProduct name
search_pricePrice
in_stockStock
product_idFeed id
deep_linkBuy link
Match rule

A brand already on the size guide is attached under that size table.

A brand that is only in the feed can open a page, instead of being skipped.

The next run replaces prices and drops any id that has left the file. Repeat runs upsert on the feed id, so rows are not duplicated.

Sample rows in tonight’s file
BrandNamePriceWhere it goes
Hartley CourtChelsea, black129.00Under this size table
Hartley CourtChelsea, oak129.00Under this size table
NorthfieldPull-on, brown98.00No size page yet

Earlier nights

Offers touched each night
WhenAddedUpdatedRemovedStatus
9 Oct · 02:101402Done
8 Oct · 02:100380Done
7 Oct · 02:10000File missing

How it works

  1. Fetch the chosen product lists and read price and availability.
  2. Add or update each product using its ID from the list.
  3. Match products to brands the size guide already lists.
  4. Show the matching offers under the size table.
  5. On the next run, replace old prices and remove products that have left the list.
  6. Leave pages with no current offer as content only.

Pipeline

flowchart LR
  A["Feed file"] --> B["Parse rows"]
  B --> C["Match brand"]
  C --> D["Upsert products"]
  D --> E["Attach offers"]
  E --> F["Drop stale"]