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. When is the ‘post_content_filtered’ column in database cleared by WordPress?
  13. Where is the old post permalink slug stored?
  14. How can I safely increase the character limit for post passwords?
  15. How to Group Posts by the First Letter or Number?
  16. Restore contents of deleted user
  17. How are terms connected with posts in database?
  18. Moving WordPress to new server: no posts found
  19. Search & Remove Specific Shortcode From All Posts
  20. WooCommerce – Create Products Programatically [closed]
  21. How do I write this SQL statement for Posts written in last 24 hours?
  22. Custom Taxonomies Incorrectly Counting Revisions?
  23. WooCommerce – Query for ordered products
  24. database columns: post_title vs post_name
  25. Sanitizing `wp_editor();` Values for Database, Edit, and Display
  26. Tons of Twitter rows in my database
  27. Importing New Posts from Live Site into Local Dev Site
  28. How much of my site can I recover from public_html?
  29. How to store an extra (surrogate) ID when creating a post with wp_insert_post?
  30. Tags to Post-ID mysql query. Tag Search
  31. Multiples Empty Posts were created and cannot delete them
  32. How to delete all the content of a wordpress site without deleting the Post and pages?
  33. Extracting post categories
  34. Insert woocommerce products programmatically with featured image and gallery
  35. Problem with adding programmatically woocommerce product post into category
  36. After database migration, posts not showing up in dashboard
  37. Skip in WordPress Post ID’s, can this cause issues?
  38. Get user categories with most posts in it
  39. MySql query to get posts with all meta and terms
  40. Can’t update old posts 3.5.2
  41. Custom order for Mysql array
  42. Copy post to separate database with “add_action(….)”
  43. List authors with the last post title and order by last post date
  44. When open add new post or page WordPress add post with ID=0 continuously [closed]
  45. Anyone know why wordpress converts some html entities to their numeric equivalents?
  46. How to Mysql select a list of posts with meta_values AND all relevant categories?
  47. Order posts alphabetically: how to set order=asc in mysql query?
  48. why there are so many posts whoes post_type is revision? will these records waste too much database space?
  49. Delete all drafts?
  50. Get posts and include taxonomy term
  51. Why my wp_posts data is so huge?
  52. Add field to user meta table in database when link is clicked
  53. Delete post revisions only for a single post
  54. wp_posts table extremely large
  55. Saving Post Data in Another Database
  56. Queries take 120+ seconds on my large WordPress site
  57. Database hacked – random posts are modified
  58. How do post IDs work in WordPress?
  59. Get author posts count after excluding a category
  60. Import custom database into wp and keep the post id
  61. why the posts queried from sql is more than those showed on the page?
  62. Moved to a new server, backup was a day old and missing 3 posts, anyway to recover them from old host?
  63. Is there a function to get post info for any publish_status by post ID?
  64. Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”
  65. How Can I Always Display A Particular Post First Using WP_Query?
  66. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  67. Deleting post tags removes categories
  68. How can I globally italicize list of texts in the UI database or Posts? [closed]
  69. Return records between two meta datetimes saved as strings
  70. Target only single product page
  71. Get category slug of the Parent category of a Product
  72. My website is showing today’s date instead of published date since db migration to a new wordpress
  73. MYSQL: Create SQL query to search for string and replace
  74. Query to fetch custom taxonomy along with post title
  75. How to fetch courses in all languages in WordPress?
  76. Mysql update menu_order problem
  77. How to distinguish pages created by woocommerce?
  78. Disaply products from category
  79. Is there a way to save different data when USER interacts with the same POST?
  80. Add postmeta to all blog posts
  81. How can I stop ‘in use’ message from intermittently blocking my wp_posts table?
  82. ‘posts’ table should not store the absolute image path
  83. Dev and prod on the same database- dev version active for IOS
  84. load post data into mysql
  85. how i show manual data in a post
  86. Clean up customize_changeset in DB
  87. How do I get a certain set of posts from the database?
  88. Maximum number of posts per page before affecting performance?
  89. Surrogate ID for posts, is there an alternative field in the posts table?
  90. Expired Post with More Recent Time Stamp?
  91. I moved my site to another server, wp admin works so does the front page, but posts don’t work
  92. Extra field in wp_post instead of postmeta
  93. Voting System, database connections?
  94. FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
  95. Load posts from external source if not found in database
  96. How to create a post based on data in a table?
  97. Wp_query WooCommerce products
  98. If meta_key exists then don’t select this post?
  99. Restore posts, but only posts that exist in my database backup
  100. Change permalinks in posts via SQL