How to Import Purchase Orders via file [Step-by-step guide]

You can import Purchase Orders into techOMS using a CSV file. This article explains how to download, prepare, and manually import the file.

This article is divided into the following sections:

1. Downloading the Canonical File
2. Importing the File
3. Reviewing the Results & Handling Errors

NOTE: Make sure that you are operating at the right Vendor/Warehouse beforehand.

WARNING: The maximum number of records per file is 10,000. Exceeding this limit will cause data consistency issues.

 

NOTE: The file's supported delimiters are comma, semicolon and tabulation, and quotation marks the supported character is ".

 

I. DOWNLOADING THE CANONICAL FILE

To import orders, you first need the canonical CSV template.  You can obtain it in two ways: 

• From techOMS Canonical Import Files [Information].
• From the Import Orders dialog explained in Step 4 below.
  

The template includes filled-out examples. Follow the structure exactly and replace the sample data with your own. You can use any program to edit the file as long as it does not alter its format.

Once the file is ready, proceed to the import steps.

II. IMPORTING THE FILE

To import Purchase Orders via CSV file:

1. Click Purchase Orders from the left menu under the Purchases section.

2. Press Actions.

3. Click Import Orders.

4. Click Files and select your CSV file.

NOTE: If you don’t have a prepared file yet, press Download Template, fill it out, and repeat this step.

5. Press Import.

The next section explains how to review the import results.

III. REVIEWING THE RESULTS & HANDLING ERRORS

Once the import file is processed, a summary message will appear.

If any lines failed to import, the summary message will contain a link: "Click here to download line(s) with Errors". Click this link to download a CSV file with a detailed report of the import process.

The file is a copy of your original upload, with two extra columns added at the end: 

• Message Status: Indicates the result for the specific line. 
• Message Text: Provides a specific reason for the error, if any. (e.g., "Serial number '1' already exists").

NOTE: Use this file to identify which lines failed. Fix only the lines with errors in your original file, then re-upload the corrected lines. Do not edit or upload the error file, since its structure differs from the expected format.