ODBC Driver for Shopify

Build 24.0.9060

CollectionListings

Query and delete information regarding different collects.

Table-Specific Information

Select

The driver processes all filters client-side within the driver. The following queries are the only ones processed server-side:
SELECT * FROM CollectionListings WHERE Id = '123'

Delete

You must specify the Id of the collection listing to delete it.

DELETE FROM CollectionListings WHERE id = '123'

Columns

Name Type ReadOnly References Description
Id [KEY] Long False

CustomCollections.Id

The Id of the collection this listing belongs to.

Title String True

The titke of the collection listing.

BodyHtml String True

The HTML body/description for this listing.

DefaultProductImage String True

The default product image in this listing.

ImageCreatedAt String True

The date and time the image for this listing was created at.

ImageSource String True

The source/link of the image for this listing.

Handle String True

The handle of this listing.

UpdatedAt Datetime True

The date and time when the collection listing was last modified.

PublishedAt Datetime True

The date and time when the collection listing was created.

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