> For the complete documentation index, see [llms.txt](https://docs.perkville.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.perkville.com/features/customers/bulk-point-updates.md).

# Bulk point updates

In Perkville, staff members with **Employee** or **Admin** level permissions can efficiently manage large volumes of point transactions by using bulk point updates. This is useful not only for adding and redeeming points in bulk, but also for correcting point errors.

There are two ways to add points in bulk:

1. **Using the** [**Add / Redeem page**](#add-redeem)**:** Use this process if each customer is getting the same number of points.
2. **Using the** [**CSV upload process**](#csv-upload)**:** Use this process if each customer is getting a different number of points and you need to process a large number of transactions.

## Accessing bulk point tools

To access both the Add / Redeem and CSV upload tools, click **My Business** and then **Add / Redeem**. To access the CSV upload, click **CSV Upload** in the upper-right corner.

## Add / Redeem

{% hint style="info" %}
Add / Redeem is best if you want to add the same point value for a list of customers. If you need to add different point values, use the [CSV upload](#csv-upload).
{% endhint %}

### **Quick Overview**

1. **Choose an action**: Give Points, Redeem Points, or Log Activity.
2. **Select the location**: Pick which location these points or activities will be associated with.
3. **Enter the list of email addresses**: Paste a list of emails on separate lines. Do not separate email addresses with commas or semicolons.
4. **Select the appropriate rule**: Decide which earning activity, redemption, or progress activity you'd like to issue.

<figure><img src="https://2181708597-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSiE75SeColbiBVbet0NZ%2Fuploads%2FbheAccXR9d0OmLFYYPvp%2FScreenshot%202025-06-20%20at%2010.02.10%E2%80%AFAM.png?alt=media&#x26;token=7b3cff30-4521-4031-8540-760e633c6568" alt=""><figcaption><p>The Add / Redeem tool allows you to add the same point amount to a list of customers.</p></figcaption></figure>

## CSV Upload

{% hint style="info" %}
CSV Uploads allow you to award different point amounts to a list of emails.
{% endhint %}

### **Quick Overview**

1. **Select the location**: Pick which location these points or activities will be associated with.
2. **Choose an action**: Give Points, Redeem Points, or Log Activity.
3. **Upload your CSV:** The file must be a `.csv`.

### CSV formatting

The CSV must contain one customer transaction per row:

* **Column A:** The customer's email address.
* **Column B:** The quantity of the transaction.

For example:

```
jane@example.com,1
sam@example.com,4
alex@example.com,2
```

Each row should contain exactly one email address and one quantity. Do not place multiple customers on a single row separated by additional commas.

{% hint style="info" %}
If you are awarding points for an earning rule where each unit, such as a class attended, earns 5 points, then a row with a quantity of 1 will award 5 points and a row with a quantity of 4 will award 20 points.
{% endhint %}

### Common CSV formatting mistakes

* Putting multiple customers or transactions on one row.
* Saving the file in a format other than CSV.
* Entering a quantity in the wrong column.
* Using an incorrect customer email address.

### Tips

* **Test with a small batch**: Upload a few records first to confirm everything works as intended before doing a large bulk upload.
* **Keep records**: Keep a copy of your CSV in case you need to double-check your entries or confirm points awarded.
* **Be mindful of email addresses**: Typos in emails can lead to points going to the wrong accounts or not being awarded at all.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.perkville.com/features/customers/bulk-point-updates.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
