Product tags table
The product tags table contains data about the product tags in your store. This table reflects the current state of product tags in your Shopify admin. This table contains one row per product tag.
A product tag is created every time you add a tag to a product. For example, you have a tag named Spring collection that you add to your seasonal products. If you add this tag to two of your products, then two product tags are created. Each of these product tags has their own ID. If you want to find out how many times the Spring collection tag has been added to your products, then do use the title column (do not use the product_tag_id column).
| Column | Data type | Description |
|---|---|---|
| product_tag_id | numeric | Unique numeric identifier for the product tag. This ID is created every time a tag is added to a product. This column is the primary key for this table. |
| product_id | numeric | ID of the product that the tag has been added to. This column is a foreign key reference to the product_id column in the products 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 tag. |
The following example returns total sales by product tags: