Amazon Catalog Table Structure
The Amazon Catalog is presented as a structured table where each row represents a product and each column represents a specific attribute.
This structure allows users to review, compare, and manage product data efficiently.
The Big Picture
The Amazon Catalog is not just a product list.It is a structured dataset that organizes Amazon product information into clear, actionable fields.
Product Information (ASIN, SKU, Parent ASIN)
Each product is identified using Amazon-specific identifiers:
- ASIN identifies the product listing
- SKU identifies the seller-specific inventory unit
- Parent ASIN groups related variations under one product family
These identifiers form the foundation of product structure in the Amazon Catalog.
Store
The Store field indicates which store or account the product belongs to.
This is important when:
- managing multiple Amazon stores
- filtering products by account
- analyzing catalog data across different regions or stores
Status
The Status field shows the current availability state of the product.
Common statuses may include:
- active
- inactive
This helps users quickly identify products that are currently available or not.
Tags
The Tags field allows products to be categorized using custom labels.
Tags can be used to:
- group products by category or strategy
- filter specific product sets
- organize large catalogs
Tags are flexible and user-defined.
Price and Cost
The table includes both Price and Cost fields.
- Price reflects the current product price from Amazon
- Cost represents the product cost defined inside EVA
These fields are essential for evaluating product profitability and making pricing decisions.
The Logic
Each column represents a distinct type of product data:
- identifiers define product structure
- status defines availability
- tags define organization
- price and cost define financial context
Together, these fields provide a complete view of each product.
Why This Matters
Without a structured table:
- product data would be difficult to interpret
- comparisons between products would be inefficient
With this structure:
- product attributes are clearly separated
- users can scan and analyze data quickly
- workflows such as filtering and updating become easier
Key Value Pillars
Structured data visibility
All important product attributes are organized into clear columns.
Efficient comparison
Users can compare multiple products across the same fields.
Action-ready information
Price, cost, and status fields support immediate decision-making.
Pro Insight
Combine columns such as price, cost, and tags to quickly identify products that require action, such as low-margin items or uncategorized products.