There are two ways to export data: exporting all records of the same type, or only certain records of your choice.
Exporting all data of the same type
To export all data of the same type:
- Go to Main Menu > General > Export Data
- Choose the type of data you’d like to export (Product Details, Sales Orders, Purchase Orders, Customers, etc.)
- Click Browse to choose where you’d like this file to be saved.
- Click Next.
For example, if you selected Product Details to export, this will create a file for all of your products in inFlow (excluding deactivated items). This file will contain information you can get from the product info page, like Price, Cost, Unit of Measure, Barcode etc.
Exporting only a selection of data
If you go to any one of the listing views (e.g. Sales Order List, Purchase Order List, Product List), you can filter that list to show only certain records. For example, let’s say you want to view and export all products under the “Misc.” category only, you can go to the product list and filter to show only “Misc.” category products, then export from there. See the GIF below for how to do this (various examples in different lists).
To export a selection of data:
- Go to the listing view of your choice (Sales Order list/ Purchase Order list/ Product list)
Filter this list to the information you want to view / export.
- Right-click on the header of the table.
- You can choose two options here:
Export contents to csv: This exports only the information in the columns that you are seeing in the list view.
Export these orders/products: This exports all information of the products regardless of what columns you have (e.g Barcode, Cost, Unit of Measure).
For example, the Cost information is not an available column in the Product List. If you are exporting a selection of products and you need to see the cost, you’ll need to click Export these products.
You can also export: Count Sheets, Stock Adjustments, Product Pricing Sheets, Customer Lists, Vendors Lists and Current Stock Lists
If you open up any one of our reports in inFlow, there is the option to save the report as a number of different file types. The default type is a standard PDF format, however you can also export the data directly to Excel.
To export a report:
- Generate one of inFlow’s many reports.
- Go to Save as in the action bar.
- Click Save as type and choose “CSV file” from the dropdown.
Data that can’t be exported
If you’re archiving your database, or would like to export as much information out of inFlow as possible, note the following:
- Work Orders can’t be exported – you can note down the details manually if you want to re-create them.
- It’s not possible to export Attachments and Pictures/Images
- Other than billing and shipping addresses, extra addresses can’t be exported.
- All settings in Personal, General and Print settings can’t be exported