Create Directory of "People Listing" in ~20K Companies

This topic contains 42 replies, has 3 voices, and was last updated by  Alex Rollin 5 years, 2 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #518804

    Travis Saw
    Expired Member
    Post count: 21

    Hi

    Just bought the script, but I’m very new to WPGeodirectory, I need a summary of steps to achieve below:

    We aim to create “People Directory” like https://www.zoominfo.com/companies-search/location-singapore instead of ordinary business directory like YellowPages / Yelp
    Our Database size: 50K – 100K rows of contacts (Most of contacts has fields: Company Name, Url, Contact Name, First Name, Middle Name, Last Name, Title, Address 1, Address 2, City, State, Zip Code, Country, Phone, Fax, Employees, Revenue, SIC Code, Industry Type, Email Address)
    The treemap of this “People Directory” is to have:
    1. A list of Industry in main page
    2. Under Industry, a list of Company Names
    3. Under Company Names, a list of Employee Names
    4. Searchable by Industry, specific Company Name, Job Function, Firmographic (by Employee Size & Revenue) – see example search box: https://us.kompass.com/

    Main objective is to have this page: https://www.zoominfo.com/pic/wilmar-international-limited/346781840 whereby it display a list of Employee Names & contacts

    Can I know, what steps that I need to take, to achieve the above?

    #518823

    Alex Rollin
    Moderator
    Post count: 27815

    Hello,

    To link a People CPT to the Company CPT you will want to use a “Link Post” field from the Custom Post Type addon.

    Each CPT can have it’s own template for the Details and Archive Item formats.

    https://wpgeodirectory.com/docs-v2/addons/custom-post-types/
    https://wpgeodirectory.com/docs-v2/templates/

    Fields can be added as described here:
    https://wpgeodirectory.com/docs-v2/places/custom/

    #518827

    Travis Saw
    Expired Member
    Post count: 21
    This reply has been marked as private.
    #518838

    Kor
    Moderator
    Post count: 16516

    Hi Travis,

    Thanks for your reply. You can refer to the instructions here https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/#recommended and I hope it helps.

    #518839

    Travis Saw
    Expired Member
    Post count: 21
    This reply has been marked as private.
    #518843

    Alex Rollin
    Moderator
    Post count: 27815

    There are several ways to do it, please see this list to get started:
    https://wpgeodirectory.com/docs-v2/places/custom/#why

    #518845

    Travis Saw
    Expired Member
    Post count: 21
    This reply has been marked as private.
    #518944

    Alex Rollin
    Moderator
    Post count: 27815

    Try adding GD Output Location to the GD Sidebar in the WP Widgets page.

    Then visit your custom fields and set your field to display in the Detail page sidebar.

    You have added widget to the GD Top widget area, you probably want to move those to a different widget area.

    #518946

    Alex Rollin
    Moderator
    Post count: 27815
    This reply has been marked as private.
    #518973

    Travis Saw
    Expired Member
    Post count: 21
    This reply has been marked as private.
    #518975

    Alex Rollin
    Moderator
    Post count: 27815

    1. You can import them in the same CSV, but I don’t think that is what you will want to do. There will be a field created for each Link Post field, and if employee post ID 7 is linked to Company post ID 12, then 7 will show in the company and 12 in the employee. You probably want to import both of them and then export them again to match them. I would recommend you add a field like ‘company_key’ and store the company there to match them after import.

    2. If you are using WP All Import for that, make sure the field is mapped. If it doesn’t work we can take a look at the issue when the developers are back in the office.

    3. The same way I described above, using the Show in Output Locations, or with tabs, or widgets.

    https://wpgeodirectory.com/docs-v2/places/tabs/

    #518977

    Travis Saw
    Expired Member
    Post count: 21
    This reply has been marked as private.
    #518978

    Travis Saw
    Expired Member
    Post count: 21
    This reply has been marked as private.
    #518986

    Alex Rollin
    Moderator
    Post count: 27815

    Are you using WP All import?
    You cannot update listings if you do not include the post ID in your import sheet. To get the post ID you would need to export the listings using the GD Export functionality.

    You can use the screen options to set paging on Places -> All to 200 and delete 200 at a time.

    Or you can use an action like this:

    
    
    
    function delete_all_posts_from_custom_post_type($cpt ){
        if($cpt){
            global $wpdb;
            $posts = $wpdb->get_results($wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE post_type = %s",$cpt));
            if(!empty($posts)){
                foreach($posts as $post){
                    wp_delete_post($post->ID,true);
                }
            }else{
                echo "done";
            }
        }
    }
    delete_all_posts_from_custom_post_type('gd_place');
    
    #518989

    Travis Saw
    Expired Member
    Post count: 21
    This reply has been marked as private.
Viewing 15 posts - 1 through 15 (of 43 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount