Is it possible to send order information to be stored onto a database when each order to a wix store is made?
My friend has a wix store which sells clothing. Order information includes things such as the item of clothing (Hoodie, tshirt etc), size, color and custom text. He currently processes and views orders by accessing the email linked with the wix store. However this is inefficient because for example he needs to check the number of hoodies, shirts and jumpers which have been ordered so he can order them from his supplier. It’s not possible to do this without manually going through each email and manually counting the number of clothing items needed. There are other reasons too.
If the order information was stored on a database instead of only email a simple SQL query could be used instead which is much faster. Anyone have any idea how I can do this?
P.S I can code, I am a familiar with HTML, SQl, PHP and JavaScript.