Multi Inventory not working properly

Reah

Hello, I'm setting up our multi inventory. I should have 4 different MI. As seen on the screenshots, the view of the product in STOCK CENTRAL shows corectly, 4 MI, but in the product page, it only shows 3. When I exported this, 2 locations is_main value is '1' and I cannot change it by importing. Need help!

japiera

Hi Reah ,

Apologies for any inconvenience caused. That's very weird. There can't be more than one main inventory per product. Do you know how they were created? It shouldn't be possible from the User Interface.

Anyway, the only way to fix this is with SQL queries. Please take the ID of the inventory that you don't want to be the Main one and execute this from your hosting provider's database management tool:

UPDATE wp_atum_inventories SET is_main = 0 WHERE id = [your ID]

Please note that you should replace 'wp_' with your database's prefix.

Please tell us if that works.

Best Regards,
José Andrés