I’d like to present a quote to users in a contact form based on a lookup of a few hundred items. Not products just one or two columns of data values and returns a price.
e.g. they wildcard search for Brand: “Sony”, Model:“PS360” and they get a quote of “$10000” displayed in the form. Then proceed in completing the form to email based on the quote.
Can’t find what I need in any condition logic contact form builders. Ideally the data is stored in a csv we can update quotes, but for now it’s just MVP. I’m looking for the simplest solution to try it out.
If there’s an easy tutorial on how to store and retrieve custom SQL data inside of Shopify I can’t find it. I’m newer to liquid though as well as the limitations of the walled garden. If any one can point me in the direction of a basic way to do that or an app solution I’ve over looked it would be much appreciated.