Create Responsive Searchable Parts Catalog for Wordpress Site

We have a client who has a Heavy Equipment Parts business. He has a catalog of over 200,000+ parts that he wants to put online. We have Linux / Apache hosting and are planning to use Wordpress to build out the rest of the site. This needs to be displayed within the Wordpress site, but can have its own admin / back-end if absolutely necessary. We would prefer to import/export through Wordpress back end if possible. We also need search functionality to search the catalog.

The interface would be similar to: [url removed, login to view] . Do a part search for "all locations" for part # TY21764. You will see how many are in stock. If you hover over "all locations" in the search result, you will see how many are at each locations. We need something similar.

We need something similar with the following specs.

1. Must be able to search parts by part number (example: TY21764) , a portion of part number (example: TY21 or 1764)

2. Would like the ability to do both soft and hard searches. As long as you search for “ABCD” and you get results for “xxxABCD”, “ABCDxxx”, and “xxxxABCDxxxx".

3. There needs to be rules put in place so that someone needs at least 4 characters to do a part search. If not a warning will come us "Your Part Number must contain at least four characters to perform a search" This is similar to what happens with [url removed, login to view]

3. Must be be able to search words in description (example: excavator cylinder Case CX130) and words do not need to be in exact order (similar to Google search)

4. Disclaimer reflects 24 hour update to database. We will import inventory numbers every 24 hours. We will not have a live inventory feed. We need to have the field names in the online database match the field names in our in-house inventory database for easy importing. We need to be able to import this data as CSV file. This main file will have 150,000+ parts.

5. About 50,000 parts in our catalog are not part of our own inventory. Instead they are drop-shipped from our suppliers. They need to be "in stock" at all times. We need rules for these and may show then as having "2" in stock at all times, for example, These will come in CSV as separate feeds, which also need to be imported into our online catalog. We do not need to adapt these INSIDE the database. Instead, we need a method to convert them before they are imported. For the purpose of this quote we will estimate that we have 2 such separate feeds of 25,000 each.

6. THERE WILL BE NO ECOMMERCE OR SHOPPING CART. Instead of "add to cart" we will have a "Reserve Part" button, which will go to a page similar to shopping cart where the buyer confirms the part(s) they need and puts in their name, email address, and phone number. This will be an email form that goes to the client.

7. We also need a record of each "Reserve Part" request to be stored in our database. We need the ability to export these names and requests.

8. We need the database download quickly, and do searches quickly.

9. The interface must be responsive. Buyers need to be able to do these searches out in the field on their tablets or smart phones.

We will provide you with a development server, ftp login info, and a basic copy of Wordpress with a theme applied.

Thank you for your help with this.

Skills: Engineering, MySQL, PHP, Software Architecture, Software Testing

See more: wordpress theme software development, wordpress ecommerce theme development, wordpress development software, where you search order for software development, use wordpress online, the parts house, theme development for wordpress, stock buyers, software for wordpress development, show how we can create a site, see your site responsive, search for wordpress, search for buyers, purpose of use case, php for wordpress development, parts inventory database, parts database example, parts buyer, online help with wordpress, online for suppliers, online export import business, online export buyers, online export business, import export online business, how to search buyers for export

About the Employer:
( 131 reviews ) Pittsburgh, United States

Project ID: #6094574

37 freelancers are bidding on average $1414 for this job


We are a team of designers and developers with expertise and experience in Web designing, HTML, CSS, PHP, AJAX, JQuery, XML, Wordpress, Bootstrap, CodeIgniter and MySql. We have developed many custom sites and applicat More

$1184 USD in 20 days
(898 Reviews)

Hello, We have read the project requirements in complete detail. We have noticed that you are seeking highly skilled and expert professional personnel to create responsive searchable parts Catalog for Wordpress webs More

$1340 USD in 20 days
(154 Reviews)

Hi There, We are an ISO 9001:2008 certified company based in India. With over 10 years of experience serving clients across globe and a workforce of over 50 developers, we have till date delivered over 1,000 project More

$1546 USD in 30 days
(95 Reviews)

Dear Sir, I can make this website for you in Wordpress with full data Import and Export options so that you can update your products data in bulk too. I am an expert in website development with over 13 years of e More

$1400 USD in 20 days
(231 Reviews)

1. Donation Site We already designed and developed a wordpress based site for donations in which we implemented paypal and paypal pro to take the payments from credit cards with a complete registration of donating per More

$1427 USD in 22 days
(89 Reviews)

Hi, if no shopping cart nd checkout page you want on site so you also not want any payment getway on site. all product data is added by backend admin ? waiting for your response. Thanks

$2061 USD in 45 days
(98 Reviews)

Hello Sri Technocrat will provide fully interactive website for your project. As per the detail, Sri Technocrat will provide three template functional schemes and sample pages to make your choice for layout. It will More

$1157 USD in 40 days
(55 Reviews)

Hello sir, my name is Evgen and iam Wordpress developer. Id like to offer you my services in part system development. i have more 200 good reviews in dev projects, so all will be done on highest level. If you intereste More

$1578 USD in 20 days
(222 Reviews)

Hi,we have good knowledge in wp as well as we work long time in php .. and we know how to handle heavy db and search optimization .. Just see some of url which we had done eco More

$1684 USD in 10 days
(151 Reviews)

____________ END THIS JOURNEY HERE _____________ __________________________________________________ Hi, this is not a project for WP unless you want to have a mess in the mid-long term. You have to use a framework More

$4444 USD in 45 days
(59 Reviews)

Hello, I am a professional programmer for web programming with php language to build the system website, Besides, I also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer https://www.freelan More

$1546 USD in 20 days
(127 Reviews)

I've built many sites like this before! Custom sites, All programming languages and database types. Sites include administrative back end systems.

$1263 USD in 20 days
(29 Reviews)

Hello, I am ready to do that [Samples of what I did before close to what you need] [My Data] http://tarekahmedlancer. More

$752 USD in 10 days
(68 Reviews)

Hi, We have a rich experience in wordpress development and have completed many successful projects. Please review our some latest projects using the below URL Wordpress Projects More

$1157 USD in 35 days
(48 Reviews)

!!!!!!!Hi, Hire expert Responsive WordPress Developer from ONE STOP Company for Web Design, WORDPRESS, and SEO Services. We have designed and built websites for various types of businesses very effectively. We work wit More

$1263 USD in 20 days
(99 Reviews)

Thanks for your detail post and descriptions. We have reviewed the same and have some queries which need to be clarified as: 1. Would like the ability to do both soft and hard searches. As long as you search for “ABCD” More

$1400 USD in 23 days
(38 Reviews)

Hi, I am sure i can help you with this project but i will need more details. Please let me know when you are available to talk about this. Regards

$1443 USD in 20 days
(28 Reviews)

i go-though and would like to discuss in detail, i understand that you want Harvey website with 200000 parts, i want to discuss about "Reserve Part" button. We are expert to do this. Than More

$1500 USD in 45 days
(10 Reviews)

Hello, Thanks for sharing your post,I can see you want an expert you who could create a site that allows users to search parts by part number , ability to do both soft and hard searches.,able to search words in des More

$1578 USD in 29 days
(46 Reviews)

Responsive site ( Bootstrap) http://www.sjb More

$1578 USD in 24 days
(48 Reviews)