Looking to clean up products that are no longer stocked? Changing vendors and needing to archive a whole brand? With inFlow, you can use imports to deactivate many items at once.

Web

Export from inFlow

1. Go to Main Menu > Export data.
2. Select Product Details from the Data type section.  This file will contain information you can get from the product info page, like Price, Cost, Unit of Measure, Barcode, etc.
3. When your csv is ready, a window will pop up asking you where you want to save the csv file. Then click Save.

Edit the CSV 

1. Open the CSV that was exported from inFlow Inventory.
2. Scroll to the last column called IsActive.
3. Enter FALSE in the product rows you want to deactivate.
4. Save the CSV file.

Import the CSV to inFlow

1. Go to Main Menu > Import data.
2. In the Data type drop-down menu, select Product details.
3. Below select CSV file from your computer. Click Next.
4. A preview of your product details will appear. If you can’t see any fields below, select Edit Data Mapping.
5. Match the IsActive inFlow field to the IsActive field in the drop-down menu.
6. Click Import.

From here, the import will run in the background. You’ll be emailed when the import is complete.  When it’s done, you will see a message mentioning how many lines have been updated. Each line item represents each line on the product details CSV.

That’s it! Now that these products are deactivated, they won’t appear in searches in inFlow. If you ever need to find them again for any reason, follow the steps here.

Windows

Exporting a selection of data

1. Go into the Main Menu > Inventory > Product List to pull up a list of all your products
2. Use the Search Filters in the top right corner to Narrow down your List to the Products you want to deactivate
3. Right-click on the header of the table.
4. Choose Export contents to CSV

To Deactivate the section of data:

Now that you’ve exported the selection you need as a CSV file, it’s time to make the changes in Excel. Editing multiple lines at once will allow you to re-import the edited file and change all of the products in question in one action.

Edit the CSV

1. Open up the .csv file you created above.
2. Choose the first Blank Column on the right-hand side, and in the first row, write “IsActive”
3. For each product you want to deactivate, add “FALSE” to the ‘IsActive’ column.
4. Click Save As > select file type “CSV – Comma Delimited” at the bottom of the window.

Import the CSV to inFlow

1. Click Main Menu  > General > Import Data.
2. Select Product Details as the data type from the menu
3. Click the Browse button and choose the file you created above.
4. In this screen, match the inFlow field name on the left to the correct column in your file by choosing it from the drop-down list (see screenshot below).
5. Match up the IsActive import field to your newly made column in Excel.

inFlow will import the data from the CSV file and update the products that have changed. Once the import is done, you’ll be emailed the results.

That’s it! Now that these products are deactivated, they won’t appear in searches in inFlow. If you ever need to find them again for any reason, follow the steps here.