Quote from Jacob on April 19, 2025, 17:29

Hello,

I get different counting entries when using BEAR Bulk compared to my own SQL queries.

After the plugin has loaded.

But when I do SQL-queries like:

SELECT COUNT(*) AS total_skus
FROM wp_postmeta
WHERE meta_key = '_sku';
"
+------------+
| total_skus |
+------------+
|       1133 |
+------------+

SELECT COUNT(*) AS total_variations
FROM wp_posts
WHERE post_type = 'product_variation';
"
+------------------+
| total_variations |
+------------------+
|             1514 |
+------------------+

Can you please tell me which EXACT SQL-query BEAR Bulk is doing when using the above setting to list entries?

I am troubleshooting a thing and need to compare the queries for an issue in the web shop with SKU's.

SELECT COUNT(*) AS total_skus
FROM wp_postmeta
WHERE meta_key = '_sku';
"
+------------+
| total_skus |
+------------+
|       1133 |
+------------+

SELECT COUNT(*) AS total_variations
FROM wp_posts
WHERE post_type = 'product_variation';
"
+------------------+
| total_variations |
+------------------+
|             1514 |
+------------------+