Squarespace Interface
Last Updated 5/27/21
Overview
The interface with Squarespace supports a 1-Way integration using Squarespaces’s API.
Sync Approach
Yellow Dog pulls sales from Squarespace’s API using a SyncWithMicrosServices.
Sync Frequency
By default the sync is scheduled to run hourly. Additional scheduling options are available upon request.
Requirements
Client
The client will need to provide a Squarespace API key with Read privileges for Orders and Transactions. Your Yellow Dog Implementation Guide will be able to provide instructions in generating the key if needed.
POS Partner
The ability to generate the API key may require an upgrade to the Commerce Advanced plan. Please consult with Squarespace.
Yellow Dog
TBD.
Responsibilities
Client
Items and recipes will need to be mapped in Yellow Dog to the correct POS item in order to deplete inventory,
POS Partner
TBD
Yellow Dog
TBD
Data Exchange and Mapping
Importing Sales Data
The following fields are provided in the .csv from Northstar:
| Squarespace Field | Yellow Dog Field |
|---|---|
| Order Id | Transaction Number |
| Order Created On | Check Closed |
| Order Line SKU | Item Number |
| Order Line SKU | SKU |
| Order Line Product Name | Item |
| Order Line Unit Price Paid Value | Item Retail |
| Order Fulfillment Status | When "Canceled" we treat as a return |
| Squarespace_[TransactionNumber] | ThirdPartyID |
| [ThirdPartyID_]_[orderLine productID]_[orderLinevariantID] | Coverted |
Additional Information
All orders with Fulfillment Status = Closed are handled as returns.
Limitations
Multiple Squarespace instances against a single Yellow Dog Database is not currently supported.
The following is not supported in this integration because they are unavailable in Squarespace’s API:
Discounts
Employee Name / Number
Register Name / Number
Parent Number (used to designate modifiers)
