Soon I will need to list ~100,000 parts on a 30bz site. This will be for ~1100 products that have ±100 parts each. If this goes well the number of parts will eventually reach about 500,000.
I want to list all ~100 parts for one product on one page with an exploded parts diagram of that product (ideally zoomable) so customers can figure out what part they need to order. The parts themselves have no description, only a short name (1 to 3 words -- think "washer", "bolt", "spring retainer", etc) and a 10 digit part number.
I do not want these 100,000 parts to appear in search results as it would make it impossible to find anything that isn't a part. That seems easy enough to do by setting "catalog only" for each part in the back office.
I have come up with two possible solutions for this but I may be missing something and would like some feedback:
Create a separate category for each product and put the ~100 parts for that product into that category. Then use @lesley's "Flex Layout Module" to enforce a custom layout for these category pages. This has an added benefit that there are a few key parts (1 or 2 per product) that we actually would like to appear in search results and this would allow us to do this.
Use product attributes. Create a "parts product" for each product we sell parts for. ~1100 "parts products" at first, eventually perhaps up to 5000. Each of these "parts products" would contain a single attribute ("part type") with ~100 different options to choose from.
Once again use @lesley's "Flex Layout Module" to design a custom layout for these products so instead of showing a huge dropdown list of 100 different choices it breaks them out onto the page itself with an "add to cart" button beside each attribute choice.
I'm not sure if I am explaining the above properly and I'm also not sure if either option is even possible. My questions though:
Assuming both options are actually possible is one better than the other?
Is having 5000 categories a problem?
How about having 5000 different products each with one product attribute containing 100 different options?
Is it realistic to use custom layouts like I described above?
Is there a better way to do this that I haven't considered?
Question
dynambee
Soon I will need to list ~100,000 parts on a 30bz site. This will be for ~1100 products that have ±100 parts each. If this goes well the number of parts will eventually reach about 500,000.
I want to list all ~100 parts for one product on one page with an exploded parts diagram of that product (ideally zoomable) so customers can figure out what part they need to order. The parts themselves have no description, only a short name (1 to 3 words -- think "washer", "bolt", "spring retainer", etc) and a 10 digit part number.
I do not want these 100,000 parts to appear in search results as it would make it impossible to find anything that isn't a part. That seems easy enough to do by setting "catalog only" for each part in the back office.
I have come up with two possible solutions for this but I may be missing something and would like some feedback:
Create a separate category for each product and put the ~100 parts for that product into that category. Then use @lesley's "Flex Layout Module" to enforce a custom layout for these category pages. This has an added benefit that there are a few key parts (1 or 2 per product) that we actually would like to appear in search results and this would allow us to do this.
Use product attributes. Create a "parts product" for each product we sell parts for. ~1100 "parts products" at first, eventually perhaps up to 5000. Each of these "parts products" would contain a single attribute ("part type") with ~100 different options to choose from. Once again use @lesley's "Flex Layout Module" to design a custom layout for these products so instead of showing a huge dropdown list of 100 different choices it breaks them out onto the page itself with an "add to cart" button beside each attribute choice.
I'm not sure if I am explaining the above properly and I'm also not sure if either option is even possible. My questions though:
Help appreciated.
Link to comment
Share on other sites
14 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now