Google Checkout module for ZC 1.3.x (beta)

Quote:

---

Originally Posted by gems14k

I got the same warning...

XML failed to validate against the schema at line: 46, column: 46, with error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'shipping-taxed'. One of '{"http://checkout.google.com/schema/2":rate, "http://checkout.google.com/schema/2":tax-area}' is expected.

What is this warning? Is it becuase I have multiple flat rates?

Thank you,

---

I am using the table rate but I was not putting enough info in the rate table. Under $30 I charge $6.95 and over $30 shipping is free.

I assumed this was what the rate table needed:
29.99:6.95,30:0.00

Anything over thirty would be 0.00

Nope ya gotta do it this way
29.99:6.95,5000:0.00

This way any amount over 29.99 up to 5000 will show 0.00

The error I was getting from GC was because it was not passing a shipment amount. Check your flat rate setup as it may not be passing the shipping on to GC

I'm getting the same XML error (Invalid content was found starting with element 'shipping-taxed'. One of '{"http://checkout.google.com/schema/2":rate, "http://checkout.google.com/schema/2":tax-area}' is expected), using table-based shipping. The table seems to be fine; the proper shipping amounts are being passed on to Google Checkout and added to my test orders, but I'm still getting the error. Thus far, it's got me stumped.

Also, for test orders placed through Google Checkout (using the sandbox), no sign of the order ever shows up in the Zen admin pages...nothing in reports, no customer details, etc. I'm not sure if the XML error above is preventing the API callback from working correctly, or if this is a completely separate and unrelated issue. I'd be interested in hearing if any other people with the XML error are having the same problem.

Any thoughts or advice would be most appreciated, and I apologize if I've committed any newbie faux pas in my inaugural post...

I got my earlier issue worked out with the checkout button not appearing.

Now, when I'm using sandbox mode, I seem to have the same problem as the previous post. I'm not getting xml errors, but the order processes at google, then sends me back the my site, however my purchase is still sitting in my shopping cart and zen hasn't processed it as an order.

Any ideas?

Quote:

---

Originally Posted by GlobalVillage

I am seeing this error in the Integration Issue Detail:

XML failed to validate against the schema at line: 48, column: 48, with error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'shipping-taxed'. One of '{"http://checkout.google.com/schema/2":rate, "http://checkout.google.com/schema/2":tax-area}' is expected.

Has anyone using GC had a sale complete yet?

---

Everyone,

Thanks for reporting this issue. It's a bug in the code; there's an extra statement that does not belong.

Here's what you can do to fix it:

1. Open the following file in a text editor:
/admin/googlecheckout/gcheckout.php

2. Remove the following statement @ Line 317 (Please note that similar statement @ Line 267 should NOT be removed)
$gcheck->element('shipping-taxed', 'true');

Please reply back if this doesn't help.


Thanks,
Jacob

Jacob, thanks for the fix! The XML errors are gone now.

Unfortunately, it does look like the other integration problem experienced by browngreen and I (items still remain in the shopping cart after completing the order, and the order isn't processed by Zen) is indeed a separate issue. Google Checkout doesn't report anything as being wrong, but it seems something just isn't happening with the callback.

Quote:

---

Originally Posted by voltage

How would you recommend integrating this with superorders? The mod calls for two edits to the file in admin/orders.php. If you use super orders, the file used it admin/super_orders.php?

---

Whatever the mods are for orders.php, find the quivalent line in super_orders.php and make the same change. Remember, super_orders.php is based on orders.php, and has all the same features (hence the same code), just more bells and whistles.

Everyone,

For those of you who have other modules installed on your Zen Cart installation, overwriting your files might break your exising installation. So I updated the contribution which now includes step-by-step installation instructions: http://www.zen-cart.com/index.php?ma...roducts_id=314

I hope this helps many people. Please don't hesitate to leave any questions or feedback; I'd be more than happy to help you get started.


Thanks,
Jacob

Please add your contribution to the Downloads Section.

Attribute bug.
If the attribute are not showing up at Google CheckOut page, you can edit the following code to fix it. This is a temporary fix.

Change following on line 91 and 101.

Code:

---

        $attributes = $db->Execute("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix
                                      from " . TABLE_PRODUCTS_OPTIONS . " popt, " .
                                      TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " .
                                      TABLE_PRODUCTS_ATTRIBUTES . " pa
                                      where pa.products_id = '".makeSqlInteger($products[$i]['id']).
                                      "'and pa.options_id = '" . makeSqlString($option) . "'
                                      and pa.options_id = popt.products_options_id
                                      and pa.options_values_id = '" . makeSqlString($value) . "'
                                      and pa.options_values_id = poval.products_options_values_id
                                      and popt.language_id = '" . $languages_id . "'
                                      and poval.language_id = '" . $languages_id . "'");

---

to

Code:

---

        $attributes = $db->Execute("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix
                                      from " . TABLE_PRODUCTS_OPTIONS . " popt, " .
                                      TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " .
                                      TABLE_PRODUCTS_ATTRIBUTES . " pa
                                      where pa.products_id = '".makeSqlInteger($products[$i]['id']).
                                      "'and pa.options_id = '" . makeSqlString($option) . "'
                                      and pa.options_id = popt.products_options_id
                                      and pa.options_values_id = '" . makeSqlString($value) . "'
                                      and pa.options_values_id = poval.products_options_values_id
                                                                                ");

---

Your are removing 2 lines:
and popt.language_id = '" . $languages_id . "'
and poval.language_id = '" . $languages_id . "'

The value of $languages_id is NULL causing no attribute to appear. By removing it, the attribute will appear. Website with only one language should not be have any problems. Websites with 2 or more languages may or may not have problems. I have not tested it out on multilanguage sites.

** MAJOR BUG: **
If you place an order through Google Checkout, it will appear in your Admin orders.
The address of the order will be added/link to the Customers address book If it finds a customer with the same name.
If you delete the Google Checkout order, the address book for the customer will be ruin!
All the addresses in the address book will be change to same address. (i.e. If you have 10 address entry in your address book. All 10 will have the same address.)

If you are attempting to re-create the error, make sure you backup your database before you delete the order.