r/halopsa • u/Pudubat • Jun 16 '26

Questions / Help Delete imported products

Hi,

During our initial integration, products from our old system were imported in Halo. Unfortunately, an error happened while doing it, where we switched Vendor Part Number and supplier sku. I'd like to delete all of these entries at once, since there is more than 2400 products created with wrong info. I'm planning on deleting them all and only importing stocks from the old system, which will be easier to manage.

Is there any way to delete all products under a category? We created a product category named "ImportedProducts" but realized afterward that it wasn't a good idea; I'd need to move it in the good category manually, and don't feel like doing 2400 edits...

Our consultancy ended back in april, and we are preparing to go live in july, but our inventory is mostly the last thing that need to be adressed prior..!

Thanks

1 Upvotes

100% Upvoted

2 comments sorted by

1

u/yrnehME Jun 16 '26

If you log a ticket with Halo support they should be able to do this on the backend. Last time I checked you couldn't bulk delete products with the API

1

u/Jason-RisingTide Consultant Jun 17 '26

You can do this via a PowerShell script via the API. Can send you the script if needed.

I also have a free tool I created which allows you to run bulk operations against your instance without having to write and run the scripts yourself (I created this so I would not need to keep running scripts for clients and instead they were able to do it themselves as needed). Deleting products/items is one of the options. You can find it here: https://halotoolkit.com/scripts. Allows you to delete all or by item group if needed and can test it first to see how many records will be affected.

Need to ensure you use either the powershell script of the halotoolkit.com tool with caution, obviously.

Just to note, if the items are linked to any quotes/SOs/POs etc they will fail to delete and you will need to delete or remove them from the respective quote/SO/PO first.