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

# How do I filter deals by ROI, margin and SAS?

> Use filter templates in the Sourcing Sheet to narrow down profitable deals quickly.

# How do I filter deals by ROI, margin and more?

## Short description

With the filters in the Sourcing Sheet you narrow down your profitable deals in seconds — by purchase source, category, marketplace, rating and price ranges. Filter combinations can be saved as templates per user.

## Step-by-step guide

### Step 1: Open the filter flyout

→ Open directly in the app: [app.arbitrageone.de/productsheets](https://app.arbitrageone.de/productsheets)

At the top, next to the **Filter templates**, click the filter icon to expand the flyout.

<img src="https://mintcdn.com/arbitrageonegmbh/TL_61VARw_FBL6qD/articles/sourcing/images/deals-filtern-01.png?fit=max&auto=format&n=TL_61VARw_FBL6qD&q=85&s=177b19d4566f09af04dcb69fbe0fa3bf" alt="Expanded filter flyout with all filter options and templates area" width="534" height="823" data-path="articles/sourcing/images/deals-filtern-01.png" />

### Step 2: Use multi-select filters

The following dropdowns allow multi-select with live search:

* **Purchase source**: source of the deal (Rossmann, Müller, Idealo …)
* **Category**: Amazon category (Website Display Group)
* **Marketplace**: target marketplace (DE, FR, IT, ES, UK …)
* **Sourcing strategy**: strategy assignment (e.g. Online Arbitrage, Retail Arbitrage)
* **Tags**: your own tags
* **Rating**: 1 (Bad) to 5 (Good)

### Step 3: Filter price ranges

* **Purchase price gross (€)**: min/max range for the purchase price
* **Selling price (€)**: min/max range for the selling price

### Step 4: Apply filters

Click **Apply** — the table updates with the active filters.

### Step 5: Save filter as a template

Under **Filter templates** enter a template name and click **Save**. Saved templates can be recalled at the top next to the filter icon.

## Notes on ROI and Margin

* **ROI**, **Margin** and **Breakeven** are shown per row as coloured badges (traffic-light system based on your thresholds in **Settings → Calculation**).

## Common issues

**Issue:** Filter doesn't apply, table shows old results
**Solution:** Reload the page. For very large sheets, the filter can take 1–2 seconds to take effect.

**Issue:** A saved filter template has disappeared
**Solution:** Templates are saved per user. If you work across multiple devices, it should be consistent — if there are problems: clear the browser cache and log in again.

**Issue:** "Purchase source" doesn't show a shop
**Solution:** Shops only appear if at least one deal has them as a source. Add the source to at least one deal.

## Related articles

* [How do I set up my calculation basics?](../erste-schritte/kalkulationsgrundlagen-einrichten)
