Products table
Products contains information about each of the products in your store. This table reflects the current state of products in your Shopify admin. This table contains one row per product.
Column | Data type | Description |
---|---|---|
product_id | numeric | Unique identifier for the product. This column is the primary key for this table. |
shop_id | numeric | ID of the store. This column is a foreign key reference to the shop_id column in the shops table. |
title | varchar | Name of the product. |
product_type | varchar | Type of the product as set by the merchant. For example, books, games. |
vendor | varchar | Name of the manufacturer, wholesaler, or other vendor of the product. |
created_at | timestamp | Date (ISO 8601) and time (UTC) when the product was added to the store. The format is YYYY-MM-DD HH:mm:ss (for example, 2016-02-05 17:04:01). |
deleted_at | timestamp | Date (ISO 8601) and time (UTC) when the product was deleted. The format is YYYY-MM-DD HH:mm:ss (for example, 2016-02-05 17:04:01). |
The following example returns products that have the word red in their title
The following example returns a list of orders that contain a product with the id 1234567891:
If you change a product detail, such as its title, in your Shopify admin, then that change will appear in this table. For information about joining this table with the sales or orders tables, see sales, orders, and line items.