We have an ecommerce and email system. We can get a feed from our ecommerce system into our email system using XML which is like
Obviously, customer can purchase 1 - infinity products.
I am thinking we can bring into a table like:
| email | product | price|
email@example.com | item 1 | 2.00 |
firstname.lastname@example.org | item 2 | 2.00 |
email@example.com | item 3 | 2.00 |
firstname.lastname@example.org | item 1 | 2.00 |
Is this the best way to manage this or can anyone suggest a better table?