Inventory sync between online platforms and gallery system

Purpose

1.1. Ensure real-time and accurate synchronization of artwork inventory between e-commerce stores (such as Shopify, WooCommerce, Magento) and a central Indigenous art gallery management system.
1.2. Prevent overselling and misrepresentation by reflecting sales, restocks, and new listings instantly on all connected platforms.
1.3. Streamline inventory updates when artworks are exhibited, sold, or transferred between locations.

Trigger Conditions

2.1. New sale recorded on any connected e-commerce platform.
2.2. Manual inventory update in the gallery management backend.
2.3. Restocking or new acquisition added to the gallery system.
2.4. Removal or reservation of artworks for exhibition or loan.

Platform Variants

3.1. Shopify
• Feature: Webhooks (Order Creation, Inventory Level Update)
• API: Admin API `/admin/api/2022-10/inventory_levels.json` for updating inventory
3.2. WooCommerce
• Feature: REST API
• Endpoint: `/wp-json/wc/v3/products/{id}/` (Update stock quantity)
3.3. Magento
• Feature: Inventory API
• Endpoint: `/V1/products/{sku}/stockItems/{itemId}`
3.4. BigCommerce
• Feature: Catalog API
• Endpoint: `/catalog/products/{product_id}` (Stock update)
3.5. Wix Stores
• Feature: Wix API
• Endpoint: `PATCH /stores/v1/products/{productId}`
3.6. Squarespace
• Feature: Inventory management via Commerce API
• Endpoint: `/commerce/inventory/{productId}`
3.7. Salesforce Commerce Cloud
• Feature: OCAPI
• Resource: `/s/-/dw/data/v19_8/inventory_lists/{inventory_list_id}/product_inventory_records/{product_id}`
3.8. PrestaShop
• Feature: Webservice API
• Endpoint: `/api/stock_availables/{id}`
3.9. OpenCart
• Feature: API
• Endpoint: `PUT /api/product/{product_id}` on stock update
3.10. Amazon Seller Central
• Feature: Selling Partner API
• Endpoint: `POST /listings/2021-08-01/items/{sellerId}/{sku}`
3.11. eBay
• Feature: Inventory API
• Endpoint: `POST /inventory_item/{sku}` (update availability)
3.12. Etsy
• Feature: Listings API
• Endpoint: `PUT /v2/listings/{listing_id}/inventory`
3.13. Artlogic
• Feature: REST API
• Endpoint: `PUT /api/v1/artworks/{id}` (update quantity/availability)
3.14. Artsy
• Feature: Partner API
• Endpoint: `/api/v1/artworks/{artwork_id}`
3.15. GalleryManager
• Feature: API
• Endpoint: `/api/v3/items/{id}`
3.16. Art Galleria
• Feature: REST API
• Endpoint: `/v1/artworks/{id}`
3.17. Zoho Inventory
• Feature: API
• Endpoint: `PUT /api/v1/items/{item_id}`
3.18. NetSuite
• Feature: SuiteTalk Web Services
• Function: Update Inventory Item record
3.19. QuickBooks Commerce
• Feature: Inventory API
• Endpoint: `PUT /v3/company/{company_id}/item/{item_id}`
3.20. SAP Business One
• Feature: Service Layer API
• Function: `PATCH /InventoryGenExits({DocEntry})` for outgoing inventory adjustments

Benefits

4.1. Reduces manual reconciliation effort—inventory is always current across all sales platforms.
4.2. Minimizes risk of double-selling unique artworks or cultural objects.
4.3. Improves customer experience with accurate online availability.
4.4. Increases operational efficiency for gallery staff, enabling focus on curation and artist relations.
4.5. Ensures compliance and transparency for provenance and stock movement reporting.