Shopify API Integration with Airtable - Position Already Filled Creating for Existing Person

Freelancer Project: Shopify, Airtable & Marketplace Integration
Project Overview
We want to start with a small, clearly defined project and then expand it as we improve the system together.

The overall client goal is to create a reliable Airtable → Shopify listing system, then use ExportYourStore (EYS) to synchronize Shopify listings to multiple marketplaces.
Phase 1 — Airtable → Shopify API Integration

Compensation
- $15 base payment for the initial project
- $10 completion bonus when Phase 1 is working as specified
- $5/week for the next 5 weeks for adjustments, improvements, bug fixes, and collaboration as we improve the system - possibly ongoing

Objective
Build a Shopify API integration that takes complete product/listing information from Airtable and creates or updates listings in Shopify.
Build parallel make.com to do the same.

Requirements
1. DooDah Company Python Site
- Build and host the integration on a Python-based site for DooDah Company.
- The system should be accessible for future development and improvements.
2. Open Code / Collaboration
- Code must be available for inspection.
- We want to be able to review, modify, and collaborate on the code.
- No proprietary black-box system that prevents us from maintaining or improving it.

3. Initial Scale
- test 15 then sunc batches of 50
- Approximately 800 listings
- Approximately 900 products
- The system should be designed so we can expand beyond this volume.

4. "List It" Button
- Airtable should have a "List It" function/button.
- When selected, the system should take the appropriate product information from Airtable and send it to Shopify through the Shopify API.
- The system should create the Shopify listing/product and return the Shopify reference information to Airtable.

5. Shopify Reference Number
- After a product is successfully listed, the Shopify reference number/ID should be written back into Airtable.
- This will allow Airtable to know exactly which Shopify product corresponds to each Airtable product.

6. Inventory Synchronization
- Inventory on hand needs to remain accurately aligned between Airtable and Shopify.
- We need to avoid duplicate products and incorrect inventory counts.
- The system should recognize existing Shopify products rather than creating duplicates.

7. Full Listing Information
The integration should support the relevant Shopify listing information, including as applicable:
- Product title
- Description
- SKU
- Price
- Inventory
- Images
- Product type
- Vendor/brand
- Tags
- Collections/categories
- Other required Shopify product fields

8. Resync / Updating
- Airtable will continue to be improved and corrected.
- We need the ability to resync/update Shopify from Airtable as information changes.
- The system should update the existing Shopify listing rather than creating a second listing.

Phase 1 Completion
Phase 1 will be considered complete when we can successfully:

Airtable → "List It" → Python/Shopify API → Shopify listing → Shopify reference returned to Airtable → inventory aligned → subsequent Airtable changes can be resynchronized to Shopify.

Phase 2 — Shopify → Multiple Marketplaces Through ExportYourStore
Compensation
- $10 base payment
- $10 completion bonus when the synchronization is successfully working

Objective
Once Phase 1 is working properly, we will use ExportYourStore (EYS) to synchronize Shopify listings to multiple marketplaces.

The target marketplaces are:
- eBay — 2 stores
- Vinted
- Mercari
- Poshmark
- Whatnot
- TikTok Shop
- Meta
-Google
-Amazon
We already know how to use ExportYourStore, so the primary objective is proper data alignment and mapping, not reinventing the EYS system.

Phase 2 Requirements
1. Shopify as the Source
- Shopify should contain the properly structured product/listing information coming from Phase 1.

2. ExportYourStore Mapping
- Configure ExportYourStore so Shopify listings map correctly to the two eBay stores.
- Ensure the appropriate fields are mapped accurately.

3. Marketplace Expansion
- Once Shopify → eBay is properly mapped, use EYS to map the same Shopify data to:
- Vinted
- Mercari
- Poshmark
- Whatnot
- TikTok Shop

4. Data Alignment all specifications to achieve 100% in ebay downstream listings
- Pay particular attention to:
- SKU
- Product title
- Description
- Images
- Price
- Quantity
- Brand
- Categories
- Variations
- Item specifics/attributes
- Marketplace-specific fields

5. Inventory Accuracy
- Shopify should remain properly aligned with the marketplace listings.
- We want to minimize overselling and duplicate inventory.

6. Testing
- Test the complete process with actual products before considering the phase complete.
- Verify that changes made upstream are properly reflected downstream.

That project will be scoped and priced separately once we determine exactly what needs to be integrated.

Overall Approach
The priority is not simply getting something working once. We want to build a system that is:
- Reliable
- Understandable
- Open for inspection
- Easy to modify
- Properly documented
- Scalable
- Accurate with inventory
- Easy for us to continue improving

If Phase 1 works well, we can continue working together on additional development and marketplace integrations.