Job description
The sheet has to store a database of customer orders and assign customers to different groups of customers and then according to these groups assign the order to a particular shipping employee, please use the data on the basis of customer A,B,C,D / product butter, bread, egg, etc....
I need to be able to easily generate a mailing list of customers in a csv file also according to a given group of customers
Please do not accept the order if there are any doubts about the implementation Only libre office Only serious orders, I am interested in a fast turnaround time
DATA is let's assume
ORDERS
customer email, product name, product quantity (there may be several products - I do not know how to solve this), package code, order number, status (shipped, not shipped)
(assigning to a particular shipper on sheet #2 according to filters),
PRODUCTS
product x / in quantity from 1-20000
product y / in quantity from 1-20000
product z / in quantity from 1-20000
CUSTOMERS
customer email and more to be discussed with selected contractor