All Questions

Filter by
Sorted by
Tagged with
0
votes
2answers
12 views

Magento 2 : We cant place the order : SQLSTATE[HY000]: General error: 1449 The user specified as a definer your_db_user@% does not exist

I have migrated a Magento 2 site to a new server and getting the below error when placing order We cant place the order : SQLSTATE[HY000]: General error: 1449 The user specified as a definer ...
0
votes
0answers
64 views

SQLSTATE[42000]: Syntax error or access violation: 1235 This version of MySQL doesn't yet support Magento 2

I am facing below error while run setup upgrade commands. SQLSTATE[42000]: Syntax error or access violation: 1235 This version of MySQL doesn't yet support 'multiple triggers with the same action ...
0
votes
4answers
206 views

Magento 2.3 - How to fetch stock statuses of all the stores

I need to fetch the stock status (In Stock/Out of Stock) of all the stores for the single product. I have configured MSI. Lets say am in store1. In product view page I should be able to get the stock ...
2
votes
1answer
50 views

How to disable/enable backorder for particular website/store?

I want to enable/disable backorder from one of the available websites. How can I implement it?
0
votes
1answer
342 views

How to show “out of stock” child products for configurable product in list and product view page magento 2?

I am trying to show out of stock child products for configurable product in details and product view.I changed the settings from catalog inventory to display out of stock products even it is not ...
2
votes
3answers
879 views

Store level Inventory for individual product Magento 2.2.0

Is there any way that have enable Store level Inventory. Its not about user config Inventory at Catalog > Inventory Its about Admin >> Catalog >> Product >> Open product which you want to ...
1
vote
1answer
716 views

Magento 2 How to set product minimum quantity selected to minimum qty configured in the Advanced Inventory product level

If 5 is the minimum Qty on Advanced Inventory product level for a product then in Product detail page it should as 5 default selected. How can I achieve this.
0
votes
1answer
32 views

Magento 1.9.3.8 Execute only when there is a change for the Stock Level

I have got a custom extension, to track stock movements. So, keep a record of when x amount stock is added for a given product and/or when x amount of stock is removed. However, Even if I don't edit ...
0
votes
1answer
455 views

What is the usage of itemId inside Update inventory REST API?

According to the swagger, the REST API PUT /V1/products/{productSku}/stockItems/{itemId} is used to update the product inventory. However, for the attribute value itemId, I found no differences no ...
1
vote
1answer
205 views

Is there any observer like 'cataloginventory_stock_item_save_commit_after' in magento 2?

I need to trigger the inventory changes in Magento 2.0 I have an observer cataloginventory_stock_item_save_commit_after in Magento 1.9 and its working fine. But I can't find the same observer in ...
2
votes
1answer
496 views

Magento 2: Remove 'low stock' label from product image

I created a product and set 'Manage Stock' to no. But when i see a product on frontend, it shows a label 'Low Stock' on product thumbnail image. I do not want to show that label. I think there is an ...
2
votes
2answers
2k views

Magento 2 Rest Api V1/products missing extension attributes

I am calling the Rest API V1/products to get the product list from Magento 2 store Request: http://{myMagentohost}/Magento/index.php/rest/V1/products?searchCriteria[currentPage]=1&...
0
votes
1answer
98 views

The catalog inventory stock item unique hase changed

I am working on a new Magento 2.1.4 projet. We have a single store. And we need to manage the inventory for a large amount of shops belonging to this store. I was thinking about using the ...
0
votes
1answer
584 views

Show Empty Categories on Catalog Page - Magento 2

I want to show all categories, even if they have no products in them. How can I achieve something like this?
1
vote
0answers
167 views

Magento2: Updating products with CSV duplicates product_id in cataloginventory_stock_item

Any ideas why Magento 2 creates duplicate product_id into cataloginventory_stock_item table for each product that I try to update via import functionality? Thanks.
1
vote
1answer
2k views

Notify for Quantity Below in Magento 2

I have a requirements to notify the admin through email when a product quantity goes below 5 in Magento 2.0.7. I have found that there is option on the admin: System > Configuration > Catalog > ...
0
votes
0answers
520 views

Get CatalogInventory stock collection in Observer

I need, on website save, get the inventory with the current website ID. Ad I'm trying to get the CatalogInventory Stock Collection in an Observer, but it finish with the error: Configuration array ...
1
vote
4answers
8k views

Magento 2 - How to set a maximum order qty of individual products?

I am trying to figure out how to set the maximum qty allowed in a shopping cart for an individual product. In my case: Most products can be added to the cart as many times as they want, but I have a ...
2
votes
1answer
351 views

Why are there 3 identical tables in Magento2?

We came across three absolutely identical in structure tables in M2 DB: cataloginventory_stock_status cataloginventory_stock_status_idx cataloginventory_stock_status_tmp Anybody has any idea ...