Collects
Query, insert, or delete information regarding different collects.
Table-Specific Information
Select
The connector processes all filters client-side within the connector. The following queries are the only ones processed server-side:SELECT * FROM Collects WHERE Id = '123'
Insert
You must specify the ProductId and CollectionId to create a collect.
INSERT INTO Collects (ProductId, CollectionId) VALUES ('512433520663', '22892937239')
Delete
You must specify the Id of the collect to delete it.
DELETE FROM Collects WHERE id = '123'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
A unique numeric identifier for the collect. | |
| CollectionId | Long | False |
The Id of the collection this collection is linked with. | |
| ProductId | Long | False |
Products.Id |
The Id of the product this collection is linked with. |
| Position | Int | True |
The position of this product in a manually sorted custom collection. The first position is 1. This value is applied only when the custom collection is sorted manually. | |
| SortValue | String | True |
This is the same value as position but padded with leading zeroes to make it alphanumeric-sortable. | |
| CreatedAt | Datetime | True |
The date and time when the collect was created. | |
| UpdatedAt | Datetime | True |
The date and time when the collect was last modified. |