Create Multiple Orders using Spreadsheet Upload

First select the order type for which you wish to create orders. Only orders of the same type can be uploaded.

For this example we are creating Purchase Orders

• Select order type

• Next, click the "Import Orders" button

Orders can be imported using a template provided by Simple RFID, or you can use your own spreadsheet.

Import using Simple RFID Template

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.

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

• Click Import

Import Using Your Own Sheet

If the information for your orders already exists on a sheet you can use your own spreadsheet to create the orders. 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

• And clicking the "Import Orders" button

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

• 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

Import Orders view

We can see the two orders from our spreadsheet.

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"

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

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