To delete all manufacturers we can advise to run the following query:

delete from va_manufacturers;

You may also need another query to update products. It is as follows:

update va_items set manufacturer_id=NULL;