Jump to content

homewetbar

Members
  • Content count

    680
  • Joined

  • Last visited

Everything posted by homewetbar

  1. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    Email the google checkout team on their site or Charge a flat sales tax % (the lowest in the state would be advisable so you don't over collect) and then just eat the rest, the max it would vary is by 1-2% I would think, unless you are doing $10,000's of thousands of sales a year in state that won't amount to much and would be less expensive than hiring someone to recode everything.
  2. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    You're going about it the hard way. Go into your google checkout setting on google's site and add the areas you need to charge sales tax.... Look at google checkout's help files on their site if you need more assistance on where to find the setting...
  3. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    Sounds like you are knee deep and overwhelmed hire a programmer (I am not one) to assist you... odesk.com is great for finding them...
  4. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    You're getting a little too deep into the checkout code for me to know what you are talking about but use the gc_return.php and add that clear cart thingy I mentioned to it to clear the cart. That is only for google checkout use the default oscommerce page for regular checkout
  5. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    I don't know what bts is, but I guess it is some sort of modified oscommerce? Try using the latest version from Google http://code.google.com/p/google-checkout-o.../downloads/list That is the actual one I used so I know it works with osCommerce ms2.2, I figured the one with the same name I referred you to in the oscommerce section in my prior post was the same but maybe, just maybe, they are different somehow? I don't know what you mean by not being tracked in Admin, but as far as clearing the cart that's pretty easy, I think you just need to add: $cart->reset(TRUE); to your return page for google cjeckout. Which will clear the cart. NOTE: it will still show on the return page like they have the items in their cart but the next page they go to or if they refresh the page the cart will show cleared....
  6. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    LOL. I didn't develop the contrib just posted some addons. But it works fine for me on Oscommerce ms v2.2 are you running cre-loaded, a template driven site, or some other modification of osCommerce?
  7. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    It works, you must have mis-installed something. Make sure you are using v1.4.5a or v1.4.5.
  8. homewetbar

    RSS Feed contribution support thread

    Leave it at the default. Or 100 max I would say. It is a new product feed not an entire site feed...
  9. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    Read the forum, I think someone else discussed this and how they did it many many pages back...
  10. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    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.
  11. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    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?
  12. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    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?
  13. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    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! ;)
  14. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    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.
  15. homewetbar

    RSS Feed contribution support thread

    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.
  16. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    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....
  17. homewetbar

    RSS Feed contribution support thread

    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.
  18. homewetbar

    MATCHING PRODUCTS CROSS-SELL

    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.
  19. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    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.
  20. 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'];
  21. homewetbar

    RSS Feed contribution support thread

    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.
  22. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    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?
  23. homewetbar

    Automated FedEx Labels

    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:
  24. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    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?
  25. homewetbar

    Offical Google Checkout module for osCommerce Support Thread

    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...
×