SQL

Using my Dolibarr
1

Hi again, community!

So I’ve now managed to painstakingly input about 150 products into my Dolibarr, but I’ve forgotten to define them all as raw materials and my immediate reaction was to try and find a console where I could use SQL to modify all of them to raw materials, obviously I have no idea if this is possible of not but it seems to me when I look around on forums I can see a lot of SQL snippets. Am I missing something or is this something that needs to be set up separately?

Thanks in advance for any replies :tongue:

2

Use phpMyAdmin to update the mySQL table in question. From your description of the problem it should be one field to mass-edit.

1 Like