Import historical order data to iCompleat in a single .csv file

If you're keen to make the move to full AP automation with iCompleat, the order import feature guarantees a seamless transition from your old AP system.

It lets you import your backlog of historical orders in bulk from a .csv file to iCompleat.

All your imported orders land in the Saved tray in Manage orders ready for processing. They can be edited, coded, and matched to an invoice when fully approved.

This guide shows you how to download and populate an Excel order template with your historical order data, and then import it to iCompleat.

1. Download the Excel template

The first step is to download an Excel template to populate with your historical order data. This saved template will become the .csv file that you import to iCompleat.

When you download the template, you can choose which iCompleat order layout the template will use. The fields on the order layout will appear as columns in the template.

Follow these steps to download and populate the template.

1. On the homepage, click Configuration.
2. Click Company.
3. Go to Ordering.
4. Next to Import purchase orders, click the edit button.
5. Select an order layout from the drop-down, and click Download.

   The Excel template reflects the fields and settings on the order layout you select. If you're importing orders that use different layouts, you need to download a separate Excel template for each layout.

   
6. Open the template from where your downloads are stored on your PC.
7. When the template opens, click Enable Editing in the yellow banner at top.
8. Populate the Header tab with the header information for each order you're importing.

   Each line on the spreadsheet represents one order. The characters you enter in the Order Reference column will become the requisition or order number in iCompleat.

9. Populate the Line tab with line information for all the orders you're importing.

   Each line on the spreadsheet represents one line from an order. The characters you enter in the Order reference column will become the requisition or order number in iCompleat.

10. Save the spreadsheet to your PC.

2. Import the orders and process them

1. In iCompleat, go to the order import configuration area again, and then go to the Upload tab.
2. Drag and drop your saved .csv file into the upload area, or click the area to search for the file on your computer and upload it.
3. A message appears confirming your file is uploaded. 
4. Go to the Saved tray.

   All imported orders have the title Manual import order, and can be processed as normal.

 Still got questions? Comment below and let us know how we can improve this article.