Develop Inventory Sync Tool Between Shopify and Airtable
Skills Required
Description
Managing product inventory manually across multiple platforms has become inefficient for our operations. We’re in need of a robust syncing solution that connects Shopify and Airtable, allowing updates on either side to reflect instantly without human intervention.
Airtable is central to how we handle inventory, warehousing data, and internal reporting. However, our Shopify store is the primary sales channel, and discrepancies between the two are causing inventory mismatches and fulfillment delays. A sync tool would dramatically streamline our workflow and improve accuracy.
This tool should support bi-directional synchronization. When an item is sold on Shopify or manually updated in Airtable, the corresponding platform should update automatically within seconds or minutes. Delays or missed updates will be unacceptable, so reliability is key.
Firebase has been our go-to for lightweight serverless functions and authentication, so we’d prefer to use it unless you recommend a better alternative for this use case. We're open to suggestions, especially if it improves long-term maintainability and cost efficiency.
You’ll be responsible for setting up webhook-based triggers from Shopify and possibly using Airtable’s scripting or automation tools for the reverse connection. A clear, well-documented approach to handling product variants, out-of-stock items, and soft-deleted entries will be important.
Error handling and visibility are also pr...