Jump to content

halbert

Members
  • Content count

    159
  • Joined

  • Last visited

1 Follower

Profile Information

  1. halbert

    Automatically send data feed to Froogle

    Okay, I figured out my problem... I had the wrong database name in the variables -- pointing to a test database instead of the real one... :blink: All is well now. -Allan :rolleyes:
  2. halbert

    Automatically send data feed to Froogle

    I have a different problem from everyone else. I installed and have been using GoogleFeeder v1.03b for the last little while with no problems However today I created a new category in my catalog, then added some items to it and to another existing category. GoogleFeeder isn't picking up the new items. It stops at the last items inserted about a week ago. I can't figure out why it won't see the other products. It's putting all my products up to products number 365 (osc internal db item #). Items 366-368 were deleted. Items 369-371 are in the newly created category, and items 372-375 are new items in the existing category. I have a hunch that GoogleFeeder isn't seeing the items in the new category or the new category, and because the other items were added after that, it doesn't see anything after item 369. Any ideas on what to check? Thanks, -Allan
  3. halbert

    Article Manager v1.0

    Argh!!! For some reason I can't edit this post... Anyhow, I suspect you've made the mistake of adding both the /catalog/includes/application_top.php and /catalog/admin/includes/application_top.php modification code to the same file -- the first application_top.php. Check to make sure that all your Admin code changes were only done to the /catalog/admin/ files and not /catalog/ files. It's pretty easy to get mixed up when you're in the thick of it. Hope this helps -al
  4. halbert

    Article Manager v1.0

    Shervin - it's very simple. Do a search in your includes/application_top.php file for the line require(DIR_WS_FUNCTIONS . '<articles.php>'); You've got it declared twice. Delete the second one and all will be fine. -al
  5. halbert

    Official PayPal IPN Support Thread

    Terra - Thanks! I've finally got it to work! I think my issue was the PayPal Profile settings... because after I changed them things worked swimmingly. Even shipping charges are transferred correctly now. My only issue now is that PayPal Sandbox hasn't triggered OSC to post payment to the database... but I'm hoping that's just Sandbox acting up. The payments are appearing in my Sandbox business account and the orders are in the database so that's good! I'm not sure what version of PP IPN and OSC the guys with the CA vs CAD currency problem were using, but I'm working on a copy of the original MS2 image and it's never been 2-character currency codes so they might have entered their currency codes incorrectly. Thanks again for all the help. I'll write up the PayPal profile settings in a text file and post them in the contributions. -al
  6. halbert

    Official PayPal IPN Support Thread

    Terra - I have been having no end of problems trying to test PP IPN with the Sandbox... I'm continually getting Message 3005 errors. Not one single test transaction has gone through PP ever, even with several different test account configurations and two different PP Developer Center accounts. Paypal "support "has been *ahem* dismal in their efforts with only one "confirm your test account email address" reply. Well DUUUUHHHHH! The orders are being stuck into the Orders database and I can see them as "Preparing [PayPal IPN]". However they do get stomped when I put another test transaction through, according to Harald's warning at the bottom of the readme. So at least I know it's working to this point! Thinking perhaps I broke something when I modded the shipping costs I went back and restored an exact copy of the PP IPN 1.2a code. It's still not passing the shipping through, but everything else is being passed correctly. The whole process is working right up until the "pay" page, after which it goes to the famous Message 3005. I'm wondering if you have a list of configuration settings that the business account profile should have set up. My PayPal Account Settings: - Canadian Business Account, Verified - Not requested API access or signature - Shipping Calculations: CAD$, no shipping values set up, transaction-based shipping override allowed - Shipping Preference: default carrier Canada Post, no ship buttons selected - Payment Receiving Preferences: Block US non-confirmed, block other currencies (non CAD$), block accidental, block Initiated payments, block eCheck - IPN Preferences: On, url is http://www.domain.com/catalog/checkout_process.php - Website Payment Preferences: Autoreturn On, return url http://www.domain.com/catalog/checkout_success.php, Payment Data Transfer On, Encrypted OFF, Contact phone Required - Encrypted Payment Preferences: default, I don't/can't use it - using a custom payment page - Language Encoding: western European My PP IPN Settings are: Enable PayPal IPN Module: True Move tax to total amount: True E-Mail Address: set to my PayPal email address Transaction Currency: Only CAD Payment Zone: --none-- Set Preparing Order Status: Preparing [PayPal IPN] Set PayPal Acknowledged Order Status: Pending Gateway Server: Testing Transaction Type: Aggregate Page Style: Custom Page Debug E-Mail Address: other email address Sort order of display: 30 Enable Encrypted Web Payments: False Your Private Key: <blank> Your Public Certificate: <blank> PayPals Public Certificate: <blank> Your PayPal Public Certificate ID: <blank> Working Directory: temp/ OpenSSL Location: /usr/bin/openssl Any advice would be greatly appreciated. Thanks in advance! -al
  7. halbert

    Official PayPal IPN Support Thread

    Hi Terra - my bad, I cut the wrong code the first time... :-" I originally was using the Chiwawa mod by mistake which I corrected and I'm now using the PP IPN 1.2a code.. Either way, the same thing has been happening. I'm using the Canada Post shipping module with Canadian taxes (7% GST for most of Canada except certain provinces where it's 15%; 7% PST for BC but not for any other provinces; no taxes for non-Canadian sales). I'm not using the Encrypted system and I'm passing the taxes to PayPal. What happens is my totals are being sent to Paypal missing shipping - so say a $100 item with $15 s/h is being sent to PayPal as only $100... and since I don't let Paypal do my shipping calculations, the s/h gets lost. But if I just cut out the code that subtracts the shipping it sends the proper values across... so I'm just going to run with that. I was worried it might break something else later but so far so good. It could be that I don't have my PP account settings correct, but that's a whole other mess unto itself. Thanks for the help. -al
  8. halbert

    Official PayPal IPN Support Thread

    Terra - I am using the official PayPal IPN v1.2a posted May 21 2006 - not Chiwawa's mod - and I downloaded it again just to make sure I hadn't mixed up my files. A quick compare shows they are the same. If you download the package from the contributions page http://www.oscommerce.com/community/contributions,2679 you can check in /includes/modules/payments/paypal_ipn.php. Lines 337-341: // PandA.nl move tax to total amount $parameters['amount'] = number_format(($order->info['total'] - $order->info['shipping_cost']) * $currencies->get_value($my_currency), $currencies->get_decimal_places($my_currency)); } else { // default $parameters['amount'] = number_format(($order->info['total'] - $order->info['shipping_cost'] - $order->info['tax']) * $currencies->get_value($my_currency), $currencies->get_decimal_places($my_currency)); So I'm not sure what's up... Any comments are appreciated. Thanks. -al
  9. halbert

    Official PayPal IPN Support Thread

    I've been testing this in my shop and have noticed that the shipping charges are not added to the total sent to Paypal. I can't see any settings where this can be set in Admin so I looked at the code and noted that it's subtracting the shipping costs from the amount sent to Paypal in the includes/modules/payment/paypal_ipn.php code (about line 340): $parameters['amount'] = number_format((($order->info['total'] - $order->info['shipping_cost']) * MODULE_PAYMENT_PAYPAL_FEE * $currencies->get_value($my_currency)+ MODULE_PAYMENT_PAYPAL_FIX_FEE), $currencies->get_decimal_places($my_currency)); Is this a code error? I changed it in my test shop but I'm not sure if it's going to break something later. Anyone got any ideas? Thanks! -al
  10. Well, after using iPower for the past 2 years for an osC cart using the Canada Post module, I'm looking for a new hosting company. Seems that in the past few weeks they've shut down all ports other than 8000-8250, so communication to the CP servers is cut off. No calculated shipping costs any more. As well I think they've turned off their sendmail as an order went through but no email was sent out. iPower refuses to do anything to resolve the situation except sell me a dedicated or virtual private server account at multiples of my current hosting costs. If you're having the same Canada Post problem ("Cannot reach Canada Post Server" errors) and you're using iPower, the solution is to find a new provider. If you're using iPower and it hasn't happened, get ready for it as they said they're "upgrading" all their shared servers to this configuration in the coming weeks. Anyone have any suggestions for a good hosting company? Canadian is preferred... but reliability is the key word here. Thanks -al
  11. halbert

    CanadaPost using Dimensions

    Try signing in to the SellOnline website and setting up your default box size. I had this problem when I gave random sizes to my packages (30x20x10 cm) in osC and discovered that I had a default box size of 20x15x10 cm in SellOnline. The system gets too smart for its own good. You should set up a number of different standard box sizes that you use on the SellOnline site and it will automatically select the appropriate one. Hope this helps. -al
  12. halbert

    Parcel to heavy to be shipped with cpc

    Don't know if you changed any of your box sizes... I had the same problem where I only defined one box size in Canada Post (my items are very small) but gave a random size to the items in OSC. The random size was larger than the box size, which meant I kept getting a "item too large to be shipped" error. You can set the box weight limit in your Sell Online profile, under the Add Modify Delete Boxes section. Hope this helps. -al
  13. halbert

    Canada Post Mod

    Check your SellOnline profile and make sure that you enter the postal code the same way in your shop, CP, and Sell Online. This means if you put the space in your postal code, it has to be in all the different parts. I had a similar error because I left the space out of the shop configuration but had it in SellOnline and CP. Hope this helps. -al
  14. halbert

    Overture / Google Adwords Reporting

    A simple thing I've done in Adwords is to set the redirect to my website with a non-existant variable attached such as this: http://www.frozenlightning.com/catalog/def...hp?ref=oscforum My log analysis software sorts by the incoming url, so I can tell down to the keyphrase used (if I set up a custom redirect for each keyphrase). I don't have a extremely high-volume site, so this works well. You could also do something similar for each search engine listing referral, using a similar url tagging system when you submit to the search engines. Otherwise you could try out Adword's new conversion tracker that's just gone live today... you have to paste a bit of code in the checkout_success.php module though (I think that's where it needs to go). -al
  15. halbert

    HyperWallet V0.9

    Thanks arakune! It solved my problems. Well, the hyperWallet problem anyhow :D -al
×