How Order Info Is Saved

Last Updated: Nov 01, 2018 05:14PM EDT
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.

Batch Processing

For technical information regarding how transaction information is stored for batch processing of orders, please contact the ProductCart support staff via email at info@productcart.com.



 

Menu

  • Support Forums
  • Video Tutorials
  • Support Request
  • Support Policy
647e99095133bd6d1ae916f97dc7f92f@productcart.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete