Cross Reference Search

Highlighted
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. 

 

Thanks!

 

 

0 Likes
Shopify Partner
46 3 10

Hey,

 

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,

ui-gab
Vancouver, BC Canada
https://www.uiavenue.ca
uiavenue.help@gmail.com
We specialize in Shopify App Development. If you need help just reach out.
0 Likes