Share My Creation SithasoDaisy: PocketBase - Mini CRM WebApp Source Code @ $5.00

Hi there

NB: Download and run PocketBase and set up an admin account there first. Here is the link

Demo hosted on Vercel.

Disclaimer: The back-end (PocketBase) for this demo is hosted on PocketHost.IO (SAAS Company), which is not optimal for production usage. Ceveat: WebApp Slow in accessing data from DB. This is different when you host / run your own version of PocketBase locally.

This MiniCRM has functionality for

• Customers
• Emails
• Email Templates
• Reminders
• Communication
• Appointments
• Tasks
• Documents
• and more

PocketBase - Open Source backend in 1 file

Open Source backend in 1 file with realtime database, authentication, file storage and admin dashboard

pocketbase.io

Pay SITHASO HOLDINGS (PTY) LTD using PayPal.Me

Go to paypal.me/anelembanga and type in the amount. Since it’s PayPal, it's easy and secure. Don’t have a PayPal account? No worries.

paypal.me

 

[Mashiane]

Drill Down by using the "Sales" column to see all sales for that product from the Products Listing

 

[Mashiane]

 

[Mashiane]

 

[Mashiane]

 

[Mashiane]

 

[Mashiane]

Demo on Vercel Updated:

SithasoDaisy Mini CRM - PocketBase

Sithaso Daisy Design System

sithaso-daisy-mini-crm.vercel.app

 

[Mashiane]

Hi

Should you need customization of this app to meet your needs, do not hesitate to DM me and we can talk.

No further development will happen on this project anymore. It has been an amazing, challenging and fullfilling piece of art.

Stay blessed and take care.

 

[Mashiane]

Finding the top customers.

In pocketbase create a collection with a type of view. Use the specified query.

select minicrm_sales.id, count(minicrm_sales.quantity) as totalqty, sum(minicrm_sales.totalprice) as totalsales, minicrm_sales.customerid from minicrm_sales group by minicrm_sales.customerid order by totalsales DESC

 

[Mashiane]

Finding the top products.

In pocketbase, create a new collection with a type of 'view', use the specified query.

select minicrm_sales.id, count(minicrm_sales.quantity) as totalqty, sum(minicrm_sales.totalprice) as totalsales, minicrm_sales.productid from minicrm_sales group by minicrm_sales.productid order by totalsales DESC