CSV Data 
Author: Steve A.
Visited 2563,
Followers 1,
Shared 0
Does anyone know how to include the order number as part of the csv data from the shopping order.
I need to import both CSV (User/order) into a database. The order number would allow me to create a set of related tables. I have explored numerous other ways, and despite searching many forums have not found a solution.
The order number, if it was provided on the both csv files would provide a unique reference and allow me to create a primary key in the customer table.
Posted on the
Hello Steve,
i am sorry but with Evolution 11 is not possible, only with the Professional version this function is included.
With the Professional 12 you can send the order in a Database. Please try the demo version here:
http://www.websitex5.com/
You can export your project and import it in a full versione of Professional 12.
Thank you.
Author
Thanks but I don't want to send it as a database. I just want to add the orders to 2 seperate tables in a database and use a unique key to join the two tables, to create an invoice. I use Access, and I'm guessing your "database" file wouldn't be compatible anyway?
Surely it's not much of a problem to add the order number filed to the csv files generated by the cart?
Or is this just a way of forcing people to go pro? Have to say this is the first time I have been very disappointed in your response!
Hello Steve,
You can set in the Professional version to save the order in a Database, then with a your personal script, you can copy the order saved in the first db, in a second db.
Author
Hi Riccardo, thanks but you're missing the point of the question. The csv data from an order arrives as two seperate csv files. One with the customer details, and on with the order details. In order to create an Access (or any) database that used related tables, you have to have a unique identifier from each record set. This is used as the link between the two tables.
This means that i could select a specific customer from table one, and it will display the linked order(s) from table 2. The unique reference number is the order number.
Your csv files do not currently have any common link, which is why I suggested adding the order number to both csv files at point of purchase using the cart. Easy enough, and no need to go pro!
Hello Steve,
with the WebSite X5 is not possible, you can write a new post in "idea" section so we can evaluate this.
Thenk you.