sillycube sillycube

Backup MySQL to Amazon S3

This is a simple way to backup your MySQL tables to Amazon S3 for a nightly backup - this is all to be done on your server :-)

Sister Document - Restore MySQL from Amazon S3 - read that next

1 - Install s3cmd

this is for Centos 5.6, see http://s3tools.org/repositories for other systems like ubuntu etc

Safari iframe cookie workaround

Safari by default discards cookies set in an iframe unless the host that's serving the iframe has set a cookie before, outside the iframe. Safari is the only browser that does this.

The 10k foot view

In order to get around the issue, the parent (src) and child/iframed/remote (dest) site have to work together, if the source site only wants users to access the destination via the iframe and can't assume that the user has visited the destination host before.

Solution for API call limit "shopify_python_api"

If you are using Python Shopify API and getting following error
"Exceeded 4 calls per second for api client. Reduce request rates to resume uninterrupted service."
but want your script to continue working with some timeout after that,
you can use following script from shopify_limits_patch.py.

For that just copy shopify_limits_patch.py to your project and import shopify_limits_patch.

Or if you want to call it implicitly import it, remove last line patch_shopify_with_limits()
and call it before all your shopify calls.

Create a Shopify Function to do 2 for $25 Items

Requirements: You want a Shopify Function to do a 2 for $25 discount like what is availble in Shopify Scripts (soon to be removed).

Your products can have different prices, some might be $29.99, some might be $25.99, others might be $19.99. You don't want to change the original prices. You want every combination of eligible produccts to be discounted to $12.50, i.e. "2 for $25" and if you have an odd total: say a cart has 2 of one eligble product and 3 of other eligible products, the most expensive one is not fully discounted (don't discount one of them). You also want a call to action to the customer to add another item in the not fully discounted line item to get the full discount.

Your eligible products are identified with a tag "2FOR25" .

Run.graphql

Your run.graphql should look like this:

	<form action="/cart/add" method="post">
	{% if product.variants.size > 1 %}
	{% if product.options[0] %}
	{% assign used = '' %}
	<label for="select-one">{{ product.options[0] }}</label>
	<select id='select-one' onchange="letsDoThis()">
	{% for variant in product.variants %}
	{% unless used contains variant.option1 %}
	<option value="{{ variant.option1 }}">{{ variant.option1 }}</option>
	{% capture used %}{{ used }} {{ variant.option1 }}{% endcapture %}

	{% comment %}
	Source: https://gist.github.com/carolineschnapp/9122054
	If you are not on a collection page, do define which collection to use in the order form.
	Use the following assign statement, replace 'your-collection-handle-here' with your collection handle.
	{% assign collection = collections.your-collection-handle-here %}
	Use the assign statement outside of this comment block at the top of your template.
	{% endcomment %}

	{% paginate collection.products by 100 %}


	/*
	##Device = Desktops
	##Screen = 1281px to higher resolution desktops
	*/

	@media (min-width: 1281px) {

	/* CSS */

	import Vue from 'vue';

	/**
	* EventHub to listen or broadcast to all components
	*
	* @see https://shopify.dev/tutorials/develop-theme-sections-integration-with-theme-editor
	*
	* Usage: eventHub.$on('shopify:section:select:{my-section-name}', (event) => handleSelect());
	*
	*/