Jump to content

wazu

Members
  • Content count

    35
  • Joined

  • Last visited

Everything posted by wazu

  1. After comparing your post to a few of our stores, it appears you are missing some tables (you have 7) here are the 11 we have: insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) Hope this helps wazu :thumbsup:
  2. wazu

    Boxes of 6 or 12 bottles

    Simple, 1 - Offer a product and assign a price, ?Assorted 6 bottle box? 2 - Add options, ?bottle1, bottle2, bottle3, etc.? 3 ? Add attributes to each ?bottle? option (with no dollar value) 1 Red wine, 1 White wine, 1 Blue wine, etc. Customer will click on product (Assorted 6 bottle box) then see 6 drop downs each containing all the choices for selection to total the 6 bottles. wazu :thumbsup:
  3. wazu

    Faster Page Loads

    Greetings, I hope this is the correct place to ask - When I set "use cashe" to "true" in the admin panel. Surf the store, the category links disappear, reset "use cashe" to "false" in the admin panel, they all re-appear? Categories Box Manufacturers Box Also Purchased Module All show up in "cashe control" :blink: chmod cashe tried 755 / 666 , Is this a permissions problem? Thanks in advance - wazu
  4. wazu

    ECHO Processing

    Try this In admin>includes>functions.php around line 22, check this if ($filename != FILENAME_DEFAULT && $filename != FILENAME_FORBIDEN && $filename != FILENAME_LOGOFF && $filename != FILENAME_ADMIN_ACCOUNT && $filename != FILENAME_POPUP_IMAGE && $filename != 'packingslip.php' && $filename != 'invoice.php' && $filename != 'purchase.php' && $filename != 'confirm.php' && $filename != 'echo_result.php') { and make sure this echo_result.php is listed, Then, in admin>admin_files.php around line 238, check this if ((substr("$file", -4) == '.php') && $file != FILENAME_DEFAULT && $file != FILENAME_LOGIN && $file != FILENAME_LOGOFF && $file != FILENAME_FORBIDEN && $file != FILENAME_POPUP_IMAGE && $file != FILENAME_PASSWORD_FORGOTTEN && $file != FILENAME_ADMIN_ACCOUNT && $file != 'invoice.php' && $file != 'packingslip.php' && $file != 'purchase.php' && $file != 'confirm.php && $file != 'echo_result.php') { and again, see if this echo_result.php is in there. You might also confirm in admin>includes>filenames.php, you have this line define('FILENAME_ECHO_RESULT', 'echo_result.php'); // ECHO Hope you find this useful :thumbsup: wazu
  5. wazu

    ECHO Administration Tool Broken ?

    angi Fatal error: Cannot redeclare class echo_cc in /home/kasali3/public_html/cart/includes/modules/payment/echo_cc.php on line 14 Sounds like echo is not being seen as a payment mod, check your install, or try it over. Make sure you enter the echo pin# in all (i think 4) places. ronr1999 once a customer places an order, the "echo processing" can be used for that customer in the future to process additional orders maybe by telephone, snailmail. wazu
  6. Is the transaction recorded in the database (mysql)? How and what does Paypal and Nochex notify you about the orders? After waiting 7 weeks with no results, and if you haven?t recorded any sales transactions, you may consider a new install (it?s useless in it?s current state). And you may not have any data to worry about losing. wazu
  7. wazu

    Skip the shipping section

    In your admin > modules > shipping, turn off (remove) all installed shipping mods wazu
  8. wazu

    Web order placement

    Maybe the way to go is sell a purchase order, and then charge the shipping? http://www.oscommerce.com/community/contributions,355 http://www.oscommerce.com/community/contributions,1892 wazu
  9. wazu

    Help with payment

    I've been using Echo, no mothly charge if no transactions for that month (seasonal stores), you can proccess through your store, or by hand on their site. The rate starts high at sign up (free), but if you call in a few months and ask for a "rate review" they drop it. Works for me. wazu
  10. wazu

    Minimum quantity by Category?

    Greetings, Is it possible to sell the gallons as a ?two gallon product?? Then in the options: Option field 1 = flavor 1 Option field 2 = flavor 2 Without charges for either option. Or you may try http://www.oscommerce.com/community/contri...ons,1570/page,7 The author claims: ?Family Products is a module that allows a shop owner to create "families" of products to Display in there shop.? :thumbsup: wazu
  11. wazu

    handling fee for certain items

    Greetings, This sounds slightly similar to what I am looking to do, http://forums.oscommerce.com/index.php?showtopic=144613 Except, I need to identify the products attributes id and charge once for each occasion, and you, need only identify the product and charge every occasion. Both would be identified at check out, so you may start with ot_loworderfee.php and try hacking it. Simple Or add one attribute (option) to that product with the description "handling fee" charging what you want. If there is only one, it will appear in the drop down with no other choice but to accept the charge as part of the purchase. :thumbsup: wazu
  12. Greetings, If the term "transfer payment method" means the same as "payment method", I believe somewhere in the 2500 or so contributions (maybe this one) http://www.oscommerce.com/community/contributions,3067 I came crossed one that will assign an editable fee, based on the method of payment used "+" "-" "=" may need a little hack to exactly suit your needs. B) wazu
  13. wazu

    Setup fee

    This mod would also prove useful for services - You sell blinds and have an install fee You sell stationary and have a logo setup charge You sell wood moldings by the foot and have a setup charge You do mail order repair or modifications and have a trouble shoot (look at) fee You sell gold chain by the inch and charge a clasp and assemble fee You sell photography and you charge a matte or frame fee You are a plastic mold injector and you charge a setup fee You sell re-manufactured parts (auto, appliance, computer) and charge a core (old part to replace your stock) fee I?m sure there are dozens of other uses. Just a thought??. :-" wazu
  14. wazu

    Setup fee

    :blink: Greetings, We sell several items that are offered with many combinations of options. We can also sell any combination of any items we offer, in 22 different colors. However, setting up and cleaning down the spray equipment (after each color), forces us to charge a one time 'SETUP FEE' for each unique color ordered. Example1: (1) x model AAA (red) = $1.00 + $.50 (setup) (5) x model DDD (red)= $2.00 ___________________________________________ Total=$11.50 Example2: (1) x model AAA (red) = $1.00 + $.50 (red setup) (5) x model DDD (red)= $2.00 (2) x model AAA (blue) = $1.00 + $.50 (blue setup) (1) x model AAA (green)= $1.00 + $.50 (green setup) ___________________________________________ Total=$15.50 Because the setup fee need only apply once (after total number of unique colors have been calculated), it seems logical to be a ot_loworderrfee hack. The problem (as you were about to point out) is ot_loworderrfee calls from if ( ($pass == true) && ( ($order->info['total'] - $order->info['shipping_cost']) < MODULE_ORDER_TOTAL_LOWORDERFEE_ORDER_UNDER) ) { Assuming our colors are an option value, maybe we need if ( ($pass == true) && ( ($order->info['options_values_id'] == 107) ) { Unless, (as you were pointing out again) we are calling from the cart, maybe? if ( ($pass == true) && ($this->contents['products_options_value_id'] == '107') ){ Am I re-inventing the wheel, maybe ot_loworderrfee is not the way to go. I looked at the CC (build custom computer mod) and it seems over kill. Any direction would be extremely appreciated.
  15. wazu

    Setup fee

    I stated with a ot_loworderfee.php. The thought was to run a re-named version of the hacked script for each color. Looked for and did not/ cannot find any reference in ?classes? or modules.php regarding ot_loworderfee.php. I eliminated all the statements regarding minimum values and renamed ot_forestgreen_colorfee.php. Then added the color forestgreen to the color option menu. Running ot_loworderfee.php and ot_forestgreen_colorfee.php together did not seem to pose a problem, both worked in many combinations. However, a setup fee was assigned to EVERY order of forestgreen. Here is the hack <?php /* $Id: ot_forestgreen_colorfee.php,v 1.11 2003/02/14 06:03:32 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License forestgreen_colorfee=108 */ class ot_forestgreen_colorfee { var $title, $output; function ot_forestgreen_colorfee() { $this->code = 'ot_forestgreen_colorfee'; $this->title = MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_TITLE; $this->description = MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_DESCRIPTION; $this->enabled = ((MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_STATUS == 'true') ? true : false); $this->sort_order = MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_SORT_ORDER; $this->output = array(); } function process() { global $order, $currencies; if (MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_LOW_ORDER_FEE == 'true') { switch (MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_DESTINATION) { case 'national': if ($order->delivery['country_id'] == STORE_COUNTRY) $pass = true; break; case 'international': if ($order->delivery['country_id'] != STORE_COUNTRY) $pass = true; break; case 'both': $pass = true; break; default: $pass = false; break; } if ( ($pass == true) && ($order->info['products_options_values'] == '(optional color)Forest green') ){ $tax = tep_get_tax_rate(MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_TAX_CLASS, $order->delivery['country']['id'], $order->delivery['zone_id']); $tax_description = tep_get_tax_description(MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_TAX_CLASS, $order->delivery['country']['id'], $order->delivery['zone_id']); $order->info['tax'] += tep_calculate_tax(MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_FEE, $tax); $order->info['tax_groups']["$tax_description"] += tep_calculate_tax(MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_FEE, $tax); $order->info['total'] += MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_FEE + tep_calculate_tax(MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_FEE, $tax); $this->output[] = array('title' => $this->title . ':', 'text' => $currencies->format(tep_add_tax(MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_FEE, $tax), true, $order->info['currency'], $order->info['currency_value']), 'value' => tep_add_tax(MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_FEE, $tax)); } } } function check() { if (!isset($this->_check)) { $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_STATUS'"); $this->_check = tep_db_num_rows($check_query); } return $this->_check; } function keys() { return array('MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_STATUS', 'MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_SORT_ORDER', 'MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_LOW_ORDER_FEE', 'MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_FEE', 'MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_DESTINATION', 'MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_TAX_CLASS'); } 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 ('Display FORESTGREEN_COLORFEE', 'MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_STATUS', 'true', 'Do you want to display the FORESTGREEN_COLORFEE?', '6', '1','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 ('Sort Order', 'MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_SORT_ORDER', '4', 'Sort order of display.', '6', '2', 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 ('Allow FORESTGREEN_COLORFEE', 'MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_LOW_ORDER_FEE', 'false', 'Do you want to allow FORESTGREEN_COLORFEE?', '6', '3', '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, date_added) values ('FORESTGREEN_COLORFEE', 'MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_FEE', '5', 'Low order fee.', '6', '5', 'currencies->format', 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 ('Attach FORESTGREEN_COLORFEE On Orders Made', 'MODULE_ORDER_TOTAL_FORESTGREEN_COLORFEE_DESTINATION', 'both', 'Attach FORESTGREEN_COLORFEE for orders sent to the set destination.', '6', '6', 'tep_cfg_select_option(array(\'national\', \'international\', \'both\'), ', 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_ORDER_TOTAL_FORESTGREEN_COLORFEE_TAX_CLASS', '0', 'Use the following tax class on the FORESTGREEN_COLORFEE.', '6', '7', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now())"); } function remove() { tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')"); } } ?> I have also tried if ( ($pass == true) && ($order->info['products_options_values_id'] == '('108') ){ with the same results. Anybody, any ideas? Once this was figured out correctly, it would have the ability to apply a one time fee (setup fee) to any attribute associated with a product (color, size, material, lettering, grafix, etc.) :rolleyes: wazu
  16. wazu

    Setup fee

    No Luck. It appears that the ot_loworderfee.php - looks for the required information (the color) :: products_options_value_id from the order :: $order->info['xxx_xxx_xxx'] However, it appears, at this point, the required information (the color) has been merged with other information about the order and the format has been changed by the shopping cart for security :: $this->cartID = $this->generate_cart_id(); Does anyone know how to extract the required information (the color):: products_options_value_id at this point? Maybe we can read it from the HTML source from boxes>shopping_cart.php at checkout confirmation (the point that loworderfee is introduced) using something like :: $cart_contents = $HTTP_POST_VARS['products_options_values_id']; or $cart_contents = $HTTP_POST_VARS['products_options_values_name']; :'( I am obviously code?en in the dark (no clue). Any response will be appreciated. wazu
  17. wazu

    Setup fee

    :thumbsup: Thank you very much sir. I apologize, if I?ve given you the impression ?I do not have the time?. The fact is, I thought it was a much simpler task and could learn enough to implement in a timely fashion. Based on our discussions, and my current (lack of) php knowledge, I cannot do this in a timely manner. I believe, I have investigated almost all 2500 available contributions, which led me to the current path. The working store currently has a required choice of 2 options of color (stainless steel and white) for all products. Stainless steel is the ?no up charge? default. White is the ?up charge ? option; we do not need a setup fee for white. We propose to add 21 additional ?up charge? colors to this option field and charge (only once per unique color) a setup fee for any of the 21 additional colors that are chosen. I believe this is the "functional spec" you described? I am not clear if posting the url is allowed, or if I emailed it to you if you would find it helpful. You have been most helpful; I will continue to explore the world of PHP. wazu
  18. wazu

    Setup fee

    We considered alternatives to incorporate the additional costs of the color option, with no feasible solution. After reevaluating this color setup fee, we have determined it has to be implemented. For the short term, we will offer it as ?custom? requiring the customer to fill out a request. This may adversely impact online sales (for those purchasing color). In the long term, my inturpation of your valuable logic leads me to believe, you might lean towards adding additional values to track the ?color fee? or ?no color fee? approach. You suggested this is based on the limited consideration you gave to date and there may be simpler alternatives. May I ask you to briefly consider the following? A hack of the ?agree to terms mod? Customer will purchase the setup fee before gaining access to the color options. (As you are pointing out, it may make navigation sloppy and restricted.) This will solve the color fee, but generate how much more work for navigation clean up? Color popup Purchasing the color setup fee implements a popup for the available colors. Will it be simpler to get the java based ?popup choice? recognized by the cart? New setup The store is setup with 22 main color categories, shopping a unique category assigns its color fee (back to loworder fee hack). Another navigation nightmare. Any feedback would be immensely valuable, as we need to commit to a direction and are presently not qualified to do so. wazu
  19. wazu

    Setup fee

    Dave, are you saying there is no way to call from the data stored in it's current form? 71{1}91{6}81{7}83{8}88 71item id {1}color 91color id {6}size 81size id {7}mount 83mount id {8}diameter 88diameter id If so, I am headed in the wrong direction. That would put this beyond me newbe. thanks, RE- group, RE- think, RE- drink? wazu
  20. wazu

    Setup fee

    This is how the cart seams to be storing the product 71{1}91{6}81{7}83{8}88 71item id {1}color 91color id {6}size 81size id {7}mount 83mount id {8}diameter 88diameter id If the color information is already being stored, can we : from checkout? ($order->info['products_options_value_id'] == '91') or from in the cart? ($this->contents['products_options_value_id'] == '91') :blush: Am i gettin closer? thanks wazu
  21. wazu

    Setup fee

    Thank you VERY much. I'm going to do some (more) php schooling. Quick question, Am I trying to write the color data to the base?. as it is set up now, we have an attribute "color" with 22 options of colors. these colors are already being stored in the base as products_options_values_id right? That said would i simply have to identify the unique id number at the checkout ? thanks again, wazu
  22. wazu

    Setup fee

    Not sure what "<pre>var_dump(--array--)</pre>" is, maybe when you have more time you can elaborate, thanks for your quick reply, wazu
  23. wazu

    Setup fee

    I understand, thanks for your time. :rolleyes: wazu
  24. wazu

    Setup fee

    I am brand new to PHP, am i headed in the right direction? It seems when the cart collects the content, it merges it and asigns a unique cart_id(classes>shopping_cart). Or is it pushed back at chekout? Thanks.
×