How Order Info Is Saved
Orders are saved to the ProductCart database using the following tables:
- Orders
The orders table contains details about the customers’ billing and shipping address, shipping and payment options used for the order, discounts applied, and more. The details field in the orders table contains a summary of the products purchased. Don’t use this field if you need to query which products were part of the order. Use the ProductsOrdered table instead. - ProductsOrdered
Contains a list of the products that were part of any order. Each product is represented by one record in the database. The idOrder field contains the order number to which the products belong. Orders that contained multiple products are represented by multiple records that share the idOrder value.