Setting product order as completed in DB
Setting product order as completed in DB
Nov 7, 2022 12:00 AM (5 months ago)

# Setting product order as completed in DB

When you need to test some quick scenarios when working on My account, there is quite offen need to set order as completed so that you can test some scenarios. It is quite inconvenient, to do this by changing the order in Admin, so there is quicker way, that this can be done.

There are two tables in DB where the order status can be changed. The tables are sales_order and sales_order_grid

Query's are:


select * from sales_order where entity_id = 'order ID number'
select * from sales_order_grid where entity_id = 'order ID number'

And update the status of order to complete