Benjamin Sehl benjaminsehl

## original-orders.js
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",

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

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

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

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

## formatters.js
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,
  )

## shop-pay-unsub-check.sql
-- 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

## headless-theme-redirect.liquid
{% comment %}

  UPDATE: Now you can use this theme to more easily manage your redirects:
  https://github.com/benjaminsehl/shopify-headless-theme

{% endcomment %}

{% assign new_website = 'https://headless-website.com/' %}
<!doctype html>
<html>

## admin-redirect-snippet.tsx
import {useUrl, useShopQuery} from '@shopify/hydrogen';

export default function AdminRedirect({response}} {
  const url = useUrl();

  if (response && response.writeHead) {
    response.doNotStream();
  }

   const {data} = useShopQuery({

## discount-link.tsx
// Place this file at `/routes/discounts/[handle].tsx`

import {useUrl, useRouteParams, useSession} from '@shopify/hydrogen';

// @TODO: Add in API route for setting session cookie with discount code: https://shopify.dev/custom-storefronts/hydrogen/framework/sessions#reading-and-updating-session-data

export async function api(request, {session}) {
  let sessionData, jsonData;

}
	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",
	export function adopt(str) {
	return str.replace(/\s([^\s<]+)\s*$/g, '\u00A0$1');
	}
	export function handleize (str) {
	return str
	.toLowerCase()
	.replace(/[^\w\u00C0-\u024f]+/g, '-')
	.replace(/^-+\|-+$/g, '')
	}
	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,
	)
	-- 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
	{% comment %}

	UPDATE: Now you can use this theme to more easily manage your redirects:
	https://github.com/benjaminsehl/shopify-headless-theme

	{% endcomment %}

	{% assign new_website = 'https://headless-website.com/' %}
	<!doctype html>
	<html>
	import {useUrl, useShopQuery} from '@shopify/hydrogen';

	export default function AdminRedirect({response}} {
	const url = useUrl();

	if (response && response.writeHead) {
	response.doNotStream();
	}

	const {data} = useShopQuery({
	// Place this file at `/routes/discounts/[handle].tsx`

	import {useUrl, useRouteParams, useSession} from '@shopify/hydrogen';

	// @TODO: Add in API route for setting session cookie with discount code: https://shopify.dev/custom-storefronts/hydrogen/framework/sessions#reading-and-updating-session-data

	export async function api(request, {session}) {
	let sessionData, jsonData;

	}