Database

All collected data is raw. The following information for each customer:
▪ Full Name
▪ Email Address
▪ Phone Number
▪ Address
▪ Date of Birth
▪ Purchase History (Date of purchase, Item/s purchased, Quantity, Price,
Total Amount, Order Number, Payment method (credit card/cash)
▪ Notes/Comments (Ex. discounts applied, special request, delivery details)s (Ex. discounts applied, special request, delivery details)
Tools use google spreadsheet the data base contains two sheets.
Sheet 1 - Customer Details
Sheet 2 - Invoices
Used two separates sheets so the data are not be mix-up and for easy
visualization.
Link of spreadsheet:
https://l.messenger.com/l.php?u=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1hsGOvNSOHNUFn_-0qip9TaTuMG0lU38UREzCdPFd6lc%2Fedit%3Fusp%3Dsharing&h=AT2SKOb2BPitLWsqRYhPAXq2aEBXlQx6PLv9n6vAFwPyPhqr-Qhrgin7d7Qn_nOvzlwcEQcKlMb_xpndLKEbS-49dVauiFv_1cfPrmbMtff8-NylDVsOWO_AH5DmZAu_SrUWzw