Purchase Orders > Importing Purchase Orders
User GuidePurchase OrdersImporting Purchase Orders
Importing Purchase Orders

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:

  1. In the Purchase Orders page, select Import.

    The Import Purchase Orders window is displayed.

  2. Scroll down the window to display the following sections.

    Note: To download the template of an import file, select Download file template.

  3. 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.
  4. 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.

  5. Select Next after selecting an import file or copying and pasting the purchase orders data.

  6. 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.
  7. Select Next.

  8. 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.

  9. 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.

  10. Select Done to close the import dialog.

Available Headers

HeaderRequired/OptionalDescriptionExample
numberRequiredPurchase order sequential number10
referenceOptionalArbitrary reference stringABC-123
dateOptionalOrder date2014-09-04T12:23:34Z
expected_atOptionalDate and time when transfer arrival is expected2014-09-04T12:23:34Z
tax_inclusive_pricesOptionalWhether prices include the tax or nottrue false
currencyOptionalCurrency codeUSD
from_supplierOptionalSupplier to deliver items fromMy Supplier
supplier_noteOptionalNote or instructions that will be visible to the supplier (as part of the purchase order email)Deliver to the back dock.
to_inventory_locationOptionalDestination inventory locationPrimary Location
draftOptionalWhether purchase order is in a draft state or nottrue false
send_emailOptionalWhether to send this PO to the supplier via email or not (when submitted)true false
shippingOptionalShipping price in the lowest currency unit24850
bill_to_nameOptionalThe name (billing address)Jimmy Smith
bill_to_address1OptionalMailing address (billing address)8912 Porter Trail
bill_to_address2OptionalThe additional line for the billing address (billing address)Level 5
bill_to_cityOptionalThe city (billing address)New York City
bill_to_companyOptionalThe company (billing address)Google LLC
bill_to_phoneOptionalThe phone number (billing address)1-(513)860-8147
bill_to_countryOptionalThe two-letter code for the country (billing address)US
bill_to_provinceOptionalThe two-letter code for the province or state (billing address)NY
bill_to_zipOptionalThe zip or postal code (billing address)10249
line_item_codeOptionalLine item code414110
line_item_costOptionalLine item cost5410
line_item_quantityOptionalAmount of items to order from the supplier100
line_item_receivedOptionalAmount of items received80
line_item_rejectedOptionalAmount of items which will not be received20
line_item_taxOptionalLine item tax (in percents)3.14
line_item_skuOptionalLine item SKU123-ABC
PREVIOUS
Receiving more items than expected
NEXT
Exporting Purchase Orders