ODBC guide

Read or search quotes

Gets quotes (cart sessions) for your store. Use the Quotes table. Optionally filter by date range or status in the WITH clause. This example lists open and completed quotes.

SELECT * FROM Quotes 
WITH (
	  Statuses='OPEN~COMPLETED',
	  --SearchFor='Test' --quote contains word "Test" in Name or blling information
	  -- query more status like below
	  --Statuses='OPEN~COMPLETED~CANCELED~EXPIRED',
	  
)