Can someone help w option set logic?

I’m building a marketplace and just devising all my datatypes. For my products I’m going to sell, I made an option set for the first category which would be Skin and Body, Home, Fitness etc. Within these categories I also have subcategories, I,e skin and body has a subcategory skincare, body wash, etc you can see what I mean (see sephora’s nav if you want a visual cue)

When I’m doing my data vs option sets, I’ve put this first category (skin and body, home fitness) as an option set - given the subcategory list (skincare, body wash etc) is derived from the primary category list items, would I make a new option set for these? Or would it be OK to put all these into the same option set.

Wondering how/when I can cut down on new option sets. Would love someone’s POV/expertise on this! Thanks

Hey @bp89 :wave:

The best approach for it is to store your category and subcategory as different databases, not option sets… :+1:

1 Like

Hey! Okay good to know, thanks. Do you mind sharing a bit of the logic behind this? I thought they’d be option sets as my “buyers” who join the marketplace would select which category their goods fall into when they upload each product and when I learned about option sets this is the primary use of that! (standardizing selections like this for “users/buyers”)

One database will be “Category” and will have this structure:

  • Name (Text Type)
  • Enable (Yes/No type)

And the other database will be “Subcategory” and will have this structure:

  • Name (Text Type)
  • Main Category (Category Type)
  • Enable (Yes/No type)

To display your categories to your users you just have to Search for categories where Enable is YES.

Changed my life, thank you!

You can also put both category and subcategory in one dataset (with a subcategory field indicator (or use the main category’s lack of a value to determine if it’s a parent or child)). In addition to minimizing the number of datasets you have, it will also allow you to have a search that checks both parents and children.