# Bulk Process Action Inquiries

If you have a large volume of action inquiries to process, you can create a CSV file with your resolutions to submit your resolutions in bulk instead of approving each one manually.

#### Create action inquiry resolutions file

1. From the left navigation menu, select ![](https://4048883401-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwMLlMoFBtKJa8ptd3zaw%2Fuploads%2Fgit-blob-230534471fef5f40808e921e41ee44e4a06ded03%2Fe6cb9548999afdc1ed3ce4942e4cb5b45b5cecbd323267aac2a7cd1915fccc09.svg?alt=media) **\[Engage]** → **Transactions → Inquiries**.
2. At the top of the list, ensure the *Resolution* filter is set to **New**.
3. Select one of these options:

   * Select ![](https://4048883401-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwMLlMoFBtKJa8ptd3zaw%2Fuploads%2Fgit-blob-ec3276f07285180fbb2167a40e148d3e43e8681c%2F05aa88f72076df5a744d4620574f19cc187b7154fe1f3bb73ad7a892b7d23002.svg?alt=media) **\[Download] → Download as CSV**.<br>

     <div data-with-frame="true"><figure><img src="https://4048883401-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwMLlMoFBtKJa8ptd3zaw%2Fuploads%2Fgit-blob-787ba929a508b3fe744890f52241c581bbb2a401%2Fef1492b615323fadf329a4c3b8440ac303f4dadc02594807cea1fff297259db8.png?alt=media" alt=""><figcaption></figcaption></figure></div>

     * You can make edits directly to the downloaded file and save them.
   * Alternatively, download [this template](https://docs.google.com/spreadsheets/d/1aVTgZGF-xhlMJD1l_TulICHAwY57FwRzgZ8RbJSy-mw/edit#gid=0) and modify it with your own data.

   <div data-gb-custom-block data-tag="hint" data-style="warning" class="hint hint-warning"><p><strong>Don't use formulas</strong>: <mark style="color:$danger;">Do not use any type of formula—only enter exact amounts</mark>. The platform will not recognize the result of Excel or Google Sheets formulas, so you <strong>will likely incur overage fees</strong> if you upload a file that contains formulas in your spreadsheet's cells. Simply convert cell values from formulas to the formulas' results to avoid this problem.</p></div>

#### Process the action inquiries CSV file

Refer to the table below for the **required columns** that impact.com needs as well as the **optional fields**:

| Id                | **Required**                                 | `123456`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | A unique value assigned to the Action Inquiry—this value is found in the `Id` column of your downloaded CSV file of Action Inquiries.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ----------------- | -------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Transaction Date  | **Required if accepting the action inquiry** | `2018-10-27T17:00:00-07:00`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | This is the date that the transaction took place, in ISO 8601 format (e.g., `2038-01-19T03:14:07+00:00`)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| Resolution Status | **Required**                                 | `VALID` , `INCOMPLETE` or `DECLINED`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | <p>Indicates if the action inquiry is accepted or declined.</p><ul><li>Enter <code>VALID</code> to accept</li><li>Enter <code>DECLINED</code> to decline</li><li>Enter <code>INCOMPLETE</code> to request the partner provide more information</li></ul>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| Resolution Reason | **Required if declining the action inquiry** | <ul><li>This transaction has been tracked successfully</li><li>Another marketing channel was credited with sale</li><li>Another marketing channel was credited with sale, due to a voucher/discount code used</li><li>Did not meet terms and conditions set by merchant</li><li>Transaction not completed - Order cancelled, changed or returned</li><li>Transaction cannot be traced</li><li>Transaction not fully completed online</li><li>Enquiry does not provide complete information required for evaluation</li><li>Other</li></ul> | Enter the reason for declining the action inquiry—for most cases, you can put `OTHER`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| Action Tracker    | **Required**                                 | `35601`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | <p>Enter the ID of the <em>Event Type</em> associated with this action.<br></p><p><strong>View your event type IDs</strong><br></p><ol><li>From the top navigation bar, select <img src="https://paligoapp-cdn-eu1.s3.eu-west-1.amazonaws.com/impact/attachments/f01cdffa431a4d75ff09c130b66974d4-ec4c7b9aa5792fe725406b280fb272b1.svg" alt="[User]"> <strong>\[User profile] → Settings</strong>. </li><li>Then select <strong>Event Types</strong>.</li></ol><p></p><p>If the action inquiry is linked to a specific order and is for an incorrectly tracked action, you can also use the <a href="https://help.impact.com/en/support/solutions/articles/155000000121-orderid-lookup">Order ID Lookup report</a> to find which event type the action inquiry is associated with.</p> |
| Final Payout      | **Required**                                 | `0`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Specify the final payout the partner will receive, or leave this blank for impact.com to generate a payout based on your contract with the partner. For declined action inquiries, enter `0`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| Resolution Notes  | Optional                                     | `{Insert any custom message}`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Field for any additional notes you'd like to add.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| Sale Amount       | Optional                                     | `1400`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Allows you to update the original sale amount reported by the Partner.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| Customer Id       | Optional                                     | `WX9299099823723432`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Order Customer Id.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| Customer Status   | Optional                                     | `new`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | Whether the purchasing user is a `new`, `returning`, or `re-engaged` customer.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| Promo Code        | Optional                                     | `SUMMER10`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Order promo code.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| Category          | Optional                                     | `Beauty`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | The line item's category.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| SKU               | Optional                                     | `LPGLOSS103`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | The line item's SKU.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| Name              | Optional                                     | `Summer Lip Gloss`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | The line item's name.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| Quantity          | Optional                                     | `12`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | The line item's quantity as a number.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| Amount            | Optional                                     | `$199.99`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | The line item's subtotal as a number with two decimal places.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |

#### Upload the processed CSV file

{% hint style="warning" %}
**Warning**: Your file cannot have any periods in its name (e.g., `Action.Inquiry.Resolutions`), as it won't be accepted. Use underscores or "CamelCase" instead (e.g., `Action_Inquiry_Resolutions` or `ActionInquiryResolutions`).
{% endhint %}

1. From the left navigation menu, select ![](https://4048883401-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwMLlMoFBtKJa8ptd3zaw%2Fuploads%2Fgit-blob-230534471fef5f40808e921e41ee44e4a06ded03%2Fe6cb9548999afdc1ed3ce4942e4cb5b45b5cecbd323267aac2a7cd1915fccc09.svg?alt=media) **\[Engage]** → **Transactions → Inquiries**.
2. In the top-right corner of the main window, select **Upload Resolutions**.
3. Use the **Choose File** button to select your CSV file.
4. Select **Submit** to process your action inquiries in bulk.

You'll receive a confirmation message on the next screen that indicates if the file was uploaded successfully.