Marketplace drposhipping - build an alternative to Shopify Collective

**Project** The project aims to build a backend service that replicates the functionality of Shopify Collective for a French retailer marketplace but staying on a dropshipping model. The core goal is to enable partner brands (suppliers) to connect their Shopify stores to the retailer's store, synchronize their products, and automatically receive orders placed by the retailer's customers via a dropshipping model. The service will have the following key functionalities: * **Product Synchronization**: * Connect to supplier Shopify stores via API. * Import selected products (title, description, price, stock, images, variants) to the retailer's store. * Update existing products if they are already present. * Store the link between supplier and retailer product IDs. * Allow manual synchronization via an endpoint and automatic synchronization every hour. * **Order Forwarding**: * Receive Shopify webhooks for orders placed on the retailer's store. * Identify involved suppliers based on ordered products. * Create corresponding orders on supplier Shopify stores, including customer shipping addresses. * Generate separate orders for each supplier if an order contains products from multiple suppliers. * Log all order details (retailer order ID, supplier order ID, status) in the database. * **Supplier Management**: * Provide admin endpoints to add, list, and deactivate suppliers. * Identify suppliers by their Shopify shop domain and API access token. The project requires the service to be simple, maintainable, and deployed to production. **Deliverables include:** * Complete TypeScript project that builds without errors. * Comments on non-trivial code sections. * Documented `.env.example` file. * Comprehensive `README.md` with installation, setup, endpoint descriptions, and deployment instructions. * Service deployed and running on Railway with a migrated PostgreSQL database. * Configured and tested Shopify webhook in production. * Railway project transfer or detailed instructions for recreation. * Documented end-to-end test. * 1 month of post-delivery support for blocking bugs. * A handover session explaining key functionalities. **Profile** The ideal candidate will possess the following qualifications and skills: * **Experience**: * Experience with Shopify API (webhooks, REST API, authentication). * Experience with similar Shopify projects, specifically API integrations and webhooks. * **Technical Skills**: * Strong proficiency in Node.js and TypeScript. * Comfortable working with Prisma ORM and PostgreSQL. * Familiarity with Express.js framework. * Experience with the `@shopify/shopify-api` SDK. * Experience with hosting platforms like Railway. * Proficiency in GitHub for version control. * **Soft Skills**: * Autonomous and capable of working independently. * Ability to deliver clean, well-documented projects. The developer will be responsible for creating and managing the Railway (or other) account during development, setting up the PostgreSQL database, and handling the handover of the Railway (or other) project or providing comprehensive documentation for recreation. All infrastructure costs during development are to be covered by the developer.