Spreadsheet order intake

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.

Available on request. Ask your SureBright contact to enable this for your store.

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.

FieldRequiredNotes
Order numberyesGroups rows into an order and becomes the order reference on the contract.
Order datePurchase date of the order.
Customer first name, last name
Customer emailyesWhere the confirmation link and the coverage email are sent.
Customer phone
Address line 1, line 2, city, state, ZIP, countryPrinted on the contract. If address details are missing, the contract is put on hold; see Why a contract is on hold.
Product IDyesIdentifies the product or plan on the line and joins to the Product sheet.
Order line keyYour line identifier, kept on the contract.
Sale pricePrice paid for the line.
QuantityUnits on the line.
Discount amount

Columns on the Product sheet#

One row per product ID referenced by the Orders sheet.

FieldNotes
Product titleShown to the customer on the confirmation page; a second column can be named as a fallback when the first is blank.
Product SKU
List priceThe 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.

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.

Where the plans appear#

Contracts show under Recent Sales on the portal's 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.

See also: Report sales made outside an integrated checkout.