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.
| 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. |
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?
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.
