Missing Data Finder for BigCommerce

What it does

Missing Data Finder scans your BigCommerce catalog and flags products that are missing required information, have invalid values, or are still set to a default. You pick which checks to run (for example empty SKUs, missing images, blank descriptions, invalid UPC/GTIN codes, or a sale price that’s higher than the regular price), and the tool produces a downloadable report listing every problem it found, one row per issue. The report runs in the background and is delivered when it’s ready, so you can leave the page while it works.

When to use it

Use it to audit your catalog before a launch, a migration, or a marketing push, anytime you want to find products that are incomplete or misconfigured. It’s handy for spotting items that will look bad on the storefront (no image, no description), items that may be rejected by Google Shopping or other feeds (missing/invalid UPC, GTIN, or MPN), and pricing mistakes (a sale price set above the regular price).

Before you start

• A connected BigCommerce store.
• Permission to read products on the connected store (the tool reads your catalog through the BigCommerce API).
• No upload file is needed, this tool creates a report for you.

Step-by-step

File / field reference

File formats: CSV or Excel (.xlsx).

Report columns: every issue found is listed as its own row with these columns:

• SKU — the SKU of the affected product.
• Field — which field has the problem (for example “Sku”, “Images”, “Brand”).
• Additional Info — extra context when available (for example the thumbnail URL of an image that’s missing alt text).
• Error — what’s wrong: missing, contains invalid characters or information, has default value, sale price is more than price, or uses page name.

Checks you can run, and what each one looks for:

• SKU is empty — product has no SKU.
• Name is empty — product has no name.
• Description is empty — product has no description.
• Categories is empty — product isn’t assigned to any category.
• Brand is empty — product has no brand.
• Images are empty — product has no images.
• Image Alt Tags are empty — one or more product images have no alt text (the report lists each affected image).
• Weight / Width / Height / Depth is empty — checked only on physical products; flags a missing dimension.
• Sale Price > Price — the sale price is set higher than the regular price.
• UPC is empty / GTIN is empty / MPN is empty — the code is blank.
• UPC / GTIN invalid — if a UPC or GTIN is present but isn’t all digits, it’s flagged as containing invalid characters.
• Product Tax Code is default / Product Tax Class is default — the tax setting is still on its default value.
• Sort Order is empty — no sort order set.
• Page Title is empty — no page title set (the product falls back to using its name).
• Meta Description is empty — no meta description set.
• Search Keywords is empty — no search keywords set.

Troubleshooting / FAQ