Common searched topics: Manufacturing, Label printing, Sales order
Browse features guide
Managing products
Imports, exports & integrations
Sales
Stock level reports
Purchasing
inFlow settings
Imports, exports & integrations
  • Exporting
Export data

How to export data or reports from inFlow

Web

There are two ways to export data: exporting all records of the same type or only certain records of your choice.

What can be exported from inFlow?

  • Product details
  • Stock levels
  • Sales orders
  • Purchase orders
  • Language
  • Bill of materials
  • Reorder settings
  • Product images

Exporting all data of the same type

To export all data of the same type:

  1. Go to Main Menu > Export Data
  2. Choose the type of data you’d like to export (Product Details, Stock levels, Customers, Vendors, Sales orders, or Purchase orders)
  3. Click Export.
  4. A Save as window will open for you to save your CSV file to your computer. Click Save once you’ve found a location to save your export file too.
  5. When done, you will see a message on your screen saying, “Your exported products are ready!

For example, if you select 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 reports

If you open up any one of our reports in the inFlow web app, there is the option to save the report as either a PDF file or a CSV file. The default type is a standard PDF format. However, you can also export the data directly to Excel.

To export a report:

  1. Generate one of inFlow’s many reports.
  2. At the top right side of the screen, click Save.
  3. Select your preferred file type.
  4. The file is then instantly saved to your computer.

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 (product images can be exported.)
  • Other than billing and shipping addresses, extra addresses can’t be exported.
  • All settings in Personal, General, and Print settings can’t be exported.

Windows

There are two ways to export data: exporting all records of the same type or only certain records of your choice.

What can be exported from inFlow?

  • Product details
  • Stock levels
  • Sales orders
  • Purchase orders
  • Language
  • Bill of materials
  • Reorder settings
  • Product images

Exporting all data of the same type

  1. Go to Main Menu > General > Export Data
  2. Choose the type of data you’d like to export (Product Details, Sales Orders, Purchase Orders, Customers, etc.)
  3. Click Browse to choose where you’d like this file to be saved.
  4. Click Export.

For example, if you select Product Details to export, this will create a file for all of your products in inFlow (excluding deactivated products). This file will contain information you can get from the product info page, like Price, Cost, Unit of Measure, Barcode, SKU, 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 the “Misc.” category products, then export from there. See the GIF below for how to do this (various examples in different lists).

  1. 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.
  2. Right-click on the header of the table.
  3. 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 about 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.

41139804_2

You can also export: Count Sheets, Stock Adjustments, Product Pricing Sheets, Customer Lists, Vendors Lists, and Current Stock Lists

Exporting reports

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.

  1. Generate one of inFlow’s many reports.
  2. Go to Save as in the action bar.
  3. Click Save as type and choose “CSV file” from the dropdown.
  4. Save!

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
Was this guide helpful?
Yes, thanks!
Not really
Thank you for your input, your feedback is important to us!

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

In this tab
  • What can be exported from inFlow?
  • Exporting all data of the same type
  • Exporting reports
  • Data that can't be exported
  • What can be exported from inFlow?
  • Exporting all data of the same type
  • Exporting only a selection of data
  • Exporting reports
  • Data that can't be exported

A complete guide on how to set up inFlow.

Get advice and answers from the inFlow Support team