Shopify: Order Lines

Description

• Each record represents a line item of an order in Shopify.

Supported Data Sources

• Shopify

Columns

Type	Name	Description
	_fivetran_synced	The time when a record was last updated by Fivetran.
	fulfillable_quantity	The amount available to fulfill, calculated as follows: quantity - max(refunded_quantity, fulfilled_quantity) - pending_fulfilled_quantity - open_fulfilled_quantity
	fulfillment_status	How far along an order is in terms line items fulfilled.
	is_gift_card	Whether the item is a gift card. If true, then the item is not taxed or considered for shipping charges.
	grams	The weight of the item in grams.
	order_line_id	The ID of the line item.
	name	The name of the product variant.
	order_id	The ID of the related order.
	price	The price of the item before discounts have been applied in the shop currency.
	product_id	The ID of the product that the line item belongs to. Can be null if the original product associated with the order is deleted at a later date.
	quantity	The number of items that were purchased.
	is_shipping_required	Whether the item requires shipping.
	sku	The item's SKU (stock keeping unit).
	is_taxable	Whether the item was taxable.
	title	The title of the product.
	total_discount	The total amount of the discount allocated to the line item in the shop currency.
	variant_id	The ID of the product variant.
	vendor	The name of the item's supplier.
	refunded_quantity	Quantity of the item that has been refunded.
	quantity_net_refunds	Quantity ordered, excluding refunds.
	variant_barcode	The barcode, UPC, or ISBN number for the product.
	variant_compare_at_price	The original price of the item before an adjustment or a sale in shop currency.
	variant_created_at	The date and time (ISO 8601 format) when the product variant was created.
	variant_fulfillment_service	The fulfillment service associated with the product variant.
	variant_grams	The weight of the product variant in grams.
	inventory_item_id	The unique identifier for the inventory item, which is used in the Inventory API to query for inventory information.
	variant_inventory_management	The fulfillment service that tracks the number of items in stock for the product variant.
	variant_inventory_policy	Whether customers are allowed to place an order for the product variant when it's out of stock.
	variant_inventory_quantity	An aggregate of inventory across all locations. To adjust inventory at a specific location, use the InventoryLevel resource.
	variant_option_1	The custom properties that a shop owner uses to define product variants. You can define three options for a product variant: option1, option2, option3.
	variant_option_2	The custom properties that a shop owner uses to define product variants. You can define three options for a product variant: option1, option2, option3.
	variant_option_3	The custom properties that a shop owner uses to define product variants. You can define three options for a product variant: option1, option2, option3.
	variant_position	The order of the product variant in the list of product variants. The first position in the list is 1. The position of variants is indicated by the order in which they are listed.
	variant_price	The price of the product variant.
	variant_sku	A unique identifier for the product variant in the shop. Required in order to connect to a FulfillmentService.
	variant_is_taxable	Whether a tax is charged when the product variant is sold.
	variant_tax_code	This parameter applies only to the stores that have the Avalara AvaTax app installed. Specifies the Avalara tax code for the product variant.
	variant_title	The title of the product variant. The title field is a concatenation of the option1, option2, and option3 fields. You can only update title indirectly using the option fields.
	variant_updated_at	The date and time when the product variant was last modified. Gets returned in ISO 8601 format.
	variant_weight	The weight of the product variant in the unit system specified with weight_unit.
	variant_weight_unit	The unit of measurement that applies to the product variant's weight. If you don't specify a value for weight_unit, then the shop's default unit of measurement is applied. Valid values: g, kg, oz, and lb.
	refunded_subtotal	Subtotal amount of the refund applied to the order line in shop currency.
	subtotal_net_refunds	Subtotal of the order line with refunds subtracted in shop currency.
	image_id	Image id of the product variant associated with the order line.
	source_relation	The schema or database this record came from, if you are unioning multiple connectors. Null if not.
	restock_types	List of how this refund line item affects inventory levels.
	order_line_tax	Total taxes for the line item.
	index	The index associated with the order.
	pre_tax_price	The total pre tax price of the order.
	tax_code	This parameter applies only to the stores that have the Avalara AvaTax app installed. Specifies the Avalara tax code for the product variant.
	pre_tax_price_set	The pre tax price of the line item in shop currency and presentment currency.
	price_set	The price of the line item in shop and presentment currencies.
	total_discount_set	The total amount allocated to the line item in the presentment currency.
	properties	Line item properties.