Thread: Google Checkout Change Order Number

I have looked into the Google Checkout gateway and I see that it uses the order number to communicate with the database. Sadly I want to send over the customer id as is it easy for our accountant.

Would it be possible for only Google Checkout orders to have the order id as orderid-customerid?

That way it would be easy for our accounts to match up and not force too many core changes.

Is this possible?

Thanks in advance.

Hi

Rather than change the gateway or the method of recording order numbers/customer ids, why not send your accountant a feed of the sales data from the orders table itself for just the Google Checkout orders?

Code:

select OrderNumber, CustomerID, OrderSubtotal, OrderTax from dbo.Orders where LOWER(paymentgateway) like 'google checkout%'  and TransactionState = 'CAPTURED' and OrderDate **between specific dates**

Hm guess that would be the best way around it, just a customer XML package to link everything up.

Shame really that Google Checkout is so hard to work with, we changed our Sage Pay Order Numbers without any issues.

Thanks for your help again.