Skip to main content

Price sanity check

With one click on the product list, this agent looks for price mistakes before a customer sees them: products without a price, a cost price above the list price and bulk prices that are off.

In short
Where you use itOn the Products & Clusters list in the Backoffice, behind the Workflows button
StartsWith a click on the agent
Changes in PropellerNothing. It only reads
Uses AINo
TextsEnglish or Dutch, a setting
Runs in n8nOne per click
DifficultyEasy

What you get​

A count per check, with the worst examples of every check that finds something.

The AI Agents dialog on the Products and clusters page with the price sanity check: all 81 products checked and no price mistakes found

CheckFlags a product when
Orderable without a priceIt can be ordered and has no price or a unit price of 0
Cost price above the list priceIts cost price is higher than its unit price. With MIN_MARGIN_PERCENT it flags a low margin instead
Suggested price below the list priceIts suggested price is lower than its unit price
Bulk price dearer than the one beforeA bulk price is higher than the price for a smaller quantity
Bulk price below the cost priceA bulk price is lower than the cost price at that quantity

The answer shows cost prices and margins to whoever starts the agent.

What you need​

  • An n8n account with the credential Propeller API key. See Set up n8n.
  • An API key with Viewer access on Product Data.
  • Backoffice access and the Configuration role with Owner access, to register the agent.

How it works​

The agent checks the products with the status Available, up to 500 per click: the ones changed most recently. In a larger catalogue the answer says it checked a sample. Use the settings to check one part of the catalogue in full, such as a category or a manufacturer.

Good to know

The workflows and agents in the Agent Hub are free to use and adapt. They are examples, not supported product features. Test them in a test environment and check the results before you use them on real customers.

Install it​

Install a workflow from the library explains each step.

  1. Import the file into n8n.
  2. Check that the nodes Count Scope and Fetch Product Page use the credential Propeller API key.
  3. Follow Register the agent in Propeller with the values below.
  4. Go to PIM > Products & Clusters, click Workflows and click the agent.
FieldValue
TriggerButton
Interaction modeSingle turn
PlacementsBack office · Products, the Products & Clusters list
Webhook Timeout (ms)60000 when you raise MAX_PAGES. A page of 100 products takes about half a second

The answer shows in the dialog. An error instead of an answer means the address, the login or the key is not right. It can also mean that the workflow is not published.

Make it yours​

SettingDefaultWhat it does
LANGUAGE'EN'The language of the answer and of the product names: 'EN' or 'NL'
CURRENCY'EUR'The currency sign of the amounts
TAX_ZONE'NL'The tax zone of the bulk prices that are checked
STATUSESAThe product statuses that are checked. A is Available
CATEGORY_IDS[]Check only these categories, with their subcategories. Empty checks every category
MANUFACTURERS[]Check only the products of these manufacturers
PRODUCT_IDS[]Check only these products
RECENT_DAYS0Check only the products changed in this number of days. 0 checks them all
MIN_MARGIN_PERCENT00 flags a cost price above the unit price. 20 flags every margin below 20%
CHECKSAll fiveThe checks that run: noPrice, margin, srpBelowList, bulkRising and bulkBelowCost
EXAMPLES5The examples shown per check
MAX_PAGES5The pages of 100 products read per click

Limits​

  • Above 500 products in scope, the agent checks the 500 changed most recently. The answer says so.
  • Only the bulk prices of the product itself are checked, not the prices in price sheets.