You can add purchase orders in batches through the import process. The import process involves one of the following:
- Using an import file that contains all the purchase orders and their details. Import files can be in .csv or .txt formats.
- Copying the products and product details into the app.
To import purchase orders, follow these steps:
-
In the Purchase Orders page, select Import.
The Import Purchase Orders window is displayed.
-
Scroll down the window to display the following sections.
Note: To download the template of an import file, select Download file template.
-
If an import file is available, do one of the following:
- Drag and then drop the file to the boxed section on the window.
- Click the boxed section to browse for and then select the import file.
-
If you prefer to copy and then paste the purchase orders and their details, select the Copy and paste option to display the text field.
-
Select Next after selecting an import file or copying and pasting the purchase orders data.
-
Configure the Override Existing Data setting:
- Override existing purchase orders – replaces existing purchase orders if found to be the same with the imported purchase orders. Two purchase orders are the same if they are using the same purchase order number.
-
Select Next.
-
Map your data headers to the available headers. The app will attempt to automatically match them, however, be sure to verify each header is correctly matched by using the preview. When complete, select Next.
-
To start uploading and processing your data, select Next.
Depending on the size of the data file your import might take some time to process. You can safely close the dialog without interrupting the import process.
-
Select Done to close the import dialog.
Available Headers
Header | Required/Optional | Description | Example |
---|---|---|---|
number | Required | Purchase order sequential number | 10 |
reference | Optional | Arbitrary reference string | ABC-123 |
date | Optional | Order date | 2014-09-04T12:23:34Z |
expected_at | Optional | Date and time when transfer arrival is expected | 2014-09-04T12:23:34Z |
tax_inclusive_prices | Optional | Whether prices include the tax or not | true false |
currency | Optional | Currency code | USD |
from_supplier | Optional | Supplier to deliver items from | My Supplier |
supplier_note | Optional | Note or instructions that will be visible to the supplier (as part of the purchase order email) | Deliver to the back dock. |
to_inventory_location | Optional | Destination inventory location | Primary Location |
draft | Optional | Whether purchase order is in a draft state or not | true false |
send_email | Optional | Whether to send this PO to the supplier via email or not (when submitted) | true false |
shipping | Optional | Shipping price in the lowest currency unit | 24850 |
bill_to_name | Optional | The name (billing address) | Jimmy Smith |
bill_to_address1 | Optional | Mailing address (billing address) | 8912 Porter Trail |
bill_to_address2 | Optional | The additional line for the billing address (billing address) | Level 5 |
bill_to_city | Optional | The city (billing address) | New York City |
bill_to_company | Optional | The company (billing address) | Google LLC |
bill_to_phone | Optional | The phone number (billing address) | 1-(513)860-8147 |
bill_to_country | Optional | The two-letter code for the country (billing address) | US |
bill_to_province | Optional | The two-letter code for the province or state (billing address) | NY |
bill_to_zip | Optional | The zip or postal code (billing address) | 10249 |
line_item_code | Optional | Line item code | 414110 |
line_item_cost | Optional | Line item cost | 5410 |
line_item_quantity | Optional | Amount of items to order from the supplier | 100 |
line_item_received | Optional | Amount of items received | 80 |
line_item_rejected | Optional | Amount of items which will not be received | 20 |
line_item_tax | Optional | Line item tax (in percents) | 3.14 |
line_item_sku | Optional | Line item SKU | 123-ABC |