eadesgin / magento2-warehouses

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

Multi Location Inventory

Because the Magento community is currently https://github.com/magento-engcom/magento2/wiki/Technical-Vision.-Catalog-Inventory we nare not longer maintaining this module.

Magento 2 Warehouses Store View Inventory

Module can be used to separate the stock on different store views based on warehouses with grid for fast stock status editing.

How to use the module

At first only one zone/warehouse is created by default. You can check the newly created zone under the EaDesign menu.

• the default zone cannot be deleted or edited. This zone will will provide the stock status for all the store views that do not have a specific zone allocated;
• when you add a new zone all the items stock statues will be base on the default zone;
• when you delete a zone all the stock data will be deleted for that zone and your stock data will be handled by the default zone.
• when you add/delete zones you will need to re-index the stock to see the fronted values right away;

Installation.

You can install the module via composer or manually by adding it to the app/code directory. The module is available on packagist.org

Via composer

• composer config repositories.magento2-warehouses git [email protected]:EaDesgin/magento2-warehouses;
• sudo composer require eadesignro/module-warehouses;
• php bin/magento setup:upgrade;

Uninstall

You need to remove the module. If you added products in the time you used EaDesign Warehouses Store View Inventory you will need to import their stocks to create the stock data. Soon we will add a synchronization system for this.

#Video install and use

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

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.

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.

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

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

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 ()

there is no file system.xml

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

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 ()