Complete AI Training
Sign inGet my AI kit

Your job's AI kit

Get your AI kit

Tell us who you are and what you do. We show you your kit right away and email you the link: skills, prompts, AI agents, MCP servers and courses for your job.

500+ jobs ready, and we make a kit for any other job. No payment needed to look.

Share

AI agent for data entry specialists

Product Catalog Attribute Entry Agent

Supplier data loaded into the catalog schema with complete, validated attributes and open questions for the gaps

Product Catalog Attribute Entry Agent: what goes in, what the agent does and what you get

What it does

Every supplier sends product data in its own layout, and the catalog needs a fixed set of fields. This agent reads each supplier file and maps its columns to the catalog schema. It checks sizes, weights and other units against allowed ranges and converts them, so inches and centimeters do not mix. It checks which required attributes are blank and drafts questions to the supplier for each gap, naming the product and the attribute. After corrections arrive, it validates again and lists anything still wrong. The specialist reviews the mapping and approves publishing the entries. Edge case: a weight of 250 for a product that is normally 2.5 kg is flagged as a likely unit slip and not published.

How it works

Follow the arrows from top to bottom. The orange dashed arrow is the loop: when a check fails, the agent goes back and tries again.

Start and resultWhat it doesA check on its own workWaits for your OKGoes back and retries
Yes, continueApprovedYes, continueApprovedNoNo 1 STARTS WHEN Supplier file arrives 2 USES A TOOL Read the file and detect its columns 3 DOES Map columns to the catalog schema using thesupplier's past mapping 4 USES A TOOL Convert units and check values against allowedranges 5 CHECKS THE RESULT Are all required attributes present and valid? If not: list the gaps and draft supplier questions, thenrecheck after the reply. Back to step 3. 6 DOES Draft questions to the supplier for missing ordoubtful values 7 YOU APPROVE Specialist approves the questions 8 USES A TOOL Load the corrected data into a draft catalog 9 CHECKS THE RESULT Do the draft entries pass validation? If not: return the failing rows with the reason. Back tostep 4. 10 YOU APPROVE Specialist approves publishing 11 RESULT Published entries and open question list
Read the steps as a list
  1. Supplier file arrives
  2. Read the file and detect its columns
  3. Map columns to the catalog schema using the supplier's past mapping
  4. Convert units and check values against allowed ranges
  5. Are all required attributes present and valid?If not: list the gaps and draft supplier questions, then recheck after the reply. Back to step 3.
  6. Draft questions to the supplier for missing or doubtful values
  7. Specialist approves the questionsThe agent waits here for your OK.
  8. Load the corrected data into a draft catalog
  9. Do the draft entries pass validation?If not: return the failing rows with the reason. Back to step 4.
  10. Specialist approves publishingThe agent waits here for your OK.
  11. Published entries and open question list

How it decides

A product is ready only when all required attributes pass type, unit and range checks. The supplier's previous files guide column mapping.

  • Flag values more than 3 times the category median as possible unit errors
  • Require the full set of mandatory attributes before publishing
  • Reuse the supplier's saved mapping when column names match
  • Hold products with no image or title

Make it yours

Every agent is a starting point. You choose these settings for your own situation.

  • Required attributes by category
  • Units and conversions
  • Outlier threshold (default 3 times median)
  • Supplier mapping templates

What keeps you in control

It always asks you first

  • Sending supplier questions
  • Publishing entries to the live catalog

Hard limits

  • Never publishes without approval
  • Never fills in an attribute the supplier did not supply

It stops when

  • Done: all rows are published or have open questions
  • Stop: the file format cannot be read

Set it up

We guide you through the set-up, step by step

Members get the full set-up guide for this agent. No technical skills needed: you copy, paste and upload.

10 minto set it up in your AI
5 AIsChatGPT, Claude, Copilot, Gemini, Grok
  • One set of instructions to paste into your AI, with the clicks for ChatGPT, Claude, Microsoft 365 Copilot, Gemini and Grok
  • The agent then walks you through connecting your own data, one source at a time
  • A downloadable copy with the flow chart, the rules and the full guide
Get access to this agent

An example run

What happensA supplier sent 480 rows with columns in a new order. The agent mapped them from last season and found 36 rows without a material attribute and 5 weights that looked 10 times too high. It drafted two questions. The supplier fixed 33 rows and said 5 weights were in grams. After conversion, validation passed for 477 rows and the specialist approved publishing.

More agents for data entry specialists