How to update your products with CSV imports to inFlow On-Premise

Please note: we will sunset inFlow On-Premise on July 31, 2024. After sunset we will stop selling or activating new licenses for inFlow On-Premise and stop providing support (including online KB articles).

In the meantime we will still provide technical support to customers with an active Support Plan.

When getting started in inFlow you might find that you’ll be filling out your product information as you go. You can always able to make updates to product records directly, but if you’d like to make changes in bulk, then re-importing your product details to inFlow is the quickest way. This can be done in 3 steps

  1. Exporting from inFlow.
  2. Editing the CSV.
  3. Re-importing to inFlow.

Before you start

Back up your database before you start the import process. This gives you the option to revert your data back to as it was before the import. For more on backing up and restoring your database see here.

Step 1 – Exporting from inFlow

  1. Go to Main Menu >General > Export data.
  2. Select Product Details from the Data type section drop down menu. (This file will contain information you can get from the product info page, like Price, Cost, Unit of Measure, Barcode etc.)
  3. Click Browse to choose where you’d like this file to be saved.
  4. Click Export.

Step 2 – Editing the CSV 

  1. Open the csv that was exported from inFlow.
  2. Find the columns where you want to make changes.
  3. Save the csv file.

Step 3 – Re-import to inFlow

  1. Go to Main Menu > General > Import data.
  2. In the Data type drop down menu select Product details.
  3. Click Browse to locate the CSV from your computer.
  4. Click Next.
  5. Match the fields to the left (inFlow fields), to the fields in the drop-downs (the CSV fields.  Example: Match the Barcode inFlow field with the Barcode field in the drop down menu)
  6. Click Import when the fields you want to update all match. 

From here the import will run. When it’s complete you will see a message on the import screen mentioning how many lines have been updated. Each line item represents each line on the product details csv.

Kerisha Caines
Archon Systems
w,
+1.866.923.4974
260 Carlaw Ave #397
Toronto, ON, M4M 3L1
Canada
June 17, 2020

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.