Woocommerce Buyer Leaderboard Buyers' Leaderboard Page

Budget: 1400 UAH Deadline: 3 days

I can do it, write to me if you're interested, we will discuss the details and start. Thank you

Budget: 25000 UAH Deadline: 25 days

Hello, I will do it!

I have 6 years of experience in creating turnkey websites and refining existing ones.
I have worked with companies from Italy, Kyiv, and the USA.
I am ready to provide free consultation.

You can see my work here:
Portfolio on Freelancehunt: Freelancehunt
Repositories on GitHub: github.com/web-programmer-pro

Write to me – let's discuss your project! Expand

Budget: 12000 UAH Deadline: 10 days

1. Dynamic Customer Ranking Page

I will create a page that automatically updates every month and displays the top ten most active customers. The table will show their rank, name, partially hidden surname, and total spent. For better readability, the top three places will be visually highlighted — for example, with gold, silver, and bronze colors.

The page will be responsive and look correct on both desktops and mobile devices.

2. Only Consider Actual Completed Orders

To avoid errors in the ranking, only orders with the status "paid" or "completed" will be considered. Delivery costs are excluded; only the actual order amount is taken.

3. Handling Customer Duplicates

One of the key issues in WooCommerce is duplicates: when some orders are placed by registered users, and others manually through the admin panel. I will implement an algorithm that merges such cases based on phone number or email, even if accounts are different or missing altogether. This will ensure a fair calculation of each customer's expenses.

4. Display of the Monthly Prize

On the ranking page, there will be a block with the current prize. The administrator will be able to change the prize name, image, and description via a user-friendly interface. This will allow easy adaptation of the page for monthly promotions without editing code.

5. Archive of Past Winners

I will implement a separate block or page where the history of winners can be viewed. It will display the prize for that month, the top 3 winners, total expenses, and partially hidden surnames. Navigation will be implemented as pagination or a drop-down menu for easy browsing.

6. Current User's Position

Each registered customer visiting the page will be able to see their position in the overall ranking even if they are not in the top 10. This additionally encourages activity.

7. Administrative Panel

A convenient interface for administrators will be created, where they can:
• set or change the current month's prize,
• manually edit historical data,
• view suspicious customer duplicates (for verification or merging).

⸻

Implementation Features
• All logic will be implemented in PHP with direct integration into WooCommerce.
• Additional fields and settings will be stored in the database via the WordPress API.
• All information will be cached for optimal page speed.
• The project is designed for scalability — later, email newsletters, push notifications, or CRM integration can be added. Expand

Budget: 7000 UAH Deadline: 3 days

Here is the best and simplest implementation option for the Leaderboard page, considering the issue of duplicate clients, admin panel capabilities, history, ratings, and automation:

⸻

1. Key to a simple and reliable implementation:

A single normalized client identifier + automatic grouping by it.

⸻

How it works in practice:

A) Single client database (table customer_profiles)
• Each unique buyer has a separate record in the customer_profiles table.
• Identifier — normalized phone number or email (+380————-, —-@———.——).
• Orders (from any source — account or manual) upon creation:
• searches for a match by phone/email,
• if found — linked to customer_profile_id,
• if not — a new profile is created.

In WooCommerce, this can be implemented via a hook on woocommerce_checkout_order_processed + background cron for existing orders.

⸻

B) Expense accounting
• For rating calculation:
• filter orders with completed or processing status,
• date within the current month,
• exclude delivery cost,
• group by customer_profile_id.

SQL query or WP_Query, or a special API endpoint (REST).

⸻

C) Leaderboard page UI
• Display top-10 clients:
• Place
• Name + hidden surname
• Total
• Styling: gold, silver, bronze
• Current prize: editable in admin via ACF or custom option.
• Bottom block: “Your place” — a separate query for the current client (by phone/email).

⸻

D) Monthly history
• Store historical tables:
• JSON/record in WP Option or custom CPT leaderboard_month
• Top-3, prize, photo, total — stored manually or via script at the beginning of the month.

⸻

E) Admin panel
• Page with tabs:
1. Current month (top-10)
2. Monthly history
3. Prizes (ACF or Settings API)
4. Possible duplicates (auto-list with same phone)
5. customer_profiles editor

⸻

Conclusion:

The best solution = combination of automation + controlled backend:
• No confusion with accounts.
• Everything built around a single client (by phone/email).
• Easy scaling.
• Minimal manual work. Expand

Budget: 1111 UAH Deadline: 11 days

Good evening, interesting task. I understand e-commerce entities, and I can bring them to the surface