Order tags table
The order tags table contains information about the order tags in your store. This table reflects the current state of these tags in Shopify.
An order tag is created every time you add a tag to an order. For example, you have a tag named Replacement order that you add to orders that cost more than $1000. If you add this tag to two of your orders, then two order tags are created. Each of these order tags has their own ID. If you want to find out how many times the Replacement order tag has been added to your customers, then use the title column (do not use the order_tag_id column).
| Column | Data type | Description |
|---|---|---|
| order_tag_id | numeric | This unique identifier is created every time a tag is added to an order. This column is the primary key for this table. |
| order_id | numeric | The ID of the order that the tag has been added to. This column is a foreign key reference to the order_id column in the orders table. |
| shop_id | numeric | The ID of the store. This column is a foreign key reference to the shop_id column in the shops table. |
| title | varchar | The name of the order tag. |
The following example returns order tags by total price: