How Can I Quickly Deactivate Multiple Products?

Not using inFlow On-Premise?

Looking to clean up products that are no longer stocked? Changing vendors and need to archive a whole brand? inFlow can’t can’t update more than one item at a time but here’s a little trick you can use to deactivate many items at once.

First, you’ll need to select which items you want deactivate and export them to Excel.

To Export 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 products you’d like to deactivate to a CSV file, you’ll need to make some changes to it in Excel so that you can update your products en masse.

  1. Open up the .csv file you created above.
  2. Choose the first Blank Column on the right hand side and  type in “IsActive” as the column header.
  3. For each product you want to deactivate, add “FALSE” to the ‘IsActive’ column.


     4. Click File > Save As  and select file type “CSV – Comma Delimited” at the bottom of the window to save your import file.

Import your new file into inFlow!

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

inFlow will update your products using the data from your csv file. Once the import is complete, a window will pop up showing that it was successful.

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

Peter
Archon Systems
w,
+1.866.923.4974
260 Carlaw Ave #397
Toronto, ON, M4M 3L1
Canada
September 11, 2018

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.