PREFLIGHT CHECK

BASE product ID and variation CSV safety checker

Check blank product/variation IDs and stock-field combinations that can create new products or fail updates in BASE.

Check CSV

🔒 Analysis runs in your browser. The CSV file itself is not uploaded to BlueprintLab.

What this tool checks

  • Warning when blank product ID creates a new product
  • Variation ID / variation stock pairing
  • Product stock on variation rows
  • Duplicate product/variation IDs
  • Per-row column count

What this tool cannot verify

The tool does not claim to verify live service-side master data, account-specific state, or network reachability that cannot be established reliably in-browser. The service’s own validation remains authoritative.

In BASE, a blank ID can change the operation itself

A blank Product ID is not the same as “leave this value unchanged.” BASE treats it as a new-product registration. Variation ID also identifies which existing variation is being edited.

For update files, losing an ID can be more consequential than leaving price or stock blank.

A missing Product ID header is an error

Without the Product ID column, this checker cannot distinguish new rows from updates, so it stops. A missing Variation ID column is only a warning because a CSV containing products without variations can still be valid.

If Variation ID is present but Product ID is blank, the checker warns because the row is still treated as new.

Variation stock needs the variation context

When a Variation ID is present, an empty variation-stock value is checked, and product-level stock on variation rows is flagged for review. Duplicate Product ID + Variation ID combinations are also surfaced.

This catches copy/paste rows that can otherwise be easy to miss.

Defaults are a separate question

This checker answers “which product/variation is this row targeting?” For blank-value behavior on new rows, use the BASE new-product default checker.

Resolve identity first, then validate the values.

Want the bigger CSV picture?
5 checks before a CSV bulk import →