Cross Reference Search

New Member
1 0 0

I am hoping to incorporate a cross reference search in my store. Where customers can type in a competitive part number and our equivalent product would appear. I have an extensive database with this information (an excel document) but I am not sure how to incorporate it into the website. I would also need to be able to easily update it as our database grows. 








Just thinking about this in a technical perspective.

Things you'd need to build:

  1. a web accessible database using a proper database technology
  2. a method to manage and modify that database as easily as possible for you, whether its add, update, delete, or recreate (depending on your use case)
  3. code that connects to read the database and filters based on the user input

There maybe some alternative methods, like directly connecting to the excel/csv file and searching and parsing, but it's likely you'll need some server side backend code to read the csv file and search for the user input. Alternatively you can load the csv file onto the site and search through with frontend javascript, but if it's a huge file, I'd recommend against that.


Let me know what you think,

We specialize in data analytics. If I've helped you today, please give our give our app a try (30-day free trial) and maybe write a good review.
Send me a message if you want a free data analysis consultation.