Squarespace Integration Add-On for Dynamics 365

API Integration with Business Central

The Squarespace Integration Addon enables seamless connectivity between your Squarespace store and Microsoft Dynamics 365 Business Central (BC) through secure and robust RESTful APIs. By leveraging classified API requests such as GET, POST, and DELETE, the addon ensures real-time synchronization of store data, products, inventory, and orders, while maintaining complete data integrity and operational efficiency.

Supported API Requests and Functionalities

GET Requests:
Used to retrieve and fetch data from Squarespace, enabling Business Central to stay updated with the latest store information. Common GET operations include:

1. Fetch Products: Retrieves the complete product catalog for the connected Squarespace store. Returns every product (physical, digital, service) with full details including product ID, name, description, URL slug, images, tags, visibility status, variants, pricing (base and sale), SKU, stock levels, weight/dimensions, SEO settings, and creation/modification timestamps. Supports pagination via cursor/nextPageUrl. Essential for initial sync and keeping product data up-to-date in external systems.
2. Fetch Inventory: Returns real-time inventory levels for all product variants across the store. Each item includes variantId, SKU, human-readable descriptor, current quantity, and whether stock is unlimited. Used primarily to prevent overselling during order placement in external platforms (e.g., marketplaces, custom checkouts). Also supports pagination.
3. Fetch Store Pages: Lists all store pages/collections configured in the Squarespace Commerce setup. Returns page ID, title, and enabled/disabled status. Useful for verification, mapping products to collections, and ensuring the store configuration matches expectations before syncing.
4. Fetch Orders: Retrieves customer orders (both live and test-mode) with comprehensive details: order number, creation/modification dates, customer email, billing & shipping addresses, fulfillment status, line items (with variantId, SKU, product name, quantity, price paid), shipping methods, totals (subtotal, shipping, tax, discounts, grand total), currency, and refunds. Supports filtering by date, status, etc., and pagination via cursor. Critical for syncing orders into external ERPs, accounting systems, or fulfillment platforms.

POST Requests:
Allows Business Central to push new or updated data back to Squarespace. Examples include updating product details or inventory levels directly from BC such as;

1. Create Product: Creates a brand-new product in the Squarespace store. Allows setting product name, description, product type (physical, digital, or service), SKU, pricing, initial stock quantity (or unlimited), weight, dimensions, and variant attributes in a single call. Returns the full created product object with assigned productId and variantId(s).
2. Update Product: Fully or partially updates an existing product. You can modify name, description, URL slug, images order, visibility, pricing (base/sale), variant attributes, shipping measurements, SEO settings, and more. Variant-specific fields require including the variantId. Squarespace applies only the fields sent in the payload (patch-style behavior).
3. Upload Product Image: Uploads one or more images to a specific product. Accepts either multipart/form-data (recommended) or base64-encoded imageData in JSON. Squarespace processes the image, generates all required sizes, and attaches it to the product. Returns imageId, URL, and format details. Images can later be reordered or deleted separately.
4. Update Inventory: Performs batched inventory adjustments across multiple variants in a single request. Each adjustment specifies SKU (or variantId) and a quantityDelta (positive to increase stock, negative to decrease). Ideal for real-time stock sync after external sales, returns, or manual corrections. Supports both limited and unlimited inventory items. Returns success/failure status per adjustment.

DELETE Requests:
Enables efficient cleanup and management of store data by allowing deletion operations, such as:

1. Delete Product: Permanently removes an entire product (including all its variants, images, and associated data) from the Squarespace store. Useful for cleaning up discontinued, test, or obsolete items. Successful deletion returns 204 No Content. The product immediately becomes unavailable for sale and disappears from all store pages.
2. Delete Image: Removes a specific image from a product. Only detaches the selected image while leaving the product and other images intact. Commonly used to replace outdated photos or clean up incorrectly uploaded media. Successful deletion returns 204 No Content. The image is instantly removed from the storefront and CDN.

API Permissions Required for Business Central ⇆ Squarespace Integration

Seamlessly integrating Squarespace Commerce with Microsoft Dynamics 365 Business Central requires a robust, secure, and fully controlled API authentication framework. This integration relies on two layers of authentication to ensure safe and reliable data synchronization across products, inventory, orders, and pricing. Squarespace employs API keys that act as primary authorization tokens, along with secret keys that provide an additional layer of security. These keys authenticate every request your system makes, enabling capabilities such as reading and updating products, managing inventory, syncing store pages, and retrieving orders — all without requiring extra permissions. For example, a sample Squarespace API key could be sqsp_test_9Fxs29JDh29skL29A, which developers can use in sandbox environments for testing. Meanwhile, Microsoft Dynamics 365 Business Central leverages Basic Authentication through a combination of a BC API username and a Web Service Access Key, ensuring that every data exchange is secure. To enable complete synchronization of products and inventory, the BC API user should have permissions like Financials.ReadWrite.All or full system access, allowing your integration to push product updates, adjust stock levels automatically, and retrieve operational data efficiently. By combining Squarespace’s secure API key model with Business Central’s read/write financial permissions, businesses achieve a fully automated workflow where product data, inventory levels, and customer orders remain accurate across all channels in real time. This integration not only eliminates manual data entry but also ensures enterprise-grade security, compliance, and seamless communication between both platforms, ultimately enhancing operational efficiency and enabling your eCommerce operations to scale with confidence.

Secure RESTful Communication

• The integration relies on secure HTTPS endpoints to transmit data between Squarespace and Business Central.

• OAuth 2.0 and API Key authentication ensure only authorized access to store data.

• Data synchronization occurs both ways — Squarespace to Business Central and Business Central to Squarespace — providing real-time, accurate, and reliable information across platforms.

Benefits for Business Operations

• Real-Time Synchronization: Orders, inventory, and products are instantly updated between Squarespace and BC.

• Data Accuracy: Reduces manual entry errors and ensures consistency across systems.

• Streamlined Workflow: Administrators can manage products, inventory, and orders efficiently from within Business Central.

• Scalable Integration: Supports multiple stores and can easily extend to additional data types or future e-commerce features.