1. Home
  2. Work
  3. Case study

AI agentsE-commerceWholesale sourcing

Agentic sourcing and outreach for an e-commerce wholesaler

A system that finds products worth stocking on Amazon, works out who supplies them and prepares the outreach. An agent runs it on a schedule, and a person approves every stage before anything moves on.

Client
E-commerce wholesale business name, if they agree
Sector
E-commerce, Amazon wholesale
My role
e.g. Solution architect and lead developer
Built with
Python, Airtable, agent orchestration on a cloud server
Status
e.g. In production since August 2026
X

products screened a week

X hrs

of manual research saved a week

100%

of outbound messages approved by a person before sending

The problem

Finding wholesale products that sell profitably on Amazon is research-heavy work. Someone has to shortlist products, check the numbers, work out which brands and distributors supply them, find the right contact and write to each one. Done by hand, that takes hours per product, and the quality depends on who did it.

Add the client’s own before-picture: how many products they reviewed a week and how long each took.


What I built

A sourcing and outreach system in three layers:

  • A deterministic Python pipeline does the heavy lifting: collecting product data, scoring opportunities, matching suppliers and drafting messages. The same input always gives the same output, so results can be checked.
  • An agent orchestrates the pipeline on a cloud server. It schedules runs, moves work between stages and reports on what happened.
  • Airtable is the team’s control room: a live view of every product and supplier, and the approval desk where people review each stage before the next one starts.
Step 1, SystemsProduct dataAmazon listings collected on a schedule
Step 2, AI agentScore and shortlistRanked against the client’s rules
Step 3, PeopleApprove shortlistTeam reviews in Airtable
Step 4, AI agentFind suppliersBrands and distributors matched
Step 5, AI agentDraft outreachA tailored email per supplier
Step 6, PeopleApprove messagesEdit or approve in Airtable
Step 7, SystemsSend and trackReplies logged per supplier
Simplified flow. Nothing moves past an approval step until a person signs it off.
  • AI agent
  • People
  • Systems

Guardrails

  • Human approval gates between stages, held in Airtable where the team already works.
  • Deterministic code for scoring and data handling, so results are repeatable and auditable. The AI handles orchestration and drafting.
  • Credentials injected through environment variables, never stored in code.
  • Built and tested locally first, then deployed, with each module verified before the next one started.

How it was built

The build followed a dependency graph: each module was specified, built and validated before anything that depended on it. I used an AI-assisted engineering workflow with separate architect, builder and validator agents, and reviewed every change myself before it moved on. It’s the same principle the finished system uses.


Results

Add results as soon as you have them: products screened, suppliers contacted, reply rate, hours saved a week. Two real numbers will make this the strongest case study on the site.

Stack

  • Python
  • Airtable
  • Agent orchestration
  • Cloud server (VPS)
  • LLM drafting
  • REST APIs

Client view

Client or manager quote about this project. Two or three sentences, with their name and role.

Tell me about the process that’s eating your team’s time.

The first call is free and takes 30 minutes. You’ll leave knowing whether it’s worth automating and roughly what it would take.