Restore woocommerce orders

It’s Simple.

Step 1: Create a replica of the instance.

Step 2: Import the old .sql file which contained one day lost orders data.

Step 3: Use https://wordpress.org/plugins/woocommerce-simply-order-export/ plugin and export CSV or XML of 1 day data which you have lost.

Step 4: Install the above plugin in the LIVE instance and import the CSV or XML generated.

That’s all.

Related Posts:

  1. Manually removing revision post types
  2. Reset/Reorder posts ID in the MySQL wp_posts table
  3. How do I find which articles are missing a featured image in The WordPress database?
  4. Remove a shortcode from all WordPress posts
  5. What do these phpMyAdmin errors mean on my WordPress databaes?
  6. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  7. How to select particular month post from table and update the post status using MySQL?
  8. Bulk find & replace on WordPress posts/pages (minus image paths)
  9. SQL trigger failes with post_content
  10. Converting Posts to Pages
  11. How to change the publishing date of each posts?
  12. How to manually delete post from database without causing conflicts?
  13. WordPress Local And Live Site
  14. Can’t update old posts 3.5.2
  15. Custom order for Mysql array
  16. Copy post to separate database with “add_action(….)”
  17. List authors with the last post title and order by last post date
  18. When open add new post or page WordPress add post with ID=0 continuously [closed]
  19. How do I change the core post search algorithm? Where is it found/constructed?
  20. wp_posts table: safely remove unused columns to save database storage
  21. Anyone know why wordpress converts some html entities to their numeric equivalents?
  22. How to Mysql select a list of posts with meta_values AND all relevant categories?
  23. Order posts alphabetically: how to set order=asc in mysql query?
  24. Show posts count for Categories and Tags in wp_nav_menu
  25. why there are so many posts whoes post_type is revision? will these records waste too much database space?
  26. Delete all drafts?
  27. Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
  28. Is it possible to use WP_Query to only pull posts with attachments?
  29. Get posts and include taxonomy term
  30. Why my wp_posts data is so huge?
  31. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  32. Add field to user meta table in database when link is clicked
  33. update image path with words starting uppercase to lowercase chars
  34. How safe is it to delete old posts edits to save database space?
  35. Delete post revisions only for a single post
  36. Move posts from a non-wordpress site to wordpress
  37. wp_posts table extremely large
  38. How to Assign / Move all Deleted post to a category
  39. Display post number by category
  40. Saving Post Data in Another Database
  41. Queries take 120+ seconds on my large WordPress site
  42. Database hacked – random posts are modified
  43. Is it possible to automatically publish a post once a woo-commerce product is published?
  44. Need to change all links in page content but not in post content
  45. Can’t update WordPress Page if post_content is Empty
  46. How do post IDs work in WordPress?
  47. Why when I create a new post I found 2 record related to this post into the posts database table?
  48. Get author posts count after excluding a category
  49. Update field in database for users
  50. Import custom database into wp and keep the post id
  51. why the posts queried from sql is more than those showed on the page?
  52. get last post’s link with SQL query
  53. Moved to a new server, backup was a day old and missing 3 posts, anyway to recover them from old host?
  54. Is there a function to get post info for any publish_status by post ID?
  55. query for filtering published posts?
  56. Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”
  57. How Can I Always Display A Particular Post First Using WP_Query?
  58. Help on conditional statement to accompany wp_insert_post function please?
  59. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  60. Deleting post tags removes categories
  61. How can I globally italicize list of texts in the UI database or Posts? [closed]
  62. Is it possible to modify posts table to only read for more recent ones?
  63. Return records between two meta datetimes saved as strings
  64. WP query taxonomy optimization
  65. Target only single product page
  66. Get category slug of the Parent category of a Product
  67. Menu Items disappearing/being empty on save or post edit
  68. My website is showing today’s date instead of published date since db migration to a new wordpress
  69. MYSQL: Create SQL query to search for string and replace
  70. Query to fetch custom taxonomy along with post title
  71. How to fetch courses in all languages in WordPress?
  72. How to setup default value of post_id
  73. Deleted products from woocommerce are still in the database
  74. Mysql update menu_order problem
  75. Prevent a post with a specific ID from being created
  76. Reusing old post IDs
  77. How to distinguish pages created by woocommerce?
  78. Trigger on DB make problem on wordpress?
  79. WordPress MySQL Search and replace with wildcard?
  80. Disaply products from category
  81. Comments are in database, don’t show up in WordPress backend or frontend
  82. Is there a way to save different data when USER interacts with the same POST?
  83. Add postmeta to all blog posts
  84. How can I stop ‘in use’ message from intermittently blocking my wp_posts table?
  85. Show code only on WooCommerce Pages
  86. ‘posts’ table should not store the absolute image path
  87. Dev and prod on the same database- dev version active for IOS
  88. load post data into mysql
  89. More Than 50K Categories and WordPress Admin Panel Stop Showing Categories and Posts
  90. how i show manual data in a post
  91. Clean up customize_changeset in DB
  92. How do I get a certain set of posts from the database?
  93. Maximum number of posts per page before affecting performance?
  94. Surrogate ID for posts, is there an alternative field in the posts table?
  95. get backup file from wordpress database in x days
  96. Expired Post with More Recent Time Stamp?
  97. I moved my site to another server, wp admin works so does the front page, but posts don’t work
  98. Can’t seem to replicate permalink structure for localhost development site
  99. Extra field in wp_post instead of postmeta
  100. Voting System, database connections?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)