cancel
Showing results for 
Search instead for 
Did you mean: 

Search for Products based on a Part Number without a Direct 1 to 1 Relationship

Search for Products based on a Part Number without a Direct 1 to 1 Relationship

I've had 2 different developers say they can do this, but cannot seem to make this work.

 

Fitment Table: Year, Make, Model, Application, Fitment ID

 

Magento Product: Fitment ID is a field on the Magento Product level that will list the Fitment IDs it will fit.  This can be any value, and any number of values, defined completely separately from the Fitment ID in the Fitment Table.

 

The relationship between the Fitment Table and the Magento Product is not a 1:1 relationship. 

 

When selecting a Year, Make, Model, the Fitment ID will be the search criteria to pull ALL Magento Products that match this Fitment ID. 

1 REPLY

Re: Search for Products based on a Part Number without a Direct 1 to 1 Relationship

That is definitely possible but its implementation is the most important aspect (as always!).

You should ensure that the performance is good when you customize Magento at that level.

I've seen that customization in projects that implement a custom search by width/height/etc.

 

Good luck!
Best regards.
Gabriel

If my answer was useful, please give "Kudos" to this post.
If my answer helps you to resolve the problem, click on "Accept as Solution".