Our own productData pipelinesAutomationRetail and ecommerce

A Shopify catalog sync that tracks a retailer's prices and stock by SKU

Our own engineering. September 2024 to February 2025, 6 months.

Shopify catalog sync at a glance

Challenge
A store reselling retail products needs its Shopify catalog to track the retailer's prices and stock, and by hand it drifts.
Solution
Extraction into MongoDB, a threaded price and stock refresh, and Shopify products created and updated by SKU, with retries.
Result
Prices and stock follow the retailer on their own, so the store stops selling at stale prices and nobody updates SKUs by hand.

The Shopify catalog sync challenge

A store that resells retail products needs its Shopify catalog to track the retailer's prices and stock. Done by hand that work is exact, repetitive and endless, and it drifts the moment anyone stops. We built the pipeline on our own account so the sync could run on a schedule instead of a person.

What went into the Shopify catalog sync

Web scrapingData pipelineEcommerce and ordering

  1. Product extraction from Costco with Selenium and BeautifulSoup

  2. Normalised storage in MongoDB, with a threaded scheduler refreshing price and stock

  3. Shopify product creation and updates keyed by SKU, with variants, images, metafields, collections and inventory levels

More of what we built3
  1. Retries and bulk operations, with rate-limit handling against the Shopify Admin API

  2. JSON export for downstream use

  3. An earlier wholesale-catalog prototype, begun in December 2022: crawl vendor catalogs, normalise them, make them searchable, and handle pricing, stock and ordering, with an ecommerce website requirements specification written in October 2023

Shopify catalog sync results

The store's catalog moves when the retailer's does, and a failed refresh retries itself rather than waiting for someone to notice.

Done again today

What this would cost today

Done again today, work like this usually costs $1.5K to $3K (Pricing and competitor monitor). The free plan says whether it fits before anything is priced.

  • Pricing and competitor monitor

    Competitor prices, stock, catalog and copy collected on a schedule, so your team sees a change the day it happens.

    $1.5K to $3K, setup · optional monthly run

    1 to 3 weeks

    Get a quote for this

Your project, next

Have a problem in this shape?

Say so in a few sentences. The free plan comes from the person who built this one.

We usually reply within 2 business days with a free plan for what to do first. No call needed.