Refresh your Material Catalog pricing

You get a line-by-line report of which materials in your catalog are still priced correctly, which have drifted, and which are flagged as unreliable, sourced from the live supplier page and not from a search result. Nothing changes until you approve it, and only the price changes.
The Prompt
Copy and Paste this to your AI Assistant
Copy Prompt

Audit and refresh the pricing in my FlipperForce Material Catalog.

  1. Pull every material in my catalog with its title, current price, unit, item SKU, internet SKU and product URL. Change nothing yet.
  2. Tell me how many materials you found, how many have a product URL on file, and whether any two materials share the same URL or SKU. Materials with no URL cannot be checked, so list those separately for me to handle by hand. List any duplicates separately too, because updating one copy and not the other will leave my catalog inconsistent.
  3. Ask me how many materials to check before you start. Opening product pages is slow. Work in batches of 8 or fewer and stop and report at the end of each batch rather than leaving a job half done.
  4. For each material in the batch, open the actual product page and read the price from the page. If you cannot open the page directly, search for it first using the model number plus the title, then open the result. Never take a price from a search result summary or a cached snippet. Those are frequently out of date and will cause you to overwrite a correct price with a wrong one.
  5. Confirm you are on the right product before you read the price. The manufacturer model number is the durable identifier. Internet SKUs get reissued by the supplier while the product stays the same, and titles get rewritten, so neither one alone proves identity. Do not substitute a similar product. If the model number does not match, stop and treat it under step 7.
  6. Compare the price on the page to the price in my catalog and calculate the difference in dollars and percent.
  7. Treat a material as discontinued only when its stored page is gone, returns an error, or the supplier states the item is discontinued. Not finding it in a search is not enough on its own. For each discontinued material, look for a successor using these rules and nothing else. If the supplier lists the same manufacturer model number under a new URL or a new internet SKU, that is the same product relisted, and you can propose it. If the supplier's own page names a specific replacement model, you can propose that and quote the supplier's wording. If neither is true, report the item as discontinued with no successor found and propose nothing. Never propose a product you picked because the name, size, brand or description looked close.
  8. Give me the results in three sections, with a count at the top of each.
  9. Do not delete any material, do not create new ones, and do not update a price you had to estimate or infer.
  10. Flag anything suspicious rather than applying it. Flag a price that moved more than 40 percent. Flag a page showing a sale, clearance, promotional or financing price rather than the regular price, including pricing like "pay this much after fifty dollars off when you open a card." Flag a price that looks specific to one store or region. Flag a unit that does not match what my catalog says, and flag any material where my catalog has no unit at all, because then I cannot tell whether the price is per each, per box or per square foot. Flag any page you are not confident is the same product.
  11. Wait for my confirmation on every change. For a price change, update only the price. For a discontinued item I approve relinking, update the price, the product URL and the internet SKU together in one change, because updating the URL without the SKU will send the next run back to the dead listing. Do not update the title, unit, category, item SKU or thumbnail on anything. Do not apply a successor's price to a material unless I have approved the relink, since a price from a different listing attached to the old URL is worse than no price at all.

When you are done, read the updated materials back from my catalog and list what changed with the old and new values for each, so I have a record and so we both know the write actually landed.

Run this in Claude with an API key and code execution. The pace is set by how fast your agent can open supplier product pages, not by the FlipperForce API. Some agents can only open a page after finding it through a search first, which roughly doubles the work per material and is why the prompt asks for a batch size up front. Plan on 8 materials or fewer per batch.

Supplier sites usually price against a default store. For large or regional items, treat the result as a starting point and confirm against your own store.

The Problem

Most material catalogs are built once and then quietly rot. Prices you entered two years ago are still driving your rehab estimates today, and you have no way to tell which ones are stale without opening every product page by hand. The failure is silent. Your estimates look precise and confident right up until the invoices come in higher than you budgeted.

The other half of the problem is what got into the catalog in the first place. Sale prices, clearance prices and credit card financing offers all look like regular prices when you are moving fast, and once one is saved it never gets questioned.

The Solution

The prompt reads your entire Material Catalog through the Public API, including each material's price, unit, model number, item SKU, internet SKU and product URL. It reports what it found, separates out anything with no URL, and tells you if two materials point at the same product.

Because opening supplier pages is slow, it asks you for a batch size before it starts and stops to report at the end of each batch instead of running out of room partway through a long catalog.

For each material it opens the actual product page and reads the price from the page. Search is used only to locate the page when it cannot be opened directly, never to read the price, because cached search summaries are frequently out of date. Identity is confirmed by the manufacturer model number, not the title and not the internet SKU. Suppliers rewrite titles and reissue internet SKUs while the product itself stays exactly the same, so the model number is the only durable key.

When a listing is genuinely gone, the prompt looks for a successor under two narrow rules. If the same model number now appears under a new URL or a new internet SKU, that is the same product relisted. If the supplier's own page names a specific replacement model, that counts too. Anything else is reported as discontinued with no successor found. It will not pick a product because the brand, size or description looked close.

Results come back in three sections so you can review them in the right frame of mind. Price changes to review, sorted by largest change, each with the exact URL the number came from. Prices confirmed unchanged, because knowing an item is still correct is a real result. And discontinued items, each showing what happened to the old listing and either a proposed replacement with its model number, URL, SKU and price, or a plain statement that nothing was found.

Anything questionable is flagged rather than applied: swings over 40 percent, sale or promotional or financing prices, store-specific pricing, a unit that does not match, a material with no unit recorded at all, or a page it is not confident is your product.

You approve item by item. Price changes update the price. Approved relinks update the price, the product URL and the internet SKU together, because changing the URL without the SKU sends the next run straight back to the dead listing. Afterward it reads your catalog back so you can see the changes actually landed.

What it will not do: it will not substitute a similar product, will not take a price from a search result summary, will not apply a sale or promotional price on its own, will not relink a material without your approval, will not attach a replacement listing's price to the old URL, will not create or delete materials, and will not touch your title, unit, category, item SKU or thumbnail.

Material Catalog
FlipperForce
Catalog prices and links
Your assistant
Reads each product page
You approve
Each price change
FlipperForce
Prices refreshed
General Setup

This prompt requires a connection to the FlipperForce Public API. Once your AI agent is connected to your account, you can run any prompt in the library.

Learn how to connect your AI agent to the FlipperForce Public API

Endpoints Used
GET /workspace/{ws}/materials/list, PATCH /workspace/{ws}/materials/{materialUuid} (only on approval)
Considerations Before You Run this Prompt:

Before you run this, check:

  • Your AI is connected to FlipperForce.
  • Your materials have product URLs saved on them. Materials without a URL cannot be checked.
  • Your AI can open supplier product pages. Some agents can only open a page after finding it through a search first, which makes each material slower.
  • You know roughly how many materials are in your catalog so you can pick a sensible batch size.

Supplier sites usually price against a default store, so for large or regional items confirm against your own store before you approve. Run this before you build a big estimate rather than after.

Other AI Prompts