How to delete orphaned inventory items.

MTG

I have some inventory records for which I know the ID product_id from the API but the product to which they were linked no longer exists. I want to delete them but I cannot find a way. I cannot find any way through the main ATUM interface to search and find such orphans. The API seems to require the product to exist in order to do anything with a linked inventory. How can I get rid of them?

Salva

Hi MTG

If the product no longer exists, you can browse your database through any DBMS like phpMyAdmin and find them in the wp_atum_inventories table and delete them.
Additionally, you should delete all their related meta from the wp_atum_inventory_meta

I hope this helps.

Best Regards,
Salva.

MTG

Salva Thank you, that did help. I eventually managed to use phpMYadmin to delete one such orphaned inventory record and also the meta record. However, unfortunately, I have other orphaned inventory records that do not show in these tables. I think these are inventory records that were once linked to variations rather than simple products. For instance, inventory record with ID 1177 has product_id 10010 but product_id 10010 does not exist in Woo.

GET https://mastersofchess.com/wp-json/wc/v3/products/10010/inventories/1177 works and responds with JSON for the inventory record.
But https://mastersofchess.com/wp-json/wc/v3/products/10010 responds with 404 - woocommerce_rest_product_invalid_id
and DELETE https://mastersofchess.com/wp-json/wc/v3/products/10010/inventories/1177 fails with 403 atum_mi_rest_cannot_delete "message": "Sorry, you are not allowed to delete this resource.",

In MyPHPAdmin, a search of the following two tables for 1177 or 10010 does not find anything. So I cannot just delete them like I did with the previous orphaned entry - there is nothing to delete.
clho_atum_inventories
clho_atum_inventory_meta
Search of clho_atum_product_data for 10010 also finds nothing.

It seems like it is impossible to delete these corrupted Inventory records.

thanks,

James

Salva

Hi MTG

However, unfortunately, I have other orphaned inventory records that do not show in these tables. I think these are inventory records that were once linked to variations rather than simple products. For instance, inventory record with ID 1177 has product_id 10010 but product_id 10010 does not exist in Woo

That makes no sense. ATUM only reads and writes inventory data from/to those tables.
If you have some cache or similar, perhaps it could cause something like this, I don't know.

Sadly, we cannot help here more than that, as this kind of "cleanup" job is out of the scope of our support service.
If you don't find the source, I'd suggest you find a developer to debug the issue and assist you with it.

Best Regards,
Salva.