Convert products into services

Using my Dolibarr PM modules
1

Hello,

I just started using Dolibarr and it’s great.

I started creating a list of products to realize later that I also could use services.
The list is quite long and I have invoices already running so I’m wondering if there is a why to convert products into services without having to delete products and recreate them into services. Thanks in advance.

2

Hi @Tiritibambix
In llx_product table

fk_product_type integer DEFAULT 0, – Type of product: 0 for regular product, 1 for service, 9 for other (used by external module)

So in theory updating from 0 to 1 will do the job.
If you use stock, wherehouses or other manufacturing related modules though there might be implications.
I suggest you backup first, test your changes and then move on with your work
Hope that helps

3

Thank you for you answer.

Forgive my ignorance but I found the page and the line but don’t know how to edit it.

Would you give me a hint ?

4

It has to be done manually for each product from PhpMyAdmin for example

2024-06-20_19-52
2024-06-20_19-521183×438 29.7 KB

5

I’ll try and learn how to setup phpmyadmin and connect it to my dolibarr db.
Thanks for the informations.

6

I simply used DbAdmin.
It was strajght forward and worked flawlessly.

Thanks for your help @sonikf