Similar products — how to create a block?

Guys, tell me - not theme specific. The theme of the website spare parts and machinery. IPhones are not that hard to pick up a similar.
1. We have directories, sub-divisions in them - the technical nature of Ki is written only in the table not fields. There is no possibility to choose the character of Cam products. The first word or item to pick up?
2. On what principle do you derive this unit? Products will vary in the block or needs to be static - once printed out and recorded the details of the goods in this unit?
From the point of view of seo-linking properly will be static to put the goods, or the algorithm will be to offer every time other similar products, to change?
Thanks for your tips, very helpful
June 14th 19 at 20:49
2 answers
June 14th 19 at 20:51
Can be implemented in different ways. If you have database features are buried in separate fields or separate records in the table then you can write a script with an intelligent logic, which he will pick
similar in certain characteristics of the goods. This approach is most reasonable in those cases, if you have a large number of items in the database and they are frequently replenished. If the goods are not many, you can manually "link" commodities among themselves, i.e. for each item you add links like in your opinion, is this approach more flexible, but requires the time to add references and support links up to date when adding new products.
Thank you for the advice. but we have about 45K of goods on the website, we physically can not relink them together (( - nikita.Stracke commented on June 14th 19 at 20:54
well , then you will approach the first of the proposed variants. - peter.Armstro commented on June 14th 19 at 20:57
Eugene thanks, addressed to provera. Will think how to do! - nikita.Stracke commented on June 14th 19 at 21:00
June 14th 19 at 20:53
Similar products in the same category as the current and with a minimum difference in characteristics relative to the current (unit the difference should be minimal).
Two options:
1. Or a selection from the table of characteristics (which is better and more correct) contained in the database and display products with minimal difference.
2. Or a separate file containing all similar items for a specific (but it is worse since the update constantly by hand - impossible).

Find more questions by tags Search engine optimization