Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Synchronize Shopify customers with Sendy

Synchronize Shopify customers with Sendy subscribers

Sendy woudln't be the Mailchimp killer without a proper Shopify integration. There we go, thanks to the Shopify gem and some ActiveRecord awesomeness.

NB: The script always keep in sync Shopify's accepts_marketing field with Sendy's unsubscribed field. I added custom fields like country and order count as an example of what we can do with it.

Installation

First make sure that you have the right ruby install (with rbenv for instance), with the right gems installed (like activerecord, shopify_api, etc) and the right mysql packages for the activerecord adapter;

  • Put those two files in the same folder, from which you will need to run the script (for instance /home/ubuntu/tasks/)
  • Edit them to match your config
  • Make sure you set the right custom_fields variable line 30. If you don't have any custom field on your sendy install, make it an empty string.

Run

Simply run ruby shopify_customers.rb

Automation

If you want to run this task periodically (e.g. every two hours), you can set up a cron task:

  • crontab -e
  • Add those lines (note that we update the PATH to get the right ruby environment - that one corresponds to a standard rbenv install):
HOME=/home/ubuntu/tasks/
PATH=/home/ubuntu/.rbenv/plugins/ruby-build/bin:/home/ubuntu/.rbenv/shims:/home/ubuntu/.rbenv/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

0 */2 * * * ruby shopify_customers.rb > /dev/null 2>&1
adapter: mysql2
host: your_sendy_mysql_host
username: your_sendy_mysql_user
password: your_sendy_mysql_pass
database: your_sendy_mysql_db_name
require 'rubygems'
require 'active_record'
require 'protected_attributes'
require 'shopify_api'
require 'yaml'
require 'mysql2'
SHOPIFY_API_KEY = 'my-key' # To get an API Key, go to Apps > Private Apps
SHOPIFY_PASSWORD = 'my-pass'
STORE_NAME = 'my-store' # As in my-store.myshopify.com
SENDY_LIST_ID = 4 ## CHANGE ME!
# This has to be the send list ID from the database, that you can grab by going to the sendy list page:
# http://my-sendy-install/subscribers?i=1&l=4 for SENDY_LIST_ID = 4
SENDY_USER_ID = 1 # You probably don't want to change this
dbconfig = YAML.load(File.open('sendy_db.yml'))
ActiveRecord::Base.establish_connection(dbconfig)
shop_url = "https://#{SHOPIFY_API_KEY}:#{SHOPIFY_PASSWORD}@#{STORE_NAME}.myshopify.com/admin"
ShopifyAPI::Base.site = shop_url
class Subscriber < ActiveRecord::Base
attr_accessible :name, :email, :join_date, :timestamp, :list, :unsubscribed, :userID, :custom_fields
end
ShopifyAPI::Customer.all.each do |customer| ## Unfortunately they don't support find_each
name = "#{customer.first_name} #{customer.last_name}"
custom_fields = "#{customer.first_name}"\
"%s%#{customer.last_name}"\
"%s%#{customer.orders_count}"\
"%s%#{customer.total_spent}"\
"%s%#{customer.last_order_name}"\
"%s%#{customer.default_address? ? customer.default_address.country : ''}"
## The order of the custom fields has to be the same than the order in which you created them
## Make it an empty string if you don't have any
subscriber = Subscriber.find_or_initialize_by(email: customer.email)
## If the user was resubscribed/unsubscribed in Sendy, we keep Shopify informed.
if subscriber.timestamp? && subscriber.timestamp > DateTime.parse(customer.updated_at).to_i
customer.accepts_marketing = (subscriber.unsubscribed == 0)
customer.save
end
subscriber.update name: name,
userID: SENDY_USER_ID,
custom_fields: custom_fields,
list: SENDY_LIST_ID,
unsubscribed: customer.accepts_marketing ? 0 : 1,
join_date: DateTime.parse(customer.created_at),
timestamp: DateTime.parse(customer.updated_at)
end
@tmushy

This comment has been minimized.

Copy link

commented Dec 2, 2016

Thank you for your script. Does this work with ruby 2.2? I cant seem to get it to work

Thank you

@seuaCoder

This comment has been minimized.

Copy link

commented Feb 23, 2017

Hi ! I'm really interested in this but i'm not ruby dev, i have this error :

Unable to activate protected_attributes-1.1.3, because activemodel-5.0.1 conflicts with activemodel (< 5.0, >= 4.0.1) (Gem::ConflictError)

can you help ?

Thank you !

@mikespax

This comment has been minimized.

Copy link

commented Apr 18, 2019

does this still work? i see there's a zapier plugin I could use..

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.