Export Purchase Orders

Via the overview screen of purchase orders, you can export purchase orders. You do this by choosing the import/export icon at the top of the list (). Then click on 'export orders' and a CSV file will download.

CSV File

The following data is exported:

  • Company name (own store)
  • Order number
  • Supplier reference
  • Status
  • Creation date
  • Delivered?
  • Delivery note
  • Comments
  • Supplier: Supplier number
  • Supplier: Name
  • Supplier: Contact
  • Supplier: Email
  • Supplier: Phone number
  • Supplier: VAT number
  • Supplier: Address line 1
  • Supplier: Address line 2
  • Supplier: Postcode
  • Supplier: Municipality
  • Supplier: Province
  • Supplier: Country
  • Tracking number
  • SKU
  • Comments
  • Quantity

Export purchase orders

?> Tip Do you want to export the overview of two different statuses (for example, 'in transit' and 'complete')? Then you need to export the entire list and create a filter on the column 'status' in the export file.

Making CSV File Readable

The export will place all data in one column. To make the file readable, convert the file to a classic Excel spreadsheet. You can do this in the following ways:

  • In the CSV file, click on 'data' and then on 'text to columns'. Important here is that you set the delimiter to a comma.
  • In the csv file, click on 'data' and then on 'from text/csv'. You select the csv file to convert and check the delimiter.
  • You use an online conversion tool to convert the csv file into a readable Excel file.