Orders are saved to the ProductCart database using the following tables:
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.
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.
For technical information regarding how transaction information is stored for batch processing of orders, please contact the ProductCart support staff via email at firstname.lastname@example.org.