How To List Products In More Than One Section?

Hi Brian,

I don't know if I know exactly what you mean, but we love a challenge and I'm sure we can figure something out. :) A few questions:

What "section editors" do you have setup right now?

Are there many categories? Could you have checkboxes in the product editor for each category: "Huckleberry", "Gourmet Cabin Foods" and then only list matching products (that have a check) in the respective categories?

Another option, we have a feature in the next release (v1.07 - due for release in the next day or so) that lets you use values from one "section editor" as options for a list field if a different section editor. So if you can select a product from your product menu in a list field (pulldown) on another menu. I hope that makes sense.

Do you think either of those will work? If I'm totally off base here maybe let me know a little bit more about the site structure or how you want things displayed.

No problem Dave, just glad to have your support!

I have about 7 sections setup right now, but only 2-3 will feature some of the same products. Since I am listing products, the menu type is "multi". I can foresee the need for maybe a total of 12-15 sections when the site is complete.

Are there many categories? Could you have checkboxes in the product editor for each category: "Huckleberry", "Gourmet Cabin Foods" and then only list matching products (that have a check) in the respective categories?

This option sounds like a possibility. Let's discuss further. I am not sure what you mean by the other option.

Thanks,
Brian

So there's 12 sections and they each have products? Are the fields the same in each section?

Maybe it would be possible to have one section "Products" which checkboxes for the 12 categories that a product might belong to? So you might have a checkbox called 'isHuckleberry' that you'd check for Huckleberry products?

If you could do that, then you could have multiple list viewers, and have each one only show the products you wanted. So you might have huckleberryList.php and you'd add this option to only show huckleberry products:

$options['where'] = "isHuckleberry = '1'";

Let me know if you think that will do the trick. If not, we can always figure out another approach.

Yea, I think that might do the trick Dave. I not 100% clear on what you have suggested, but it sounds like a good option. If you think you understand what I need, and feel this is a good solution, then I trust you and am ready to proceed with instructions to try this out. Can we try it out with a simple test to make sure this is what I need before going to far into it?

Thanks,
Brian

I just made another attempt at doing what you suggested (sorry I didn't get back to you on my first attempt, since I got busy with another project).

It appears to work like you instructed. My only question now is whether or not I need to have all products added through an "All Products" section editor, or if I can still have the separate section editors for each product category. I can see a lot of advantages to having all products under one section editor but I also see a disadvantage with having a lot of products to manage all under one section. And is there an easy way to move all products from separate sections over to just the one?

Thanks,
Brian

It's true, there's advantages and disadvantages to both. So it really just depends on what's best for the project.

There's no easy way to migrate products from one section to another. The way to do it would be to use a tool like phpMyAdmin or something similar and write a custom MySql query to copy them over.

If you've entered a lot of data already email me directly (dave@interactivetools.com) and I'll see what I can do to help automate the process for you.

Okay Dave, I just sent you an email with the site details.

Thanks,
Brian

Dave, you had once offered to help me move product records in MySQL from the separate sections they are listed in and put them in one section called "All Products". The more I work with CMS Builder and customize ways to handle product listings, the more it seems to me that having all products under one section is more advantageous than other options. Unless there is a future enhancement that will change how products and categories can be handled in CMS Builder, then I am ready to make this change on one of my sites.

Could you still do this? Please let me know what you need and if it is something we could do in the next few days.

Thanks,
Brian