Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  1. You rule Mark! I'll wait for it (with great appreciation :rolleyes: ) Thanks a lot! ps: where will you be putting the file? in the download section? DicE
  2. Hi Mark, I would really much appreciate this MS1 modification. Or just a little bit more info. I read your answer: But I'm not really getting it. I looked into your modified boxes.php but I don't know were to start with point 1... :unsure: could you give a bit more info on how to make this work on MS1? I get the same error about the tep_output_string() function missing. Thanks for your help. Looks like a great contrib to have! best regards. DicE
  3. I, I liked your contribution a lot so I decided to give the install a go. the admin part works fine, but in the catalog I get a error about a missing funtions: It's about that tep_output_string() funtion that being used in boxes.php. where is it supposed to be? I double checked all your install instructions. and don't think I missed anything.. could you give me a hint please? I'm using a heavily modified MS1 shop btw thanks for the help DicE
  4. Hi, I'm using the "Free Shipping over amount" contrib on a MS1 shop. http://www.oscommerce.com/community/contributions,146/page,2 I love the idea of your contrib but I can't get it to work. I mean, the checkout button is showing fine, but it's not showing any of the free shipping info. is it not supposed to work with this contrib then? Or better... can you make it work? I'd be very thankfull! keep it up. it's little details like this that make a shop look professional and yours is surely one of them! loving it already :-) ps: just got v1.1 going to update... will it work? who knows! DicE
  5. that would indeed be excellent, but for now, if the "pickup in store" module could be made a bit more intelligent to recognize the zipcode of the deliveryaddress upon checkout, it should be possible to just put a different description there. e.g. : "Free delivery at you home" instead of "Pick up the products in our store" the cost stays the same for both, it's just a matter of changing the text where needed... I've found some code in the 'extraship' contribution that works with zipcodes, but I'm having a hard time putting it together with the 'store pickup' contrib... :blink: if anyone wants to help me on this that would be great! thanks a lot!!!! DicE
  6. The pickup at store is working fine, I would just like to have the text changed to "free delivery" when certain zipcodes are used in the deliveryaddress during checkout... nothing more :unsure: If only I knew ... Thanks for any help!!! DicE
  7. I know how the language files work and how they fit into the osc structure. What I don't know, is how to make the test for the zipcode so that the pickup mod identifies the zipcode and displays the correct text string. Either "free delivery" when the zipcode matches the one(s) I specify, or "pick up at the store" when it's another one... anybody know where to start with that? thanks! DicE
  8. Thanks for the replies, the ship in cart module doesn't seem a good solution, and I've tried to mod the "pickup in store" mod. That seems to be an easier solution since I offer pickup in store for free, I would just need to change the text to "free delivery" when a certain zip code is used in delivery address. but I just can't seem to make it work... Does anybody know how to modify the code below so the text during checkout reads "free delivery" instead of "pickup in store" ? the variables involved are : $this->title = MODULE_SHIPPING_PICKUP_TEXT_TITLE; $this->description = MODULE_SHIPPING_PICKUP_TEXT_DESCRIPTION; but how to change this on the fly when a certain zipcode is used???? class pickup { var $code, $title, $description, $icon, $enabled; // class constructor function pickup() { global $order; $this->code = 'pickup'; $this->title = MODULE_SHIPPING_PICKUP_TEXT_TITLE; $this->description = MODULE_SHIPPING_PICKUP_TEXT_DESCRIPTION; $this->sort_order = MODULE_SHIPPING_PICKUP_SORT_ORDER; $this->icon = ''; $this->tax_class = MODULE_SHIPPING_PICKUP_TAX_CLASS; $this->enabled = ((MODULE_SHIPPING_PICKUP_STATUS == 'True') ? true : false); if ( ($this->enabled == true) && ((int)MODULE_SHIPPING_PICKUP_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_PICKUP_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 = '') { $this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_PICKUP_TEXT_TITLE, 'methods' => array(array('id' => $this->code, 'title' => MODULE_SHIPPING_PICKUP_TEXT_WAY, 'cost' => MODULE_SHIPPING_PICKUP_COST))); 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_PICKUP_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 PickUp Shipping', 'MODULE_SHIPPING_PICKUP_STATUS', 'True', 'Do you want to offer pickup 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, use_function, set_function, date_added) values ('Steuersatz', 'MODULE_SHIPPING_PICKUP_TAX_CLASS', '0', 'W?hlen Sie den MwSt.-Satz f?r diese Versandart aus.', '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 ('Versand Zone', 'MODULE_SHIPPING_PICKUP_ZONE', '0', 'Wenn Sie eine Zone ausw?hlen, wird diese Versandart nur in dieser Zone angeboten.', '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 ('Reihenfolge der Anzeige', 'MODULE_SHIPPING_PICKUP_SORT_ORDER', '0', 'Niedrigste wird zuerst angezeigt.', '6', '0', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('PickUp Cost', 'MODULE_SHIPPING_PICKUP_COST', '0.00', 'What is the Shipping cost? The Handling fee will also be added.', '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_PICKUP_STATUS', 'MODULE_SHIPPING_PICKUP_COST', 'MODULE_SHIPPING_PICKUP_TAX_CLASS', 'MODULE_SHIPPING_PICKUP_ZONE', 'MODULE_SHIPPING_PICKUP_SORT_ORDER'); } } ?>
  9. Hi all, I'm looking for a shipping module that can be configured to give free delivery based on the postal code (and country=country of store) of the delivery address. does anyone know if this exist? or would it be difficult to modify the "pickup at store" module to include it? I would like to deliver for free to customers living near me so the options should only be showing during checkout for the postal codes that I configure... please help! thank you DicE
  10. DicE

    Paypal IPN Module help

    Hey Jason I think Craig misunderstood your question. inserting the .sql file into your database using phpmyadmin is actually quite easy (providing your ISP gave you enough access.) when you are in the main screen of phpmyadmin, on the left, select the database used by oscommerce in the pulldown menu. then on the right you should get all kinds of tabs, one is named SQL go into that one, and there you should have a text box where you can manually type in SQL commands for phpmyadmin to execute on your db. the .sql file you have, contains those commands so you don't have to type them. Just below the text box you should have an option to browse for .sql files. Providing your ISP gave you enough access, you should be able to browse to the file, select it and then execute the script file so it creates the necessairy tables for you. If you don't have that "browse" button, you can always open the sql file in a text editor, and copy - paste the code in there into the text window. And then execute the script. It's basically the same thing.... the second option is just less work :) Hope it works out fine now! DicE
  11. DicE

    EasyPopulate MODIF Question

    is there nobody who can help me with this? I'm not asking that much. Just a few hints where to look... I've read about plenty of people who modified EP for there needs. Can't be that there is nobody who can answer this for me... thank you very much!
  12. DicE

    Bulk Upload of Products

    that's because you're using a recent snapshot. the tep_array_merge() function of oscommerce has changed name. There's a post about that right here: http://forums.oscommerce.com/viewtopic.php...t=teparraymerge check it out! greetz Maarten
  13. I would like to change Easypopulate 2.60 so it doesn't touch my descriptions anymore. This is because they get totaly messed up when I upload them again + when you export the excel file back to tab-delimited text file, you must make sure that the complete field of "description" is visible! If you don't do that, the part that was still hidden does not get exported. That and the way EP handles special characters like " and ' ... In short, that bugs me :) I already made changes so I can now export to a text file that doesn't include the description, but when I upload it again, it keeps blanking out my descriptions again. So somewhere in the import routine, something's going wrong... could someone give me some pointers as to where I should look for this? This is the modified export part: is this ok like that? case 'priceqty': // CHANGE TO REFLECT THINQ NEEDS $iii = 0; // $filelayout = array( 'v_products_model' => $iii++, 'v_products_image' => $iii++, ); foreach ($langcode as $key => $lang){ $l_id = $lang['id']; $filelayout = tep_array_merge($filelayout , array( 'v_products_name_' . $l_id => $iii++, 'v_products_head_title_tag_'.$l_id => $iii++, )); } $filelayout = tep_array_merge($filelayout , array( 'v_products_price' => $iii++, 'v_date_avail' => $iii++, 'v_manufacturers_name' => $iii++, 'v_tax_class_title' => $iii++, 'v_status' => $iii++, )); // build the categories name section of the array based on the number of categores the user wants to have for($i=1;$i<$max_categories+1;$i++){ $filelayout = tep_array_merge($filelayout, array('v_categories_name_' . $i => $iii++)); } $filelayout_sql = "SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_date_available as v_date_avail, p.manufacturers_id as v_manufacturers_id, p.products_tax_class_id as v_tax_class_id, p.products_status as v_status, subc.categories_id as v_categories_id FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id "; break; I always thought that EP made it's upload scalable according to the headingline (first line of your text file containing the "v_description_" blablabla etc... but I don't have the description, and it still overwrites my description field in the DB... Any suggestions? Thanks a Lot!!!!! Maarten
  14. DicE

    Wishlist MS1 SQL error

    thanx for the effort Rob, but I already tried that without any luck... :( anybody else any ideas? DicE
  15. Hi, I'm running Wishlist mod with the MS1 modification (so it's supposed to work), but I can't get it to work properly. Adding products is no problem, but when you delete them from the wishlist I get this SQL error: It seems he doesn't know what products_id to take (as it's always <nothing>). I've had multiple users of my shop try it out and all SQL errors look alike, except for the customer_id ofcourse. When you try to move a product from the wishlist to the cart, it copies the product to the cart, and leave the wishlist entry there also, instead of removing it... Does anybody know why I'm having these errors? Could it be because of the "Search Engine Friendly url" I have enabled? I've tried it with the setting disabled also but no Joy... PLEASE HELP! Just tell me what you want to see. DicE