Quotidien Shaarli
10/28/24
The SKU (xxx) you are trying to insert is already under processing [woocommerce_rest_product_not_created] error · Issue #51412 · woocommerce/woocommerce
{"code":"woocommerce_rest_product_not_created","message":"L\u2019UGS (1-XXXX) que vous tentez d\u2019ins\u00e9rer est d\u00e9j\u00e0 en cours de traitement","data":{"status":400}}
And no UGS in product page of woocommerce.
Because I had the same issue, the SQL requests. Make a backup. :
-- Check
select * from wp_postmeta left join wp_posts
on wp_postmeta.post_id = wp_posts.ID
where wp_posts.ID IS NULL;
-- Delete
delete wp_postmeta from wp_postmeta left join wp_posts
on wp_postmeta.post_id = wp_posts.ID
where wp_posts.ID IS NULL;
Delete orphan variation
-- Check
SELECT * FROM `wp_posts` o
LEFT OUTER JOIN `wp_posts` r
ON o.post_parent = r.ID
WHERE r.id IS null AND o.post_type = 'product_variation'
-- Delete
DELETE o FROM `wp_posts` o
LEFT OUTER JOIN `wp_posts` r
ON o.post_parent = r.ID
WHERE r.id IS null AND o.post_type = 'product_variation'
Pense-bête :
https://xxxxx/?XDEBUG_TRIGGER=StartProfileForMe
Starts a xdebug session, can be loaded with intellij ultimate or phpstorm