I have tried to import product CSV file using a magmi but somehow it's not assigned Default stock value. For that, I need to re-save the product from admin then after it will add into the cart.

I have also tried to add quantity, is_in_stock column in CSV file but it's not working.

have any idea, please share.

enter image description here


1 Answer 1


Run Below SQL:

    Insert into `inventory_source_item` (source_code, sku, quantity, status)
    Select 'default', sku, qty, stock_status from (`cataloginventory_stock_status` as `lg` join `catalog_product_entity` as `prd`
    on ((`lg`.`product_id` = `prd`.`entity_id`))) ON DUPLICATE KEY UPDATE quantity = VALUES(quantity), status = VALUES(status);

    UPDATE `inventory_source_item` SET `status`=0 WHERE `quantity`<=0;

    UPDATE `inventory_source_item` SET `status`=1 WHERE `quantity` > 0;

use_config_manage_stock = '1';

manage_stock = '1';

is_in_stock = 1

quantity = 100

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.