Inventory CSV Preflight

Check inventory CSVs without changing the source. Get a readable HTML report and JSON findings for your next automation step. Leading zeros in product identifiers are preserved.

How to use it

1. Paste CSV text with its header row.
2. Select the exact SKU column and, optionally, a location column.
3. Choose required fields, quantity columns, price columns, and whether negative quantities are allowed.
4. Run the check and open HTML report in Output. Use JSON report or Storage to retrieve structured findings.

Example input:

{
  "csvText": "SKU,Location,Quantity,Price\n000123,North,4,9.99\n",
  "skuColumn": "SKU",
  "locationColumn": "Location",
  "quantityColumns": ["Quantity"],
  "priceColumns": ["Price"],
  "requiredColumns": [],
  "allowNegativeQuantities": false
}

What it checks

• Blank or whitespace-only keys and required fields.
• Duplicate or conflicting rows with the same SKU/location key.
• Leading or trailing whitespace.
• Whole-number quantities under your chosen negative-quantity policy.
• Finite, nonnegative prices.
• Formula-like text for review. A warning does not prove that a spreadsheet will execute it.

Column names and keys are case-sensitive. Findings apply only to the selected rules. This tool does not repair files, validate a specific importer, or guarantee that an import will succeed.

Limits and reports

Up to 5 MiB of UTF-8 CSV, 50,000 data rows, and 50 columns. Reports include the input hash, row numbers, selected rules, and complete finding counts. At most 10,000 individual finding details are returned, with omitted details clearly counted. Duplicate groups retain their full row-number lists.

Each completed run also writes one compact default-dataset summary with status, aggregate record and finding counts, the input hash, and the REPORT and REPORT.html storage keys. It contains no CSV values or finding previews.

HTML is intended for the Output preview. If Chrome cannot preview JSON there, open or download the JSON record from Storage instead.

Data handling

Submit inventory data only, without personal data, customer or employee records, credentials, or other sensitive values. Inputs and reports stay in the Apify run's storage under its configured retention rules. Reports can contain short previews of flagged values. The checker does not send your CSV to outside APIs or access a store account.

Price and support

The price is $1 per completed report, including platform usage. Both report formats are saved before a report charge is requested. Rejected input or a failure to generate or save the reports does not request a report charge. The live pricing shown by Apify governs each run.

For a reproducible problem, open an Actor issue with the selected rules and a small synthetic example. Do not post private input data in public issues.