Inventory Link Audit
Summary
Inventory Link Audit flags supplier inventory links at risk of cost, brand, or identifier mismatches across multi-supplier catalogs, and emails a results file you review and re-upload to remove bad links in bulk.
Inventory Link Audit finds supplier inventory links at high risk of a data mismatch (cost, brand, or identifier discrepancies) across multi-supplier catalogs. It emails a results file you review and upload back to remove incorrect links in bulk.
- Detect mismatches: flags links with cost, brand, or UPC/MPN discrepancies.
- Scope by scenario: choose which mismatch scenarios to run and exclude enrichment-only sources.
- Review results: each flagged item shows the link, its fields, and an audit reason.
- Remediate in bulk: upload the file back to remove incorrect links at scale.
To unlink in bulk, select listings in the grid and use the Unlink bulk action. For supplier links across the catalog, the Inventory Link Audit result file has an Unlink column and is re-imported with Import and Unlink. Remap Inventory SKUs is a CSV with SKU and New SKU for a source and renames an inventory SKU; it does not switch a product to a different supplier.
| Check | Detail |
|---|---|
| Cost discrepancies | Linked sources whose cost differs beyond expectation. |
| Brand inconsistencies | Links where brand values disagree. |
| Identifier mismatches | UPC and MPN that do not line up across the link. |
| When to use | Why |
|---|---|
| Supplier onboarding | Validate links as you connect new suppliers. |
| Pricing or availability investigations | Trace discrepancies to bad links. |
| Routine health checks | Keep the catalog reliable over time. |
| Automation prep | Build confidence before advanced order routing. |
Manual link removal
To remove a single supplier inventory link from a product variant, navigate to Products > Product Catalog and open the specific variant. Scroll to the Inventory Links section, locate the source inventory item you wish to disconnect, and click the delete icon (trash can) for that row, then save the variant. You can use the Undo option if needed before saving.
Audit tool limitations
The Inventory Link Audit only surfaces products where a supplier link has a cost, brand, or UPC/MPN mismatch. If a product link meets all validation rules, it will not appear in the audit results and cannot be removed through the bulk audit process. For these valid links, use the manual delete option on the product variant page.
How do I get the audit results?
How do I keep a link the audit flagged?
How do I avoid false positives?
When should I run it?
Does the Inventory Link Audit remove links?
What it does
The Inventory Link Audit tool helps you maintain a clean Master Catalog by identifying "mismatched" inventory. This occurs when products from different sources (suppliers, 3PLs, or internal warehouses) are incorrectly merged under a single Master SKU due to misaligned builder settings or overlapping identifiers like UPCs or MPNs.
Running an audit
- Navigate to the Product Catalog.
- Select the products you wish to audit (or select all).
- Click the Actions dropdown and select Inventory Link Audit.
- Configure your audit criteria to identify mismatches. Common thresholds include:
- Cost: Flags items where costs differ by a specific percentage or dollar amount.
- Brand: Flags items where the brand names do not match.
- UPC/MPN: Flags items where these identifiers are inconsistent across linked sources.
- Exclude any sources that should not be part of the audit (e.g., product data-only sources without cost info).
- Click Export and Review.
Reviewing and unlinking results
Once the export is processed, you will receive a report via email or the in-app notifications center. The report groups variants by their Master SKU so you can compare source data side-by-side.
| Column | Action |
|---|---|
| Unlink (Column A) | Set to true to remove the link, or false to keep it. |
| Product Link | Use this URL to view the product details and images in Flxpoint for manual verification. |
| Flag Reason | Review why Flxpoint flagged the item (e.g., "Cost Mismatch" or "UPC Mismatch"). |
After updating the spreadsheet, return to the Product Catalog, click Actions, and select Import and Unlink to apply your changes.
Why it matters
Ensuring your inventory links are accurate is critical for downstream operations. Incorrectly merged items can lead to:
- Pricing Errors: Syncing a low cost from a different item can cause you to lose margin on your Sales Channel.
- Order Routing Errors: DOM may route an order to a source that does not actually carry the intended product.
- Overselling: Inventory levels may be inflated by combining stock from unrelated items.
