What data is typically stored in the database for site search purposes?

Asked 7 months ago

What types of data is typically stored in the database for site search purposes? For context I run an online clothing store selling menswear.

Walter Castillo

Friday, September 22, 2023

In terms of site search, your database stores:

  • Product data: This includes the product name, description, price, category, tags, and other relevant attributes.
  • Content data: This includes the text of blog posts, articles, and other pages on your website.
  • User data: This includes the customer's name, email address, shipping address, and purchase history.

In your case, selling menswear online, this can specifically be things like:

Product data:

  1. Product name (e.g., "Men's Black Button-Down Shirt")
  2. Product description (e.g., "A classic black button-down shirt that is perfect for any occasion.")
  3. Product price (e.g., "$50.00")
  4. Product category (e.g., "Shirts")
  5. Product tags (e.g., "black", "button-down", "shirt", "menswear")

Content data:

  • Blog posts about men's fashion
  • Articles about how to dress for different occasions
  • Guides to choosing the right clothes for your body type

User data:

  • Customer name
  • Email address
  • Shipping address
  • Purchase history




Write an answer...

Cancel

Please follow our  Community Guidelines

Can't find what you're looking for?