<div>
Several ways.<br />
<br />
1) You can use some existing plugin, likely an extended profile manager or form system, then write code to transcribe your current data into the table schema used by the plugin.<br />
<br />
2) You can keep your same schema + write a plugin to access your schema.<br />
<br />
3) You can use a combination of #1 + #2.
</div>


<div>
This requires some set up: <br><br>Representatives are <a href="https://www.wpbeginner.com/wp-tutorials/how-to-create-custom-post-types-in-wordpress/" rel="ugc">Custom Post Types</a><br>The countries are <a href="https://www.wpbeginner.com/wp-tutorials/create-custom-taxonomies-wordpress/" rel="ugc">Custom Taxonomies</a><br>The Meta: Name, address, website etc Use <a href="https://www.advancedcustomfields.com/" rel="ugc">Advanced Custom Fields</a><br><br>Create your select/dropdown by <a href="https://codebriefly.com/display-wordpress-custom-taxonomy-dropdown/" rel="ugc">looping through the Taxonomies</a>.
</div>


<div>
I'm sorry both suggestions are foreign language to me.&nbsp;&nbsp;
</div>


<div>
@Irollins, <br>What you are wanting to do requires someone with deep WordPress development knowledge. Do you have someone like that on your team? Someone who's built a <strong>custom theme</strong> and can code?
</div>


<div>
Are you only looking for a rep list or are you trying to move your entire site with products and services etc?<br><br>There are multiple ways to get what you want for that search. Plug ins for one &nbsp;<a href="https://wordpress.org/plugins/search/store+locator/" rel="ugc">https://wordpress.org/plugins/search/store+locator/</a><br><br>If you set your site up as part store part blog using Woo Commerce <a href="https://woocommerce.com/," rel="ugc">https://woocommerce.com/,</a> there is an option for a locator as well <a href="https://demo.wpexperts.io/store-locator-for-woocommerce/?product_id=97" rel="ugc">https://demo.wpexperts.io/store-locator-for-woocommerce/?product_id=97</a><br><br>There are plenty of options to do this client side with javascript too and no database required.<br><br>&nbsp;<br><br><br><br><br><br>
</div>


Developer & Coffee Roaster

Scott Fell

<div>
<div class="content wysiwyg-content fr-view">
We are redoing our website using WordPress format. &nbsp;On the current website we have a database that contains our Rep List. &nbsp;I've provided the link below.<br><br><a href="http://morrisontexmach.com/contact-world.cfm" rel="ugc">MTMCo Worldwide Representatives (morrisontexmach.com)</a>&nbsp;<br><br>Does anyone have any suggestions on how I can do this on our new WordPress formatted website??
</div>
</div>



We are redoing our website using WordPress format.  On the current website we have a database that contains our Rep List.  I've provided the link below.
MTMCo Worldwide Representatives (morrisontexmach.com)
 
Does anyone have any suggestions on how I can do this on our new WordPress formatted website??

Setting up database for rep contacts on WordPress website

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

WordPress is a free and open-source content management system (CMS) based on PHP and MySQL for creating websites and blogs. Features include a plugin architecture, a template system and strong management, customization and search systems; through its dynamic presentation of content, webmasters have the flexibility to create websites easily.