CartCustomItems

Returns and manages the custom, non-catalog items in a cart. Custom items cannot be updated after being added; delete and re-add the item instead.

Table Specific Information

Select

CartCustomItems returns the custom, non-catalog items in a cart. A value for CartId is required, since BigCommerce does not offer an endpoint to list custom items across all carts.

SELECT * FROM CartCustomItems WHERE CartId = '82676093-e069-4d1d-93a2-96c1d3169dfc'

Insert

To add a custom item to a cart, specify at least the CartId, Sku, Name, Quantity, and ListPrice.

INSERT INTO CartCustomItems (CartId, Sku, Name, Quantity, ListPrice) VALUES ('82676093-e069-4d1d-93a2-96c1d3169dfc', 'custom-sku', 'Custom Engraving', 1, 15.00)

Update

Custom items cannot be updated once added. To change a custom item, delete it and insert a new one instead.

Delete

DELETE FROM CartCustomItems WHERE CartId = '82676093-e069-4d1d-93a2-96c1d3169dfc' AND Id = '66e3fa1e-49ff-483b-8302-1830dcf5c33e'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	The unique identifier of the custom item.
CartId [KEY]	String	False	The Id of the cart this item belongs to.
Sku	String	False	The SKU of the custom item.
Name	String	False	The name of the custom item.
Quantity	Integer	False	The quantity of the custom item in the cart.
ListPrice	Decimal	False	The list price of the custom item.
ExtendedListPrice	Decimal	True	The list price multiplied by the quantity.
ImageUrl	String	False	The URL of the custom item's image.