missing order_key for imported orders
-
I have imported orders successfully, but the imported orders seem to be missing an order_key. Has this been seen before?
I have noticed it because download links on a My-Account > Order page are broken. If I log the order, I can see that order_key is blank.
-
The problem is that the import didn’t add meta_data to the order with the key _order_key. (It *did* correctly add an order key to the order itself.)
For others who may come across this, I was able to fix it with this SQL statement, which fixed over 59,000 orders in about 33 seconds (the
post_passwordcolumn is where Woocommerce stores the order_key):
INSERT INTOwp_postmeta(post_id,meta_key,meta_value)
SELECT
wp_posts.ID,
'_order_key',
wp_posts.post_password
FROMwp_posts
WHEREpost_type= 'shop_order'
AND NOT EXISTS(
SELECT 1
FROMwp_postmeta
WHEREpost_id=wp_posts.ID ANDmeta_key= '_order_key'
)
The topic ‘missing order_key for imported orders’ is closed to new replies.
