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 and Sync Behaviors

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

Object Name	Supported?	Sync Keys	Behaviors
Customer	✅	Email	Update or Create
Fulfillment	✅	Any unique identifier	Add
Inventory Level	✅	N/A	Update or Create
Order	✅	Source ID	Update or Create, Update Only
Product	✅	Tag ID, Handle	Update or Create
Product Variant	✅	SKU	Mirror

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

Learn more about all of our sync behaviors in our Syncs documentation.

Contact us if you want Census to support more Shopify objects and/or behaviors.

Updating Product Images

Census supports setting product images by passing an 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.

Need help connecting to Shopify?

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