Shopify: Products

Description

• Each record represents a product in Shopify.

Supported Data Sources

• Shopify

Columns

Type	Name	Description
	is_deleted	Whether the record has been deleted in the source system.
	_fivetran_synced	The time when a record was last updated by Fivetran.
	created_timestamp	The date and time when the product was created.
	handle	A unique human-friendly string for the product. Automatically generated from the product's title.
	product_id	An unsigned 64-bit integer that's used as a unique identifier for the product. Each id is unique across the Shopify system. No two products will have the same id, even if they're from different shops.
	product_type	A categorization for the product used for filtering and searching products.
	published_timestamp	The date and time (ISO 8601 format) when the product was published. Can be set to null to unpublish the product from the Online Store channel.
	published_scope	Whether the product is published to the Point of Sale channel.
	title	The name of the product.
	updated_timestamp	The date and time when the product was last modified.
	vendor	The name of the product's vendor.
	total_quantity_sold	Quantity of the product sold.
	subtotal_sold	Total amount (in shop currency) of the product sold.
	quantity_sold_net_refunds	Quantity of the product sold, excluding refunds.
	subtotal_sold_net_refunds	Total amount (in shop currency) of the product sold, excluding refunds.
	first_order_timestamp	The timestamp the product was first ordered.
	most_recent_order_timestamp	The timestamp the product was most recently ordered.
	source_relation	The schema or database this record came from, if you are unioning multiple connectors. Null if not.
	avg_quantity_per_order_line	Average quantity per order line with this product.
	product_total_discount	Total discounts associated with the product.
	product_avg_discount_per_order_line	Average discount per order line with this product.
	product_total_tax	Total taxes associated with the product.
	product_avg_tax_per_order_line	Average taxes per order line with this product.
	count_variants	Count of product variants.
	has_product_image	If the product has an image.
	status	The status of the product. Valid values: - active: The product is ready to sell and is available to customers on the online store, sales channels, and apps. By default, existing products are set to active. - archived: The product is no longer being sold and isn't available to customers on sales channels and apps. - draft: The product isn't ready to sell and is unavailable to customers on sales channels and apps. By default, duplicated and unarchived products are set to draft.
	collections	Comma-separated list of collections associated with the product.
	tags	Comma-separated list of tags associated with the product.