Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

allaboutwicker

Members
  • Posts

    467
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by allaboutwicker

  1. @kymationHi Jim,

    Thanks for your advice. I do not fully understand the database as you said. I do have a backup of my database before I made any changes. I cannot remember doing a restore of my database or if I did it was a long time ago and not sure of best method to do so. Should I do it through phpmyadmin in my cpanel or is there a better way? I have read to go into the database and click to check all tables and drop, then import the database sql file of old database. Is this correct?

     

     

  2. I was able to install this on my modified 2.3.4 BS site with using the sql file for 48 US Continental states, but I need to break those out into 3 zones so I have the Northeastern US states in one, middle states in another and then the Western states in 3rd zone. I thought I could use the sql for the 48 states and change it to include only the states I wanted in each zone, but I must be doing something wrong with my code? Can anyone give me a clue what I am doing wrong here?

    Here is original sql file for all the 48 states:

    INSERT INTO `geo_zones` VALUES ('', 'Shp: United States: 48', 'United States:  Continental 48 states', NULL, now());
    INSERT INTO `zones_to_geo_zones` VALUES ('', 223, 1, last_insert_id(), NULL, now()),
                                            ('', 223, 4, last_insert_id(), NULL, now()),
                                            ('', 223, 5, last_insert_id(), NULL, now()),
                                            ('', 223, 12, last_insert_id(), NULL, now()),
                                            ('', 223, 13, last_insert_id(), NULL, now()),
                                            ('', 223, 14, last_insert_id(), NULL, now()),
                                            ('', 223, 15, last_insert_id(), NULL, now()),
                                            ('', 223, 16, last_insert_id(), NULL, now()),
                                            ('', 223, 18, last_insert_id(), NULL, now()),
                                            ('', 223, 19, last_insert_id(), NULL, now()),
                                            ('', 223, 22, last_insert_id(), NULL, now()),
                                            ('', 223, 23, last_insert_id(), NULL, now()),
                                            ('', 223, 24, last_insert_id(), NULL, now()),
                                            ('', 223, 25, last_insert_id(), NULL, now()),
                                            ('', 223, 26, last_insert_id(), NULL, now()),
                                            ('', 223, 27, last_insert_id(), NULL, now()),
                                            ('', 223, 28, last_insert_id(), NULL, now()),
                                            ('', 223, 29, last_insert_id(), NULL, now()),
                                            ('', 223, 31, last_insert_id(), NULL, now()),
                                            ('', 223, 32, last_insert_id(), NULL, now()),
                                            ('', 223, 33, last_insert_id(), NULL, now()),
                                            ('', 223, 34, last_insert_id(), NULL, now()),
                                            ('', 223, 35, last_insert_id(), NULL, now()),
                                            ('', 223, 36, last_insert_id(), NULL, now()),
                                            ('', 223, 37, last_insert_id(), NULL, now()),
                                            ('', 223, 38, last_insert_id(), NULL, now()),
                                            ('', 223, 39, last_insert_id(), NULL, now()),
                                            ('', 223, 40, last_insert_id(), NULL, now()),
                                            ('', 223, 41, last_insert_id(), NULL, now()),
                                            ('', 223, 42, last_insert_id(), NULL, now()),
                                            ('', 223, 43, last_insert_id(), NULL, now()),
                                            ('', 223, 44, last_insert_id(), NULL, now()),
                                            ('', 223, 45, last_insert_id(), NULL, now()),
                                            ('', 223, 47, last_insert_id(), NULL, now()),
                                            ('', 223, 48, last_insert_id(), NULL, now()),
                                            ('', 223, 49, last_insert_id(), NULL, now()),
                                            ('', 223, 51, last_insert_id(), NULL, now()),
                                            ('', 223, 53, last_insert_id(), NULL, now()),
                                            ('', 223, 54, last_insert_id(), NULL, now()),
                                            ('', 223, 55, last_insert_id(), NULL, now()),
                                            ('', 223, 56, last_insert_id(), NULL, now()),
                                            ('', 223, 57, last_insert_id(), NULL, now()),
                                            ('', 223, 58, last_insert_id(), NULL, now()),
                                            ('', 223, 59, last_insert_id(), NULL, now()),
                                            ('', 223, 61, last_insert_id(), NULL, now()),
                                            ('', 223, 62, last_insert_id(), NULL, now()),
                                            ('', 223, 63, last_insert_id(), NULL, now()),
                                            ('', 223, 64, last_insert_id(), NULL, now()),
                                            ('', 223, 65, last_insert_id(), NULL, now());
     

    and here is my sql code for to attempt to add just the Northeastern states:

    INSERT INTO `geo_zones` VALUES ('', 'Shp: United States: NE', 'NE United States', NULL, now());
    INSERT INTO `zones_to_geo_zones` VALUES ('', 223, 14, last_insert_id(), NULL, now()),
                                            ('', 223, 15, last_insert_id(), NULL, now()),
                                            ('', 223, 29, last_insert_id(), NULL, now()),
                                            ('', 223, 31, last_insert_id(), NULL, now()),
                                            ('', 223, 32, last_insert_id(), NULL, now()),
                                            ('', 223, 40, last_insert_id(), NULL, now()),
                                            ('', 223, 41, last_insert_id(), NULL, now()),
                                            ('', 223, 43, last_insert_id(), NULL, now()),
                                            ('', 223, 44, last_insert_id(), NULL, now()),
                                            ('', 223, 47, last_insert_id(), NULL, now()),
                                            ('', 223, 51, last_insert_id(), NULL, now()),
                                            ('', 223, 53, last_insert_id(), NULL, now()),
                                            ('', 223, 59, last_insert_id(), NULL, now()),
                                            ('', 223, 61, last_insert_id(), NULL, now()),
                                            ('', 223, 63, last_insert_id(), NULL, now());

    Thanks for any advice.

  3. I would say Jack gave a very good response for your question. The only thing I think more to add would be with the PayPal Payments Pro (Direct Payment)  - $30/month you get the virtual terminal ability which means you will be able to log into their website and process payments if you take a phone order and such, but if not I would say try the Hosted Solution and see how it goes for the customer to stay on your website if that it what you would prefer and you can always upgrade to the other if needed.

  4. Hi Heather,

     

    Just curious as to why you decided to go with the standard shop instead of with the bootstrap version right away as that one is responsive and such for handheld devices. I would recommend thinking about going the bootstrap route since it appears you are just starting out and do not have any modifications done and not much time into it yet.

  5. Hi Heather,

     

    You do not put all files into one folder. I am looking at the standard version of the directions. You did not mention which one you have, but believe that is what you are using. Under new files in directions I see this:

     

    2.2.3 New Files
     
    catalog/includes/languages/english/modules/header_tags/ht_theme_switcher.php
     
    catalog/includes/modules/header_tags/ht_theme_switcher.php
     
    ** I think I found your store setup under the folder "cataloginstall" Therefore, that is what you have as your "catalog" folder mentioned in the directions. So you must place that 1 file in package called ht_theme_switcher.php in the header_tags folder which is found under the modules folder which is found under english folder which is found under languages folder which is under the includes folder in your cataloginstall folder
     
    Then you must place the other ht_theme_switcher.php file in the package into the catalog (or in your case catalginstall / includes / modules / header_tags folder
     
    You then need to download and make a copy of your 
     
    catalog (cataloginstall) /includes / template_top.php file. You can try to upload modified file provided in package over the one you have and see if it works or if not, you will need to do a file compare of the 2 and see what would have to be changed manually.
  6. Hi Bill, 

     

    You did not mention what type of shipping you offer currently, but say you use just straight flat rate shipping. You use a duplicate of that module with the added fee for Liftgate included so they can pick which one they want. We use a table rate for our site as we ship small and larger items as well needing to be shipped via freight, but for this example I just set it up quick to show a rate of $224.00 for Regular Shipping and then $324.00 if they wanted to chose Shipping with Liftgate. I did not change the wording on my site to that so I just over-layed the correct text for the effect as can be seen on this screenshot http://allaboutwicker.com/images/Extra-shipping-with-liftgate.jpg You should be able to do the same thing if you use table rate as I believe you should be able to duplicate that or possibly just use another module that is similar with the additional rate for Liftgate included. Not sure if that is what you are looking to do, but hope that helps.

  7. To find your project version is easy if newer as you can just log into your admin side and look under Tools ---> Version Checker. If you do not see that option then probably have older version which can be found in your application_top.php file found in your catalog/includes folder of your website files. You can access those via FTP or file manager in your website cpanel of your host company.

  8. Hi Sam,

     

    Welcome to Oscommerce World. FYI, when you post on the forums it is most helpful to tell us what version you are using. I am assuming it must be an older one as we used to be able to connect to Linkpoint  / Firstdata on our old 2.2 version website, but have not found a solution to it being integrated into the newer 2.3 version website we now have set up. We have now gone fully to PayPal Pro using the App found here: http://addons.oscommerce.com/info/9184 That is for the newer 2.3 version software. If the website you took over is still running on an older version than 2.3 then you may really want to think about upgrading it. 

  9. We have still not found a way to integrate the new Firstdata Payeezy payment module at this time. We have chosen to go with PayPal Pro for now so we can take credit cards directly on site. We were able to get that going and It appears to work well, but would like the ability to use the Payeezy gateway as we get a little better charge rates through them and it all adds up over time out of our expenses. Anyways, if anyone can figure out how to integrate that payment gateway please let us all know.

     

    Thanks!

  10. I have not yet been able to integrate First Data Payeezy gateway into my oscommerce store. They refer me back to the software developer which of course I am using oscommerce. I can't believe it could be all that impossible for someone that may understand it all better then me. As you can see by the following link that many other ecommerce shops have been able to do it. https://www.firstdata.com/en_us/customer-center/merchants/ecommerce-partner-directory.html  Isthere no oscommerce shop using this payment gateway? I have put it out there as a job request the other day, but no responses yet. I hate to think of having to switch our payment processor after using them for years on our old oscom site or go to using PayPal for all of our payments. Any ideas folks? Thanks

  11. I have now found that First Data has changed their software again recently due to security updates and now it is called the Payeeze Gateway. https://support.payeezy.com/hc/en-us We have had to purchase the upgraded software from them directly to be able to use it and am awaiting the code for integration into our new store. I am hoping it will work. We get a better rate through them vs PayPal as far as fees and a monthly charge of $20 vs $30 if we go with PayPal, so it should in theory pay for itself within 10 months or sooner. If it doesn't work we may get a PayPal Pro account to use for direct payments online, but trying to use First Data if possible as have been with them for several years now. I will update once they send the code and we see how it goes.

  12. I did get module to install on my site after Gary pointed me to the issue of needing to have soap installed on the server, but then I got the same error as stated in previous post. Anyone know how to fix this?

     

    I prefer the AIM process. We've switched to FirstData but I haven't dropped our current virtual merchant provider until I get this module working. Getting the same SOAP error discussed above even after checking and changing the password.

     

    Warning: stream_context_set_option() [function.stream-context-set-option]: called with wrong number or type of parameters; please RTM in /home/XXXXXXXX/public_html/includes/modules/payment/gge4_cc_aim.php on line 43

    Fatal error: Uncaught SoapFault exception: [HTTP] Authorization Required in /home/XXXXXXXXX/public_html/includes/modules/payment/gge4_cc_aim.php:45 Stack trace: #0 /home/XXXXXXXXX/public_html/includes/modules/payment/gge4_cc_aim.php(45): SoapClient->__doRequest('<?xml version="...', 'https://api.dem...' 'http://secure2....' 1, 0) #1 [internal function]: SoapClientHMAC->__doRequest('<?xml version="...', 'https://api.dem...' 'http://secure2....' 1, 0) #2 /home/XXXXXXXXX/public_html/includes/modules/payment/gge4_cc_aim.php(185): SoapClient->__call('SendAndCommit', Array) #3 /home/XXXXXXXXX/public_html/includes/modules/payment/gge4_cc_aim.php(185): SoapClientHMAC->SendAndCommit(Array) #4 /home/XXXXXXXXX/public_html/includes/classes/payment.php(191): gge4_cc_aim->before_process() #5 /home/XXXXXXXXX/public_html/checkout_process.php(81): payment->before_process() #6 {main} thrown in /home/XXXXXXXXX/public_html/includes/modules/payment/gge4_cc_aim.php on line 45

     

    Any new thoughts or success stories?

     

    Thanks!

×
×
  • Create New...