Magento – How to get a quote id after an order is made

checkoutdatabasequote

Okay the question is how to get a quote id after an order is made.. and I know what people are going to say – why?

Well I have some custom details being inserted into a custom table at checkout (via a module of course) and am tracking the session with the quote id so that data can be later edited by the user (upon reviewing the order and in the 'my account' section).

So imagine the table has 5 columns: 'entry_id', 'quote_id', 'order_id', 'custom_data', 'created_at'.

All of the columns (except order id of course) are filled in before final checkout (order placed) but the quote is no longer accessible after this so I cannot add the order id to the correct entry and therefore lose the ability to edit the details. This post – Is it possible to get the QuoteId that was used once an OrderId has been created – didn't work – perhaps an older version of magento and it's methods seem loose. There must be a standard technique for this that is full-proof.

Suggestions as to an alternative way to go about what I'm doing are also welcome. Thanks

Best Answer

Sure, the quote_id is saved with the order, so you can just:

$order->getQuoteId()

And the method should work too, maybe you couldn't load the order...

To get the order, you can hook in one of the events after the order creation:

checkout_onepage_controller_success_action
checkout_type_onepage_save_order_after
checkout_submit_all_after

If you only need the order ID, you can just use checkout_type_onepage_save_order_after and save the ID to the database.

Related Solutions

Magento – Price re-index causes DB deadlocks during checkout

There is quite big probability that your payment method is processing payment wrongly.

Magento Order Save Process is quite simple:

Prepares all data that should be transfered from quote item to order item, including prices and product information, afterwards it doesn't invoke price retrieval.
Invoke before order submit events checkout_type_onepage_save_order and sales_model_service_quote_submit_before
- Mage_CatalogInventory_Model_Stock::registerProductsSale() is invoked at this event observer
Start DB transaction
Invoke $order->place() method that processes the payment by calling $paymentMethod->authorize(), $paymentMethod->capture() or $paymentMethod->initialize() depends on its logic.
Invoke $order->save() method that saves processed order to DB tables sales_flat_order_*.
Commit DB transaction (At this step DB releases lock on inventory table)

So as you see, it couldn't be possible, that payment method charges money before the inventory lock and read of product prices or product info.

It is only possible in case if payment method is implemented in such a way, that it performs loading of products itself with prices, after the API call for charging operation is performed.

Hope this will help you in debugging your issue.

As for reindexing, it should be safe, if you don't have this issue with payment method. Since read operation that depend on locks are performed before money gets charged.

Magento – Display Custom Billing Address Fields in Admin Sales Order Grid

My article refers to joining an 'standard' Magento EAV attribute/table to a flat table in Magento.

What you are trying to do is join a custom table to a flat table.

Something like the following should do the trick:

$collection = Mage::getModel('sales/order')->getCollection();
$collection
       ->getSelect()
       ->joinLeft(
              array('customattribute1' => 'sales_order_custom'),
              "customattribute.order_id=main_table.entity_id AND customattribute.key = 'keynumber1here'"
               )
          )
        ;

(replace keynumber1here with the key you'd like to add)

Then you could do the following in the grid:

$this->addColumn('your_column_name',array(
     'label' => $this->__('Your Label'),
     'index' => 'customattribute1.value'
    )
)

Hope this helps!

Best Answer

Related Solutions

Magento – Price re-index causes DB deadlocks during checkout

Magento – Display Custom Billing Address Fields in Admin Sales Order Grid

Related Topic