Get WordPress Multisite blog_id by blog's path using wp-cli

You have a csv file has this format (mycsv.csv):

path,some_field
somepath,some_value
anotherpath,another_value
...

and you want to get the blog_ids of those path(s). This following bash shell will help you to get blog_ids by taking advantages of wp-cli, get_blogid_from_url.sh:



$ chmod +x get_blogid_from_url.sh
$ ./get_blogid_from_url.sh mycsv.csv myblog.com /wordpress/path > result.csv

The result will be something like:

546,myblog.com/somepath/
456,myblog.com/anotherpath/
...