benjaminsehl

-- A SQL query to find customers that may have unintentionally unsubscribed from their e-mail.
-- This is related to a Shop Pay bug where if customers come from a Headless shop, they're unsubscribed.


SELECT T1.metadata__email "Email", C.accepts_marketing "Subscribed", C.accepts_marketing_updated_at "Unsubscribe Date", T2.created_at "Transaction Date", O.created_at "Order Date"
FROM ca_ecomm.transactions__receipt__charges__data T1
LEFT JOIN ca_ecomm.transactions T2
ON 
T1.metadata__order_transaction_id::VARCHAR = T2.id::VARCHAR
LEFT JOIN ca_ecomm.customers C

benjaminsehl

const formatters = [
  { pattern: /'/g, replacement: '’' }, // Replace straight quotes with smart quotes
  { pattern: /\s([^\s<]+)\s*$/g, replacement: '\u00A0$1' }, // Add non breaking spaces before the last word
]

const formatted = (a) =>
  formatters.reduce(
    (a, f) => a?.toString().replace(f.pattern, f.replacement),
    a,
  )

benjaminsehl

alias scripts="pcregrep -M '(?<=scripts\":\s)(.|\n)*?(?=\n\s*},)' package.json"

benjaminsehl

export function handleize (str) {
  return str
    .toLowerCase()
    .replace(/[^\w\u00C0-\u024f]+/g, '-')
    .replace(/^-+|-+$/g, '')
}

benjaminsehl

export function adopt(str) {
  return str.replace(/\s([^\s<]+)\s*$/g, '\u00A0$1');
}

benjaminsehl

{"lastUpload":"2020-08-28T21:31:48.308Z","extensionVersion":"v3.4.3"}

benjaminsehl

const shopifyStores = [
  {name: 'Canada Web', tablePrefix: 'ca_ecomm'},
  {name: 'Canada Retail', tablePrefix: 'ca_retail'},
  {name: 'Intl. Web', tablePrefix: 'us_ecomm'},
  {name: 'Intl. Retail', tablePrefix: 'us_retail'}
];

let KotnEmailsArray = [
  "kotn",
  "ordinarysupply",