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'

https://xxxxx/?XDEBUG_TRIGGER=StartProfileForMe

Starts a xdebug session, can be loaded with intellij ultimate or phpstorm

Pense-bête : commande console OSGI