Quote with no items - add to cart error Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?adding attributes to quote items via configPossible Bug - Hidden tax amount on quote and order item but no discount amountproblem unsetting quote (cart), data is not savedProgrammatically add items to cart and assign to guest userMagento 2 Rest API - How to add custom option to Cart Item?Why are quotes not converted to is_active=0 after checkout? M1/M2How to get the order items and quote items whenever create order from admin panel?Convert MagentoQuoteModelQuote to MagentoSalesModelOrder: Magento 2Adding products to cart programmatically with custom price in controller: Magento 2Request for quote and checkout at same time
Circuit to "zoom in" on mV fluctuations of a DC signal?
Using audio cues to encourage good posture
Amount of permutations on an NxNxN Rubik's Cube
Integration Help
Why do the resolve message appear first?
Why are there no cargo aircraft with "flying wing" design?
How come Sam didn't become Lord of Horn Hill?
Should I use a zero-interest credit card for a large one-time purchase?
Why do we bend a book to keep it straight?
Is "Reachable Object" really an NP-complete problem?
When the Haste spell ends on a creature, do attackers have advantage against that creature?
Do I really need recursive chmod to restrict access to a folder?
Is it fair for a professor to grade us on the possession of past papers?
8 Prisoners wearing hats
What do you call the main part of a joke?
How to tell that you are a giant?
Why wasn't DOSKEY integrated with COMMAND.COM?
Do I really need to have a message in a novel to appeal to readers?
What is the meaning of the simile “quick as silk”?
How can I use the Python library networkx from Mathematica?
Can a party unilaterally change candidates in preparation for a General election?
Can you use the Shield Master feat to shove someone before you make an attack by using a Readied action?
For a new assistant professor in CS, how to build/manage a publication pipeline
Dating a Former Employee
Quote with no items - add to cart error
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?adding attributes to quote items via configPossible Bug - Hidden tax amount on quote and order item but no discount amountproblem unsetting quote (cart), data is not savedProgrammatically add items to cart and assign to guest userMagento 2 Rest API - How to add custom option to Cart Item?Why are quotes not converted to is_active=0 after checkout? M1/M2How to get the order items and quote items whenever create order from admin panel?Convert MagentoQuoteModelQuote to MagentoSalesModelOrder: Magento 2Adding products to cart programmatically with custom price in controller: Magento 2Request for quote and checkout at same time
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I'm facing this strange issue on add to cart action:
sometime after I checkout (with a registered customer) correctly my order, if I try to purchase another item I got the following error:Call to a member function setFinalPrice() on a non-object in app/code/core/Mage/Sales/Model/Quote/Item/Abstract.php on line 73
I have debugged the code and found out that the issue is created by some old quotes associated to my user that are still active and have not items associated with it.
If I check the problematic quote in the Db it has items_count = 0
any way Mage_Sales_Model_Resource_Quote_Item_Collection::_assignProducts()
method try to load an item using null as Id :
$product = $productCollection->getItemById($item->getProductId());
This trigger the above error.
Now the fast fix it to set to is_active = 0
in all these quote, something like:
UPDATE `sales_flat_quote` SET `is_active` = 0 WHERE `is_active` = 1 AND `items_count`= 0 and customer_id is not null and customer_id <> 0
Question
Anyway I would like to understand the following points:
- Is it normal to have old quotes (also multiple for same user) with 0 items and
is_active = 1
? - Is ok to delete all these quotes ? ( I have 10000+ quotes like this )
Any suggestion is welcome
orders quote debug
bumped to the homepage by Community♦ 14 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I'm facing this strange issue on add to cart action:
sometime after I checkout (with a registered customer) correctly my order, if I try to purchase another item I got the following error:Call to a member function setFinalPrice() on a non-object in app/code/core/Mage/Sales/Model/Quote/Item/Abstract.php on line 73
I have debugged the code and found out that the issue is created by some old quotes associated to my user that are still active and have not items associated with it.
If I check the problematic quote in the Db it has items_count = 0
any way Mage_Sales_Model_Resource_Quote_Item_Collection::_assignProducts()
method try to load an item using null as Id :
$product = $productCollection->getItemById($item->getProductId());
This trigger the above error.
Now the fast fix it to set to is_active = 0
in all these quote, something like:
UPDATE `sales_flat_quote` SET `is_active` = 0 WHERE `is_active` = 1 AND `items_count`= 0 and customer_id is not null and customer_id <> 0
Question
Anyway I would like to understand the following points:
- Is it normal to have old quotes (also multiple for same user) with 0 items and
is_active = 1
? - Is ok to delete all these quotes ? ( I have 10000+ quotes like this )
Any suggestion is welcome
orders quote debug
bumped to the homepage by Community♦ 14 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I'm facing this strange issue on add to cart action:
sometime after I checkout (with a registered customer) correctly my order, if I try to purchase another item I got the following error:Call to a member function setFinalPrice() on a non-object in app/code/core/Mage/Sales/Model/Quote/Item/Abstract.php on line 73
I have debugged the code and found out that the issue is created by some old quotes associated to my user that are still active and have not items associated with it.
If I check the problematic quote in the Db it has items_count = 0
any way Mage_Sales_Model_Resource_Quote_Item_Collection::_assignProducts()
method try to load an item using null as Id :
$product = $productCollection->getItemById($item->getProductId());
This trigger the above error.
Now the fast fix it to set to is_active = 0
in all these quote, something like:
UPDATE `sales_flat_quote` SET `is_active` = 0 WHERE `is_active` = 1 AND `items_count`= 0 and customer_id is not null and customer_id <> 0
Question
Anyway I would like to understand the following points:
- Is it normal to have old quotes (also multiple for same user) with 0 items and
is_active = 1
? - Is ok to delete all these quotes ? ( I have 10000+ quotes like this )
Any suggestion is welcome
orders quote debug
I'm facing this strange issue on add to cart action:
sometime after I checkout (with a registered customer) correctly my order, if I try to purchase another item I got the following error:Call to a member function setFinalPrice() on a non-object in app/code/core/Mage/Sales/Model/Quote/Item/Abstract.php on line 73
I have debugged the code and found out that the issue is created by some old quotes associated to my user that are still active and have not items associated with it.
If I check the problematic quote in the Db it has items_count = 0
any way Mage_Sales_Model_Resource_Quote_Item_Collection::_assignProducts()
method try to load an item using null as Id :
$product = $productCollection->getItemById($item->getProductId());
This trigger the above error.
Now the fast fix it to set to is_active = 0
in all these quote, something like:
UPDATE `sales_flat_quote` SET `is_active` = 0 WHERE `is_active` = 1 AND `items_count`= 0 and customer_id is not null and customer_id <> 0
Question
Anyway I would like to understand the following points:
- Is it normal to have old quotes (also multiple for same user) with 0 items and
is_active = 1
? - Is ok to delete all these quotes ? ( I have 10000+ quotes like this )
Any suggestion is welcome
orders quote debug
orders quote debug
asked Apr 9 '15 at 5:01
FraFra
4,575115194
4,575115194
bumped to the homepage by Community♦ 14 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 14 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
If it is throwing for all the customers then you can delete sales_flat_quote_item table. If this happens only for particular customer then do the following thing. In this case, all the quotes wont be deleted.
- Get the customer id from sales_flat_quote_address(column name: customer_id) table. Here you can get the specific quote id(column name in table is quote_id) which is causing the problem.
Example: SELECT quote_id FROM sales_flat_quote_address where
customer_id=23423
- Now, go to sales_flat_quote_item then delete the particular records which is causing the problem.
Example: DELETE FROM sales_flat_quote_item WHERE quote_id=43535
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%2f63121%2fquote-with-no-items-add-to-cart-error%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
If it is throwing for all the customers then you can delete sales_flat_quote_item table. If this happens only for particular customer then do the following thing. In this case, all the quotes wont be deleted.
- Get the customer id from sales_flat_quote_address(column name: customer_id) table. Here you can get the specific quote id(column name in table is quote_id) which is causing the problem.
Example: SELECT quote_id FROM sales_flat_quote_address where
customer_id=23423
- Now, go to sales_flat_quote_item then delete the particular records which is causing the problem.
Example: DELETE FROM sales_flat_quote_item WHERE quote_id=43535
add a comment |
If it is throwing for all the customers then you can delete sales_flat_quote_item table. If this happens only for particular customer then do the following thing. In this case, all the quotes wont be deleted.
- Get the customer id from sales_flat_quote_address(column name: customer_id) table. Here you can get the specific quote id(column name in table is quote_id) which is causing the problem.
Example: SELECT quote_id FROM sales_flat_quote_address where
customer_id=23423
- Now, go to sales_flat_quote_item then delete the particular records which is causing the problem.
Example: DELETE FROM sales_flat_quote_item WHERE quote_id=43535
add a comment |
If it is throwing for all the customers then you can delete sales_flat_quote_item table. If this happens only for particular customer then do the following thing. In this case, all the quotes wont be deleted.
- Get the customer id from sales_flat_quote_address(column name: customer_id) table. Here you can get the specific quote id(column name in table is quote_id) which is causing the problem.
Example: SELECT quote_id FROM sales_flat_quote_address where
customer_id=23423
- Now, go to sales_flat_quote_item then delete the particular records which is causing the problem.
Example: DELETE FROM sales_flat_quote_item WHERE quote_id=43535
If it is throwing for all the customers then you can delete sales_flat_quote_item table. If this happens only for particular customer then do the following thing. In this case, all the quotes wont be deleted.
- Get the customer id from sales_flat_quote_address(column name: customer_id) table. Here you can get the specific quote id(column name in table is quote_id) which is causing the problem.
Example: SELECT quote_id FROM sales_flat_quote_address where
customer_id=23423
- Now, go to sales_flat_quote_item then delete the particular records which is causing the problem.
Example: DELETE FROM sales_flat_quote_item WHERE quote_id=43535
edited Sep 21 '18 at 9:34
![](https://i.stack.imgur.com/uznN5.jpg?s=32&g=1)
![](https://i.stack.imgur.com/uznN5.jpg?s=32&g=1)
Ansar Husain
1,765218
1,765218
answered Sep 21 '18 at 9:26
TS GuhanTS Guhan
12410
12410
add a comment |
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%2f63121%2fquote-with-no-items-add-to-cart-error%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