How Product Configurations are Stored
How is a product configuration saved into the database when an order is placed?
- Order details are stored in the “orders” table
- Products details are stored in the “productsOrdered” table, which references the order ID
- Item configuration details for a Configurable Product that was purchased within that order are stored in the “configSessions” table. The “configSessions” table describes the configured product that the customer has purchased. The “productsOrdered” table contains a link to the “configSessions” table via the “idConfigSession” field.