carpenoctem

Your solution sounds better indeed 🙂 But I’m grasping to understand how to make it work for my job board.

Consider this:

North America
–––Mexico
Latam
–––Mexico
South America
–––French Guiana
European Union
–––French Guiana
MENA
–––Egypt
–––Israel
Africa
–––Egypt
Asia
–––Israel

The above are not exceptions. There are a lot of overlaps.

So, the issue is that I need various types of country groupings – geographical, political, business, economic. And I don’t see how they can be put in a single hierarchy.

Do I duplicate the countries somehow or is there a smarter solution?

Regarding Uzbekistan. It is part of Eastern Europe according to Wikipedia, but this can be challenged I guess 😅 Thanks for bringing this to my attention – I’m going to change it.

Ok, I figured it out. For anyone interested:

This is the snippet:

function iwpe01_get_company_id_by_name($company_name = '') {
    // If the input is empty, return nothing
    if(empty($company_name)) {
        return '';
    }

    // Try to get the post by title
    $query = new WP_Query(array(
        'title' => $company_name,
        'post_type' => 'companies',
        'post_status' => 'publish',
        'posts_per_page' => 1
    ));

    // If a post was found, return its ID
    if($query->have_posts()) {
        $query->the_post();
        return get_the_ID();
    }

    // If no post was found, return nothing
    return '';
}

This is how you call it in ImportWP (change 2 to your column):

[iwpe01_get_company_id_by_name("{2}")]

Well, it works the way it should work (relatively to the url), but I don’t think that’s good for me 🙁

When my url is http://example.com/music/page/3 it outputs http://example.com/music/page/3?artist=somebody
Is there a way to make it stick to the category, ignore the paging and output http://example.com/music?artist=somebody on every page?

Thank you very much! Works great!

Any ideas?