ecart not storing summary order in database

Since I installed databridge design extender ecart never store summary order by default. I put remote default, local default either ones works like before. What could be wrong with it. For example: it stores the price and product name but the others fields go emty like shipping name, shipping address, shipping phone etc. Also I add datapiker and message field that I want to store in database. How it should be configured to work perfect?

You may already have an orders table in your database with different column names.

Open the store cart summary in database server behavior on the confirm.php page and you should be able to re-assign any columns you want stored including the date and message fields you have added.

Originally Said By: Ray Borduin

  You may already have an orders table in your database with different column names.

Open the store cart summary in database server behavior on the confirm.php page and you should be able to re-assign any columns you want stored including the date and message fields you have added.  

They already assign but not working maybe something wrong, I will check it later. So how to include the new field. I already assigned in the preset manager but doesn't appear in the form like the other I meant the fields appears but in the server behavior not for binding

Did you add the field to the checkout form? It should automatically appear in the bindings once added to the form.

Originally Said By: Ray Borduin

  Did you add the field to the checkout form? It should automatically appear in the bindings once added to the form.  

Yes, but when I bind it I get 0 as value. If not I get null value. When I make wizard checkout I get pp_confirm.php with all of the field setup for example: orders summary an orders details ready. Order details work very good but order summary doesn't work. Only insert the price, product Id and product name other fields go emty. I try to add to the confim.php using persistent form. Where show me the form fields but I only got 0 as value.

Your bindings look wrong...

On line 176 of pp_confirm try:

$ConditionalQuery->bindColumn("OrderDeliveryDate", "t", "".WA_getSavedFormValue('CheckoutWizardShipping_Ornament_Ornament','Datapicker') ."", "WA_DEFAULT");

Also, you have a "d" for most of the column types... it should be "s" for string values. "d" is only for numbers.

Originally Said By: Ray Borduin

  Your bindings look wrong...

On line 176 of pp_confirm try:

$ConditionalQuery->bindColumn("OrderDeliveryDate", "t", "".WA_getSavedFormValue('CheckoutWizardShipping_Ornament_Ornament','Datapicker') ."", "WA_DEFAULT");

Also, you have a "d" for most of the column types... it should be "s" for string values. "d" is only for numbers.  

ok thank you I will try to fix that

Originally Said By: Jose

  ok thank you I will try to fix that  

Hello, Ray sorry to bother you again. I wanted to understand way ecart doesn't store all assigned column when I play by PayPal option. For example: when I pay by card it store all column but when I choose PayPal option it only store well first name an last name. The other columns go the same for customers and shipping address and telephone never store into the database base either for shipping address either for customers. Can you please tell me why it happenings?

Paypal uses the pp_confirm.php page instead of the confirm.php page to store the database information. You may have some of the same data type issues on that page or maybe need to update the server behaviors on that page to save the fields correctly.

The FTP information you provided previously no longer works, so I can't look for myself.