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

# Product Revenue Import (CSV)

> For customers with this module, we support the following bulk import specs:

### Contact Product Purchases

This import is meant to capture aggregated purchase history per Contact, broken down by product category and year.

***Required fields***

* **purchased\_amount** - Total spend, in USD (Example: 52000, *do not* include any formatting such as currency symbol \$, commas, etc.)
* **year** - 4-digit year (Example: 2025)
* **contact\_id** - Unique customer contact identifier, should match customer Contact 'contact\_id' field (e.g. ERP customer ID or number; Salesforce Account ID; etc)

One of the following:

**product\_name** - Name of product, which should match product definitions linked to Contacts (Examples: Zidua; Xitavo; 3210 Brand; Acuron; Amistar; etc.)

OR

**product\_id** - Product ID, which should match product ID definitions linked to Contacts (Examples: 1234xyz; etc.)

***Optional fields***

* **crop** - Commodity code, see list of [supported commodity codes in this CSV](/assets/commodity-codes.csv) attached to this help article; used if product has variable pricing depending on the crop commodity
* **map\_item\_external\_id** - Internal unique identifier linking the purchase to an imported point or boundary feature of interest (e.g. retail or wholesale location); if provided, must map to an previously imported location (see [Creating Custom Map Layers: Location Points](/company-layers/creating-custom-map-layers-location-points-bulk-upload))
  ***Example***

| contact\_id | year | product\_name | purchased\_amount | crop | map\_item\_external\_id |
| ----------- | ---- | ------------- | ----------------- | ---- | ----------------------- |
| 55512345    | 2025 | Zidua         | 52000             | corn | LOC-004                 |
| 55512345    | 2025 | Acuron        | 18500             |      |                         |
| smithfarms  | 2024 | 3210 Brand    | 31000             | soy  | LOC-004                 |

A contact has one row per product, year, crop, and location combination.