eadesgin/magento2-warehouses

Module to separate the stock on different store views based on warehouses.

magento2-warehouses's Issues

On Magento 2.1.7 after checkout decrease qty in all Locations

In Magento 2.1.7 after checkout i notice that product qty in all Stock Ids are decrease,
i need to decrease only actual store view stock qty.

Is this the standard behavior? Or I've missed something?

Thanks

Inventory per Store

How hard is to add the inventory level to Store Options instead of Store View.

Why????

Ex:
Website (currency) - Store (Warehouse) - Store View (language)
EURO - NETHERLANDS - EN
EURO - NETHERLANDS - FR
EURO - NETHERLANDS - SP
EURO - NETHERLANDS - PT
EURO - NETHERLANDS - IT

USD - US(NY) - EN

CAD - CAN(Toronto) - EN
CAD - CAN(Toronto) - FR

Magento 2.1.7 after add new product create only default stock

In Magento 2.1.7 after adding new product i can't create new entry in stock id.
It create only default stock qty and i can't add the others.

New instalation error

Magento 2.1.3

[Zend_Db_Statement_Exception] SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (magento2.warehouseinventory_stock_item, CONSTRAINT WAREHOUSEINV_STOCK_ITEM_STOCK_ID_WAREHOUSEINV_STOCK_STOCK_ID FOREIGN KEY (stock_id) REFERENCES warehouseinven
tory_stock (stock_id), query was: INSERT INTO warehouseinventory_stock_item () VALUES ()

this extension is conflicting with Magentos layered navigation.

When this module is enabled, magentos layered navigation is throwing the following erros.

2 exception(s):
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'color_filter.value' in 'where clause', query was: INSERT INTO `search_tmp_5ac383ed324023_32217399` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, (((0) + (0) + (0) + (0)) * 1) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index`
 LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id
 INNER JOIN `catalog_category_product_index` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1'
 LEFT JOIN `warehouseinventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (category_ids_index.category_id = 24) AND (color_filter.value = '59') AND (style_general_filter.value = '133')) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC
 LIMIT 10000
Exception #1 (PDOException): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'color_filter.value' in 'where clause'

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'color_filter.value' in 'where clause', query was: INSERT INTO `search_tmp_5ac383ed324023_32217399` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, (((0) + (0) + (0) + (0)) * 1) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index`
 LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id
 INNER JOIN `catalog_category_product_index` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1'
 LEFT JOIN `warehouseinventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (category_ids_index.category_id = 24) AND (color_filter.value = '59') AND (style_general_filter.value = '133')) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC
 LIMIT 10000

Error on adding warehouse

I get this error after i add a new warehouse

There was a problem saving the zoneSQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (magento2.warehouseinventory_stock_item, CONSTRAINT WAREHOUSEINV_STOCK_ITEM_STOCK_ID_WAREHOUSEINV_STOCK_STOCK_ID FOREIGN KEY (stock_id) REFERENCES warehouseinventory_stock (stock_id), query was: INSERT INTO warehouseinventory_stock_item () VALUES ()

Table stoc_status unchanged

When i save one product from another website with x qty the table stoc_status doesn't recognize this but the the stock_item table works fine and it's updated.

This extension does not work with configurable products

Hi I am using Magento 2.1.9 with a number of simple products and configurable products. The simple products are working absolutely fine, however the configurable product is constantly shown as out of stock and cannot be purchased. For an example. Please see the site https://rosita.weareblacklab.digital/our-products.html

there is no file system.xml

we are not able to see magento 2 warehouses module in magento2 admin side.