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

# Sales by Collection Report in Eaglecart

> Read the Eaglecart Sales by Collection report, why collection rows can add up to more than the total, and how sales of products in no collection are shown.

[Help Center](https://help.eaglecart.com/introduction.md)

[Reports and analytics](https://help.eaglecart.com/reports.md)

Sales by Collection report

# Sales by Collection report

**Sales by Collection** shows how your collections, such as seasonal edits, campaigns and curated groups, are performing. Open it from **Sales** > **Sales by Collection**.

## Cards

| Card | What it shows |
| - | - |
| **Collections sold** | How many different collections had a sale. |
| **Value from collections** | What products in collections sold for, tax included. Carries the comparison badge. |
| **Top collection** | The biggest earner. The note shows its value and units. Click it to open the collection. |
| **Not in a collection** | Sales of products that were in no collection. The note shows what share of sales that was. |

## A product can be in several collections

The report handles this in two ways on purpose:

* **In the rows**, a product in three collections counts in all three. Each collection gets credit for what it sold.
* **In the total row and the Value from collections card**, each sale is counted **once**. Otherwise the report would claim you sold three times what you did.

So the rows can add up to more than the total. That's not an error.

**Example:** a jacket sells for 200 and is in **New Arrivals**, **Winter** and **Sale**. Each of those rows includes the 200, but **Value from collections** goes up by 200 only once.

## Collection revenue trend

What your collections brought in over time, with each sale counted once. With comparison on, the earlier period is dotted behind. **Chart** / **Table** toggle.

## Collections sold table

Searchable by name.

| Column | What it shows |
| - | - |
| **Collection** | The collection. |
| **Products** | How many different products sold in it. |
| **Units sold** | Items sold. |
| **Total inc. Tax** | What customers paid, including tax. |
| **Tax** | Tax charged. |
| **Net sales** | Sales after discount, without tax. |
| **Cost** | What the products cost you, for products with a cost entered. |
| **Gross profit** | Net sales minus cost. |
| **Margin** | Gross profit as a share of net sales. |

## Products in no collection

Products that were in no collection when they sold never get a row. They only show in the **Not in a collection** card. See [Add products to collections](https://help.eaglecart.com/products/add-products-to-collections.md).

## Common questions

**Why do the collection rows add up to more than the total?** Products in several collections count in each row but once in the total.

**Why doesn't a product appear in any row?** It was in no collection when it sold.

## Keep reading

* **Next:** [Sales by Customer report](https://help.eaglecart.com/reports/sales-by-customer.md): who bought and who still owes.
* [Create and manage collections](https://help.eaglecart.com/products/create-and-manage-collections.md): build collections.
* [Sales by Category report](https://help.eaglecart.com/reports/sales-by-category.md): earnings by category.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.