Google Checkout problem

[heinscott]

Hello. I seem to have a little problem...
We've added an additional warehouse to our site to allow for items that are free to ship. We've also added a shipping method "Free Shipping" for all the products in this warehouse. Now, after setting this up in our site, for whatever reason in Google Checkout we are seeing that the "Free Shipping" method is being given as an option, even though the products selected are not included in the free shipping warehouse. No matter what is in the cart, Google will show both options. The shipping works correctly, however, for all non-google methods of payment.
Any ideas??

Scott

[Tomgard]

I am having the same issue.

[Robbie@FireFold]

Same problem here. Google Checkout doesnt' care what about says about 'Warehouse assigned products.'

[combra]

Hello. I seem to have a little problem...
We've added an additional warehouse to our site to allow for items that are free to ship. We've also added a shipping method "Free Shipping" for all the products in this warehouse. Now, after setting this up in our site, for whatever reason in Google Checkout we are seeing that the "Free Shipping" method is being given as an option, even though the products selected are not included in the free shipping warehouse. No matter what is in the cart, Google will show both options. The shipping works correctly, however, for all non-google methods of payment.
Any ideas??

Scott

Right now AC 7 doesn't use the full level 2 integration of Google Checkout, so unfortunately as it currently exists, multiple warehouses won't work with your Google Checkout account.

-Brandon

[heinscott]

Is there any kind of alternative for us? Right now, all of our Google Checkout customers are just choosing the free shipping option, even though they are not buying items that qualify for free shipping.
What should we do? Free shipping is a huge part of our new pool builder platform we are working on, but we'd certainly like to keep Google Checkout running as well.
Any ideas???

Scott

[Robbie@FireFold]

I had to pull our free shipping.

We needed to keep Google Checkout around for the addition/extra image it provides in Froogle/Adwords. Along with the free processing since we use Adwords.

[heinscott]

According to the AbleCommerce website, the Google Checkout for AC7 has full level-2 integration. Should this work then??

[Robbie@FireFold]

Good question. I posted this here: viewtopic.php?f=45&t=9287

[combra]

According to the AbleCommerce website, the Google Checkout for AC7 has full level-2 integration. Should this work then??

I was told that was an error in the documentation a while back when I asked. (I use Google Checkout exclusively by the way.) The previous version of AC had full level 2 integration, but not AC 7 up to this point.

-Brandon

[sohaib]

Google Checkout for AC7 is full level2 compliant as far as I know.

The problem you are reporting could possibly be a bug. It is certainly not a consequence of level2 non-compliance.

I have reviewed the GoogleCheckout code again and as far as I see the case you describe above should work correctly.

Please note that one of the biggest issue people have with GC is that on callback GC gives your website only 3 seconds to calculate the shipping charges. If your site is slow and could not respond in time all shipping methods will be displayed with the default ship rate that you have set in GC configuration. If you are getting non-default rates for different shipping methods then your store is fast enough.

If you see a shipping method that should not have been applicable to the shipping address provided by the user at GoogleCheckout, then it could be a bug. In that case please provide full details of your AC installation, shipping configuration, definition of zones and warehouses, and the addresses you can use to recreate the issue.

[combra]

Google Checkout for AC7 is full level2 compliant as far as I know.

The problem you are reporting could possibly be a bug. It is certainly not a consequence of level2 non-compliance.

I have reviewed the GoogleCheckout code again and as far as I see the case you describe above should work correctly.

Please note that one of the biggest issue people have with GC is that on callback GC gives your website only 3 seconds to calculate the shipping charges. If your site is slow and could not respond in time all shipping methods will be displayed with the default ship rate that you have set in GC configuration. If you are getting non-default rates for different shipping methods then your store is fast enough.

If you see a shipping method that should not have been applicable to the shipping address provided by the user at GoogleCheckout, then it could be a bug. In that case please provide full details of your AC installation, shipping configuration, definition of zones and warehouses, and the addresses you can use to recreate the issue.

Hi Sohaib,

My understanding is if AC 7.0 was fully level 2 compliant, and not partial, it would be able to do at least the following:
1) send an API command to AC when tracking information is entered in GC Merchant Account and vise versa.
2) send an API command to AC when GC cancels an order or I cancel an order.
3) send an API command to AC if partial refund or full refund is done.
4) Ability to handle multiple shipping warehouses (as mentioned previously), as well as fixed shipping or variable cost shipping at the same time for each individual products.

Currently, AC 7.0 doesn't have full level 2 intregation. I was told this would be a feature for the future.

-Brandon

[sohaib]

1) send an API command to AC when tracking information is entered in GC Merchant Account and vise versa.

This one I know is not implemented because at the time when we implemented GC (more than a year ago) it was not part of GC API.
'Edit' : This is also implemented. See the next message

2) send an API command to AC when GC cancels an order or I cancel an order.

This is implemented.

3) send an API command to AC if partial refund or full refund is done.

This is also implemented.

4) Ability to handle multiple shipping warehouses (as mentioned previously)

If this is not working I think it should be considered a bug.

as well as fixed shipping or variable cost shipping at the same time for each

There is nothing AC can do about it. GC API does not allow you to send a checkout request that contains both fixed-rate shipping and merchant-calculated shipping at the same time.
The fixed-rate shipping methods that you define in AC is still obtained correctly in GoogleCheckout on merchant callback.

[sohaib]

1) send an API command to AC when tracking information is entered in GC Merchant Account and vise versa.

I have looked at our GC implementation again and this is also implemented. AC can receive tracking data when order is shipped from GC Merchant Console. Similarly AC sends tracking information when to GC when it is added to an order.

I suspect some of this may not have been correctly exposed in our Admin UI.

[heinscott]

Yes, for me it definitely is the multiple warehouse thing that is not working. I do get both options (both the fixed rate, and the free-shipping) so I know that it is not a timeout issue. So, should I go ahead and post a bug for this issue then? Here is how my shipping is setup:
Method: Flat Rate Shipping (either 9.99 or 12.99 depending on cart total) > Uses Warehouse: PoolGeek (contains almost all products)
Method: Free Shipping (free) > Uses Warehouse: PoolGeek Free Shipping (contains just a few products).
Try adding this product to the cart
http://www.poolgeek.com/Aladdin-Magic-Lube-P2936.aspx
and use GoogleCheckout. If you have an account, you can see the two shipping methods listed there, even though this product is only in the the main PoolGeek warehouse.

Also, for Brandon... If you want to update tracking numbers, you can use this code to update the tracking and ship status in your google checkout admin.

Code: Select all

protected static void ShipGoogleItems(string MyTransactionId, string MyTrackingNumber)
{
    WebRequest request = WebRequest.Create("https://checkout.google.com/api/checkout/v2/requestForm/Merchant/MerchantNumberHere/");
    request.Method = "POST";
    string postData = "_type=deliver-order&google-order-number=" + MyTransactionId + "&tracking-data.carrier=UPS&tracking-data.tracking-number="+MyTrackingNumber+"&send-email=false";
    byte[] byteArray = Encoding.UTF8.GetBytes(postData);
    request.ContentType = "application/xml;charset=UTF-8";
    String googleuserdata = "EncryptedGoogleUserNameAndPasswordHere";
    String HeaderData = "Authorization: Basic " + googleuserdata + " Content-Type: application/xml;charset=UTF-8 Accept: application/xml;charset=UTF-8";
    request.Headers.Add(HeaderData);
    request.ContentLength = byteArray.Length;
    Stream dataStream = request.GetRequestStream();
    dataStream.Write(byteArray, 0, byteArray.Length);
    dataStream.Close();
    WebResponse response = request.GetResponse();
    dataStream = response.GetResponseStream();
    dataStream.Close();
    response.Close();
}

I use an external method to import all of my tracking from UPS, and I run this method from that program. I'm sure you could add it as a button or whatever from your shipping screen.

Scott

[Robbie@FireFold]

I was able to get both methods as expected.

It would be amazing to get this fixed. I could actually offer FREE shipping!

[sohaib]

So, should I go ahead and post a bug for this issue then?

Yes sure. I do consider it a bug.

Btw ... I am wondering if anyone of you have used 'Cancel', 'Refund', 'Charge' etc and verified if it works two-way between AC and GC (as it is supposed to)?
Brandon reports that it is not working for him ... so I was wondering ....

[heinscott]

Our 'Cancel' 'Charge' and 'Refund' work correctly with GC.
The shipping/tracking does not update admin in GC though.

[Robbie@FireFold]

To add on here:

I have a method called Local Pickup for NC/SC customers only.

It's allowing anyone to receive this option.

[Logan Rhodehamel]

4) Ability to handle multiple shipping warehouses (as mentioned previously), as well as fixed shipping or variable cost shipping at the same time for each individual products.

We have been looking into this for two days. So far none of us can conceive of a way to handle this correctly using the features of the API. It's not a feature of Google Checkout to handle line-item shipping options or the concept of multiple 'shipments'. If you know of some documentation to the contrary, I would be happy to see it.

In my mind, Google Checkout is not compatible with multiple warehouses (which tend to result in different shipping options). The best solution so far seems to be, if a basket contains items from multiple warehouses the google checkout button should be disabled.

[heinscott]

Logan,

This would definitely work to solve when there are items from both warehouses on one order, but, the problem I am having is that both shipping prices are offered in Google (both the free and the flat rate) no matter whether I am trying to buy an item that is in the free shipping warehouse, or whether I am trying to buy an item in the regular flat rate warehouse.
Try both of these items... (one at a time, of course)

http://www.poolgeek.com/Aladdin-Magic-Lube-P2936.aspx
http://www.poolgeek.com/Pentair-Clean-a ... P4107.aspx

You'll see that the customer is allowed to selected "Free Shipping" for the lube, even though it is not in that warehouse. Similarly for the pump, a flat rate fee is the default selected from the drop-down.
So, it seems that both my warehouse ship methods are displayed in GC no matter what.
Any ideas?

Thanks,

Scott

[sohaib]

Hello,

Here is some of the discussion that took place in our bug tracker that will give you some idea of whats the problem

Say there are two warehouses. Warehouse A and Warehouse B.
Have a few Ship-Methods defined; Some applicable to Warehouse A and some
applicable to Warehouse B. Purchase a shippable product that ships from
Warehouse A. On checkout using GC the ship methods defined for Warehouse B
should not show.

------- Comment #13 From Uzair 2009-01-21 01:48:08 [reply] -------

Verified....
using demo store.

------- Comment #14 From Katie Randolph 2009-01-24 16:35:05 [reply] -------

confirmed. Working as expected when products in basket are from multiple
warehouses. If there is a shipping method that only applies to one of the
warehouses, it is not shown. Only the shipping methods appear that will work
from warehouses.

Also tested shipping methods available to specific zones. This is working.

------- Comment #15 From Katie Randolph 2009-01-24 16:56:47 [reply] -------

Reopening...not sure if this is the correct behavior.

Create Product A - assigned to warehouse A.
Shipping Method ($5.99) only from warehouse A.

Create Product B - assigned to warehouse B.
Shipping Method ($8.99) only from warehouse B.

If I add both products to the basket, and use GoogleCheckout, I don't get
either of the shipping methods. I'm bringing this up because of the referenced
forum post ....

I honestly don't know how it should work. But Sohaib had mentioned awhile ago
that it should add shipping for both products and give a total.

I'll see if I can find the original bug report.

------- Comment #16 From Katie Randolph 2009-01-24 17:18:24 [reply] -------

Ok, this was discussed partly in bug 5649 and also in an email I wrote Sohaib.
I updated that original bug report to fill in the gaps.

It does appear that we should support warehouses. However, I think I'm
deviating from the original bug report so I would like for Sohaib or Logan to
review this issue and let us know if it should be taken care of.

------- Comment #17 From Sohaib 2009-01-26 05:07:41 [reply] -------

(In reply to comment #15)
>
> I honestly don't know how it should work. But Sohaib had mentioned awhile ago
> that it should add shipping for both products and give a total.
>

Yes that is when the shipping method is applicable on both the products...
If it is applicable only on one product and there is no shipping method applicable on
both then we can't show any method ...

------- Comment #18 From Sohaib 2009-01-26 06:52:14 [reply] -------

Hello Logan,

Can you please comment on the above scenario. I don't see how we can handle
this with GoogleCheckout treating the whole order as one shipment. Technically
what is returned by our current implementation is correct. None of the shipping
methods was applicable as a whole on the full order... and we don't have a way
to tell GoogleCheckout that part of the order can be shipped with one shipping
method and part of it can be shipped with another...

------- Comment #19 From Logan Rhodehamel 2009-01-27 17:40:45 [reply] -------

(In reply to comment #18)
> I don't see how we can handle this with GoogleCheckout

I don't see it either. GC shipping capability is much simpler than what we can
do with our own checkout. My gut reaction is this is better to be documented
as a limitation of our integration. Katie, is a customer asking that this be
corrected for a particular business need?

------- Comment #20 From Katie Randolph 2009-01-27 18:14:07 [reply] -------

If you read through the forum thread here -
viewtopic.php?f=42&t=9270
there are a number of customers who are asking about the multiple warehouse
thing.

Now, before we get too far along on this, I had written the docs and made this
note:
-----------
Multiple Shipments - AbleCommerce supports the creation of multiple shipments
such as using multiple warehouses or multiple shipping addresses. Google
cannot support this feature.
-----------

It looks like most people are using multiple warehouses to provide 'product
specific' shipping choices. So, product A is in the Free shipping warehouse
and Product B gets regular rates.

Add both products to the cart and in AC, we end up with two shipments, one is
free and one is paid. Since GC doesn't support multiple warehouses then it's
unclear to me how our customers can expect this setup to work. It seems
impossible unless we can exclude any shipping that doesn't apply to all
products in the order.

------- Comment #21 From Logan Rhodehamel 2009-01-28 16:53:51 [reply] -------

(In reply to comment #20)
> Add both products to the cart and in AC, we end up with two shipments, one is
> free and one is paid. Since GC doesn't support multiple warehouses then it's
> unclear to me how our customers can expect this setup to work. It seems
> impossible unless we can exclude any shipping that doesn't apply to all
> products in the order.

I just don't see a way to do it. Warehouse A has Product A which gives the
Free Shipping method. Warehouse B has Product B which gives the Ground
Shipping method.

I add one of each product to my basket and proceed to Google. What should I
see? Google does not understand the concept of shipments. There is only one
set of shipping method choices for the entire order. In my mind I can see in
this simple example we could just show the Ground choice since the other
shipping has no charge. But if there are actually different methods with
different costs that becomes impossible.

This is a silly example, but to help illustrate imagine I am an online fish
supply store. I mainly sell supplies, but I also sell live fish. All supplies
can be shipped using standard ground methods, but live fish can only be shipped
2 day. If a customer tries to add fish and supplies to the same basket, our
current application cannot determine how to give Google the shipping charge.


------- Comment #22 From Katie Randolph 2009-01-28 17:06:34 [reply] -------

Well, I agree. Somebody needs to set the record straight though. In the
forum, we have this listed as a bug. In the docs, it says it will not work,
and another customer keeps saying it doesn't work because we not level 2
compliant.

I think customers who have special shipping requirements should not use
Googlecheckout. We already have a 3 second delay to get the shipping rates, I
wonder how trying to do some kind of match would even work, and what happens
when there wasn't match.

Should we look at this as a 'future' bug? Or just close it with 'wontfix'

------- Comment #23 From Logan Rhodehamel 2009-01-29 09:48:44 [reply] -------

(In reply to comment #22)
> Should we look at this as a 'future' bug? Or just close it with 'wontfix'

I propose we draw our line in the sand and enforce it. We are headed down a
path that is no good, trying to facilitate something Google Checkout just
cannot handle at this time.

So my suggestion is we update the google checkout control. We already have to
examine the items in the basket to make sure none are prohibited by google.
Amend this check so that it also makes sure all items are in the same
warehouse. Multiple warehouses, disable button, and we are done with this
issue.

Then there is no mistaking things. AC has a feature GC cannot handle, and
that's the way it is right now. What do you think of this much simpler
solution?

------- Comment #24 From Katie Randolph 2009-01-29 10:00:21 [reply] -------

Yes, I'm good with it. I think we've made it quite clear on the limitations
with Google checkout.

Passing back to Sohaib then.

------- Comment #25 From Logan Rhodehamel 2009-01-29 10:19:43 [reply] -------

OK... Sohaib, did you follow what I was saying? Just disable GC button for
multiple warehouses, same as we would if the basket contains prohibited
products.

Thanks,
Sohaib

[heinscott]

I think you are misunderstanding my problem...
The problem I have is that a normal item in our store (ie, it does NOT qualify for free shipping) will allow a customer, through Google Checkout, to select "Free Shipping" from the drop-down menu, even though that option should not be available.
Do you see what I mean? Simply adding a "free shipping warehouse" to the site in general, causes BOTH shipping options to show up in Google Checkout. I'm not talking about the problem of having 2 item each with different shipping assignments in GC at the same time. I understand why that is problematic.
If this was working correctly, you could add this product:

http://www.poolgeek.com/Aladdin-Magic-Lube-P2936.aspx

to the cart, and GC would only show the $12.99 shipping option.
Thanks for the help
Scott

[sohaib]

I think you are misunderstanding my problem...
The problem I have is that a normal item in our store (ie, it does NOT qualify for free shipping) will allow a customer, through Google Checkout, to select "Free Shipping" from the drop-down menu, even though that option should not be available.
Do you see what I mean? Simply adding a "free shipping warehouse" to the site in general, causes BOTH shipping options to show up in Google Checkout. I'm not talking about the problem of having 2 item each with different shipping assignments in GC at the same time. I understand why that is problematic.
If this was working correctly, you could add this product:

http://www.poolgeek.com/Aladdin-Magic-Lube-P2936.aspx

to the cart, and GC would only show the $12.99 shipping option.

I think you did not read the full post. What you mentioned has been fixed but associated issues prevent us from allowing google checkout for baskets with multiple warehouses.

What you mentioned above is what we started with and it was fixed. These comments were after the fix was applied and it was confirmed by QA to be working

Say there are two warehouses. Warehouse A and Warehouse B.
Have a few Ship-Methods defined; Some applicable to Warehouse A and some
applicable to Warehouse B. Purchase a shippable product that ships from
Warehouse A. On checkout using GC the ship methods defined for Warehouse B
should not show.

------- Comment #13 From Uzair 2009-01-21 01:48:08 [reply] -------

Verified....
using demo store.

------- Comment #14 From Katie Randolph 2009-01-24 16:35:05 [reply] -------

confirmed. Working as expected when products in basket are from multiple
warehouses. If there is a shipping method that only applies to one of the
warehouses, it is not shown. Only the shipping methods appear that will work
from warehouses.

Also tested shipping methods available to specific zones. This is working.

[Logan Rhodehamel]

The only remaining problem we cannot solve now is how to enable Google Checkout for baskets that contain items coming from different warehouses. In those cases we would have to determine what shipping methods are valid for each set of products, then look for shipping methods that are common to all products and return them as a combined rate.

EDIT: Sohaib has worked on the GC features more than I, and now from what he has told me it sounds like we have already done the above.

[heinscott]

Ahhh, I see...
Is the first fix available then?
I would love to at least be able to have shipping correct for my normal items.
Thanks

Scott