How to detect if a revision was made by woocommerce or wordpress?

Woocommerce uses the post_type product for products, so it should be easy enough to search for those instead of posts.

Just look out for the proper post_type.

You could filter the revisions using a self-joined select like this:

SELECT *
FROM `wp_posts` p1
LEFT JOIN `wp_posts` p2 ON (p2.post_parent = p1.ID and p1.post_type="products")
WHERE p1.`post_type` = "revision"
LIMIT 50

Still, I wouldn’t convert my revisions into posts nor anything like that. You’ll end up with TONS of garbage posts laying around.

Related Posts:

  1. How to select WooCommerce products by post_meta and order them
  2. Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
  3. Get WooCommerce product details and transfer them to a custom DB table
  4. Sum the total amount of a specific product purchased per user and display in table
  5. email alert for product availability
  6. WordPress WP_Query without query GET parameters
  7. Modify WooCommerce used to get all orders in dashboard
  8. Convert a column of a table containing an Array as response in HTML
  9. How to import woocommerce custom fields data into another site?
  10. append data to mysql table via submit button coded in php – not working
  11. How to set variable to specific field when querying
  12. Fatal error: Call to undefined function mysql_connect()
  13. the_date() not working
  14. How to return number of found rows from SELECT query
  15. How to correctly add Javascript in functions.php
  16. How to make WordPress plugin check for database changes and then do something?
  17. How to remove “out of stock” variation options from size dropdown in woocommerce?
  18. Woocommerce: How to override core functions in functions.php?
  19. Successful or Error Message after running mysql code in functions.php
  20. Get WooCommerce shipping methods programmatically
  21. Add a custom text field to WooCommerce admin product data “Variations”
  22. Translating add to cart woocommerce button [closed]
  23. PHP/MySQL issues when running WP on EC2 cloud [closed]
  24. WordPress get pagination on wpdb get_results
  25. Looking for most performant way to execute several similar WP queries within shortcodes
  26. Help with some php math in WordPress
  27. How do I display a user’s previous orders as a select box option on a product?
  28. Show MySQL errors that occur when I excute $wpdb->insert()
  29. combine Code 1 with Code 2
  30. Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
  31. Get updated query results on page after insert in database
  32. WordPress not reflecting changed of the database
  33. Automated Cart Update With Alert Box Each Time
  34. How can I fix WordPress installation errors?
  35. Two Different Links for Same Product – WooCommerce [closed]
  36. WooCommerce/WordPress: how hide entire table form after submit (Admin Dashboard)?
  37. Show prices with tax in Woocommerce Mini Cart [closed]
  38. Problem with custom plugin using AJAX to pull info from php file
  39. Woocommerce related product text
  40. Is it possible to intercept all ajax requests and get the parameters and the returns?
  41. How to make products with no cost in WooCommerce
  42. How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
  43. Hacked WordPress website /Homepage redirect [closed]
  44. Refresh table data with Ajax
  45. Database query works fine outside WordPress
  46. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  47. Help with a $wpdb MySQL Query
  48. How i can obtain all the post meta for a specific post as an array?
  49. Can’t Query Custom Table Using $wpdb Method
  50. $wpdb returns duplicate posts
  51. Update postmeta after theme switch
  52. Creating Database Table vs. Adding MetaData to Post & User
  53. Add product to cart for user – WC()->cart->add_to_cart [closed]
  54. Seo Friendly Filter URLs
  55. how can i add class or span tag at sprintf?
  56. Display attribute on shop page after the title
  57. WooCommerce – Moving Product Price to the Left of Add to Cart Button [closed]
  58. Where to copy woocommerce files to in my custom theme to avoid editing the core plugin?
  59. Have Woocommerce show product price if id, when not logged in
  60. Query the links Database
  61. WooCommerce Query Product Titles
  62. Display Results of SQL Query on WP site
  63. How to add a shortcode which runs a .php file for the current post
  64. Run a sql (update) after 12 hours after the user login. Woocommerce users
  65. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  66. How can I change the background color of divs dynamically (depending on an order-status in woocommerce)?
  67. Use Search Term in html link and redirect
  68. How to get content on a blank basket/cart page in a custom theme with woocommerce
  69. How to display MySQL table data which is stored as an array?
  70. WooCommerce REST API AJAX Auth – 401 response
  71. Looping through and combining calls to Woocommerce REST API
  72. Woocommerce – if selected attribute term equals
  73. split 1 cart item into instock and back ordered
  74. Adding a widget under an ‘Add to Cart’ button through a PHP snippet
  75. Woocommerce Related Product by 2 taxonomy
  76. Hide price excluding tax when price is empty
  77. Woocommerce variation with radio button + price
  78. Display text of price (minus 20%) on every product page in a sentence.
  79. WordPress WPDB::insert 13th param is always blank (only if format)
  80. Ajax not updating to database
  81. How do I prevent a folder from reappearing in my home directory?
  82. can’t delete a row from post_meta table
  83. jQuery doesn’t work in my php snippet
  84. MySQL query in WordPress with AJAX
  85. retrieve wordpress post-meta using php not wordpress functions
  86. Splash pages on a high traffic site
  87. How to add custom checkout field in user details mail template
  88. Add specific phrase after every product title including the discounted price? [closed]
  89. Display Sale Price Before Regular Price (WooCommerce)
  90. Submit cf7 form to cfdb as pdf/BLOB [closed]
  91. WooCommerce – Show ‘Sales’ badge on variable products where only some variations have sales price [closed]
  92. How to create a container in php then customise it in CSS
  93. Show button in header when product custom field is not empty
  94. WordPress 6.1.1 UTF8 Slug Limit Increase
  95. Woocommerce Convert existing order to the cart
  96. How to add SKU and remove product title from WooCommerce url?
  97. Product Search in search.php
  98. using custom pages for myaccount in woocommerce
  99. Putting form result in my database
  100. How can I update a value of a field depending on outside source?