Shopify: Inventory Levels

Description

• Model representing the current status of an inventory level in Shopify. Inventory Levels are unique pairings of inventory items (which have a 1:1 relationship with product variants) and locations. Inventory Level = Inventory item @ a Location.

Supported Data Sources

• Shopify

Columns

Type	Name	Description
	_fivetran_synced	The time when a record was last updated by Fivetran.
	available_quantity	The available quantity of an inventory item at the inventory level's associated location. Returns null if the inventory item is not tracked.
	inventory_item_id	The ID of the inventory item associated with the inventory level.
	location_id	The ID of the location that the inventory level belongs to.
	updated_at	The date and time (ISO 8601 format) when the inventory level was last modified.
	is_inventory_item_deleted	Boolean representing whether the record was soft-deleted in Shopify.
	sku	The unique SKU (stock keeping unit) of the inventory item.
	cost	The unit cost of the inventory item. The shop's default currency is used.
	province_code_of_origin	The province code (ISO 3166-2 alpha-2) of where the item came from. The province code is only used if the shipping provider for the inventory item is Canada Post.
	country_code_of_origin	The country code (ISO 3166-1 alpha-2) of where the item came from.
	is_shipping_required	Boolean representing whether a customer needs to provide a shipping address when placing an order containing the inventory item.
	is_inventory_quantity_tracked	Boolean representing whether inventory levels are tracked for the item. If true, then the inventory quantity changes are tracked by Shopify.
	inventory_item_created_at	The date and time (ISO 8601 format) when the inventory item was created.
	inventory_item_updated_at	The date and time (ISO 8601 format) when the inventory item was last modified.
	is_location_deleted	Boolean representing whether the record was soft-deleted in Shopify.
	is_location_active	Boolean representing whether the location is active. If true, then the location can be used to sell products, stock inventory, and fulfill orders.
	address_1	The location's street address.
	address_2	The optional second line of the location's street address.
	city	The city the location is in.
	country	The country the location is in (two-letter code).
	country_code	The two-letter code (ISO 3166-1 alpha-2 format) corresponding to country the location is in.
	location_created_at	The date and time (ISO 8601 format) when the location was created.
	is_legacy_location	Boolean representing whether this is a fulfillment service location. If true, then the location is a fulfillment service location. If false, then the location was created by the merchant and isn't tied to a fulfillment service.
	location_name	The name of the location.
	phone	The phone number of the location. This value can contain special characters, such as - or +.
	province	The province, state, or district of the location.
	province_code	The province, state, or district code (ISO 3166-2 alpha-2 format) of the location.
	location_updated_at	The date and time (ISO 8601 format) when the location was last updated.
	zip	The zip or postal code.
	variant_barcode	The barcode, UPC, or ISBN number for the product.
	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.
	variant_id	The unique numeric identifier for the product variant.
	variant_image_id	The unique numeric identifier for a product's image. The image must be associated to the same product as the variant.
	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_price	The price of the product variant in shop currency.
	product_id	The unique numeric identifier for the product.
	is_variant_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.
	subtotal_sold	Total amount (monetary, in shop currency) sold from the inventory level. Includes refunds.
	quantity_sold	Total quantity sold from the inventory level. Includes refunds.
	count_distinct_orders	The number of distinct orders placed from this inventory level.
	count_distinct_customers	The number of distinct customers (based on customer_id) that have placed orders against this inventory level.
	count_distinct_customer_emails	The number of distinct customer emails that have placed orders against this inventory level.
	first_order_timestamp	The timetamp of the first order against this inventory level.
	last_order_timestamp	The timestamp of the first order against this inventory level.
	subtotal_sold_refunds	The monetary amount (in shop currency) of inventory level goods that have been refunded.
	quantity_sold_refunds	The quantity of inventory level goods that have been refunded.
	net_subtotal_sold	Net monetary amount sold (in shop currency) from the inventory level. Excludes refunds.
	net_quantity_sold	Net quantity sold from this inventory level. Excludes refunds.
	count_fulfillment_pending	Count of currently pending distinct fulfillments for this inventory level. "Pending" = Shopify has created the fulfillment and is waiting for the third-party fulfillment service to transition it to 'open' or 'success'.
	count_fulfillment_open	Count of currently open distinct fulfillments for this inventory level. "Open" = The fulfillment has been acknowledged by the service and is in processing.
	count_fulfillment_success	Count of successful distinct fulfillments for this inventory level. "Success" = The fulfillment was successful.
	count_fulfillment_cancelled	Count of cancelled distinct fulfillments for this inventory level. "Cancelled" = The fulfillment was cancelled.
	count_fulfillment_error	Count of distinct fulfillments for this inventory level that encountered an error. "Error" = There was an error with the fulfillment request.
	count_fulfillment_failure	Count of distinct fulfillments for this inventory level that failed. "Failure" = The fulfillment request failed.
	source_relation	The schema or database this record came from if you are making use of the shopify_union_schemas or shopify_union_databases variables, respectively. Empty string if you are not using either of these variables to union together multiple Shopify connectors.