i want to delete orders in specific time period

Query on the ‘posts’ table. post type ‘shop_order’ and filter on the post_date column. Doing it in PHPMYADMIN may be better than SQL so you can see what you’re doing.

i have around 39000 orders in last several years so this is not “acceptable” as it looks like.

If I delete rows created up to specific date… in table posts.. will this do the job or should i delete also something else not to get any errors?

i need to reduce web so i want to delete all old products and old orders and pictures of old products..