cartevent-observermagento-1.7quote
I need to save some additional data in sales_flat_quote table. So what is the event which dispatching when the abandoned cart data saves in this table?
EDIT: I need to save item names comma separately in the sales_flat_quote table by adding a new column. Hope a data script can be used to fill the column. But How can I do this without an event observer?
Please be kind enough to provide suggestions.
Thanks in advance.
You don't need to save price for product.
Just pass your dynamic price with in post parameter and set your dynamic price for product in observer event.
You can use an observer class to listen to checkout_cart_product_add_after, and use a product’s “Super Mode” to set custom prices against the quote item.
In your /app/code/local/{namespace}/{yourmodule}/etc/config.xml:
<config>
...
<frontend>
...
<events>
<checkout_cart_product_add_after>
<observers>
<unique_event_name>
<class>{{modulename}}/observer</class>
<method>modifyPrice</method>
</unique_event_name>
</observers>
</checkout_cart_product_add_after>
</events>
...
</frontend>
...
</config>
And then create an Observer class at /app/code/local/{namespace}/{yourmodule}/Model/Observer.php
class <namespace>_<modulename>_Model_Observer
{
public function modifyPrice(Varien_Event_Observer $obs)
{
// Get the quote item
$item = $obs->getQuoteItem();
// Ensure we have the parent item, if it has one
$item = ( $item->getParentItem() ? $item->getParentItem() : $item );
// Load the custom price
$price = "your custom price logic";
// Set the custom price
$item->setCustomPrice($price);
$item->setOriginalCustomPrice($price);
// Enable super mode on the product.
$item->getProduct()->setIsSuperMode(true);
}
}
Because abandoned carts pull from the sales_flat_quote table you should be able to join on sales_flat_quote_item and use the name field:
Best Answer
controller_action_postdispatch_customer_account_logoutevent to check thesales_flat_quotetable which aren't present insales_flat_ordertable. This will give you the abandoned quotes (in other words abandoned carts).note:
Therefore cron would be the better Idea!
or
There are some paid extensions to do this job for you.