Comparing Order shipment , payment received , return tools
order number always numeric only no space .. can accept these characters / -
Dear programmer ... we ship around ... 100 of order on every day basis ,,.. each order shipped with the batch numbers...
one courier one batch number.
these shipped order we want to insert into data base as
order no | batch No | Courier | Date
now after we ship the order.. there are further process as below ...
A. we received payments. particular order numbers
B. few order we received order return
C. Order get cancel
now from script we need to know
A. - how many order and there number neither received return, nor paid and not canceled..
B. - How many order and there numbers we got return
B. - How many order and there numbers we got payment