Cycling Frog

Crossfading Data

Cycling Frog is a CBD and THC Seltzer brand headquartered in Seattle.

With their wide distribution, they utilize Vermont Information Processing (VIP). VIP is the leading finder API for people in the beverage industry.

But Cycling Frog ran into a problem. A lot of their wholesale beverages were being sold through Shopify, but were not being integrated into the API and thus their finder app.

Built on Shopify, they asked us to create a custom API feed that would take VIP data, Shopify Data, and even allow custom retail accounts.

Leveraging WordPress as the Engine

We rooted the API URL in the WordPress content management system.

In it, we set up cURLs to the VIP API that run hourly to synchronize data.

We then, built a Shopify integration into it that would pull wholesaler buyers according to customer data. The data needed to be parsed by specific parameters, including the customer’s last buy.

This data also updates hourly and drops off accounts that are not within the date range.

Finally, we created a custom location adder matching the field structure that would allow Cycling Frog to add wholesalers outside Shopify and VIP.

Within WordPress, we built functions to sort all of the data. Our biggest challenge was to make sure all the various sources were mapped to central field conventions.

Although these sources are vastly different, we almagamated them into a singular stream of data.

A Map for Finding Your Frog

The final result is built on Shopify.

Upon search, it queries the custom API and locates the product at applicable locations.

The API feed is encrypted to prevent misuse outside of the Shopify use-case.