CData Python Connector for Shopify

Build 23.0.8839

Products

List of products.

Table-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the following columns: Id, Title, Vendor, Handle, ProductType, PublishedStatus, CreatedAt, PublishedAt, and UpdatedAt. The connector processes other filters client-side within the connector.

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

SELECT * FROM Products WHERE Id = '123'

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

SELECT * FROM Products WHERE CreatedAt > '2017-10-25'

SELECT * FROM Products WHERE Title = 'just a title'

SELECT * FROM Products WHERE Vendor = 'just a vendor'

Insert

  • Create a new product with the default product variant.

    INSERT INTO Products (Title, BodyHtml, Vendor, ProductType, Tags) VALUES ('Burton Custom Freestyle 151', 'Good snowboard!', 'Burton', 'Snowboard', 'Barnes & Noble, Johns Fav, Big Air')

  • Create a new unpublished product.

    INSERT INTO Products (Title, BodyHtml, Vendor, ProductType, Tags, Published) VALUES ('Burton Custom Freestyle 151', 'Good snowboard!', 'Burton', 'Snowboard', 'Barnes & Noble, Johns Fav, Big Air', false)

Update

To update a product you must specify its Id.

UPDATE Products SET Published = true  WHERE Id = '123'

UPDATE Products SET MetafieldsGlobalTitleTag = 'Brand new title', MetafieldsGlobalDescriptionTag = 'Brand new description' WHERE Id = '123'

Delete

To delete a product you must specify its Id.

DELETE FROM Products WHERE Id = '123'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

A unique numeric identifier for the product.

BodyHtml String False

The description of the product, complete with HTML formatting.

Handle String True

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

Images String False

A list of image objects, each one representing an image associated with the product.

ProductType String False

A categorization that a product can be tagged with, commonly used for filtering and searching.

Options String False

Custom product property names like 'Size', 'Color', and 'Material'.

Variants String False

Custom product property names like 'Size', 'Color', and 'Material'.

PublishedScope String False

Indicates whether the product is published to the Point of Sale channel.

Tags String False

A categorization that a product can be tagged with. Use commas to separate categories.

Status String False

The status of the product.

TemplateSuffix String True

The suffix of the liquid template being used.

Title String False

The name of the product.

Vendor String False

The name of the vendor of the product.

PublishedAt Datetime True

The date and time when the product was published to the Online Store channel.

CreatedAt Datetime True

The date and time when the product was created.

UpdatedAt Datetime True

The date and time when the product was last modified.

PublishedStatus String True

Return products by their published status: published: show only published products;unpublished: show only unpublished products; any: show all products.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.

Name Type Description
Published Bool

Set to true to publish the product or to false to not publish it.

MetafieldsGlobalTitleTag String

The name of the product, to be used for SEO purposes.

MetafieldsGlobalDescriptionTag String

The description of the product, to be used for SEO purposes.

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