Author image
Project image

Client

Perifit is a medical company that produces & sells IoT enabled medical devices. Perifit reached out to Self Made to build their analytics backend.

Project Description

The system had 3 responsibilities:

- It should collect historical data back to 2018.

- It should run in daily intervals to collect up to date orders.

- It should calculate the profit margins for every product (with regard to platform commissions, taxes, shipping costs etc).

Outcome

Within 2 weeks, the system had been put in place. The result was a script that ran for almost 24 hours due to Amazon MWS & Shopify rate limits.

Final spreadsheet

missing alt text

Challenges

- After completing the project using Amazon MWS, Amazon Selling Partner API was released. Amazon Selling Partner API would be more effective but it had not yet been released.

- It was difficult to acquire Shopify fee data. Finally, we succeeded by looking at the payment receipt info. It was not documented well and we had to dig into many pages of stack overflow and Shopify community answers.

Self Made role

Self Made ran the whole project inhouse and continues to cooperate with Perifit to integrate marketing data into the system.

Technology used

Tech iconTech iconTech iconTech icon