---
title: "Bulk upload"
description: "Record many past sales from a CSV, or upload a scanned invoice and let the portal read the line items, then review before anything is saved."
---

Two shortcuts let you record sales without typing each one into [Record Sale](/pos/recording-a-sale): a CSV upload for a batch of past sales, and an invoice upload that reads a PDF or photo of a customer's receipt. Both end in a review step; nothing is saved until you confirm.

## Upload a CSV of sales

Use this when you have a spreadsheet of sales, for example from your till, and want plans recorded for all of them.

<Steps>
  <Step title="Prepare the file">
    Open the upload dialog from the **Record Sale** header and download the sample file (one for US sales, one for Canadian sales) and the **Sales Data Upload Guidelines** PDF. Keep the column headings exactly as in the sample. Save as `.csv`; other spreadsheet formats are rejected.
  </Step>
  <Step title="Upload">
    Click **Select file**, choose the CSV and click **Upload**. The portal checks every row.
  </Step>
  <Step title="Review">
    Rows are split into **Needs attention** (fix these to include the records in your reports) and **Ready to add** (these records will be added to your reports). Each row shows whether the product is **Eligible** or **Not Eligible** for a plan. Edit a cell inline to fix an error, assign the sale to a team member with **Select team member...**, or **Skip this item** to leave a row out.
  </Step>
  <Step title="Save or discard">
    **Confirm & Save** records the valid and fixed rows and shows a summary. Rows that could not be saved are listed with the reason. **Discard** throws the whole upload away.
  </Step>
</Steps>

### What to put in each column

| Column | What to put in it |
|---|---|
| **Sale date** | The date of the sale. |
| **Product**, **SKU/ Model number**, **Manufacturer Name** | The product sold. |
| **Manufacturer Warranty Duration** | In months. |
| **Product condition** | New, Used, Refurbished or Certified Refurbished. |
| **Product price** | What the customer paid for the product. |
| **Plan term**, **Coverage type**, **Plan Retail Price** | The plan sold, for example `3 Years`, `Accidental Damage Plan`, and the price the customer paid for it. |
| **Quantity** | Units sold. One plan is recorded per unit. |
| **Team Member** | The team member who made the sale. |
| **First name**, **Last name**, **Email Id**, **Phone Number** | The customer. |
| **Street Address**, **Address Line Two**, **City Name**, **State**, **Zip Code**, **Country** | The customer's address. |

Imported sales appear in [Sales History](/pos/sales-history) like any other sale, and the dashboard logs a **Bulk sales upload** activity.

## Upload a scanned invoice

Use this when a customer hands you a receipt or you have a PDF invoice: the portal reads it and turns the line items into a cart.

<Steps>
  <Step title="Upload the file">
    In **Record Sale**, use the invoice upload button and choose a PDF, PNG, JPG or WebP file. Other types are refused with **Unsupported file. Upload a PDF or image invoice.**
  </Step>
  <Step title="Wait for extraction">
    An **Extracting** screen follows progress while the invoice is read. Large invoices take a few extra seconds. If the file cannot be read, or reading takes too long, you are told to try again or enter the details manually.
  </Step>
  <Step title="Review invoice items">
    The **Review invoice items** step lists every line found, with the file name and **Purchased on** date at the top. Each row shows **Product**, **Price**, **Warranty plan** and **Status**. Under the product title, **Still needed:** names anything missing (**Condition**, **Manufacturer**, **Warranty**). Click **Edit product** to fill them in; a category is suggested automatically where possible.
  </Step>
  <Step title="Fix what is not eligible">
    A row that cannot carry a plan says why: the product is not eligible, no plan is available, or the price is outside the plan range. Adjust the price or quantity inline, pick a plan with **Select plan**, or remove the line. Every product needs a unique SKU. You can edit any detail until you submit.
  </Step>
  <Step title="Continue">
    Click **Next**. If your cart already has items, **Items already in your cart** asks whether to add to them. The reviewed lines join the cart and you continue to customer details as in [Recording a sale](/pos/recording-a-sale#step-2-enter-the-customers-details).
  </Step>
</Steps>

<Note>
Invoice upload records a single sale for one customer. For many sales at once, use the CSV upload above.
</Note>
