Need minor help with db insert customization

I need minor help with db insert customization. Can someone help me please?
It seems better to tie into what code is written than using the webassist extensions to store in db, or am I wrong.
The db tables are ready. It's the php code for insertion that I need help with.

#1) I would like the OrderID to be inserted into the ps4_registrants table with each registrant. (this is a custom table for compiling all registrants in one place)

#2) I would 2 custom text fields to be inserted into the ps4_orders table.

<input name="school_club_name" type="text">
into OrderSchoolName of the ps4_orders table

<select name="kids" id="kids"> quantity value chosen to be inserted
into OrderKids_Under3 of the ps4_orders table.

Thank you very much for your help today,

^^^Please advise me on what page to update and what tools to use - thanks a bunch^^^

John

This is not a supported modification of Power Store, the page that stores the order information to the database is the webassist/plugins/shopping_cart/store_cart.php page


you would need to edit the store order summary behavior to store additional information to the ps4_orders table. and you would need to add a store order details behavior to store information to the ps4_registrants table.


this goes beyond what we can help you with in the forums, if you require assistance, please sign up for a premiere support appointment.