Contact person: Business Client

Phone:Show

Email:Show

Location: Reinholds, United States

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"We are a raffle business in which customers order digital art in exchange for entries for a grand prize. For example, a person may purchase $20 worth of digital art in exchange for 20 entries for the grand prize. We may set a maximum limit of entries for each drawing/campaign.

We would like to have shopify integrated with Airtable. The first request is to have two Airtable tables, 1 with unique customers with their total amount of orders and entries. Since a customer can purchase multiple times, the table should have a total amount of entries within a designated date/time range.

The second table will be the "draw" table. In this table, we will have each individual table row designate as an unique entry for each customer, also randomized. Previously mentioned about the max entries, we would also like to randomize these unique rows. For example, if a campaign has 10,000 max entries, and a customer purchases $20 (20 entries), we would like the rows to be created to be random (1, 4, 39, 51, 70, 200, 251, 388, and so on). The idea is that we would output the second table to a public website on Godaddy Airo so customers can reference their entries. We would use a third party randomizer to pick a random entry from the website that has Table 2.

We are requesting a resource that has experience with Airtable integration with Shopify and can output into a Godaddy html.

The data should be updated in real time and allow administration to change the filters for easy viewing.


If you’re comfortable with the Airtable API, Shopify’s admin API or approved third-party connectors and can set up reliable automations, you’re exactly who I need.

Deliverables
• A fully configured Airtable ⇆ Shopify integration, tested end-to-end
• A live GoDaddy page that pulls from the same data source
• Clear hand-off notes outlining how to add new fields or products and troubleshoot basic sync issues

Once those three items are working smoothly, the project is complete. We will also require post go live support as well." (client-provided description)