Skip to content

Instantly share code, notes, and snippets.

@GreatPotato

GreatPotato/quotes.ql

Last active November 11, 2021 08:44
Show Gist options
  • Save GreatPotato/5b3510104f078018e1892d6a8701ca35 to your computer and use it in GitHub Desktop.
Save GreatPotato/5b3510104f078018e1892d6a8701ca35 to your computer and use it in GitHub Desktop.
Download ZIP
Create a view for quotes in LS (excludes all main carts)
Raw
quotes.ql
CREATE VIEW fiftydigital_quotes AS
SELECT DISTINCT concat(cart_name, '_', customer_id) as 'id', cart_name, customer_id
FROM shop_customer_cart_items
WHERE cart_name != 'main'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment