Shopify

This page describes how to use Census with Shopify.

🏃‍♀️ Getting Started

In this guide, we will show you how to connect Shopify to Census.

Prerequisites

• Have your Census account ready. If you need one, create a Free Trial Census account now.

• Have your Shopify account ready.

• Have the proper credentials to access to your data source. See our docs for each supported data source for further information:

  • Azure Synapse

  • Databricks

  • Elasticsearch

  • Google BigQuery

  • Google Sheets

  • MySQL

  • Postgres

  • Redshift

  • Rockset

  • Snowflake

  • SQL Server

🔌Connecting Shopify

Note: Census will only query Shopify based on the syncs/objects that you configure

1. Census connects via OAuth, so you need a Shopify user that can login to the instance with the following permission scopes:

   write_products	read_products
   write_customers	read_customers
   write_orders	read_orders
   write_inventory	read_inventory
   write_fulfillments	read_fulfillments
   write_assigned_fulfillment_orders	read_assigned_fulfillment_orders
   write_merchant_managed_fulfillment_orders	read_merchant_managed_fulfillment_orders
   write_third_party_fulfillment_orders	read_third_party_fulfillment_orders

2. There is some setup that is needed to do on the Census side to setup Shopify, while this process is under construction 🏗️, please contact us via email or start a conversation with us via the in-app chat with the topic: "Shopify Setup". In your communication please provide your Shopify Store URL so we can get started on your set up!

🗄 Supported Objects

Census currently supports syncing to the following Shopify objects (Contact us if you're looking for more!):

Object Name	Supported?	Sync Keys
Customer	✅	Email
Fulfillment	✅
Inventory Level	✅
Order	✅	Source ID
Product	✅	Tag ID, Handle
Product Image	✅ (via Product)
Product Variant	✅	SKU

Census also supports Shopify's Custom Metafields on Customer and Product as well.

Updating Product Images

Census supports setting product images by passing a Arrays and Nested Objects Array to the images field on the Product. The images array needs to be a set of one more objects that contain URLs to each image you want to upload. It should look something like the following:

[
  { 
    "position": 1, 
    "src": "https://via.placeholder.com/300.png?text=iPod%20Nano,%208GB", 
    "width": 640, 
    "height": 480 
  }
]

Only the src field is required. position, width, and height are optional.

🔄 Supported Sync Behaviors

Learn more about all of our sync behaviors on our Core Concepts page.

Behaviors	Supported?	Objects
Update or Create	✅	Customer, Inventory Level, Order, Product
Update Only	✅	Order
Append	✅	Fulfillment
Mirror	✅	Product Variant

Contact us if you want Census to support more Sync behaviors for Shopify.

🚑 Need help connecting to Shopify?

Contact us via [e-mail] or start a conversation with us via the in-app chat.