---
title: "Spreadsheet order intake"
description: "Email SureBright a spreadsheet of your orders and have the protection plans set up for you, with no storefront integration: what to send, what your customers receive and where the plans appear."
---

<Note>Available on request. Ask your SureBright contact to enable this for your store.</Note>

Use spreadsheet order intake when your orders do not come from a connected storefront or POS. You email an Excel workbook of orders to the mailbox SureBright gives you. SureBright finds the plans in it, asks a customer to confirm which product their plan covers where that is not obvious, and sets up the plans. Read this page when you are setting it up, or when you want to know what happens after you send a file.

## What happens after you send a file

1. **You send the file.** Attach the `.xlsx` to an email from a sender address you registered with SureBright and send it to the intake mailbox. Mail from any other sender is ignored.
2. **SureBright reads it.** Within a few minutes SureBright reads the workbook and works out which lines are products and which are plans. A line counts as a plan when its product ID is one of the plan SKUs you agreed at setup.
3. **Customers confirm the covered product.** For an order with exactly one product and one plan, the plan is matched to the product automatically. For anything else the customer receives an email with a link to confirm which product each plan covers.
4. **Plans start.** Once every plan on the order is matched to a product, SureBright creates the contract and emails the customer their coverage confirmation.

Sending the same file twice does nothing: a file with the same contents is handled only once. Send a new file with new orders instead.

## What the workbook must contain

The workbook has two sheets, **Orders** and **Product**, joined by the product ID. Your column headers can differ from the names below. SureBright matches your headers to these fields once at setup (capital letters do not matter) and uses the same matching for every file you send after that. Fields marked **required** must be present and filled on every row, or the order cannot be handled.

### Columns on the Orders sheet

One row per order line. Rows that share the same order number form one order.

| Field | Required | Notes |
|---|---|---|
| Order number | yes | Groups rows into an order and becomes the order reference on the contract. |
| Order date | | Purchase date of the order. |
| Customer first name, last name | | |
| Customer email | yes | Where the confirmation link and the coverage email are sent. |
| Customer phone | | |
| Address line 1, line 2, city, state, ZIP, country | | Printed on the contract. If address details are missing, the contract is put on hold; see [Why a contract is on hold](/contracts/holds). |
| Product ID | yes | Identifies the product or plan on the line and joins to the Product sheet. |
| Order line key | | Your line identifier, kept on the contract. |
| Sale price | | Price paid for the line. |
| Quantity | | Units on the line. |
| Discount amount | | |

### Columns on the Product sheet

One row per product ID referenced by the Orders sheet.

| Field | Notes |
|---|---|
| Product title | Shown to the customer on the confirmation page; a second column can be named as a fallback when the first is blank. |
| Product SKU | |
| List price | The product's list price, distinct from the sale price. |
| Product description | |
| Product URL | |
| Product condition | |

If you want an extra column kept with the order, ask for it at setup. Do not include credentials or other sensitive columns in the file; SureBright uses only the columns above.

## What the customer receives

**Confirmation email.** Subject *Complete your warranty registration*. It thanks the customer for buying a warranty with your store, says how many warranties they have to link to how many products, and has a **Link my warranty** button. The link is specific to the order and expires after the number of days stated in the email; if they did not buy the warranty they can ignore it. Customers can reply to the email with questions.

**Confirmation page.** Titled **Confirm your protection plan** with the line *Tell us which product each protection plan covers so we can activate it.* For each plan the page asks **Which product does this plan cover?** and lists the order's products; a product already matched to another plan is marked as such. The customer can choose **I'm not sure** and come back later. **Confirm & activate** submits the choices and shows **Your protection plan is confirmed**. An expired or already used link shows *We couldn't open this activation* with instructions to use the most recent email or reply to it for a new one.

**Coverage email.** Once the contract exists the customer receives the standard SureBright coverage confirmation for your store.

<Tip>
Orders with one product and one plan skip the confirmation step entirely; the customer only receives the coverage email. Keeping one order per product in your export therefore gets customers covered fastest.
</Tip>

## Where the plans appear

Contracts show under **Recent Sales** on the portal's [Sales](/merchant-portal/sales) page like any other sale, with your order number as the reference. Until a customer confirms, the order has no contract; SureBright can re-send the confirmation link on request. If a plan cannot be matched to a product, or a contract cannot be created after the customer confirms, SureBright reviews the order and it may appear in **Order Resolution**.

## What SureBright needs from you at setup

- The sender address (or addresses) your files will come from.
- The sheet names and column headers you use, so they can be matched to the fields above.
- The SKUs or product IDs of the plans you sell, so plan lines can be recognised.
- Your store's country and the name you want customers to see in the emails.

## Related

<CardGroup cols={2}>
  <Card title="Manual and draft orders" href="/manual-orders/overview">
    Other ways to sell a plan outside your storefront checkout.
  </Card>
  <Card title="Order Resolution" href="/merchant-portal/order-resolution">
    Where an order appears when it needs a decision from you.
  </Card>
</CardGroup>

**See also:** [Report sales made outside an integrated checkout](/platforms/other-platforms#report-sales-made-outside-an-integrated-checkout).
