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
Is it a good idea to use CNN to classify 1D signal?
Can melee weapons be used to deliver Contact Poisons?
Should I use a zero-interest credit card for a large one-time purchase?
Delete nth line from bottom
When the Haste spell ends on a creature, do attackers have advantage against that creature?
Denied boarding although I have proper visa and documentation. To whom should I make a complaint?
Dating a Former Employee
Is it fair for a professor to grade us on the possession of past papers?
Is it common practice to audition new musicians 1-2-1 before rehearsing with the entire band?
Trademark violation for app?
How do I make this wiring inside cabinet safer? (Pic)
Is there a kind of relay only consumes power when switching?
Can an alien society believe that their star system is the universe?
2001: A Space Odyssey's use of the song "Daisy Bell" (Bicycle Built for Two); life imitates art or vice-versa?
Why aren't air breathing engines used as small first stages
What is homebrew?
How do I stop a creek from eroding my steep embankment?
Fundamental Solution of the Pell Equation
Extracting terms with certain heads in a function
First console to have temporary backward compatibility
What are the out-of-universe reasons for the references to Toby Maguire-era Spider-Man in ITSV
If a VARCHAR(MAX) column is included in an index, is the entire value always stored in the index page(s)?
Compare a given version number in the form major.minor.build.patch and see if one is less than the other
Where are Serre’s lectures at Collège de France to be found?
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
asked Apr 9 '15 at 5:01
FraFra
4,575115194
bumped to the homepage by Community♦ 32 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
asked Apr 9 '15 at 5:01
FraFra
4,575115194
bumped to the homepage by Community♦ 32 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
asked Apr 9 '15 at 5:01
FraFra
4,575115194
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
asked Apr 9 '15 at 5:01
FraFra
4,575115194
asked Apr 9 '15 at 5:01
FraFra
4,575115194
asked Apr 9 '15 at 5:01
FraFra
4,575115194
asked Apr 9 '15 at 5:01
FraFra
4,575115194
4,575115194
bumped to the homepage by Community♦ 32 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♦ 32 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
edited Sep 21 '18 at 9:34
Ansar Husain
1,765218
answered Sep 21 '18 at 9:26
TS GuhanTS Guhan
12410
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
edited Sep 21 '18 at 9:34
Ansar Husain
1,765218
answered Sep 21 '18 at 9:26
TS GuhanTS Guhan
12410
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
edited Sep 21 '18 at 9:34
Ansar Husain
1,765218
answered Sep 21 '18 at 9:26
TS GuhanTS Guhan
12410
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
edited Sep 21 '18 at 9:34
Ansar Husain
1,765218
answered Sep 21 '18 at 9:26
TS GuhanTS Guhan
12410
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
Ansar Husain
1,765218
answered Sep 21 '18 at 9:26
TS GuhanTS Guhan
12410
edited Sep 21 '18 at 9:34
Ansar Husain
1,765218
edited Sep 21 '18 at 9:34
Ansar Husain
1,765218
edited Sep 21 '18 at 9:34
Ansar Husain
1,765218
1,765218
answered Sep 21 '18 at 9:26
TS GuhanTS Guhan
12410
answered Sep 21 '18 at 9:26
TS GuhanTS Guhan
12410
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
