Python Developer Needed to Build Product Rotation Algorithm

"Big Al" - Tiktok Live Algorithm

Project Overview

I am looking for a Python developer to build a product rotation and sales-tracking algorithm called Big AL for my football-themed business, Top Binz.
Big AL will be used to organise TikTok Live selling sessions. Each TikTok Live will feature:
11 player fanart t-shirt designs
11 signed player print designs
The goal is to make every Live different, avoid unnecessary duplication, give every design fair exposure, and use sales data to identify best sellers and the strongest buying times. The best-performing products will later be used to improve my Shopify store collections and product promotion.

Main Goal

Build a Python-based system that can automatically generate TikTok Live product sets based on product IDs, performance data, availability, and rotation rules.
The system should help answer:
Which t-shirt designs should appear in the next Live?
Which signed prints should appear in the next Live?
Which products have not been shown enough?
Which products are best sellers?
Which players, categories, and time slots perform best?
Which products should be pushed onto Shopify as winners?

Product Structure

Each individual design will have its own unique ID.
Example t-shirts:
TEE-0001 — Zidane Design 1
TEE-0002 — Zidane Design 2
TEE-0003 — Messi Design 1
Example prints:
PRT-0001 — Zidane Signed Print
PRT-0002 — Messi Signed Print
PRT-0003 — Ronaldinho Signed Print
The algorithm should treat every design as its own product, not just group everything by player.

Required Features

1. Product Database
The system should allow me to store and manage:
Product ID
Product type: T-shirt or signed print
Player name
Design name
Category, such as Brazil, Argentina, Premier League, France, GOAT, etc.
Stock quantity
Status: Active, New, Hot, Cold, Retired
Number of times shown in Lives
Sales
Revenue
Last shown date/time
2. TikTok Live Set Generator
The system must generate a Live set containing:
11 unique t-shirt IDs
11 unique signed print IDs
Each Live should avoid:
Duplicate products in the same Live
Repeating the same products too often
Showing out-of-stock or retired products
Overloading one Live with too many designs from the same player, unless allowed
3. Rotation Rules
The algorithm should be able to follow rules such as:
Prioritise designs that have never been shown
Prioritise designs with low appearances
Include a small number of proven best sellers
Include some new or test designs
Avoid products that appeared in the most recent Lives
Keep each Live fresh and different
A suggested starting structure is:
60% new or low-exposure products
30% proven performers
10% wildcard/test products

This should apply separately to t-shirts and prints.
4. Performance Scoring
The system should score each product based on performance.
Useful metrics include:
Total sales
Revenue
Sales per appearance
Conversion rate if views/clicks are entered
Average sales by day
Average sales by time slot
Last shown date
Stock remaining

Example score:

Sales per appearance = total sales ÷ number of Live appearances
The scoring system should help classify products as:
New
Rising
Hot
Average
Cold
Retired
5. Live Results Tracking
After each TikTok Live, I need to be able to enter results such as:
Live ID
Date
Time
Product IDs shown
Views if available
Clicks if available
Sales
Revenue
Notes
This data should update future product selections.
6. Calendar / Schedule Generator
The system should support a schedule of:
5 days per week
3 Lives per day
45 Lives per week
11 t-shirts and 11 prints per Live
The algorithm should be able to generate a weekly schedule while keeping products fairly rotated and avoiding duplication where possible.
7. Shopify Winner Output
The system should be able to export or identify products for Shopify, including:
Best sellers
Trending products
Products with strong conversion
Products that should be featured on the homepage
Products that should be tagged as TOP_TIER, TRENDING, HOT, or LOW_TIER
A CSV export would be useful for future Shopify product tagging.
8. Dashboard / Reports
The system should generate simple reports showing:
Top-selling t-shirts
Top-selling prints
Best-performing players
Best-performing categories
Best days for sales
Best time slots for sales
Products that need more exposure
Products that should be retired or redesigned