Product CSV Audit: Duplicate SKUs & Price Checks

Check product catalogue data before it enters your next workflow step.

Penny flags duplicate SKUs, missing identifiers, conflicting product information, unusual prices and spreadsheet-formatting risks. Receive audit findings and a processed CSV for review—without connecting your online store.

Who is it for?

• Ecommerce teams reviewing supplier product files.
• Developers adding CSV validation to data pipelines.
• AI agents checking catalogue data before an approved import.

Quick example

Select JSON input and paste:

{
  "csv": "sku,name,price,currency\nDEMO-1,Example Widget,19.95,AUD\nDEMO-1,Example Widget,20.95,AUD",
  "delimiter": ",",
  "requireBarcode": false
}

These fictional rows share a SKU but have different prices. Penny flags the duplicate and conflicting prices for review. It does not choose which price is correct or silently merge the rows.

Input requirements

Field	Description
csv	Required. Product CSV text, up to 500 product rows and 128 KB.
delimiter	Comma ,, semicolon ;, or the string tab. Default: comma.
requireBarcode	Set to true when barcode information is required. Default: false.

Your CSV must contain a column named sku. Map differently named supplier columns explicitly before submitting.

Only submit product data you have permission to process. Do not include personal information, credentials or confidential documents.

What Penny checks

• Duplicate product SKUs.
• Missing product identifiers.
• Inconsistent product names and prices.
• Invalid or unusual price values.
• Missing barcode information when required.
• Potential spreadsheet-formatting risks.

Results

After a successful run, open the Actor’s Dataset or Output view to inspect and download the findings and processed CSV.

A successful run means processing completed—not that the catalogue is approved for import.

Penny does not:

• Update your store or delete products.
• Decide which conflicting record is authoritative.
• Guess missing prices.
• Certify barcode ownership.
• Guarantee Shopify, WooCommerce or other marketplace import compatibility.

Duplicate SKUs can be intentional. Review the business context before changing them.

The processed CSV is a review copy, not guaranteed import-ready data. Treat formula-like values as untrusted. Import spreadsheet columns as text or inspect the JSON results first.

API and AI-agent integration

Actor identifier:

pennymachine42/penny-product-catalog-audit

Apify API identifier:

pennymachine42~penny-product-catalog-audit

Use this Actor’s API tab for generated integration examples. Supply the JSON input shown above and keep your Apify token private.

For asynchronous integrations:

1. Start an authorized Actor run.
2. Wait for the run to finish successfully.
3. Retrieve its dataset.
4. Inspect findings before performing any downstream update.

Apify MCP supports retrieving this Actor’s details by its exact identifier. Agents should inspect the input schema and current pricing before requesting execution.

Discovery alone does not authorize a paid run. Execution requires the customer’s authorized Apify account or a supported agent-payment arrangement.

Pricing

The current published price is:

• US$0.05 per completed catalogue audit, up to 500 product rows.
• US$0.00005 per Actor-start event, with a minimum of one event and additional events depending on allocated memory.

At 1 GB of allocated memory, one start event plus one completed audit totals US$0.05005.

Check the live Pricing tab for current prices and any applicable account charges or taxes. Free-plan usage does not generate creator revenue.

Repeatable workflow

Use Penny after a supplier CSV arrives and before an approved catalogue import:

Receive CSV → audit → review findings → approve any changes → import.

This Actor audits one supplied file. It does not provide live inventory monitoring or compare successive catalogue versions.

Support

Use the Actor’s Issues tab with a small fictional example, the observed result and the expected behaviour.

Never post customer files, credentials or API tokens publicly.