Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Best Practices for Creating a Year Make Model Search Widget
 
webdbapps
Jr. Member
 
Total Posts:  9
Joined:  2012-04-06
 

Hi,

I have a table in MySQL with the SKU and all related year, make and model matches for each product.  I need to implement a search feature that queries this table for the input values from the search form and returns the products that matches these inputs.  What are the best practices for implementing this type of search widget?

 
Magento Community Magento Community
Magento Community
Magento Community
 
markoshust
Sr. Member
 
Avatar
Total Posts:  129
Joined:  2007-09-05
Cleveland, OH
 

besides putting in a foreign key constraint as well as standard indexing… not sure if there are any other best practices besides your standard database normalization

 
Magento Community Magento Community
Magento Community
Magento Community
 
webdbapps
Jr. Member
 
Total Posts:  9
Joined:  2012-04-06
 

Mark,

Thanks for your response. What table should be set as thectargetbfor the foreign key relationship?  Are therevanynotherbjoings in the query that need to link us to the product ID?

Take care,
Sid

 
Magento Community Magento Community
Magento Community
Magento Community
 
webdbapps
Jr. Member
 
Total Posts:  9
Joined:  2012-04-06
 
mageshopexpert - 23 March 2013 06:38 PM

You shouldn’t change any foreign key in magento, you should use magento api.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top