I have a post in my wordpress website, which has lot of custom fields.
I also have an excel sheet with “post link” – “custom field data” combination.
That custom field(video url) is already set for each post, But now i need to change and update those links appropriate to excel sheet. I do not have a
“post_id – post metadata” combination, just link and appropriate metadata value.
Is there a way to update these data with some plugin or code?
You need to write and execute a WP command.
Save your spreadsheet as CSV file and use fgetcsv() to iterate through it. For each entry find a post using url_to_postid() and update the metadata as needed.