X-Cart forums

[advantageco]

I want to add an extra field (an RA#) that will be initially populated from a session variable that will be displayed at checkout, in the customers order info, and definitely stored in the database so it can be referenced via the orders section. I figure it would be easiest to add the field directly to the order table, I just am unable to figure out where in the code I could add something like this in so it does get saved.

[advantageco]

Seems I have solved my own problem to a point, here's what I did:
-Added new field 'ranumber' to 'xcart_order_details' table
-Added new line in func.order.php (711)

$insert_data = array (
                    'orderid' => $orderid,
                    'productid' => $product['productid'],
                    'product' => addslashes($product['product_orig']),
                    'product_options' => addslashes($product['product_options']),
                    'amount' => $product['amount'],
                    'price' => $product['price'],
                    'provider' => addslashes($product["provider"]),
                    'extra_data' => addslashes(serialize($product["extra_data"])),
                    'productcode' => addslashes($product['productcode']),
                    'ranumber' => '$MYRANUMBER'); //This is the line I added.

Next steps for me is to add the functionality to display the RA# in the cart, invoice, and orders pages which will be a piece of cake after this.