Whats best way for filtering shop items

Question

how amazon filters items?
It uses sql or php?

Answer 1

In question title you wrote filtering shop items, then in Description you mention filter transition. You also mentioned in websites they use number instead of text; which websites? they use number instead of text for what? and what this csv you wrote for translating numbers?
If possible rephrase your question to add clarity so people can help you with it. I'm sorry but I feel confused by the question, though I do want to help, it's hard to understand what you mean ...