Same item in multiple categories. Is is possible?

First, this program is amazing. I never knew that excel could do so much.

My question is about categories and what I would call views. I'm looking for a way for a visitor to view the same item, but in multiple ways. For example, I will sell military flags for the different branches. I want to have the flags appear in a flags category, but I also want a visitor to be able to view all items I have that are related to a specific branch of the military. Is this possible with xle?

I was thinking that multiple

I was thinking that multiple copies was the way to go. However, will that mess things up if I decide to use inventory?

Thanks,

Mark

Thanks, Mark

RE: I was thinking that multiple

It depends on how you set up your inventory control. You can use cell formulas that relate / refer to the multiple copies of the items to keep track of the inventory.

Sam Raheb
XLEcom Program Developer

RE: Same item in multiple categories. Is is possible?

The simplest way to have the same item appear in multiple categories is to make multiple copies of the same item in the Database sheet. This way you can assign different Main and Sub categories combinations for the same item. By doing this you can control where you want the Products Ads to appear within you website. See the following simplified Database example below.

Item

Item Number

Main Category

Sub Category

1

AF001

Colonial

USA Flags

2

AF001

Civil War

USA Flags

3

AF001

Modern

USA Flags

Sam Raheb
XLEcom Program Developer