# Uploading the Mapping Sheet and Matching Part Numbers in the "Dahua Integration"

> Source: https://help.getedara.com/en/articles/90000023-uploading-the-mapping-sheet-and-matching-part-numbers-in-the-dahua-integration · Category: Extensions Store › Dahua · العربية: https://help.getedara.com/ar/articles/90000023-%D8%B1%D9%81%D8%B9-%D9%88%D8%B1%D9%82%D8%A9-%D8%A7%D9%84%D9%85%D8%B7%D8%A7%D8%A8%D9%82%D8%A9-%D9%88%D8%B1%D8%A8%D8%B7-%D8%A7%D9%84%D8%A3%D8%B5%D9%86%D8%A7%D9%81-%D8%A8%D8%A3%D8%B1%D9%82%D8%A7%D9%85-%D8%A7%D9%84%D9%82%D8%B7%D8%B9-%D9%81%D9%8A-%D8%A7%D9%84%D8%B1%D8%A8%D8%B7-%D9%85%D8%B9-%D8%AF%D8%A7%D9%87%D9%88%D8%A7

Dahua knows every product by its own part number, while your items in "Edara" have their own codes and names. If an item doesn't reach Dahua with the right part number, your sales and stock of it aren't counted as they should be.

With the "Dahua Integration", you upload the mapping sheet Dahua sends you once, your items are matched to it by themselves, and all that's left for you is picking the right number when an item has more than one.

## Follow the Steps

The mapping sheet is a file Dahua sends you, with a "Part number", "Dahua model" and "Customer model" for each product.

### Uploading the Mapping Sheet

Upload the sheet as an .xlsx or .csv file, up to 2 MB:

1. Open " **Mapping** ", then the " **Mapping sheet** " tab.
2. Click " **Choose file** ", and choose the sheet.
3. Check how many items are "Ready to report" and how many "Need attention".

Each item's model is looked up in the "Customer model" column first, then in the "Dahua model" column, and the item is:

- **"Ready":** it has one part number, and is reported with it.
- **"Unresolved":** it has several part numbers, and you pick the right one.
- **"No match":** its model isn't on the sheet, so it's treated as not Dahua and isn't reported.

> **Note:** The "Dahua model" and "Customer model" are compared with the item field you choose in "Match items to the sheet by" under "Settings" › "General".

### Picking the Right Part Number

An item is only reported when it has exactly one part number, so when the integration finds more than one on the sheet:

1. Open the " **Edara items** " tab, then click " **Need attention** ".
2. Click " **Pick the right one** " next to the item.
3. Click " **Use this one** " next to the right part number, then click " **Use this one** " to confirm.

The item becomes "Ready", and is reported with this part number from the next send.

### Unmatched Items

If an item is from Dahua but wasn't matched, its model in "Edara" is usually written differently from the sheet:

1. Click " **Unmatched** ", and check the items.
2. Fix the item's model in "Edara".
3. Click " **Refresh from Edara** ".

> **Note:** You don't need to fix items that aren't from Dahua; they stay "No match" and aren't reported.

## Important Things to Know

- If Dahua sends you a newer sheet, click "Replace the sheet" in the "Mapping sheet" tab.
- "Unresolved" items aren't reported, and their rows show under "Reasons rows are held back" when you preview, as in [Previewing Reports and Activating Daily Sending in the "Dahua Integration"](https://help.getedara.com/en/articles/90000024-previewing-reports-and-activating-daily-sending-in-the-dahua-integration) .
- Uploading the sheet is one of the items needed before you can activate, as in [Setting Up the "Dahua Integration"](https://help.getedara.com/en/articles/90000022-setting-up-the-dahua-integration) .

## Try It Yourself

Sample data — it doesn't affect any real data. Upload the sheet, then pick the part number for each "Unresolved" item, and fix the unmatched item and click "Refresh from Edara".

## You May Be Wondering

**What format is the mapping sheet?**

An .xlsx or .csv file up to 2 MB, with "Part number", "Dahua model" and "Customer model".

**Why is an item "Unresolved"?**

Because its model is on more than one row of the sheet with different part numbers, so you pick the right one.

**Is a "No match" item reported?**

No. It's treated as not Dahua. If it is from Dahua, fix its model in "Edara" and click "Refresh from Edara".

**When is the part number I picked used?**

From the next send, in every report.