Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

homewetbar

Pioneers
  • Posts

    680
  • Joined

  • Last visited

Everything posted by homewetbar

  1. Leave it at the default. Or 100 max I would say. It is a new product feed not an entire site feed...
  2. Read the forum, I think someone else discussed this and how they did it many many pages back...
  3. I think I read it somewhere that it is your google checkout merchant is and merchant key as the password. Regardless as long as it is up you shouldn't need to visit that URL yourself, it's only for google checkout.
  4. When I went to disable shipping over 175 pounds in googlecheckout/gcheckout.php it seems that it is not taking into account the packaging materials fixed # or % set in admin like all other shipping contributions do. For instance if I want to disable packages over 175 I really use 150 pounds since the packaging is not figured in like so: googlecheckout/gcheckout.php FIND: if (($googlepayment->merchantid == '') || ($googlepayment->merchantkey == '')) { $Gcart->SetButtonVariant(false); $Gwarnings[] = GOOGLECHECKOUT_STRING_WARN_NO_MERCHANT_ID_KEY; } ADD AFTER: //*** Disable if over 175 pounds if ($total_weight > 150) { $Gcart->SetButtonVariant(false); } Has anyone else noticed this and is there a fix or did I just overlook something?
  5. I think there is actually a weight limit of 175, at least if you are using FedEx, at which point Google Checkout just sends you to a screen saying: "Oops! We were unable to process your request." I wonder if it has something to do with the max weight FedEx will accept for a box, and google checkout is querying them as if it will all go in one box? Anyway I don't have a clue how to fix it, the only thing I can think is to possibly disable Google Checkout on orders over 175, can anyone else suggest a fix?
  6. I've been working to fully integrate this with the INDIVIDUAL SHIP CONTRIBUTION , basically a hack but it works great, here is my fix: INTEGRATING GOOGLE CHECKOUT with INDIVIDUAL SHIP CONTRIBUTION googlecheckout/gcheckout.php FIND: if (isset ($products[$i]['attributes']) && is_array($products[$i]['attributes'])) { reset($products[$i]['attributes']); while (list($option, $value) = each($products[$i]['attributes'])) { $products_name .= "\n- ". $products[$i][$option]['products_options_name'] .' ' . $products[$i][$option]['products_options_values_name']; } } ADD AFTER: //*** Products Individual Ship $products_indiv_ship = tep_db_fetch_array(tep_db_query("select products_ship_price, products_ship_price_two from " . TABLE_PRODUCTS_SHIPPING . " where products_id = '" . $products[$i]['id'] ."' ")); if (($products[$i]['quantity'] >= 2) && ($products_indiv_ship['products_ship_price_two'] > 0)){ $add_ship_charges = $add_ship_charges + $products_indiv_ship['products_ship_price'] + (($products[$i]['quantity'] - 1) * $products_indiv_ship['products_ship_price_two']); } else { $add_ship_charges = $add_ship_charges + ($products[$i]['quantity'] * $products_indiv_ship['products_ship_price']); } //*** End Products Individual Ship FIND: $values = explode('|', gc_compare($CCSCode . $method. $type , $carriers_config, "_CCS:", '0|0|0')); if($values[0] != '0') { ADD AFTER: //*** Individual Ship Charges $values[1] = $values[1] + $add_ship_charges; //*** End Individual Ship Charges I hope whoever releases the next version will include this in the instructions along with my product attributes fix for all to use. In the mean time I hope this is able to help someone else, enjoy! ;)
  7. It is shown as a button before you login on the shopping cart page right below the checkout button. If you don't have it there you missd something in the install specifcally on the shopping_Cart and login pages so go check over that install again.
  8. Thanks but I am not the author... however I'm sure they appreciate your kind words. If you have it fixed yes. But you'll still have to test that to make sure you fixed the problem after you add new products as I said before.
  9. I honestly don't know about the lower rates they are quoting, perhaps they are quoting for the items only not the items + packaging? Regardless you can compensate by adding a % on top of the ground rate if need be, we actually thought it was too high so we are subtracting a percentage. Checkout the docs included in the google checkout contribution for more details. We have not encountered the 150 limit but we have not had an order that heavy yet either....
  10. Once you fix the oscid thing it will not fix it on any old products you had previously since your reader already pulled that data so you may have fixed it and not realized you did. You'll have to create some new products to see if you fixed it or not.
  11. Entirely different... It will take a lot of modifying of the code you will need to custom do this or hire a developer... I am not a developer but you could find one on odesk.com for relatively cheap I would think.
  12. I don't think you can exlude alaska and hawaii, but I'm not 100% try googling google checkout API and reading the google docs they may shed some light on it.
  13. Here's a little code modification I made to make the contrib compatible with Google Checkout... Please don't email me on how to install, it has been verified by 3 others so far to work, so I am just providing this code as is. Always remember to backup! INTEGRATING GOOGLE CHECKOUT with PRODUCT ATTRIBUTES OPTION TYPE FEATURE catalog/googlecheckout/gcheckout.php FIND (line 142): $attr_value = $attributes_values['products_options_values_name']; CHANGE TO: // Product Option Type if ($value == PRODUCTS_OPTIONS_VALUE_TEXT_ID) { $attr_value = $products[$i]['attributes_values'][$option] . tep_draw_hidden_field('id[' . $products[$i]['id'] . '+++' . $i . '][' . TEXT_PREFIX . $option . ']', $products[$i]['attributes_values'][$option]); } else { $attr_value = $attributes_values['products_options_values_name'] . tep_draw_hidden_field('id[' . $products[$i]['id'] . '+++' . $i. '][' . $option . ']', $value); } // End Product Option Type catalog/googlecheckout/responsehandler.php FIND (line 631): 'products_options_values' => $attributes_values['products_options_values_name'], CHANGE TO: 'products_options_values' => $order->products[$i]['attributes'][$j]['value'], // Product Options Changed FIND (line 644) $products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . $attributes_values['products_options_values_name']; CHANGE TO: // Product Option Type contribution $products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . tep_decode_specialchars($order->products[$i]['attributes'][$j]['value']); // $products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . $attributes_values['products_options_values_name'];
  14. Not a bad question, Google it, or here is a page that explains it: http://rss.softwaregarden.com/aboutrss.html It's much less complex than it sounds.
  15. I kind of feel like I'm talking to myself here... is anyone else on this forum that can answer questions? :P Anyway I've been looking at the Logs Google Checkout generates and there is some sensitive data here, not to mention the files will get HUGE over time. It does not store any credit card numbers or anything, but I'm still not comfortable with the addresses and customer info it is storing in the logs. Is there anyway to turn off the log file or does anyone have an idea on how we can overwrite it say every day or two so this info is not just left piling up in the log directory indefinately?
  16. We recently just added the Google Checkout Contribution and it required modifying the code of this fedex labels contribution to make it notify google checkout that the order had shipped and to send the tracking info to google. Below is all of the code we used to do this, in case anyone else adds the google contrib, the code below will save you a lot of trouble. Simply make the one change below in: admin/ship_fedex.php FIND: // update the order record ADD BELOW: //---------------------------- // ** Google Checkout email customer tracking and update google ** $testGoogle = substr($order_info['payment_method'], 0, 6); if($testGoogle == 'Google') { define('GC_STATE_NEW', 100); define('GC_STATE_PROCESSING', 101); define('GC_STATE_SHIPPED', 3); define('GC_STATE_REFUNDED', 103); define('GC_STATE_SHIPPED_REFUNDED', 104); define('GC_STATE_CANCELED', 105); require_once('../' . DIR_WS_LANGUAGES . $language . '/modules/payment/googlecheckout.php'); $payment_value= MODULE_PAYMENT_GOOGLECHECKOUT_TEXT_TITLE; $num_rows = tep_db_num_rows(tep_db_query("select google_order_number from google_orders where orders_id= ". $order)); global $db,$messageStack, $orders_statuses; define('API_CALLBACK_ERROR_LOG', DIR_FS_DOCUMENT_ROOT. "/googlecheckout/logs/response_error.log"); define('API_CALLBACK_MESSAGE_LOG', DIR_FS_DOCUMENT_ROOT . "/googlecheckout/logs/response_message.log"); include_once(DIR_FS_DOCUMENT_ROOT.'/includes/modules/payment/googlecheckout.php'); include_once(DIR_FS_DOCUMENT_ROOT.'/googlecheckout/library/googlerequest.php'); $googlepayment = new googlecheckout(); $Grequest = new GoogleRequest($googlepayment->merchantid, $googlepayment->merchantkey, MODULE_PAYMENT_GOOGLECHECKOUT_MODE== 'https://sandbox.google.com/checkout/' ?"sandbox":"production", DEFAULT_CURRENCY); $Grequest->SetLogFiles(API_CALLBACK_ERROR_LOG, API_CALLBACK_MESSAGE_LOG); $google_answer = tep_db_fetch_array(tep_db_query("SELECT go.google_order_number, go.order_amount, o.customers_email_address, gc.buyer_id, o.customers_id FROM " . $googlepayment->table_order . " go inner join " . TABLE_ORDERS . " o on go.orders_id = o.orders_id inner join " . $googlepayment->table_name . " gc on gc.customers_id = o.customers_id WHERE go.orders_id = '" . $order ."' group by o.customers_id order by o.orders_id desc")); $google_order = $google_answer['google_order_number']; $amount = $google_answer['order_amount']; // If status update is from Google Processing or Google Refunded -> Google Shipped on the Admin UI // this invokes the deliver-order and archive-order commands // 2->Google Processing or Google Refunded, 3-> Google Shipped (refunded) // Add tracking Data $carrier = 'FedEx'; $tracking_no = $trackNum; $comments = GOOGLECHECKOUT_STATE_STRING_TRACKING ."\n" . GOOGLECHECKOUT_STATE_STRING_TRACKING_CARRIER . $carrier ."\n" . GOOGLECHECKOUT_STATE_STRING_TRACKING_NUMBER . $tracking_no . ""; list($curl_status,) = $Grequest->SendDeliverOrder($google_order, $carrier, $tracking_no, ($cust_notify==1)?"true":"false"); if($curl_status != 200) { $messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_DELIVER_ORDER, 'error'); } else { $messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_DELIVER_ORDER, 'success'); } list($curl_status,) = $Grequest->SendArchiveOrder($google_order); if($curl_status != 200) { $messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_ARCHIVE_ORDER, 'error'); } else { $messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_ARCHIVE_ORDER, 'success'); } // Is the order is not archive, I do it if($check_status['orders_status'] != GC_STATE_SHIPPED && $check_status['orders_status'] != GC_STATE_SHIPPED_REFUNDED){ list($curl_status,) = $Grequest->SendArchiveOrder($google_order); if($curl_status != 200) { $messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_ARCHIVE_ORDER, 'error'); } else { $messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_ARCHIVE_ORDER, 'success'); } } } // ** END GOOGLE CHECKOUT ** I hope someone else finds use for this code, enjoy! :thumbsup:
  17. I've got google checkout running properly but when the customer goes back to the gc_return.php I am getting the following error at the top of the page "Unknown column 'Array' in 'where clause'" select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id in (Array) and pd.products_id = p.products_id and pd.language_id = '1' Any idea on what is causing this? I'm using the stock gc_return.php page from google checkout 1.4.5 if that helps?
  18. Here's a tip for advanced programmers that need to transfer something from the site to the order created by google checkout such as a tracking # in google checkout. It took us quite awhile to figure this out but it's fairly simple once you know how. You just have to use google checkout's merchant-private-data field In googlecheckout\gcheckout.php ADD: $private_text = 'WHATEVER YOU WANT TO TRANSFER'; $Gcart->SetMerchantPrivateData(new MerchantPrivateData(array("YOUR-NAME-OF-DATA" => $private_text))); In googlecheckout/responsehandler.php FIND: $order->delivery['format_id'] = 2; ADD BELOW: $order->delivery['YOUR-FIELD-NAME'] = $gc_data[$root]['shopping-cart']['merchant-private-data']['YOUR-NAME-OF-DATA']['VALUE']; FIND: 'date_purchased' => 'now()', ADD BELOW: 'NAME-OF-YOUR-FIELD-IN-OSCOMMERCE-ORDER-DATABASE' => $order->delivery['YOUR-FIELD-NAME'], You will need to modify the above for your situation, and I AM NOT PROVIDING SUPPORT FOR THE ABOVE, which is why I say it is for Advanced Programmers only. However maybe it will help and save some time if you need to transfer data behind the scenes...
  19. I think I have this fixed for use with google checkout now, here is my fix: INTEGRATING GOOGLE CHECKOUT with PRODUCT ATTRIBUTES OPTION TYPE FEATURE catalog/googlecheckout/gcheckout.php FIND (line 142): $attr_value = $attributes_values['products_options_values_name']; CHANGE TO: // Product Option Type if ($value == PRODUCTS_OPTIONS_VALUE_TEXT_ID) { $attr_value = $products[$i]['attributes_values'][$option] . tep_draw_hidden_field('id[' . $products[$i]['id'] . '+++' . $i . '][' . TEXT_PREFIX . $option . ']', $products[$i]['attributes_values'][$option]); } else { $attr_value = $attributes_values['products_options_values_name'] . tep_draw_hidden_field('id[' . $products[$i]['id'] . '+++' . $i. '][' . $option . ']', $value); } // End Product Option Type catalog/googlecheckout/responsehandler.php FIND (line 631): 'products_options_values' => $attributes_values['products_options_values_name'], CHANGE TO: 'products_options_values' => $order->products[$i]['attributes'][$j]['value'], // Product Options Changed FIND (line 644) $products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . $attributes_values['products_options_values_name']; CHANGE TO: // Product Option Type contribution $products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . tep_decode_specialchars($order->products[$i]['attributes'][$j]['value']); // $products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . $attributes_values['products_options_values_name'];
  20. I think I have this fixed for use with google checkout now, here is my fix: INTEGRATING GOOGLE CHECKOUT with PRODUCT ATTRIBUTES OPTION TYPE FEATURE catalog/googlecheckout/gcheckout.php FIND (line 142): $attr_value = $attributes_values['products_options_values_name']; CHANGE TO: // Product Option Type if ($value == PRODUCTS_OPTIONS_VALUE_TEXT_ID) { $attr_value = $products[$i]['attributes_values'][$option] . tep_draw_hidden_field('id[' . $products[$i]['id'] . '+++' . $i . '][' . TEXT_PREFIX . $option . ']', $products[$i]['attributes_values'][$option]); } else { $attr_value = $attributes_values['products_options_values_name'] . tep_draw_hidden_field('id[' . $products[$i]['id'] . '+++' . $i. '][' . $option . ']', $value); } // End Product Option Type catalog/googlecheckout/responsehandler.php FIND (line 631): 'products_options_values' => $attributes_values['products_options_values_name'], CHANGE TO: 'products_options_values' => $order->products[$i]['attributes'][$j]['value'], // Product Options Changed FIND (line 644) $products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . $attributes_values['products_options_values_name']; CHANGE TO: // Product Option Type contribution $products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . tep_decode_specialchars($order->products[$i]['attributes'][$j]['value']); // $products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . $attributes_values['products_options_values_name'];
  21. Still no progress, I tried changing the order status configs to 1 for processing and 3 for shipped at the top of admin/orders.php but this did no good, does anyone have an idea on how to do this? Thanks in advance.
  22. The many google statuses are confusing. How do I change the statuses so I can use my default oscommerce shipped status instead of using the google checkout google_shipped status?
  23. Had the same problem. Fixed it by moving the l </form> BEFORE the google checkout button.
  24. I'm not sure if this will work but make sure the </form> is before the google checkout button.
  25. homewetbar

    Google Checkout

    It seems to be in googlecheckout/library/googlecart.php Here is a post by theantiquestore I think answers your question: http://www.oscommerce.com/forums/index.php?sho...p;#entry1160641
×
×
  • Create New...