Magento 2 get quantity of product in cart without loop
I have written a controller in Magento 2 that adds products to the logged in users account.
The controller is working properly however i am facing a slight issue.
You cannot add a product to your cart with a greater quantity than what is in stock. so you cannot add a quantity of 6 if there are only 5 in stock, this results in a 500 error. to get around this I am using this:
if($QuantityToAdd > $ProductStock){
// throw error
}
else{
// add to cart
}
and this is working fine for the scenario above.
however, this will also allow the user to add 4 products, and then try to add another 2 products separately. This will again result in a 500 error, stating:
main.ERROR: We don't have as many "XXXX" as you requested.
in the logs.
So I added a foreach, on the current cart items to get the quantity of that product already in the cart:
if(($QuantityToAdd + $QuantityInCart) > $ProductStock){
// throw error
}
else{
// add to cart
}
this solved my errors. However now the controller regularly times out as it will cycle the cart foreach within the add products for each, so if the user is trying to add 200 product variants and they already have 200 products in the cart, the controller will loop over 40,000 times.
200x200 = 40,000 loops
The quantities mentioned here are potentially at the lower end of possible usage.
To optimise this I have found a function:
if ($this->checkoutSession->create()->getQuote()->hasProductId($productId)) {
//product is available in the cart
}
Without performing another foreach, or any kind of loop, is it possible to get the current quantity of the product in the cart, if the above if statement is true?
or alternatively,
$this->cart->addProduct($productToadd, $params);
is there a function that updates the product in the cart instead of adding the new quantity on to the existing quantity?
Thanks.
EDIT:
Foreach by request:
foreach($products as $purchase){
$productSku = $purchase['Sku'];
$qty = $purchase['Quantity'];
$loadedProduct = $this->getProductBySku($productSku);
$productStock = $this->stockRegistry->getStockItem($loadedProduct->getId());
$manageStock = $productStock->getData('manage_stock');
if($manageStock == "1"){
$productQty = $productStock->getQty();
$quantityInCart = 0;
$items = $this->cart->getQuote()->getAllItems();
$productId=$loadedProduct->getId();
foreach ($items as $item) {
if ($item->getProductId() == $productId) {
$quantityInCart = $quantityInCart + $item->getQty();
}
}
if($productStock->getBackorders() > 1){
if(($qty + $quantityInCart) > $productQty){
$this->_messageManager->addError(__("Failed to add " . $purchase['Name'] . " - " .$purchase['Option'] . " " . $productQty . " available"));
$return = $purchase['Name'] . " - " .$purchase['Option'] . " " . $productQty . " available";
$proceed = false;
$returnObject->success = false;
}
}
}
}
This foreach checks through each of the products the user is trying to add, if they are all fine, there is a second for each to add the products.
magento2 cart addtocart
add a comment |
I have written a controller in Magento 2 that adds products to the logged in users account.
The controller is working properly however i am facing a slight issue.
You cannot add a product to your cart with a greater quantity than what is in stock. so you cannot add a quantity of 6 if there are only 5 in stock, this results in a 500 error. to get around this I am using this:
if($QuantityToAdd > $ProductStock){
// throw error
}
else{
// add to cart
}
and this is working fine for the scenario above.
however, this will also allow the user to add 4 products, and then try to add another 2 products separately. This will again result in a 500 error, stating:
main.ERROR: We don't have as many "XXXX" as you requested.
in the logs.
So I added a foreach, on the current cart items to get the quantity of that product already in the cart:
if(($QuantityToAdd + $QuantityInCart) > $ProductStock){
// throw error
}
else{
// add to cart
}
this solved my errors. However now the controller regularly times out as it will cycle the cart foreach within the add products for each, so if the user is trying to add 200 product variants and they already have 200 products in the cart, the controller will loop over 40,000 times.
200x200 = 40,000 loops
The quantities mentioned here are potentially at the lower end of possible usage.
To optimise this I have found a function:
if ($this->checkoutSession->create()->getQuote()->hasProductId($productId)) {
//product is available in the cart
}
Without performing another foreach, or any kind of loop, is it possible to get the current quantity of the product in the cart, if the above if statement is true?
or alternatively,
$this->cart->addProduct($productToadd, $params);
is there a function that updates the product in the cart instead of adding the new quantity on to the existing quantity?
Thanks.
EDIT:
Foreach by request:
foreach($products as $purchase){
$productSku = $purchase['Sku'];
$qty = $purchase['Quantity'];
$loadedProduct = $this->getProductBySku($productSku);
$productStock = $this->stockRegistry->getStockItem($loadedProduct->getId());
$manageStock = $productStock->getData('manage_stock');
if($manageStock == "1"){
$productQty = $productStock->getQty();
$quantityInCart = 0;
$items = $this->cart->getQuote()->getAllItems();
$productId=$loadedProduct->getId();
foreach ($items as $item) {
if ($item->getProductId() == $productId) {
$quantityInCart = $quantityInCart + $item->getQty();
}
}
if($productStock->getBackorders() > 1){
if(($qty + $quantityInCart) > $productQty){
$this->_messageManager->addError(__("Failed to add " . $purchase['Name'] . " - " .$purchase['Option'] . " " . $productQty . " available"));
$return = $purchase['Name'] . " - " .$purchase['Option'] . " " . $productQty . " available";
$proceed = false;
$returnObject->success = false;
}
}
}
}
This foreach checks through each of the products the user is trying to add, if they are all fine, there is a second for each to add the products.
magento2 cart addtocart
add a comment |
I have written a controller in Magento 2 that adds products to the logged in users account.
The controller is working properly however i am facing a slight issue.
You cannot add a product to your cart with a greater quantity than what is in stock. so you cannot add a quantity of 6 if there are only 5 in stock, this results in a 500 error. to get around this I am using this:
if($QuantityToAdd > $ProductStock){
// throw error
}
else{
// add to cart
}
and this is working fine for the scenario above.
however, this will also allow the user to add 4 products, and then try to add another 2 products separately. This will again result in a 500 error, stating:
main.ERROR: We don't have as many "XXXX" as you requested.
in the logs.
So I added a foreach, on the current cart items to get the quantity of that product already in the cart:
if(($QuantityToAdd + $QuantityInCart) > $ProductStock){
// throw error
}
else{
// add to cart
}
this solved my errors. However now the controller regularly times out as it will cycle the cart foreach within the add products for each, so if the user is trying to add 200 product variants and they already have 200 products in the cart, the controller will loop over 40,000 times.
200x200 = 40,000 loops
The quantities mentioned here are potentially at the lower end of possible usage.
To optimise this I have found a function:
if ($this->checkoutSession->create()->getQuote()->hasProductId($productId)) {
//product is available in the cart
}
Without performing another foreach, or any kind of loop, is it possible to get the current quantity of the product in the cart, if the above if statement is true?
or alternatively,
$this->cart->addProduct($productToadd, $params);
is there a function that updates the product in the cart instead of adding the new quantity on to the existing quantity?
Thanks.
EDIT:
Foreach by request:
foreach($products as $purchase){
$productSku = $purchase['Sku'];
$qty = $purchase['Quantity'];
$loadedProduct = $this->getProductBySku($productSku);
$productStock = $this->stockRegistry->getStockItem($loadedProduct->getId());
$manageStock = $productStock->getData('manage_stock');
if($manageStock == "1"){
$productQty = $productStock->getQty();
$quantityInCart = 0;
$items = $this->cart->getQuote()->getAllItems();
$productId=$loadedProduct->getId();
foreach ($items as $item) {
if ($item->getProductId() == $productId) {
$quantityInCart = $quantityInCart + $item->getQty();
}
}
if($productStock->getBackorders() > 1){
if(($qty + $quantityInCart) > $productQty){
$this->_messageManager->addError(__("Failed to add " . $purchase['Name'] . " - " .$purchase['Option'] . " " . $productQty . " available"));
$return = $purchase['Name'] . " - " .$purchase['Option'] . " " . $productQty . " available";
$proceed = false;
$returnObject->success = false;
}
}
}
}
This foreach checks through each of the products the user is trying to add, if they are all fine, there is a second for each to add the products.
magento2 cart addtocart
I have written a controller in Magento 2 that adds products to the logged in users account.
The controller is working properly however i am facing a slight issue.
You cannot add a product to your cart with a greater quantity than what is in stock. so you cannot add a quantity of 6 if there are only 5 in stock, this results in a 500 error. to get around this I am using this:
if($QuantityToAdd > $ProductStock){
// throw error
}
else{
// add to cart
}
and this is working fine for the scenario above.
however, this will also allow the user to add 4 products, and then try to add another 2 products separately. This will again result in a 500 error, stating:
main.ERROR: We don't have as many "XXXX" as you requested.
in the logs.
So I added a foreach, on the current cart items to get the quantity of that product already in the cart:
if(($QuantityToAdd + $QuantityInCart) > $ProductStock){
// throw error
}
else{
// add to cart
}
this solved my errors. However now the controller regularly times out as it will cycle the cart foreach within the add products for each, so if the user is trying to add 200 product variants and they already have 200 products in the cart, the controller will loop over 40,000 times.
200x200 = 40,000 loops
The quantities mentioned here are potentially at the lower end of possible usage.
To optimise this I have found a function:
if ($this->checkoutSession->create()->getQuote()->hasProductId($productId)) {
//product is available in the cart
}
Without performing another foreach, or any kind of loop, is it possible to get the current quantity of the product in the cart, if the above if statement is true?
or alternatively,
$this->cart->addProduct($productToadd, $params);
is there a function that updates the product in the cart instead of adding the new quantity on to the existing quantity?
Thanks.
EDIT:
Foreach by request:
foreach($products as $purchase){
$productSku = $purchase['Sku'];
$qty = $purchase['Quantity'];
$loadedProduct = $this->getProductBySku($productSku);
$productStock = $this->stockRegistry->getStockItem($loadedProduct->getId());
$manageStock = $productStock->getData('manage_stock');
if($manageStock == "1"){
$productQty = $productStock->getQty();
$quantityInCart = 0;
$items = $this->cart->getQuote()->getAllItems();
$productId=$loadedProduct->getId();
foreach ($items as $item) {
if ($item->getProductId() == $productId) {
$quantityInCart = $quantityInCart + $item->getQty();
}
}
if($productStock->getBackorders() > 1){
if(($qty + $quantityInCart) > $productQty){
$this->_messageManager->addError(__("Failed to add " . $purchase['Name'] . " - " .$purchase['Option'] . " " . $productQty . " available"));
$return = $purchase['Name'] . " - " .$purchase['Option'] . " " . $productQty . " available";
$proceed = false;
$returnObject->success = false;
}
}
}
}
This foreach checks through each of the products the user is trying to add, if they are all fine, there is a second for each to add the products.
magento2 cart addtocart
magento2 cart addtocart
edited Jan 16 at 13:33
vmp
asked Jan 16 at 13:17
vmpvmp
14613
14613
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
I don't fully understand your need, but I think I can help a bit.
this code
foreach ($items as $item) {
if ($item->getProductId() == $productId) {
$quantityInCart = $quantityInCart + $item->getQty();
}
}
gets executed multiple times with the same result.
You can try to call it outside the other foreach loop like this:
$qtysInCart = ;
$items = $this->cart->getQuote()->getAllItems();
foreach ($items as $item) {
$cartProductId = $item->getProductId();
if (!isset($qtysInCart[$cartProductId])) {
$qtysInCart[$cartProductId] = 0;
}
$qtysInCart[$cartProductId] += $item->getQty();
}
Now you should have an array with all the qtys in the cart for each product in the cart.
Now do the other loop:
foreach($products as $purchase){
$productSku = $purchase['Sku'];
$qty = $purchase['Quantity'];
$loadedProduct = $this->getProductBySku($productSku);
//rest of your code here except the other foreach
//but instead of `if(($qty + $quantityInCart) > $productQty){` do this
...
$productId = $loadedProduct->getId();
if (isset($qtysInCart[$productId]) and $qty + $qtysInCart[$productId] > $productQty) {
//error code in here
}
}
Now the complexity will be O(n)
instead of O(n^2).
like you had before.
So for 200 products in the cart and adding 200 more you will get 200 + 200 checks instead of 200 * 200.
Note: I didn't test the code so watch out for typos.
without running it, this looks like something that i was thinking about doing earlier, but did not think to use the Product Id as the array index, so thought i would still be looping over (200?) items on each loop again. Ideally i was looking for a cart function along the lines of $this->checkoutSession->create()->getQuote()->GetQuantityinCart($productId); That would return an integer. but your solution looks like it should not be too resource heavy. I will give it a go. Cheers.
– vmp
Jan 16 at 14:25
add a comment |
In addition to Marius answer, and considering the amount of products you mentioned in your question. You have $quoteId
$quoteId = $this->cart->getQuote()->getId();
So, in terms of performance, you can get this info directly from quote_item database table. You'd just add MagentoFrameworkAppResourceConnection in your constructor class, and then...
$qtysInCart = ;
$connection = $this->_resourceConnection->getConnection();
$query = $connection->select()
->from($this->_resourceConnection->getTableName('quote_item'))
->where('quote_id = ?', $quoteId)
foreach ($connection->fetchAll($query) as $row){
$qtysInCart[$row['product_id']] = $row['qty'];
}
Using same approach you can get inventory info for involved product IDs (querying cataloginventory_stock_item database table) to check if requested qty can be satisfied, which will make your request kindly lighter & faster
UPDATE
In fact, if I've understood what you want, you'll need only 2 SQL queries (you get all product IDs in quote with the first, so you can run the inventory one using IN condition & you'll get all info you need in your controller logic)
this is a different angle from what I had considered myself, however looks like it would do the job. What would the efficiency be like on performing 200 SQL queries through the resource connection?
– vmp
Jan 16 at 14:27
I have not tried the code, just wanted to help with another point of view. Not sure how this would perform in Magento2 (in Magento1 using approaches like this were always strongly faster than using model methods)... try it & share the results :)
– Raul Sanchez
Jan 16 at 14:40
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f258027%2fmagento-2-get-quantity-of-product-in-cart-without-loop%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
I don't fully understand your need, but I think I can help a bit.
this code
foreach ($items as $item) {
if ($item->getProductId() == $productId) {
$quantityInCart = $quantityInCart + $item->getQty();
}
}
gets executed multiple times with the same result.
You can try to call it outside the other foreach loop like this:
$qtysInCart = ;
$items = $this->cart->getQuote()->getAllItems();
foreach ($items as $item) {
$cartProductId = $item->getProductId();
if (!isset($qtysInCart[$cartProductId])) {
$qtysInCart[$cartProductId] = 0;
}
$qtysInCart[$cartProductId] += $item->getQty();
}
Now you should have an array with all the qtys in the cart for each product in the cart.
Now do the other loop:
foreach($products as $purchase){
$productSku = $purchase['Sku'];
$qty = $purchase['Quantity'];
$loadedProduct = $this->getProductBySku($productSku);
//rest of your code here except the other foreach
//but instead of `if(($qty + $quantityInCart) > $productQty){` do this
...
$productId = $loadedProduct->getId();
if (isset($qtysInCart[$productId]) and $qty + $qtysInCart[$productId] > $productQty) {
//error code in here
}
}
Now the complexity will be O(n)
instead of O(n^2).
like you had before.
So for 200 products in the cart and adding 200 more you will get 200 + 200 checks instead of 200 * 200.
Note: I didn't test the code so watch out for typos.
without running it, this looks like something that i was thinking about doing earlier, but did not think to use the Product Id as the array index, so thought i would still be looping over (200?) items on each loop again. Ideally i was looking for a cart function along the lines of $this->checkoutSession->create()->getQuote()->GetQuantityinCart($productId); That would return an integer. but your solution looks like it should not be too resource heavy. I will give it a go. Cheers.
– vmp
Jan 16 at 14:25
add a comment |
I don't fully understand your need, but I think I can help a bit.
this code
foreach ($items as $item) {
if ($item->getProductId() == $productId) {
$quantityInCart = $quantityInCart + $item->getQty();
}
}
gets executed multiple times with the same result.
You can try to call it outside the other foreach loop like this:
$qtysInCart = ;
$items = $this->cart->getQuote()->getAllItems();
foreach ($items as $item) {
$cartProductId = $item->getProductId();
if (!isset($qtysInCart[$cartProductId])) {
$qtysInCart[$cartProductId] = 0;
}
$qtysInCart[$cartProductId] += $item->getQty();
}
Now you should have an array with all the qtys in the cart for each product in the cart.
Now do the other loop:
foreach($products as $purchase){
$productSku = $purchase['Sku'];
$qty = $purchase['Quantity'];
$loadedProduct = $this->getProductBySku($productSku);
//rest of your code here except the other foreach
//but instead of `if(($qty + $quantityInCart) > $productQty){` do this
...
$productId = $loadedProduct->getId();
if (isset($qtysInCart[$productId]) and $qty + $qtysInCart[$productId] > $productQty) {
//error code in here
}
}
Now the complexity will be O(n)
instead of O(n^2).
like you had before.
So for 200 products in the cart and adding 200 more you will get 200 + 200 checks instead of 200 * 200.
Note: I didn't test the code so watch out for typos.
without running it, this looks like something that i was thinking about doing earlier, but did not think to use the Product Id as the array index, so thought i would still be looping over (200?) items on each loop again. Ideally i was looking for a cart function along the lines of $this->checkoutSession->create()->getQuote()->GetQuantityinCart($productId); That would return an integer. but your solution looks like it should not be too resource heavy. I will give it a go. Cheers.
– vmp
Jan 16 at 14:25
add a comment |
I don't fully understand your need, but I think I can help a bit.
this code
foreach ($items as $item) {
if ($item->getProductId() == $productId) {
$quantityInCart = $quantityInCart + $item->getQty();
}
}
gets executed multiple times with the same result.
You can try to call it outside the other foreach loop like this:
$qtysInCart = ;
$items = $this->cart->getQuote()->getAllItems();
foreach ($items as $item) {
$cartProductId = $item->getProductId();
if (!isset($qtysInCart[$cartProductId])) {
$qtysInCart[$cartProductId] = 0;
}
$qtysInCart[$cartProductId] += $item->getQty();
}
Now you should have an array with all the qtys in the cart for each product in the cart.
Now do the other loop:
foreach($products as $purchase){
$productSku = $purchase['Sku'];
$qty = $purchase['Quantity'];
$loadedProduct = $this->getProductBySku($productSku);
//rest of your code here except the other foreach
//but instead of `if(($qty + $quantityInCart) > $productQty){` do this
...
$productId = $loadedProduct->getId();
if (isset($qtysInCart[$productId]) and $qty + $qtysInCart[$productId] > $productQty) {
//error code in here
}
}
Now the complexity will be O(n)
instead of O(n^2).
like you had before.
So for 200 products in the cart and adding 200 more you will get 200 + 200 checks instead of 200 * 200.
Note: I didn't test the code so watch out for typos.
I don't fully understand your need, but I think I can help a bit.
this code
foreach ($items as $item) {
if ($item->getProductId() == $productId) {
$quantityInCart = $quantityInCart + $item->getQty();
}
}
gets executed multiple times with the same result.
You can try to call it outside the other foreach loop like this:
$qtysInCart = ;
$items = $this->cart->getQuote()->getAllItems();
foreach ($items as $item) {
$cartProductId = $item->getProductId();
if (!isset($qtysInCart[$cartProductId])) {
$qtysInCart[$cartProductId] = 0;
}
$qtysInCart[$cartProductId] += $item->getQty();
}
Now you should have an array with all the qtys in the cart for each product in the cart.
Now do the other loop:
foreach($products as $purchase){
$productSku = $purchase['Sku'];
$qty = $purchase['Quantity'];
$loadedProduct = $this->getProductBySku($productSku);
//rest of your code here except the other foreach
//but instead of `if(($qty + $quantityInCart) > $productQty){` do this
...
$productId = $loadedProduct->getId();
if (isset($qtysInCart[$productId]) and $qty + $qtysInCart[$productId] > $productQty) {
//error code in here
}
}
Now the complexity will be O(n)
instead of O(n^2).
like you had before.
So for 200 products in the cart and adding 200 more you will get 200 + 200 checks instead of 200 * 200.
Note: I didn't test the code so watch out for typos.
answered Jan 16 at 13:48
Marius♦Marius
164k28313666
164k28313666
without running it, this looks like something that i was thinking about doing earlier, but did not think to use the Product Id as the array index, so thought i would still be looping over (200?) items on each loop again. Ideally i was looking for a cart function along the lines of $this->checkoutSession->create()->getQuote()->GetQuantityinCart($productId); That would return an integer. but your solution looks like it should not be too resource heavy. I will give it a go. Cheers.
– vmp
Jan 16 at 14:25
add a comment |
without running it, this looks like something that i was thinking about doing earlier, but did not think to use the Product Id as the array index, so thought i would still be looping over (200?) items on each loop again. Ideally i was looking for a cart function along the lines of $this->checkoutSession->create()->getQuote()->GetQuantityinCart($productId); That would return an integer. but your solution looks like it should not be too resource heavy. I will give it a go. Cheers.
– vmp
Jan 16 at 14:25
without running it, this looks like something that i was thinking about doing earlier, but did not think to use the Product Id as the array index, so thought i would still be looping over (200?) items on each loop again. Ideally i was looking for a cart function along the lines of $this->checkoutSession->create()->getQuote()->GetQuantityinCart($productId); That would return an integer. but your solution looks like it should not be too resource heavy. I will give it a go. Cheers.
– vmp
Jan 16 at 14:25
without running it, this looks like something that i was thinking about doing earlier, but did not think to use the Product Id as the array index, so thought i would still be looping over (200?) items on each loop again. Ideally i was looking for a cart function along the lines of $this->checkoutSession->create()->getQuote()->GetQuantityinCart($productId); That would return an integer. but your solution looks like it should not be too resource heavy. I will give it a go. Cheers.
– vmp
Jan 16 at 14:25
add a comment |
In addition to Marius answer, and considering the amount of products you mentioned in your question. You have $quoteId
$quoteId = $this->cart->getQuote()->getId();
So, in terms of performance, you can get this info directly from quote_item database table. You'd just add MagentoFrameworkAppResourceConnection in your constructor class, and then...
$qtysInCart = ;
$connection = $this->_resourceConnection->getConnection();
$query = $connection->select()
->from($this->_resourceConnection->getTableName('quote_item'))
->where('quote_id = ?', $quoteId)
foreach ($connection->fetchAll($query) as $row){
$qtysInCart[$row['product_id']] = $row['qty'];
}
Using same approach you can get inventory info for involved product IDs (querying cataloginventory_stock_item database table) to check if requested qty can be satisfied, which will make your request kindly lighter & faster
UPDATE
In fact, if I've understood what you want, you'll need only 2 SQL queries (you get all product IDs in quote with the first, so you can run the inventory one using IN condition & you'll get all info you need in your controller logic)
this is a different angle from what I had considered myself, however looks like it would do the job. What would the efficiency be like on performing 200 SQL queries through the resource connection?
– vmp
Jan 16 at 14:27
I have not tried the code, just wanted to help with another point of view. Not sure how this would perform in Magento2 (in Magento1 using approaches like this were always strongly faster than using model methods)... try it & share the results :)
– Raul Sanchez
Jan 16 at 14:40
add a comment |
In addition to Marius answer, and considering the amount of products you mentioned in your question. You have $quoteId
$quoteId = $this->cart->getQuote()->getId();
So, in terms of performance, you can get this info directly from quote_item database table. You'd just add MagentoFrameworkAppResourceConnection in your constructor class, and then...
$qtysInCart = ;
$connection = $this->_resourceConnection->getConnection();
$query = $connection->select()
->from($this->_resourceConnection->getTableName('quote_item'))
->where('quote_id = ?', $quoteId)
foreach ($connection->fetchAll($query) as $row){
$qtysInCart[$row['product_id']] = $row['qty'];
}
Using same approach you can get inventory info for involved product IDs (querying cataloginventory_stock_item database table) to check if requested qty can be satisfied, which will make your request kindly lighter & faster
UPDATE
In fact, if I've understood what you want, you'll need only 2 SQL queries (you get all product IDs in quote with the first, so you can run the inventory one using IN condition & you'll get all info you need in your controller logic)
this is a different angle from what I had considered myself, however looks like it would do the job. What would the efficiency be like on performing 200 SQL queries through the resource connection?
– vmp
Jan 16 at 14:27
I have not tried the code, just wanted to help with another point of view. Not sure how this would perform in Magento2 (in Magento1 using approaches like this were always strongly faster than using model methods)... try it & share the results :)
– Raul Sanchez
Jan 16 at 14:40
add a comment |
In addition to Marius answer, and considering the amount of products you mentioned in your question. You have $quoteId
$quoteId = $this->cart->getQuote()->getId();
So, in terms of performance, you can get this info directly from quote_item database table. You'd just add MagentoFrameworkAppResourceConnection in your constructor class, and then...
$qtysInCart = ;
$connection = $this->_resourceConnection->getConnection();
$query = $connection->select()
->from($this->_resourceConnection->getTableName('quote_item'))
->where('quote_id = ?', $quoteId)
foreach ($connection->fetchAll($query) as $row){
$qtysInCart[$row['product_id']] = $row['qty'];
}
Using same approach you can get inventory info for involved product IDs (querying cataloginventory_stock_item database table) to check if requested qty can be satisfied, which will make your request kindly lighter & faster
UPDATE
In fact, if I've understood what you want, you'll need only 2 SQL queries (you get all product IDs in quote with the first, so you can run the inventory one using IN condition & you'll get all info you need in your controller logic)
In addition to Marius answer, and considering the amount of products you mentioned in your question. You have $quoteId
$quoteId = $this->cart->getQuote()->getId();
So, in terms of performance, you can get this info directly from quote_item database table. You'd just add MagentoFrameworkAppResourceConnection in your constructor class, and then...
$qtysInCart = ;
$connection = $this->_resourceConnection->getConnection();
$query = $connection->select()
->from($this->_resourceConnection->getTableName('quote_item'))
->where('quote_id = ?', $quoteId)
foreach ($connection->fetchAll($query) as $row){
$qtysInCart[$row['product_id']] = $row['qty'];
}
Using same approach you can get inventory info for involved product IDs (querying cataloginventory_stock_item database table) to check if requested qty can be satisfied, which will make your request kindly lighter & faster
UPDATE
In fact, if I've understood what you want, you'll need only 2 SQL queries (you get all product IDs in quote with the first, so you can run the inventory one using IN condition & you'll get all info you need in your controller logic)
edited Jan 16 at 16:13
answered Jan 16 at 14:25
Raul SanchezRaul Sanchez
1,91431135
1,91431135
this is a different angle from what I had considered myself, however looks like it would do the job. What would the efficiency be like on performing 200 SQL queries through the resource connection?
– vmp
Jan 16 at 14:27
I have not tried the code, just wanted to help with another point of view. Not sure how this would perform in Magento2 (in Magento1 using approaches like this were always strongly faster than using model methods)... try it & share the results :)
– Raul Sanchez
Jan 16 at 14:40
add a comment |
this is a different angle from what I had considered myself, however looks like it would do the job. What would the efficiency be like on performing 200 SQL queries through the resource connection?
– vmp
Jan 16 at 14:27
I have not tried the code, just wanted to help with another point of view. Not sure how this would perform in Magento2 (in Magento1 using approaches like this were always strongly faster than using model methods)... try it & share the results :)
– Raul Sanchez
Jan 16 at 14:40
this is a different angle from what I had considered myself, however looks like it would do the job. What would the efficiency be like on performing 200 SQL queries through the resource connection?
– vmp
Jan 16 at 14:27
this is a different angle from what I had considered myself, however looks like it would do the job. What would the efficiency be like on performing 200 SQL queries through the resource connection?
– vmp
Jan 16 at 14:27
I have not tried the code, just wanted to help with another point of view. Not sure how this would perform in Magento2 (in Magento1 using approaches like this were always strongly faster than using model methods)... try it & share the results :)
– Raul Sanchez
Jan 16 at 14:40
I have not tried the code, just wanted to help with another point of view. Not sure how this would perform in Magento2 (in Magento1 using approaches like this were always strongly faster than using model methods)... try it & share the results :)
– Raul Sanchez
Jan 16 at 14:40
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f258027%2fmagento-2-get-quantity-of-product-in-cart-without-loop%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown