Store order information in your database

Storing your order information in your database is one of the most important aspects of your online store. By storing this information in a database, you will be able to track orders, revenue, provide customer features such as an Order History, or even a Download Center for selling digital goods.

eCart 5 now includes the ability to create the necessary database tables and columns for you. To do this, choose the Create from preset checkbox, and choose the appropriate preset.

Note: In most cases, you will want to choose the Default option, this will create the necessary tables and columns without any interaction from you. If you are modifying PowerStore, a PowerStore preset is provided for you to choose.

Manually Binding values

You can choose to manually bind these values if you have an orders and orderdetails tables that include custom configurations. The following two steps are involved when manually binding these values. Each step requires a separate database table.

  • Order Summary: The order summary includes information such as total order price, date, customer id, etc.
  • Order Details: The order details include information such as each individual item included in the order, and the price purchased and quantity.

Once you have completed binding the values, you will have the opportunity to save these settings as a preset, for you to use later. This will save you a great deal of time when creating future checkout procedures.