Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

richandzhaoyan

Archived
  • Posts

    76
  • Joined

  • Last visited

Everything posted by richandzhaoyan

  1. Help needed fast Guys, I have been setup with HSBC for a few months now with a couple hundred orders have gone through succesfully - Now, its all gone for a bag of rats! As of last night the HSBC are taking the payment OK but the orders are not showing up in OScommerce Admin - Meaning people are happily paying me for stuff but I don't know what to send them..... I know Tim Elliot had a similar problem a couple of pages back but cant see an explanation of what was wrong or how to fix it! I am guessing that either HSBC or my hosts (United Hosting) must have changed something as I have not done any work at all on the site recently. If anyone out there can confirm that their system is working ok, particularly if they are hosting with UH I would appreciate it. Also, any thoughts on what might be wrong could really help out, Cheers Guys.
  2. Hi guys, I have the Category Descriptions mod installed and working perfectly and now I am finding out more about the search engines and working my site up the rankings, I would like to add the Category Metatag contrib. I already have the header tag controller installed and its great but as I have a huge catalog of individual products, I would like my Category pages to have the best chances in the search engines. My problem is that my copy of admin/categories.php is very heavily modded, with not only the Category Descriptions added but Master Products and Category enable/disable as well. I would just like to know if anyone has the Metatag contrib installed over the top of the Category Description and how well it is working. (Oh yeah, maybe a quick peek at someones categories.php file may just get me out of a crisis!!) Cheers in advance for any help. B)
  3. Hi guys, All I can add at present is that I took two orders today, one at 9am and one at 9pm and they both went through ok, with HSBC and OScommerce. I did get one order phoned through to the shop but apparently this was just because the customer wanted to check stock, not because of any problems with the site. I cannot see any other instances of failed orders on the User Tracking (although it is sometimes difficult to tell what people are up to with this tool - it looks like one customer made an account, checked her shopping cart which was empty!! and then tried to check out!??! Very strange behaviour :unsure: ) It has been a quiet day, lots of people looking but nobody buying!!! (The same in store unfortunately :( ) I will keep checking and let you know of any more feedback as and when I get it. Sorry I cant be of more help just now, Richard.
  4. Just a quick thanks to Ryan, Have entered your bit of code alongside Matti's and now all is perfect. Cheers, Richard.
  5. Matti, You are the greatest! That works a treat and does exactly what I want it to. To be honest, I am very surpised this has not been covered already - still, I guess everyones needs are slightly different. Cheers again for your help. (I will let you get back to work now) :P Richard.
  6. Sorry Matti, Maybe I am not being too clear. I understand about the zero price on the master product and that works great. It is on all my previously added products that I have the problem. On my current live setup I just have the add to cart button with no quantity drop down box. Now that I have added Master Products ALL my products have the drop down box and that is what I dont want. To clarify, if a product is a master product with slaves, I do not want the master to be purchasable and I do want the slaves to have the drop down quantity boxes, so your above suggestion of no master product price is perfect. However, if I have a stand alone product, ie it is not a master and has no slaves, like all my products prior to using the master product mod, I would like it just to have the Add To Cart button with no quantity select. Just as it is on a clean OS install. Sorry if this is getting difficult to explain, I still believe there must be a simple solution - I just want the master products mod to apply to the products I choose. Cheers, Richard (I am still wondering if I have installed correctly? If a product is not a master or a slave should it still aquire this drop down quantity box?)
  7. OK, Forgive me, its been along day... I have just realised, that the Master not being added at all is exactly what I am after!! Is this easily implemented? If so, how? Cheers, Richard.
  8. Matti, Your a goddamn superstar! Don't know if this is really going to suit me but I sincerely appreciate your reply all the same. After playing with things this afternoon I was coming to the same realisation, I just thought I must have been missing something. Given that this is the case I will try your new suggestion (tomorrow!). I know Master Products will work for me, just gotta bend it the right way. Again, I thank you not just for your replies today, but all the work you have done to date, Cheers, Richard
  9. Matti, Thanks again for the quick reply, I know your a busy guy and working hard on the next release but is there any quick and easy fix to remove this dropdown quantity box for the product_info pages? I know that plenty of people want master products to do everything under the sun but in my case it is perfect apart from having changed my product_info pages!! If it aint easy dont worry, I am sure I will be able to bludgeon a crude fix myself, just might take a bit of time, and I can see from this monster thread how much time you have already put into this mod and I dont want to distract your present plans, thanks again for your work, Cheers, Richard.
  10. Ok, After my last post, I must reply to you Tim, I have been putting it off all week, mainly as I was hoping to have a bit more in the way of facts to post. Alas this is not the case..... Having implemented the User Tracking mod I have eagerly been awaiting evidence of why customers have failed to connect to the HSBC and, would you believe it, everyone since has gone through without a hiccup!!! Now, all I have changed is my cookie settings in my includes config file and I have implemented your mods for the HSBC returns. Good work BTW, your fix is exactly what I wanted to do myself given the time and knowledge. It is working a treat for me and saving a whole load of phone calls from confused customers! Just for reference, my cookie paths are slightly different from yours, (maybe due to the fact that I am on a dedicated SSL?) Here is my config settings, Although this is a little different to yours, I have taken the liberty of checking out your site and it appears to behave exactly the same as mine with regards to session ids. (Nice site BTW, might need to place a purchase when my little 9 month old lad grows a bit!). I do still have to set Force Cookie Use to False. Not sure why, and am not too bothered, but it would be nice to have the option to set it to True! All I can add at present is that my AOL theory has been partially been blown out the water as I have had an order placed and seen through the payment succesfully. (Just out of interest did you get any info out of phoning HSBC?). In this instance the order was just for a single item so I am still waiting for proof that AOL users can add multiple products to their cart. OK, the bottle (and a half) of Vino Calapso is starting to catch up on me.... I will say that after a week and a bit of having my cookies set correctly and having the User Tracking installed (and having installed your HSBC return setup), I am a little happier with the whole HSBC situation, although I am still wary. Can I recommend that anyone with the HSBC mod installed implements the User Tracking? Not only should it help get us any facts to throw back at HSBC but it will certainly help us all with tacking who is buying from our sites, where they are coming from, which service provider they are using, etc.... (Oh yeah, just be wary if you are using a 56k dial up, it takes a bit of time to load the page info) I would just like to add to this and my last post that after mentioning Jose (the great), Neil, Tim and Andrew (plus many more I havent mentioned who have posted on this thread) the main thanks must go out to Freerangemum for handing this mod over to the Open Source!! Without her goodwill I may have saved myself many headaches but I certainly wouldnt have got off the starting blocks! Right the wines done, just the whisky left to have a go at! :P Cheers and goodnight, Richard.
  11. Hi guys, Well, here I am posting questions on the forum and then not replying for a week!! Well its been a pretty busy week and aside from the HSBC mod I am now trying to get my head around the Master Products setup... That really is testing my copy and paste abilities. Right firstly a quick reply to the above 2 posts. It is possible to get this thing running with no knowledge of php/coding, etc, BUT its not easy. To try and briefly establish the way ahead, Start with your hosting. You MUST have Safe mode set to OFF. I dont know what that means exactly but it is to do with running the executables required to POST to the HSBC CPI. It can be done without safe mode set to off but this requires your host specifically installing the scripts for you at great expense by all accounts. Secondly, the return from the HSBC CPI must arrive at a SSL page. ie, although you are paying HSBC to take care of all the credit card details for you, they in their infinite wisdom have decided that you still need SSL installed. This is not as bad as it seems as you can use a free shared SSL cert, I know there are several posters on this forum who have gone that route, and it should really be used to give your customers confidence when entering their personal details on your site. OK, I think these 2 have been the main stumbling blocks with regards to hosting problems. Getting started with the install...(Its been awhile since I did it and even then I tried so many ways...). Basically, use your copy and pasting skills with Jose's mod for the php files. Next, upload the executables, the libCcCpiTools.so (I belive this is referred to as a library file) and CcOrderHash.e. (These files are located on the secure e-payments CD that HSBC should have sent you.) Now, I may be wrong this bit caused me major headaches, but I belive these files should be uploaded to your cgi bin and then the path needs to be set in your copy of includes/modules/payment/hsbc.php. Look for and edit appropriately. (Reading one of Jose's posts, I think these files may be uploaded to any directory as long as the path is correct, but the above is what worked for me.) Right, you should now have the basic setup. If you cannot connect to the HSBC CPI from your site now, it is time to re-read this thread and start to implement the various suggestions that have got different people connected.. Neil's time fix is one that springs to mind, as is checking you have entered your hash key/client ID correctly and if all else fails, check with HSBC that your hash key is actually correct, yes, this has been the cause of many many lost hours for one fellow on this board. Needless to say he was probably even more p'd off with HSBC than the rest of us! OK, now, by this stage you should be connecting with the HSBC CPI which is quite a milestone. The next step is trying to get the CPI to return to you correctly so that the orders are entered into your osCommerce database and show up in your admin. I am not going to go into this in depth as its a bit of a bugger. Briefly, start with implementing , then make sure you have your return direct in hsbc_return.php set correctly.....I would love to be able to tell you what this should be but it appears to be slightly different for everyone!! Just for reference, mine is now OK, you following so far? If it has taken you as long as it took me, we should be about two weeks into the process by now with only a few hours sleep in between!! You are into the final furlong, so take hope! You should be at the stage now where you are taking orders and could be up and running on a live site. The only thing I would strongly recommend after this is to re-read the last few pages of this thread and implement Tim and Andrews little mod for redirecting customers who have had their payment placed into a Review state by HSBC. This Review state was the biggest problem I encountered once I thought I had the mod installed correctly. Basically if the customer enters a different shipping address or billing address to their credit card address, HSBC places the payment into a review state. This may be a good thing to avoid charge backs but it played havoc with customers in my gift shop as it occured regularly and meant that although HSBC were prepared to accept payment, once I had reviewed it, the HSBC mod, in its virgin state through the customers back to an error page and sent them into a massive spin of confusion - probably much like you are after having read this!! Ok, here endeth chapter one from the good book HSBC!!! I certainly aint no expert and if you have any specific questions, although I will do my best to help, time and knowledge are both pretty sparse for myself at present. Oh yeah, just one final thought on this whole matter...... I keep thinking of the whole HSBC mod as the traditional sexist map reading issue. You know, how if two people, one male, one female are both trying to find an unknown destination whilst driving. Well, the bloke obviously knows how to read a map and therefore sees absolutely no need to stop and ask for help, while the lady just doesnt see the point in reading the map if there is somebody available to ask?? Well for sure us blokes know that women just cannot read maps but for some reason the girls will allways arrive at the destination first?? Yeah, you know what I am talking about. Well, I would just like to point out that the two people who have admitted to asking the great Jose Leon to implement this mod for them have been ladies, and they both appear to have had it installed very quickly, painlessly and are both very happy with the whole HSBC setup!! Gotta make you wonder hasnt it lads? B) Right. my half drunk bottle of wine needs polishing off (I use this as the reason for any typos). I do hope the above helps, Cheers, Richard.
  12. Cheers for the reply Matti, You are absolutley right this is the quickest and easiest method and I will use it. Now one final quick question before I implement it on my live site - I now have drop down boxes for quantities on all my product_info pages! (I want them for my new slaves but do not want them for all my originally entered non master/slave products). Is this due to a correct installation of master products and intentional on your part or have I goofed somewhere along the line? Cheers again, this really is a great mod and just what I was looking for. Richard.
  13. Hi all, I have installed master products and it looks great, good work guys. I have just one question that I have failed to find the answer to in all 70+ pages which surpises me. I want the Master to have a price but not be available to buy. I know that if I set the price to 0 then the Add to Cart option is removed then no price display on the product listing page. (I want the slaves hidden). The actual situation is that I to sell plates with different patterns. Hence I want a 6" Plate (priced say ?5) as a master product and the slaves would be Blue, Green, Red, but all at the same price so it would be good if this price was listed as the Master Price. I guess I could do this with the standard OS attribute system but then I cannot have an image of each plate pattern and I cannot have a Qty select box. Any ideas? Apologies if this has been covered, I have tried my damndest to find it (about 3 days looking!) Cheers, Richard.
  14. Hi Again All, Still waiting to hear how you have got your sessions set up... Just a theory at present Tim but I reckon we may both be having a similar problem. The only explanation for a problem I have of some customers creating multiple sessions and therefore having all their goods jumping out of their shopping carts (!!) is that they may be connecting with AOL. Now, I also know that some customers are having difficulies connecting to the HSBC site and the ones I have spoken to were using IE6 and Windows XP!! Still, at the time I did not ask who their ISP was - Doh. I am struggling to find any info about AOL and OSc probs but I have just installed the "User Tracking" mod so am hoping to have more conclusive proof. I am guessing (and it is just a guess) that if I could run the site with "Force Cookies - Enabled" then these problems may go away - BUT, I cannot currently work the HSBC mod with these settings, I have to have "Force Cookies - False"!!! I must admit I am a bit out of my depth on all this but surely if we come up with conclusive proof that AOL users cannot access HSBC then they should really look into the situation (HSBC I mean), lets face it, AOL aint exactly small fry. Come on guys - give us a bit of info on this one... I will get back to you as soon as I get any concrete proof from the User Tracking - Bl**dy great Contribution BTW. Cheers For Now and may the orders keep coming in! Richard
  15. Oh Yeah, Darren - If your still looking for hosting, United Hosting are good for me, others have mentioned Europa/Webfusion. Both I believe run with PHP Safe Off which means the .so library and .e files do not need any installation, they just need uploading. I wouldn't worry to much about the HSBC guide, it is bl**dy confusing, instead print out and read carefully every single page on this thread!!! If you follow it carefully you are in with a chance - alternatively wait for Joses proposed update to the mod which will hopefully include many of the fixes listed in the forum. Richard.
  16. Hi guys, Just a quick update, I now have Tim/Andys mod added so that orders placed in a review state are accepted and things are looking pretty good. Cheers Guys. :D A quick tip when looking to install this mod from scratch, make sure your cookie paths are set correctly before going through the aggro of setting all this up. Mine weren't and as such I have had to spend another day or two playing with all this to get it working correctly with cookies. Now, with this in mind, can anyone tell me if they have managed to get this working with the setting 'Force Cookie Use' set to True?? ;) I cant - It gets all upset on the return post from HSBC to Checkout Process!! Its not a massive problem but I would like to know how other users have their session use set up. I have prevent spider sessions set to true and everything else set to false at present - seems to be the only way mine will work. Cheers for any response, Richard
  17. Hiya Jose, Gotta tell you thats the best news I have heard in ages. I know alot of people appreciate the work you have done on this mod already and to have an improved version would be just great. Thanks in advance, Richard
  18. Tim, Again, the programming is pretty much over the top of my head, I am a copy and paste merchant. However, as far as I can tell, the key is in the Post from the HSBC back to OScommerce. This occurs as soon as the transaction is confirmed on the HSBC site and before the customer is returned to your site. I may well be wrong as its been a little while since I looked at all this in depth but I would think that this second Post should contain the customer id and hence all you need to identify the customer and their order details. Just a quick thought, I havent really followed this through yet, but would you not be better off not worrying about the order status prior to the transfer to HSBC, but looking more at the results code sent back from them. The current mod seems to process the order if the result code = 0, but reject it if it has any other value. I am thinking it may be possible to just point OScommerce in a different direction depending on the result code, ie if the result is "placed in review state", OScommerce just takes it as a success. This result can of course be checked at a later stage by the store owner. Apologies is I am miles from the mark, I am currently at home with the wife, kid and half laid patio!!! Will try and spend a bit more time looking at it later in the week. Best of Luck anyhow, think your gonna need it, Richard.
  19. Hiya Guys, So the problems continue!! I agree Tim that this mod does need some pretty serious rewriting. Unfortunatley my main gripe is with the HSBC side of things rather than the OScommerce setup. I am getting between 2 and 5 orders a day currently, and being a gift shop I am hoping this figure will rise dramatically later in the year. Still, about 1 in 8 order attempts are simply not working due to people not being able to access the HSBC site. I have been quite lucky in that customers have contacted me by email or phone to complete their payment but they should not have to do this!! It is very unprofessional and just keeps me thinking about how many orders I am losing/going to lose. It strikes me that HSBC have just gone too far ahead with security and fraud prevention. This may sound strange as it should be in our interest but I would rather they left some of the decisions to me. Letting me know that an order is in review state because the shipping address is different to the Billing address is fine, letting the customer know is not necassary and as we all know prevents OScommerce from completing the order!! Currently I have got around this by simply changing any return error codes to a success status and pointing the browser to checkout success. Of course this means the order goes through no matter what, even if the customer wants to back out and presses the cancel button, far from satisfactory but in my view better than taking a customers money and then having to contact him to ask what his order was for!!! Very embarrassing. Even more serious is the fact that IE 5 has big problems connecting with HSBC. I know, I am using it. Firstly, IE5 users have to visit the Windows site to upgrade their browsers to 128bit encryption but even then, my first attempt to connect as a customer allways fails. I know I have to hit the back button on my browser and then it will connect second time round but other customers aint gonna know this!! How other browsers work with it I dont yet know, but I do know that I still have several customers who have failed to connect even on IE6 - the reasons for this I dont know. What I do know is that it is hard enought to attract customers and even harder to get them to part with their hard earned cash - any obstacles in the way of this will soon send them elsewhere!! Now that the site is live, and not being a programmer makes playing with this a little difficult at the moment. Still, I will have to find the time to try and improve things, hopefully sooner rather than later and will try and get some info from HSBC with regards to browser compatibility. I am going to give it a bit more time as I do like the idea of having the HSBC image integrated into the site but if I continue to have problems with payments I will have no choice but to look elsewhere. This is my buisiness and losing customers is just not an option. In summary, at present I can only reiterate what many others have said on this forum about the HSBC setup, if you aint started, think very seriously about other options first. Oh yeah, I meant to ask about the problem of closing the browser. I dont get this as once the customer accepts the HSBC confirmation, the HSBC send the second post results which should confirm the order without the need for the customer to return to your site. The problem I have is, as stated above, when the transaction is placed into a review state. Usually caused by a different shipping address but also sometimes due to a correct address being entered in an unrecognised format, ie. the customer placing their details in the wrong order/boxes. As far as I am concerned these orders need to be accepted and reviewed later but HSBC dont see it that way and send an error for a return code which OScommerce just dont like. Right, gotta go for now. Sorry for rambling but there are a lot of issues here that do need clearing up somehow. There seems to be alot of us that are having problems we just dont need and could avoid by simply changing payment processors. Cheers for now, Richard
  20. United Hosting are getting my hard earned cash. They have had a toubled time in the couple of weeks since Ive been with them due to a server migration but all their customers seem more than happy with their long term performance. Now that things have settled down my site is up with the HSBC mod installed and everything seems well. Their help forum is excellent with help coming quickly not only from the United Hosting team but also a very knowledgable and quick to assist group of customers. Anyhow, worth checking out. Richard.
  21. Neil, Firstly I would like to add my thanks to you for your hard work on this mod. I have it fully working no and am looking to go live after the weekend. With regards to the order not submitting problem, my orders are showing up in the admin section as soon as the HSBC confirmation page appears. I believe that this is to with the 2nd Post, the reply from HSBC. Not too sure about the code side of things, its all a bit over the top of my head. I have copied and tried everything on this forum and just had one little problem at the end with the order numbers. The orderid number was not being called and so in the file checkout_process I had to insert the line $orderid=$GLOBALS["OrderId"]; Prior to this I was getting the time related order being submitted to HSBC and then another orderid beign generated a few minutes later, depending on the length of time taken for the customer to process his details. The orders were close but not the same. Anyhow, as I say this is now sorted and as far as I can make out there is no problem with customers closing there browser windows. Thanks again for all of your hard work. Cheers, Richard.
  22. Right Quick Update, I have connected - Yipee! Thanks for your post above Michael, it was indeed the path to the cgi-bin that was the problem, traced through the log files as you suggested. - Just out of interest, I have entered the path as just //Path where the TestHash.e executable is located $path='/var/www/cgi-bin' This is working beautifully but as it is obviousley rather different to the original I would just like to know if there are going to be any problems with it.
  23. Martin, I cant help you a great deal as I am still falling at the first hurdle. However it sounds to me as though you dont have the HSBC e-payments CD. This has the TestHash.e and the .so files that you will need. I believe they can be downloaded from the HSBC webpage. Once you have these they need putting in the correct place on your site, see Michaels post above. This is I think where I am having a few difficulties. I get access denied when trying to FTP to the usr/lib directory. Any ideas on that one? That aside, as posted on the previous page, this really is not a straight forward install. I am only perceveiring out of a matter of pride ( I think most of my problems are still to come, I am still trying to get the web space set up properly). Still, sit down with a nice large glass of whisky and start off by reading all 10 pages of this thread and you may have a better idea of whats to come. Good Luck!
  24. One Small Step...... Right, finally some slight progress, even if it is only really a sideways step. Thanks for the input Michael, it was the lack of any errors on the log files that was driving me loopy!! The cause? Well I had the site setup on a shared SSL which must have been sending the errors to some shared log file as opposed to the ones for my domain!! Oh well only about 3 days wasted on that then. I have set the SSL to false for the time being and....... ..... now I know why I am getting no hash, because my TestHash.e file is not being found in my cgi-bin. However, why its not finding it I do not know. I ftp'd the file into the cgi-bin directory and changed the CHMOD to 755. I have changed the $path string to the cgi path given by my hosting company yet still I recieve the No Such File or Directory. Again I am stumped. I guess this is more of a hosting/cgi query than HSBC mod but any input would be much appreciated. How are things with your setup Michael, have you finished the setup yet?
  25. Well, another good few hours down the line and I am no closer, still getting exactly the same message back - orderhash value but no value for the hash!!!! As far as I can tell, at no point is the testhash.e file being called. I have checked my error logs and there is no mention of it which on the surface sounds good BUT if I delete it from my cgi-bin there is still no mention of it in my error logs. I just dont understand, surely if the testhash file is not on the server and it is called from the hsbc.php it should show up in the errorlogs right? Or am I missing the point completely? I am pretty sure my CPI URL, Hash Key and Client ID are all ok because it is trying to connect, but it just gets bumped straight back with the hacking error. If I change any of these values then I don't get returned to the HSBC_Return url. I am trying to install this on a clean OSCommerce install to rule out any interferance from any other mods I have installed to my site. Its getting a bit depressing as I feel like I havent got past the starting post yet! Neils offer of quoting for an install is looking quite promising at the moment, although I think if I could just get started then I would be in with a chance. I pretty much follow the rest of the threads on this forum. Any help would be much appreciated, Thanks in advance, Richard.
×
×
  • Create New...