Same item in multiple categories. Is is possible?
Submitted by markf57 on May 5, 2006 - 7:44pm
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?
- Login to post comments
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