> ## Documentation Index
> Fetch the complete documentation index at: https://docs.topsort.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Schema Description

export const LastUpdated = ({date, lang = "en"}) => {
  const translations = {
    en: "Last updated:",
    es: "Última actualización:",
    pt: "Última atualização:",
    fr: "Dernière mise à jour:",
    de: "Zuletzt aktualisiert:"
  };
  const label = translations[lang] || translations.en;
  return <>
<style>{`
.last-updated-component {
display: inline-flex;
align-items: center;
gap: 8px;
padding: 10px 16px;
border-radius: 8px;
margin-top: 12px;
margin-bottom: 16px;
font-size: 14px;
background-color: rgba(0, 0, 0, 0.05);
border: 1px solid rgba(0, 0, 0, 0.12);
color: rgba(0, 0, 0, 0.75);
line-height: 1;
}

        .last-updated-component svg {
          flex-shrink: 0;
          vertical-align: middle;
        }

        .last-updated-component span {
          display: inline-flex !important;
          align-items: center !important;
          line-height: 1 !important;
        }

        [data-theme="dark"] .last-updated-component {
          background-color: #3a3a3a;
          border: 2px solid #888888;
          color: #ffffff;
        }

        [data-theme="dark"] .last-updated-component svg {
          stroke: #ffffff;
        }
      `}</style>
      <div className="last-updated-component">
        <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" strokeWidth="2" strokeLinecap="round" strokeLinejoin="round">
          <circle cx="12" cy="12" r="10" />
          <polyline points="12 6 12 12 16 14" />
        </svg>
        <span>
          <strong style={{
    fontWeight: 600
  }}>{label}</strong> 
          <time dateTime={date}>{date}</time>
        </span>
      </div>
    </>;
};

## Core Identification

| Field               | Type       | Description                                           |
| ------------------- | ---------- | ----------------------------------------------------- |
| `id`                | **UUID**   | Unique identifier for the standardized product record |
| `source_product_id` | **STRING** | Product ID from the original catalog submission       |
| `marketplace_id`    | **UUID**   | Identifier for the submitting marketplace or vendor   |

## Product Information

| Field         | Type       | Description                            |
| ------------- | ---------- | -------------------------------------- |
| `title`       | **STRING** | Cleaned and standardized product title |
| `description` | **STRING** | Standardized product description       |

## Brand Data

| Field                  | Type       | Description                                           |
| ---------------------- | ---------- | ----------------------------------------------------- |
| `raw_brand_name`       | **STRING** | Brand name as received in the original catalog        |
| `brand_id`             | **UUID**   | Recognized canonical brand ID                         |
| `standard_brand_name`  | **STRING** | Standardized brand name associated with the brand ID  |
| `standard_brand_score` | **FLOAT**  | Standardized brand score associated with the brand ID |

## Category Classification

| Field                     | Type       | Description                                                   |
| ------------------------- | ---------- | ------------------------------------------------------------- |
| `raw_category_name`       | **STRING** | Original category label from the catalog                      |
| `category_id`             | **UUID**   | Mapped category ID from the standardized taxonomy             |
| `standard_category_path`  | **STRING** | Full category path (e.g., Electronics → Phones → Smartphones) |
| `standard_category_score` | **FLOAT**  | Standardized brand score associated with the category path    |

## Deduplication and Quality

| Field               | Type        | Description                                                               |
| ------------------- | ----------- | ------------------------------------------------------------------------- |
| `master_product_id` | **UUID**    | Unified product ID representing deduplicated variants of the same product |
| `is_duplicate`      | **BOOLEAN** | Indicates whether the product is a duplicate of an existing item          |
| `confidence_score`  | **FLOAT**   | Confidence score (0–1) indicating certainty in the standardization        |

## Metadata

| Field        | Type          | Description                                   |
| ------------ | ------------- | --------------------------------------------- |
| `created_at` | **TIMESTAMP** | Timestamp when the product was processed      |
| `updated_at` | **TIMESTAMP** | Last updated time for the standardized record |

***

<LastUpdated date="2025-11-18" />