halbert

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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

navvi - i had the same problem, and I think I resolved it by turning off the cp mod in the admin tool then going back to the my store configuration part, entering the store postal code, and then re-activating the cp mod. I think I had to do this twice... but I can't remember exactly what the order was. i suspect that somehow the data got mixed up and cp needed to be turned off to clear the bad data from teh database. good luck! -al

Thanks for creating and posting this contribution... I hope to put it to use soon! I am trying to set it up with my account, but my account number seems to differ from yours.... I sent myself an invoice and i have a 5 digit ID in the link as below (I x'd out my ID): https://www.hyperwallet.com/payInvoice.do?type=B&ID=xxxxx Is this a problem? Or is it due to me being at a different financial institution than yourself (I use Citizens Bank). Thanks! -al

I would add too that it's a very nice and quick way to update your products, move them between categories, and keep an off-line inventory of your shop... Certainly beats doing mass product updates or moves via the Admin tool. -al

interesting... that's my customized code. I didn't post it on the contrib section but had a link to it on another thread for others to see how to add custom fields... hope it didn't get folded back into the main release. -al

cralyn - I haven't worked on it in about 2 weeks but I'm probably 90% finished the Hyperwallet module, so if you want to work on it together let me know. I'm a bit snowed at the moment with visitors and things, so I probably won't get back to it for at least another week. It looks pretty easy anyhow. I thought I'd be able to finish it in an hour but I got side-tracked... -al

I just finished one for E-xact a week or so ago... it's posted in the credit modules. I found that the Authorize.net module was a good one to look at to start. Good luck! -al

Okay version 1.0 of the E-xact payment gateway has been posted in the contributions section. :D :D :D Please let me know if you find it useful. -al

check the dynamics mopics thread for more info, but I think you need to change the name of your first pics. catalog/images/images_small/product1.jpg catalog/images/images_big/product1.jpg If that doesn't help, set MAIN_THUMB_IN_SUBDIR false and move your first thumb to the images directory catalog/images/product1.jpg Good luck! -al

Sorry, I didn't read your declarations very closely. You're right, you don't need the '_pic' extension on your main thumb. Unfortunately I can't think of any reason this is happening for your site - I gather you haven't modified the dynamic mopics code at all? Sorry I can't be more of a help... You might want to PM dreamscape and see if he has any suggestions. Good luck! -al

Just a quick look at your site urls shows that the thumb is coming from http://www.directplastics.com/images/produ...ll/aaa_pic1.jpg and the big pic is coming from http://www.directplastics.com/images/produ...ig/aaa_pic1.jpg How are you naming your pictures? They should be I think there's a bug in the code if you set define('MAIN_THUMB_IN_SUBDIR', true); but I haven't had the time or inclination to check it out and fix it. So don't use true (I see you're not so it's not a problem). Hope this helps. It took me a while to figure it out as well. -al