Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

HDLLC

Archived
  • Posts

    156
  • Joined

  • Last visited

Posts posted by HDLLC

  1. Hi-

     

    I'm working on a store and I am trying to figure out the best shipping module for what I am doing.

    The cool thing is that every box is the same size, and pretty well the same weight. It's one item per box - pretty simple.

    I'd like to use realtime UPS rates, but wasn't sure how big of a hassle that was with using a module like that. I believe I tried one like this before and there was some red tape to cut through on the UPS side with getting access to do this.

     

    It's a low volume site right now, as it's just starting up. I'm not sure if this makes a difference or not. Just trying to get all the info I can, included in this question.

     

    Any suggestions?

     

    Thanks!

     

    --Jeff

  2. Hi!

     

    I've got SEO-G installed and the admin portion is working just fine - picked up my cat and product names by default almost - and have followed the directions (three times) and still getting an error.

     

    It's not redirecting to the rewritten URL (product-name.html) and I get a 404.

     

    Here's the guts of my htaccess file:

     

    # $Id: .htaccess,v 1.3 2003/06/12 10:53:20 hpdl Exp $
    #
    # This is used with Apache WebServers
    #
    # For this to work, you must include the parameter 'Options' to
    # the AllowOverride configuration
    #
    # Example:
    #
    # <Directory "/usr/local/apache/htdocs">
    #   AllowOverride Options
    # </Directory>
    #
    # 'All' with also work. (This configuration is in the
    # apache/conf/httpd.conf file)
    
    # The following makes adjustments to the SSL protocol for Internet
    # Explorer browsers
    
    <IfModule mod_setenvif.c>
     <IfDefine SSL>
       SetEnvIf User-Agent ".*MSIE.*" \
                nokeepalive ssl-unclean-shutdown \
                downgrade-1.0 force-response-1.0
     </IfDefine>
    </IfModule>
    
    # If Search Engine Friendly URLs do not work, try enabling the
    # following Apache configuration parameter
    #
    # AcceptPathInfo On
    
    # Fix certain PHP values
    # (commented out by default to prevent errors occuring on certain
    # servers)
    #
    <IfModule mod_php4.c>
     php_value session.use_trans_sid 0
     php_value register_globals 1
    </IfModule>
    
    <IfModule mod_php5.c>
     php_value session.use_trans_sid 0
     php_value register_globals 1
    </IfModule>
    
    #-MS- SEO-G Added
    Options +FollowSymLinks
    RewriteEngine On
    # Next line must be changed to match your osCommerce folder - the relative path
    RewriteBase /
    RewriteRule ^(.*).html$ root.php?$1.html&%{QUERY_STRING}
    #-MS- SEO-G Added EOM

     

    my install is located in the root folder...

     

    host has mod_rewrite installed...

     

    Any ideas?

     

    Thanks in advance!

     

    --Jeff

  3. Thanks for the information, Jack! Much appreciated!

     

    I too am having some difficulties with the files... Do we simply look for every instance of "table" and change every one that is not a db table name?

     

    I've tried a couple of different variations... Nothing seems to work. I keep getting errors in the admin...

    Do you, by chance, have a changed file that we can look at for reference?

     

    Thanks, in advance!

     

    --Jeff

     

     

    Okay - I have it. I'll post the file that works for reference.

    Look for instances of table2 and TABLE2 - where appropriate. Case is important - as Jack has stated - so pay close attention.

     

    Best wishes!

     

    --Jeff

     

    <?php
    /*
     $Id: table.php,v 1.27 2003/02/05 22:41:52 hpdl Exp $
    
     osCommerce, Open Source E-Commerce Solutions
     [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url]
    
     Copyright © 2003 osCommerce
    
     Released under the GNU General Public License
    */
    
     class table2 {
       var $code, $title, $description, $icon, $enabled;
    
    // class constructor
       function table2() {
         global $order;
    
         $this->code = 'table2';
         $this->title = MODULE_SHIPPING_TABLE2_TEXT_TITLE;
         $this->description = MODULE_SHIPPING_TABLE2_TEXT_DESCRIPTION;
         $this->sort_order = MODULE_SHIPPING_TABLE2_SORT_ORDER;
         $this->icon = '';
         $this->tax_class = MODULE_SHIPPING_TABLE2_TAX_CLASS;
         $this->enabled = ((MODULE_SHIPPING_TABLE2_STATUS == 'True') ? true : false);
    
         if ( ($this->enabled == true) && ((int)MODULE_SHIPPING_TABLE2_ZONE > 0) ) {
           $check_flag = false;
           $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_TABLE2_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id");
           while ($check = tep_db_fetch_array($check_query)) {
             if ($check['zone_id'] < 1) {
               $check_flag = true;
               break;
             } elseif ($check['zone_id'] == $order->delivery['zone_id']) {
               $check_flag = true;
               break;
             }
           }
    
           if ($check_flag == false) {
             $this->enabled = false;
           }
         }
       }
    
    // class methods
       function quote($method = '') {
         global $order, $cart, $shipping_weight, $shipping_num_boxes;
    
         if (MODULE_SHIPPING_TABLE2_MODE == 'price') {
           $order_total = $cart->show_total();
         } else {
           $order_total = $shipping_weight;
         }
    
         $table_cost = split("[:,]" , MODULE_SHIPPING_TABLE2_COST);
         $size = sizeof($table_cost);
         for ($i=0, $n=$size; $i<$n; $i+=2) {
           if ($order_total <= $table_cost[$i]) {
             $shipping = $table_cost[$i+1];
             break;
           }
         }
    
         if (MODULE_SHIPPING_TABLE2_MODE == 'weight') {
           $shipping = $shipping * $shipping_num_boxes;
         }
    
         $this->quotes = array('id' => $this->code,
                               'module' => MODULE_SHIPPING_TABLE2_TEXT_TITLE,
                               'methods' => array(array('id' => $this->code,
                                                        'title' => MODULE_SHIPPING_TABLE2_TEXT_WAY,
                                                        'cost' => $shipping + MODULE_SHIPPING_TABLE2_HANDLING)));
    
         if ($this->tax_class > 0) {
           $this->quotes['tax'] = tep_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
         }
    
         if (tep_not_null($this->icon)) $this->quotes['icon'] = tep_image($this->icon, $this->title);
    
         return $this->quotes;
       }
    
       function check() {
         if (!isset($this->_check)) {
           $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_TABLE2_STATUS'");
           $this->_check = tep_db_num_rows($check_query);
         }
         return $this->_check;
       }
    
       function install() {
         tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Table Method', 'MODULE_SHIPPING_TABLE2_STATUS', 'True', 'Do you want to offer table rate shipping?', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
         tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Shipping Table', 'MODULE_SHIPPING_TABLE2_COST', '25:8.50,50:5.50,10000:0.00', 'The shipping cost is based on the total cost or weight of items. Example: 25:8.50,50:5.50,etc.. Up to 25 charge 8.50, from there to 50 charge 5.50, etc', '6', '0', now())");
         tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Table Method', 'MODULE_SHIPPING_TABLE2_MODE', 'weight', 'The shipping cost is based on the order total or the total weight of the items ordered.', '6', '0', 'tep_cfg_select_option(array(\'weight\', \'price\'), ', now())");
         tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Handling Fee', 'MODULE_SHIPPING_TABLE2_HANDLING', '0', 'Handling fee for this shipping method.', '6', '0', now())");
         tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Tax Class', 'MODULE_SHIPPING_TABLE2_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now())");
         tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Shipping Zone', 'MODULE_SHIPPING_TABLE2_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', '6', '0', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now())");
         tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_SHIPPING_TABLE2_SORT_ORDER', '0', 'Sort order of display.', '6', '0', now())");
       }
    
       function remove() {
         tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
       }
    
       function keys() {
         return array('MODULE_SHIPPING_TABLE2_STATUS', 'MODULE_SHIPPING_TABLE2_COST', 'MODULE_SHIPPING_TABLE2_MODE', 'MODULE_SHIPPING_TABLE2_HANDLING', 'MODULE_SHIPPING_TABLE2_TAX_CLASS', 'MODULE_SHIPPING_TABLE2_ZONE', 'MODULE_SHIPPING_TABLE2_SORT_ORDER');
       }
     }
    ?>
    

     

     

    and then in the languages/english/modules/shipping:

     

    <?php
    /*
     $Id: table.php,v 1.5 2002/11/19 01:48:08 dgw_ Exp $
    
     osCommerce, Open Source E-Commerce Solutions
     [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url]
    
     Copyright © 2002 osCommerce
    
     Released under the GNU General Public License
    */
    
    define('MODULE_SHIPPING_TABLE2_TEXT_TITLE', 'Next Day');
    define('MODULE_SHIPPING_TABLE2_TEXT_DESCRIPTION', 'Next Day');
    define('MODULE_SHIPPING_TABLE2_TEXT_WAY', 'Best Way');
    define('MODULE_SHIPPING_TABLE2_TEXT_WEIGHT', 'Weight');
    define('MODULE_SHIPPING_TABLE2_TEXT_AMOUNT', 'Amount');
    ?>
    

  4. I tried these exact steps, with the table module, but it doesnt seem to load the text. When I list the available modules in admin, the one for my new module is a blank row, and the install button wont work. I have checked that the language file is the same name as the module file.

     

    Any suggestions?

     

    Thanks

     

     

    Thanks for the information, Jack! Much appreciated!

     

    I too am having some difficulties with the files... Do we simply look for every instance of "table" and change every one that is not a db table name?

     

    I've tried a couple of different variations... Nothing seems to work. I keep getting errors in the admin...

    Do you, by chance, have a changed file that we can look at for reference?

     

    Thanks, in advance!

     

    --Jeff

  5. refer to previous threads...

     

    change all sprint_f in that file to sprintf..that will fix the error prompt...

     

    however, if you have the problem of removing the option values, then dont worry...i have that problem too...some say its browser incompatibility...but i think its more in the codes...as there are actually no codes for removing the option values...read it on the installation file...the creator mentioned 'no removing of option values'. so i guess we have to create them...

     

    anyone with a fix on removing option values?

     

    That fix works like a champ!

     

    Thanks a million!

     

    --Jeff

  6. I've installed this contribution before -without incident...

    Tried it on another site today - and it won't save the changes in the admin...

     

    Any ideas?

     

    Thanks, in advance!

     

    --Jeff

     

    I've checked permissions on the installed files - all set to 755 - so not sure where else to look.

     

    I install it through the admin, and go to add my settings (email address, debug, etc.) and the changes won't save.

     

    Any ideas?

     

    Thanks in advance!

     

    --Jeff

  7. I'm looking for a contribution to create an affiliate network that rewards those linking to products on my web site(s).

    Want to be able to track the sales they generate and then provide them with a commission based upon sales they helped generate.

     

    Seems like some affiliate contributions work the opposite (bill)...?

     

    Maybe I misunderstand how each might work - but wondered if anyone had some experience to share about which contrib for this purpose is working for them. (good, bad, etc.)

     

    Thanks in advance!

     

    --JH

  8. Hi-

     

    Running into a problem where a customer cannot order more than one of any item.

    If they do - it doesn't ever add to the cart...

     

    I have Product Option Type installed to allow for extra text information.

     

    In addition, the number of items in the cart (shown in text at top of the site) doesn't match what is actually in the cart.

    Always seems to be 5 or so bogus items in there when I check cart contents.

    ie: top nav shows 7 items in my cart, but looking at my cart I only have 3.

     

    Any ideas where I can start looking for the culprit?

     

    Thanks!

     

    --Jeff

  9. Actually - the information is being trapped - as it's in the order email I get from the store (on a test order as a customer) - but not showing in the "orders" within the admin.

     

    Any ideas?

     

    Thanks!

     

    --Jeff

     

     

    Problem solved... line of code in checkout_process.php had been commented out, preventing the insertion of the attributes into the database.

     

    Thanks for the help!

     

    --Jeff

  10. Question: I have QTPro installed - and was working, now not...

     

    Not sure if I modified something I should not have... Not really sure where to even start looking.

     

    Problem is that once an order is placed, I cannot see the chosen attributes in the admin. I can see it showing in some previous orders, but not in the orders placed as of late.

     

    Where can I start looking in the code to get this solved...?

     

    Thanks in advance!

     

    --Jeff

     

     

    Actually - the information is being trapped - as it's in the order email I get from the store (on a test order as a customer) - but not showing in the "orders" within the admin.

     

    Any ideas?

     

    Thanks!

     

    --Jeff

  11. Question: I have QTPro installed - and was working, now not...

     

    Not sure if I modified something I should not have... Not really sure where to even start looking.

     

    Problem is that once an order is placed, I cannot see the chosen attributes in the admin. I can see it showing in some previous orders, but not in the orders placed as of late.

     

    Where can I start looking in the code to get this solved...?

     

    Thanks in advance!

     

    --Jeff

  12. Hi-

     

    I am running product option type feature contribution to allow for event registration.

    It's running now - just need to allow for free shipping on those particular items.

     

    The packages I downloaded for free shipping are just replacement files - but they are the files I have already modified...

     

    Anyone have the code broken down that I can insert into those two files to make things work?

     

    Or - possibly there is another way I am not thinking of...?

     

    Thanks in advance for any ideas!

     

    --Jeff

  13. http://www.oscommerce.com/forums/index.php?showtopic=247976

     

    Trying to make a fix to the PayPal IPN to get another contribution going - but hit a snag...

     

    Anyone here have ideas on this issue with PayPal IPN and Product Option Type feature?

     

    I downloaded virtually every version of PayPal IPN, and searched the text for the third line, as prescribed in this fix (link above) and have come up empty handed.

     

    Anyone have any ideas on this one? I am having the exact same problem - only I cannot find the code in the paypal_ipn.php file to make the fix.

     

    Hitting a dead-end with this. Hoping someone can point me in the right direction.

     

    Thanks in advance for any help...

     

    --Jeff

  14. Is this fix written for any particular version of the IPN...? I tried searching for this in a couple different versions of the osc paypal IPN, and cannot locate that third line of code to be replaced (even tried searching for parts of the code...).

     

    Thanks in advance!

     

    --Jeff

     

    Anyone running this have problems with not being able to order more than one of any particular item?

     

    I am suddenly having problems with this... Not good.

     

    Anyone have any ideas?

     

    Thanks!

     

    --Jeff

  15. Thanks Jeff!!

    Mike

     

    You are very welcome.

     

    And, my problem corrected itself upon importing the second sql file a couple of times... ID reset so all is good.

     

    Anyone have a good version of the PayPal IPN files that have the fix to carry over the TEXT options? I found the three step fix, but cannot get the third one in.

    I cannot even locate the third line to replace. I even downloaded the last two versions of OSC paypal IPN...

     

    Thanks!

     

    --Jeff

  16. GREAT Information!

     

    Thanks for taking the time to post this.

     

    Having a problem - cannot locate the third piece of code to replace...?

     

    Any ideas?

     

    Thanks!

     

    --Jeff

     

     

    Is this fix written for any particular version of the IPN...? I tried searching for this in a couple different versions of the osc paypal IPN, and cannot locate that third line of code to be replaced (even tried searching for parts of the code...).

     

    Thanks in advance!

     

    --Jeff

×
×
  • Create New...