close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

ecart not storing summary order in database

Thread began 4/01/2016 1:08 pm by Jose | Last modified 7/12/2016 8:37 pm by Ray Borduin | 230 views | 14 replies |

Jose

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?

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Jose

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

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post

Jose

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Jose

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

Sign in to reply to this post

Jose

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?

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Jose

Originally Said By: Ray Borduin
  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.  
Attached Files
pp_confirm.php
Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...