Quote Id not present on db ?

[mhenry13400]

Hello,

We have an order with status "Complete" that has not its quote_id in quote table, is it normal ?
How can you explain that, even without quote entry, the products information are shown in the back-office order ?

Best Regards.

[Manish Mittal · Accepted solution]

Hello @mhenry13400 

After order placed you have to check in below tables instead of quote:

• sales_order;

• sales_order_address;

• sales_order_aggregated_created;

• sales_order_aggregated_updated;

• sales_order_grid;

• sales_order_item;

• sales_order_payment;

• sales_order_status_history;

• sales_order_tax;

• sales_order_tax_item

[mhenry13400]

Hello,

Thanks for the answer, so in magento 2 an order with (state, status) = complete does not have an entry in quote table ?

Best Regards.

[Tarandeep Singh · Accepted solution]

@mhenry13400 

To answer your question. In Magento once an order is placed, entries from the quote table get delete by Magento cron in sometime.

So what you are seeing it normal.