What is the solution for providing engagment from your customers in order to buy your products ?
Issue : Nowadays, a lot of customers put some items into their basket without ordering them in the end.
Solution : Provide a mailing system that send emails to these customers to remind them to buy the product.
Database overview with Lucidchart
We need to structure the database into 3 tables:
You can do this here
Here an overview of what the Firebase DB could look like :
You can create your database here
Our database will be a part of the company’s database. We will filter the basket table according to two attributes that are “Productwasbuy” and “date”. Then we will retrieve the customer ID and product ID from the results of the previous queries to get to the email address and name of the product through two filtered queries on the customer’s table and product’s table.
Customize the queries
We need to create a form for the company to customize its queries. For instance, they could only target the customers that didn’t buy what they put in their basket during the previous week to send them reminding emails if they want to. They just need to enter the dates of the beginning and of the end of the research.
This could be a part of the form:
Please select a date :
Here a suggestion of code to display the email adresses of customers according to the previously defined criteria: