Not using inFlow Cloud to manage your inventory yet? Try a free 14 day trial

How do I export data or other transactions from inFlow Cloud?

View the inFlow On-Premise version of this article

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

41139804_1

To export 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 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:

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

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.

To export a report:

  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
andrewstiver
Archon Systems
w,
+1.866.923.4974
260 Carlaw Ave #397
Toronto, ON, M4M 3L1
Canada
February 13, 2019

Rate this article

Not enough ratings yet
1 star2 stars3 stars4 stars5 stars
Loading...
  • Did this article help? If not, please let us know so we can improve it.

  • This field is for validation purposes and should be left unchanged.