bulk deleting inventory and bulk delisting out-of-stock products

xcjy

New Feature Suggestion

The functions of bulk adding/deleting inventory and bulk delisting out-of-stock products would be very useful.
For example, if my website has 300 products, and each product has inventory in the US, Japan, and Australia, then adding three warehouses named US, JP, and AU to all products with one click would save a lot of work.
we also encounter scenarioAs where a batch of products are no longer produced and need to be delisted uniformly.

Check if there are any missing settings in the warehouse.
For example, my website has hundreds of products, each with multiple stocks, totaling over a thousand. Some might have missed crucial settings. I hope there's a way to directly check if settings are complete.
Like in the image, the
region setting was missed , causing the warehouse inventory to be unusable.Because I have hundreds of warehouses, I didn't notice that this wasn't set up correctly.

xcjy

have already slove problem about
about if there are any missing settings

SELECT
    ati.ID AS atum_inventory_id,
    ati.product_id AS atum_product_id,
    ppml.sku AS product_sku
FROM
    wp_atum_inventories ati
LEFT JOIN
    wp_atum_inventory_regions atir ON ati.ID = atir.inventory_id
LEFT JOIN
    wp_wc_product_meta_lookup ppml ON ati.product_id = ppml.product_id
WHERE
    atir.inventory_id IS NULL;

Salva

Hi xcjy

Good to know that you have figured out how to get inventory data from the database.
To perform an inventory removal in bulk, you have the batch endpoints in the ATUM REST API:

https://stockmanagementlabs.github.io/atum-rest-api-docs/#batch-update-product-inventories

Best Regards,
Salva.

xcjy

Salva Yes, I know how to do it, but it's not easy for those without a coding background. If ATUM could enrich these features, it would be even better, haha.

Salva

xcjy

I see. Thanks for your suggestion