Setup Data Warehouse / Order Hub – Upwork

The high-level goal of this project is incorporating order history from three ecommerce platforms and two affiliates systems under one roof.

Ecommerce platforms:
WooCommerce (archived), SamCart (archive), Shopify or ThriveCart (TBD)

Affiliate program:
AffiliateWP (archived) and GoAffPro (current)

LMS:
Thinkific (courses)

Goals:
– Central place for all customer and order history to live. Data goes back to 2014.
– Ability for customer service team to look up customer and see orders
– Make order changes (or sync from eccomerce) and make access changes in Thinkific (line items on orders correlate to bundle access in Thinkific)
– Central place for affiliate partner data (tied to above order data) to live. Data goes back to 2014.
– Executive team can see affiliate partner performance and sales in reports.

Implementation:
The implementation will be up to experience of you. Though a technical person myself, I’m open to how this could be implemented:
– Maybe an existing analytics/data warehouse solutions will suffice
– Or something could be built using no-code tools like AirTable, Bubble, Zapier, etc.
– Or could require custom web app with it’s own API and webhook integrations

Excited to hear from you. Open to teams or individuals.

Hourly Range: $15.00-$35.00

Posted On: March 11, 2022 21:10 UTC
Category: Full Stack Development
Skills:WordPress, Data Warehousing, Shopify, ETL, Airtable, Ecommerce Support, Ecommerce, WooCommerce, Analytics, Klipfolio, Fivetran

Country: United States

click to apply

Generated by Feedzy