How do I bulk remove products from multiple categories?

If you have previously assigned your products to multiple product categories, you can remove them from those additional categories in bulk using the process outlined below.

  • Log in to the Onsight web console at https://web.onsightapp.com.
  • Click on ‘Catalogue’ from the left-hand side menu.
  • Click on the ‘Manage Products’ menu item.
  • Click on the ‘Action’ button at the top of the screen and then click on ‘Import Product Hierarchy’.
  • This will open up the 4-step bulk upload tool.

Step 1: Download the product hierarchy data sheet

The excel sheet displays all your products in alphabetical order and displays the category tree that they fall within. Product Category 1 displays the top category, and Product Categories 2 to 10 are for any sub-categories that the product falls within.

Step 2: Edit the datasheet

If you want to remove a product from an additional category, you must keep the row that says ‘Is Primary’ is ‘Yes’ and then remove the row where ‘Is Primary’ is ‘No’. This will remove that product from the additional category. You can remove as many additional categories (rows) as you wish. However, if you remove all the rows relating to this product, nothing will change. You must keep the main row where ‘Is Primary’ is ‘Yes’ for the deletions to be processed.

Step 3: Upload the data sheet

Save your file. Then select its location on your computer, and upload it to Onsight for processing.

Step 4: Import the data

Once you click the “Import” button your spreadsheet will be analysed and validated.

If your spreadsheet passes validation you will be shown a list of updates that will happen once you approve the import job, and you will be able to approve it so that the datasheet is actually processed and your product information imported. If the spreadsheet fails, you will be shown a list of errors to rectify before uploading it all again. If everything is OK – hit “Approve Job” and all your information will be imported into the database.

Check on your import jobs

To see the status of all your import jobs, go to Setup > Import Jobs and you will see them all listed.

 

 

 
Related articles:
How to add a single product to multiple categories
How to bulk allocate products to multiple categories

Back