> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cellbot.chat/llms.txt
> Use this file to discover all available pages before exploring further.

# CSV Import

> Bulk import repair prices from a CSV file

## CSV Format

Your CSV file should have these columns:

| Column     | Required | Description                              |
| ---------- | -------- | ---------------------------------------- |
| brand      | Yes      | Device brand (e.g., "Apple")             |
| model      | Yes      | Device model (e.g., "iPhone 15 Pro")     |
| repair     | Yes      | Repair type (e.g., "Screen Replacement") |
| price      | Yes      | Price in pence (e.g., 8999 for £89.99)   |
| currency   | No       | Currency code (default: GBP)             |
| warranty   | No       | Warranty period                          |
| turnaround | No       | Estimated minutes                        |

## Example

```csv theme={null}
brand,model,repair,price,currency,warranty,turnaround
Apple,iPhone 15 Pro,Screen Replacement,8999,GBP,90 days,60
Apple,iPhone 15 Pro,Battery Replacement,4999,GBP,90 days,30
Apple,iPhone 14,Screen Replacement,7999,GBP,90 days,60
Samsung,Galaxy S24,Screen Replacement,7499,GBP,90 days,45
Samsung,Galaxy S24,Battery Replacement,3999,GBP,90 days,30
```

## Import Steps

1. Go to **Pricebook** in the dashboard
2. Click **Import CSV**
3. Upload your CSV file
4. Preview the resolved entries — green rows are matched, yellow need attention
5. Click **Import** to add all resolved entries

## Tips

* Device names are fuzzy-matched — "iPhone 15 Pro" will match the device in the catalogue
* Repair types are matched by name — use standard names like "Screen Replacement", "Battery Replacement"
* Duplicate entries (same device + repair) are skipped