How do I change product categories in bulk?

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.

To update the Category field on multiple products at once, you can use a Product Details import.

The quickest way to do this is to export your current products into a spreadsheet first:

  1. Go to the Main Menu > Inventory > Product List. You can use this screen to export all of your products, or you can filter for specific products only.
  2. To export your product list, right-click on the column header and select Export Contents to CSV and save the file to your computer.
  3. Open the resulting file in Excel and update the Category column with your new product categories.

  4. Save the file as a .CSV file type (click Save As and select “.csv (comma delimited)” from the “Save as type:” drop down).
  5. Click Save (Excel will warn you about the loss of formatting, this is not a problem, please click Yes to complete your save).

Once you have your updated import file, all you need to do is import it into inFlow!

  1. Click Main Menu  > General > Import Data.
  2. Select Product Details as the data type at the top of the screen.
  3. Click the Browse button to select your import file and click Next.
  4. In the following screen, match the inFlow field Item Name/Code and Category to the correct column in your file (Item and Category) by selecting them from the drop down list (see screenshot below).
  5. Once you’re satisfied with your matches, click Next.


That’s it! Your product categories will now be updated with those from your import file.

For steps on how to import other types of data into inFlow On-Premise, have a look at our import guide here.

danielakrapivnik
Archon Systems
w,
+1.866.923.4974
260 Carlaw Ave #397
Toronto, ON, M4M 3L1
Canada
January 2, 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.