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

Asked 10 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?