My issue revolves around the way the suppliers are set up within the product pages. If I select Supplier "A" as the supplier for a specific product, the default supplier option is not automatically selected upon clicking Supplier "A" on the left hand side. I have a module that relies on the default supplier being selected, so obviously the module doesn't work because of this.
There doesn't appear to be a way to automatically set the selected supplier as the default without manually going into each product and checking the radio button next to the default supplier.
In my case where there is a website with nearly 4000 products, 99% of which have not had the default supplier selected - only the supplier being used, this is just a ridiculous task to consider.
Even after going in to the database it doesn't look as though the id_supplier is even recorded unless the supplier is selected as default. Where is the information for which supplier is connected to each product stored?
I need to try and create a query that references a specific supplier name, matches that to the supplier in the ps_supplier table, and then uses that information to pull a list of all products using that supplier within the ps_products table so that I can add the ID of the supplier to those specific products - therefore adding the supplier as the default one.