How to update your products with CSV imports
When getting started in inFlow, you might find that you’ll be filling out your product information as you go. You can also update your products in bulk at any time! See below for complete details.
Web
You can update your product records one by one, but if you’d like to make changes in bulk, then re-importing your product details to inFlow is the quickest way to do that. This can be done in 3 steps.
- Exporting from inFlow.
- Editing the CSV.
- Re-importing to inFlow.
Step 1 – Exporting from inFlow
- Go to Main Menu > Export data.
- Select Product Details from the Data type section.
- When your csv is ready, a window will pop up asking you where you want to save the csv file. Then click Save.
Step 2 – Editing the CSV
- Open the CSV that was exported from inFlow Inventory.
- Find the columns where you want to make changes.
- Save the CSV file.
Step 3 – Re-import to inFlow
- Go to Main Menu > Import data.
- In the Data type drop-down menu, select Product details. Click Select file to upload your CSV to inFlow, then click Next.
- A preview of your product details will appear. If you would like to edit the way the fields are mapped from your spreadsheet, click Edit Data Mapping.
- You can then match the fields to the left (inFlow fields) with the fields in the drop-downs (the CSV fields. Example: Match the Barcode inFlow field with the Barcode field in the drop-down menu)
- Click Next when the fields you want to update match.
From here, the import will run in the background, and later, you’ll be emailed when the import is complete. When it’s complete, you will see a message mentioning how many lines have been updated. Each line item represents each line on the product details CSV.
Updating products by CSV webinar
Check out this webinar for complete steps on updating products with a CSV.
Windows
You can update your product records one by one, but if you’d like to make changes in bulk, then re-importing your product details to inFlow is the quickest way to do that. This can be done in 3 steps
- Exporting from inFlow.
- Editing the CSV.
- Re-importing to inFlow.
Step 1 – Exporting from inFlow
- Go to Main Menu >General > Export data.
- 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.)
- Click Browse to choose where you’d like this file to be saved.
- Click Export.
Step 2 – Editing the CSV
- Open the CSV that was exported from inFlow Inventory.
- Find the columns where you want to make changes.
- Save the CSV file.
Step 3 – Re-import to inFlow
- Go to Main Menu > General > Import data.
- In the Data type drop-down menu, select Product details.
- Click Browse to locate the CSV from your computer.
- Click Next.
- 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)
- Click Import when the fields you want to update all match.
From here, the import will run in the background, and later, you’ll be emailed when the import is complete. When it’s complete, you will see a message mentioning how many lines have been updated. Each line item represents each line on the product details CSV.
Updating products by CSV webinar
Check out this webinar for complete steps on updating products with a CSV.
0 Comments