eadesgin / magento2-warehouses Goto Github PK
View Code? Open in Web Editor NEWModule to separate the stock on different store views based on warehouses.
Home Page: https://www.eadesign.ro
License: Apache License 2.0
Module to separate the stock on different store views based on warehouses.
Home Page: https://www.eadesign.ro
License: Apache License 2.0
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
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
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.
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 ()
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
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 ()
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.
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
we are not able to see magento 2 warehouses module in magento2 admin side.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.