PickupMethods

Returns a list of Pickup Methods.

Table Specific Information

Select

The connector uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

Id supports the = and IN comparisons.
DateModified supports the =, <, >, <= and >= comparisons.

The rest of the filter is executed client-side within the connector.

For example, the following query is processed server-side:

SELECT * FROM PickupMethods WHERE Id = 3

Insert

To insert a pickup method, specify at least the LocationId, CollectionInstructions, CollectionTimeDescription and DisplayName columns.

INSERT INTO PickupMethods (LocationId, DisplayName, CollectionInstructions, CollectionTimeDescription) VALUES (1, 'Curbside Pickup', 'Call when you arrive', 'evening')

Update

UPDATE PickupMethods SET DisplayName = 'In-Store Pickup' WHERE Id = 3

Delete

DELETE FROM PickupMethods WHERE Id = 3

DELETE FROM PickupMethods WHERE Id IN (3,4)

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	The unique identifier of the pickup method.
LocationId	Integer	False	The Id of the inventory location this pickup method is associated with.
DisplayName	String	False	The name of the pickup method, as displayed to shoppers.
CollectionInstructions	String	False	Instructions shown to shoppers for collecting their order.
CollectionTimeDescription	String	False	A description of when the order will be ready for collection.
DateCreated	Datetime	True	Date and time the pickup method was created.
DateModified	Datetime	True	Date and time the pickup method was last modified.