# Create Multiple Orders using Spreadsheet Upload

<p class="callout info">First select the order type for which you wish to create orders. Only orders of the same type can be uploaded.</p>

<span style="white-space: pre-wrap;">For this example we are creating </span>****Purchase Orders****

- Select order type

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2025-06/scaled-1680-/image.png)](https://kb.simplerfid.com/uploads/images/gallery/2025-06/image.png)

- Next, click the "Import Orders" button

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2025-06/scaled-1680-/6Sbimage.png)](https://kb.simplerfid.com/uploads/images/gallery/2025-06/6Sbimage.png)

<span style="white-space: pre-wrap;">Orders can be imported using a template provided by Simple RFID, or you can use your own spreadsheet. </span>

---

##### ****Import using Simple RFID Template****

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2025-06/scaled-1680-/FM3image.png)](https://kb.simplerfid.com/uploads/images/gallery/2025-06/FM3image.png)

The sheet contains:

- ****Order Number (required)****
- ****Origin (required)****
- ****Destination (required)****
- ****SKU (required)****
- ****Quantity (required)****
- Lot Number
- Exp Date
- cost
- Born Date
- Serial Number
- Sell By Date

Input details for the sheet.

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2025-06/scaled-1680-/G8qimage.png)](https://kb.simplerfid.com/uploads/images/gallery/2025-06/G8qimage.png)

- Click the "+ Choose" button
- Locate your file on your computer

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2025-06/scaled-1680-/NYjimage.png)](https://kb.simplerfid.com/uploads/images/gallery/2025-06/NYjimage.png)

- Click Import

##### ****Import Using Your Own Sheet****

<span style="white-space: pre-wrap;">If the information for your orders already exists on a sheet you can use your own spreadsheet to create the orders. </span>****It's critical that the sheet contain all required fields:****

- ****Order Number (required)****
- ****Origin (required)****
- ****Destination (required)****
- ****SKU (required)****
- ****Quantity (required)****

After selecting the order type

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2025-06/scaled-1680-/image.png)](https://kb.simplerfid.com/uploads/images/gallery/2025-06/image.png)

- And clicking the "Import Orders" button

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2025-06/scaled-1680-/6Sbimage.png)](https://kb.simplerfid.com/uploads/images/gallery/2025-06/6Sbimage.png)

- Click the "+ Choose" button
- Locate your file on your computer

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2025-06/scaled-1680-/NYjimage.png)](https://kb.simplerfid.com/uploads/images/gallery/2025-06/NYjimage.png)

- Next, click on the "The Custom Template Details" button to expose the field mapping
- Choose whether you wish to map by Title (such as SKU, Quantity, etc.), or if you wish to map by Index (Column Headers A, B, C)
- Choose the related Simple RFID field
- Click Import

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2025-06/scaled-1680-/vV9image.png)](https://kb.simplerfid.com/uploads/images/gallery/2025-06/vV9image.png)

---

##### ****Import Orders view****

<span style="white-space: pre-wrap;">We can see the two orders from our spreadsheet. </span>

Any validation errors must be resolves before the orders can be saved. For our example we wrote "Warehouse" on our spreadsheet, however the location is named "Warehouse Location"

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2025-06/scaled-1680-/97Himage.png)](https://kb.simplerfid.com/uploads/images/gallery/2025-06/97Himage.png)

- Once the validation error has been resolved, click the Save button

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2025-06/scaled-1680-/hgVimage.png)](https://kb.simplerfid.com/uploads/images/gallery/2025-06/hgVimage.png)

Our orders have now been created and are in Receiving status, able to be printed and received.

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2025-06/scaled-1680-/YmPimage.png)](https://kb.simplerfid.com/uploads/images/gallery/2025-06/YmPimage.png)

#####   