Guide — ORO Product XREF Explorer

What this dashboard is

This dashboard shows DiversiTech's product cross-reference (XREF) records: the lists that map a customer's or competitor's part number to the matching DiversiTech product SKU. The data comes from Snowflake (ORO) and is read-only — nothing you do here changes it.

Cross-references

Distinct products

Distinct customers

Distinct competitors

Live numbers, pulled from the same data as the dashboard.

Key terms

Cross-reference (XREF) row: One pairing of an outside part number with one of our products.
Product SKU: Our DiversiTech part number.
XREF SKU: Their part number — the customer's or competitor's code for the same item.
Customer: The customer whose part number is being crossed to ours.
Competitor: The competitor whose part number is being crossed to ours.
Source: The name attached to the row — the customer or the competitor it came from.
Effective / expiration date: When the cross-reference starts and stops applying.
Family: The broadest product grouping for our SKU (for example HVAC/R Electrical or Tools), from the DiversiTech product master.
Super category: The next level down inside a family.
Category: The most detailed grouping, inside a super category.
Family group: Sits above Family; it only merges two families (Chemicals and Components & Accessories), so it's shown as a column, not a filter.
(Unmapped): Our SKU wasn't found in the product master, or it has no family there.

Type codes

C rows are tied to a customer.
CP rows are tied to a competitor.
R and S rows have no customer or competitor attached.

That's all the data itself tells us. No official definitions for these codes were found, so treat any other meaning as unconfirmed.

How to use it

Pick filters on the left. Type, Customer, Competitor, Source, Product SKU, Family, Super category, Category, the date ranges, price, and a free-text search box. For Customer, Competitor and Product SKU, start typing to find a name.
Try it: Type = CP Try it: Customer = THERMAL SUPPLY Try it: Competitor = MARS Motors Try it: Family = HVAC/R Electrical
Know how filters combine. Several picks in one filter mean "any of these". A Customer pick plus a Competitor pick shows rows for either one. Every other filter narrows the results further. Picking a Family narrows the Super category list to what's inside it, and so on down.
Check the chips. Each active filter shows as a chip above the results. Click the × on a chip to remove it, or "Clear all" to start over.
Read the cards and charts. The totals, type breakdown, top sources, top products, product family chart and monthly trend all update to match your filters. Click a bar in the top products chart to filter to that SKU; click a family bar to drill down to its super categories, then categories.
Work the table. Click a column heading to sort (click again to reverse). Use the columns button to show or hide columns, and the controls below to change page or rows per page.
Click a row to see every field for that record in a side panel.
Export CSV to download everything matching your filters — not just the current page — up to 50,000 rows. For big pulls, filter first.
Share a view by copying the page address. It holds your filters, sort and columns, so whoever opens it sees the same thing.
Open "Data quality" at the bottom to see how complete each field is for your current filters.

Questions you can answer

Which competitors' parts do we cross-reference most?

Set Type = CP, then look at the top sources chart: the longest bars are the competitors with the most cross-references.

Try it: Type = CP

What does a specific customer or competitor cross over to?

Pick the name under Customer or Competitor, then read the Product SKU column next to their XREF SKU.

Try it: THERMAL SUPPLY

Which of our products have the most cross-references?

These products have the strongest conversion coverage. Look at the Top products by cross-reference count chart: the 15 longest bars are the SKUs with the most rows. Hover a bar for the description; click it to filter to that SKU. Add Type = CP to rank by competitor coverage only.

Try it: All rows Try it: Type = CP

Which competitor parts map to a given DiversiTech SKU?

Type the SKU in the Product SKU filter and set Type = CP. The XREF SKU and Competitor columns list the matching parts.

Try it: Product SKU = ORM5458B, Type = CP

Are cross-references current?

The expiration date is filled in on almost every row (empty on ), so you can use it to find stale records. Use the effective date range to see what started recently.

Which product families have the most competitor cross-references?

Set Type = CP and read the Cross-references by family chart. Click a family bar to see its super categories, then click again for categories.

Try it: Type = CP

Where do we have little cross-reference coverage by family?

Look at the shortest bars in the family chart (and drill in to find thin categories). The (Unmapped) bar is rows whose SKU has no family in the product master — not low coverage.

Try it: All rows Try it: Family = Tools

How fast is the cross-reference library growing?

Look at the monthly trend chart, which counts records by created date. Add filters to see the growth for one customer, competitor or type.

Where are the data gaps?

Open Data quality. Across all rows, right now:

XREF description empty on — most lookups give you their part number without a description.
XREF description 2 empty on — rarely used.
XREF price empty on — don't rely on this for pricing comparisons.
xref_product_id empty on — where it is filled, it's not yet shown in the dashboard table.
No product family on of rows — those show as (Unmapped).

I need a list for a customer or sales conversation.

Filter to the customer or competitor (and product, if needed), choose the columns you want, then click Export CSV.

Limitations and data notes

XREF descriptions are empty on of rows and prices on .
xref_product_id is empty on of rows.
The product hierarchy is missing for of rows ( of SKUs), shown as (Unmapped).
R and S rows have no customer or competitor.
Type codes have no official lookup, so they're shown as raw codes.
The data is only as fresh as the Snowflake source it reads from.

Data source: RAW_NA_ORO.PUBLIC.RAW_NA_DT_ORO_DT_XREF_PRODUCT_VIEW joined with RAW_NA_ORO.PUBLIC.RAW_NA_DT_ORO_DT_VIEW_DT_XREF_PRODUCT on id. Product hierarchy: DT_BUS_LAYER.PUBLIC.VW_PRODUCT_MASTER, matched on Product SKU = ITEM_NUMBER.

FAQ and troubleshooting

I see no results.: Check the chips — you may be filtering too narrowly. Remove some, or click "Clear all".
My export stopped at 50,000 rows.: That's the limit. Add filters and export in smaller pieces.
A name appears twice, or covers more rows than expected.: Some customers share a name across several source IDs. Filtering by the name includes all of them.