ODBC Driver for Shopify

Build 24.0.9060

ProductVariants

List of the product variants.

Table-Specific Information

Select

The driver uses the Shopify API to process search criteria that refer to the Id and ProductId column. The driver processes other filters client-side within the driver.

For example, the following queries are processed server-side.

SELECT * FROM ProductVariants WHERE Id = '123'

SELECT * FROM ProductVariants WHERE Id IN ('123', '456')

SELECT * FROM ProductVariants WHERE ProductId = '456'

Insert

You must specify the ProductId to insert a product variant.

INSERT INTO ProductVariants (ProductId, Option1, Price) VALUES ('123', 'Yellow', 3.5)

Update

You must specify the Id of the variant to edit a product variant.

  • Update the title and price of an existing variant.

    UPDATE ProductVariants SET Option1 = 'Pink', Price = 99.99  WHERE Id = '123'

Delete

You must specify the ProductId and the Id of the variant to delete a product variant.

DELETE FROM ProductVariants WHERE Id = '123' AND ProductId = '456'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

A unique numeric identifier for the product variant.

ProductId Long False

A unique numeric identifier for the product this variant belongs to.

InventoryItemId Long False

The unique identifier for the inventory item, which is used in the Inventory API to query for inventory information.

ImageId Long False

A unique numeric identifier for the image this variant belongs to.

Price Decimal False

The price of the product variant.

CompareAtPrice String False

The competitors prices for the same item.

Title String False

The name of the product.

Grams Int False

The weight of the product variant in grams.

Barcode String False

A human-friendly unique string for the Product automatically generated from its title.

Weight Double False

The weight of the product variant in the unit system specified.

WeightUnit String True

The unit of measurement that applies to the product's variant weight.

FulfillmentService String False

Service which is doing the fulfillment.

InventoryManagement String False

Specifies whether or not Shopify tracks the number of items in stock for this product variant.

InventoryPolicy String True

Specifies whether or not customers are allowed to place an order for a product variant when it's out of stock. Valid values are deny or continue.

InventoryQuantity Int True

The number of items in stock for this product variant. Default value 1.

Option1 String False

Custom properties that a shop owner can use to define product variants.

Option2 String False

Custom properties that a shop owner can use to define product variants.

Option3 String False

Custom properties that a shop owner can use to define product variants.

Position Int False

The order of the product variant in the list of product variants.

RequiresShipping Bool False

Specifies whether or not a customer needs to provide a shipping address when placing an order for this product variant.

Sku String False

A unique identifier for the product in the shop.

Taxable Bool False

Specifies whether or not a tax is charged when the product variant is sold.

CreatedAt Datetime True

The date and time when the product variant was created.

UpdatedAt Datetime True

The date and time when the product was last modified.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060