search

macopedia / magmi-m2

Magmi GitHub, see branch magento2 for a version compatible with Magento 2
113 stars 53 forks source link

problem with quantities #49

Open gandrap opened 5 years ago

gandrap commented 5 years ago

// Provide a general summary of the issue in the Title above

Preconditions

// Magento 2.3.2

Steps to reproduce

Simple test csv with sku, name and qty

Actual result

  1. Product is not visible on frontend, Problem is I think with salable quantity, because that field is empty. image

After editing anything in that product and saving, salable quantity is not empty anymore and product is visible on frontend image

This is happening only with new products.

nilesh111091 commented 4 years ago

Same problem with Magento 2.3.4 found for new products. For me, new products are added but Salable Quantity and Quantity per Source are not populating their field and stays blank even after updating only inventory with SKU's and qty fields.

Also on edit page of product we can not see salable quatity input box. I think Magmi only support 2.1.x.

How to troublshoot this issue ?

Henrik41 commented 1 year ago

Same with me. I had to modify the database as such:

INSERT IGNORE 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)));

Reindex and flush

This needs to be resolve for Magento 2.4.5