Database format for shopping cart orders 
Author: Martin GrossHello Steve,
works perfectly. Many thanks!
However, I still have a (hopefully minor) issue. In the body of the e-mail summary sent to me after having placed an order successfully, the data is correct including the 5 digit order number, but in the csv attachments (user_data.csv and order_data.csv) the order number is missing. At the moment I am trying this out on X5 10 Evolution. I plan to migrate the whole website to my new X5 Pro in order to write the order data into a database for further processing (invoicing, accounting). At the moment my hosting service is running on MSSQL so that I do not have a chance to test the database yet.
Would you please advice me how exactly looks the the structure in which the data will be written to the database (1 or 2 tables, columns) so that I can prepare accordingly?
Many thanks!
Martin
Hello Martin,
there is different tables in the DB, the order datas and client information are save in different tables in the DB.
In the .csv file the order number is not present, you can see it only in the email.
Try to test the sending to te DB with the WebSite x5 Professional 10.
Let me know if you have trouble.
Author
Hi Ricardo, thank you for your response.
I already tested on X5 Pro and in the admin the information is fine. I will try to connect the database to Excel so that I can see how to proceed with invoice automation.