Skip to main content
Magento 2

Magento 2 – Mark an order as complete via the database

By May 11, 2021August 16th, 2023No Comments

Magento 2.4 seems to have an issue with marking part refunded orders as complete even after invoicing and credit memos have been created. It seems that if a customer ordered 5 of an item and only 4 were in stock, it’s always a struggle to mark an order complete and it remains pending. This only happens with partial refunds, not full refunds or any other orders.

 

Until a fix can be found I’ve been setting the order status for partially refunded orders to complete directly in the Magento 2 database.

 

Solution to marking Magento orders complete

Find your order entity_id via the Magento admin. This should be the first number in the url of that order in Magento admin.

Then using PHPMyAdmin login into your db admin panel and look for that entity_id in the two tables below.

The tables are ‘sales_order’ and ‘sales_order_grid’

 

 

sales_order_grid

 

 

Then manually change the status from pending to complete. I hope that helps.

Andrew Taylor

A senior UI designer with over 25 years of web design and web development experience working for some of the largest companies in the UK. An expert in all things Magento and WordPress.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.