How to change group code for multiple items (products, Inventory or Recipes) at once

V5 Question
1

How to change group code for multiple items (products, Inventory or Recipes) at once

After using the software for 2 years, I decided to re-organize the list of Product Items, Inventory Items and Recipes to be easier to edit and track

The only way I can do that is by going through each and every single item in the program and change it one by one :tired_face: which are in hundreds

I have been searching through the forum for so long looking for a way to change the Group Code for multiple items at once, but with no luck. so I posted this request

Please I need your support in this matter

Regards

2

You would need to use SQL and update the tables for them.

3

It’s a little risky. I advise you to be careful and take backup

4

@Jesse
Is there a tutorial for this ?

5

No and unlikely to be, direct SQL updates can easily screw up things badly so not the kind of think that would be left open on forum where they could be misused and cause more issues that solves.