Jump to content


  • Content count

  • Joined

  • Last visited


Profile Information

  • Real Name
    Gunter Sammet
  • Location
  1. I packaged this functionality as a contribution. Looking for a few people to do a test install before I upload it to the contribution section. Thanks, Gunter
  2. guntersammet

    Order update email in customer language

    Hi all: I packaged this contribution over the weekend. Looking for a few people who would like to do a test install. Please contact me via PM or email (gunter aaaaht sammysolutions doooot com). Thanks, Gunter
  3. guntersammet

    Order update email in customer language

    Been working on it today to improve it a bit. Have again a look at http://oscommerce.sammysolutions.com/showc...amp;action=edit Additionally I added an edit tool for the order comments: http://oscommerce.sammysolutions.com/showc...us_comments.php Settings should be pretty self explanatory. You can add placeholders to the comment. Convention is <<|your question here|>> (tag starts with <<| and ends with |>>, the text inbetween is the question for the prompt box. Have a look at the fourth and fifth comment. Please have a look and let me know if there are any bugs. Will try to package it up sometime this week! Cheers, Gunter
  4. guntersammet

    Order update email in customer language

    Hi Carine: Can you please point me to that contribution. Thanks, Gunter
  5. guntersammet

    help with syntax error

    You can't have 2 where clauses. Not sure if this has been caused by adding a contribution but you might want to try the following: $check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_lastname, customers_password, customers_email_address, customers_default_address_id, affiliate_id, affiliate_firstname, affiliate_password, affiliate_email_address from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . " and affiliate_email_address = '" . tep_db_input($email_address) . "'"); In this case you will need an email address in the $email_address variable and affiliate_email_address needs to be a column in the customers table AND both email fields need to have the same email address in it. HTH Gunter
  6. Hi all: While working on some other contributions I added a little functionality to the order update email. Have a look at: http://oscommerce.sammysolutions.com/showc...amp;action=edit to see what I mean. I added a select to select the language the email should be sent at. Also added a field to the database to capture the order language. If this is set, it automatically suggests that language. Besides that I added a little selector box where you can select default comments in the respective language (there is currently no admin tool for the comments). Just been wondering if this would be of some interest to the community. If yes, I'll try to package it as a contribution. Any input appreciated! Cheers, Gunter
  7. Hi all: Been working on a new and improved inventory system. It's almost ready for release and it would be nice if I could get some testers and input from the community to weed out bugs and such. The admin for the attributes can be found here: http://oscommerce.sammysolutions.com/showc...attributes2.php -->On this page you can add/remove options from a product and update the inventory. -->To the right of the products selector is a link to "[Add/Edit/Delete Option Groups and Values]". I hope everything is pretty intuitive to use. There are a few tiny issues. Please check below in the todo list and known bugs list. Also want to mention that if you click on this link, you only will be able to add a new option group after you selected an option. Option values can be sorted on this page. Unfortunately options can't be sorted at the moment. I might address this down the road but it would have been a lot of work (at the time I discovered that this would be a nice to have) to add it right now and I don't have the time. Sortorder is the ID for option groups. Workaround would be, to delete option groups and recreate them. E.g. for clothing it would make sense to have the size first and then other attributes. The shop URL is as folows: http://oscommerce.sammysolutions.com/showcase2/index.php -->Product with multiple attributes will have a dynamic generated drop down. If the browser supports it (tested on Firefox and IE. Would be nice if testers could test it on different browsers). only attributes with inventory will show. I set up a sample here: http://oscommerce.sammysolutions.com/showc...products_id=140 If JavaScript is turned off or the browser doesn't support it (didn't test browsers that don't support the dynamic option generation), there will be a link displayed. If the user clicks it, a session variable is set and all attributes will be displayed. The inventory check will be done during checkout. todo list: ====== -Add the product status to the drop down selector in admin. -Display the option values in admin in sorted order (as set in the option admin page). -Add an "Add Option Group" button to the option admin popup before an option is selected. -Package the changes to release it as a contribution. -Write an installation manual and basic usage manual. -Write a "how to" to add programming changes to contributions that need to change the inventory (e.g. order admin contributions). -Functionality to increase inventory again when order status is changed to specific statuses (e.g. Cancelled). Currently it only increases the inventory when the order is deleted and the "increase inventory" checkbox is selected. known bugs: ======== -If you update inventory (form submit) and you click on the "[Add/Edit/Delete Option Groups and Values]" link and then click the "[Return to Attribute Admin]" link, the page refresh does another form submit. If you confirm the form submit, it does the action again. If you inserted inventory for a product the first time, it will result in a sql error. If you cancel, the changes to option groups/values won't be reflected at the current screen. You have to select another product and then return again. known annoyances/potential issues: ======================= -There is no inventory check in the checkout_process.php. If sombody stays for too long on the confirmation page and somebody else orders the last product, the order still goes through resulting in a negative inventory. Looking forward to lots of input! Thanks, Gunter
  8. guntersammet

    Problems Please Help... Amanda maybe?

    After reading it again, you it seems like you want to use count. Are you making sure that you are in the correct scope for $cart_num? If not, $cart_num might not be available where you try to use it. HTH Gunter
  9. guntersammet

    Problems Please Help... Amanda maybe?

    Not 100% sure what you try to do. somehow it appears to me that you want to sum up the $cart_num array but you use count which returns you the number of elements in the array. BTW, did you have a look at my gift registry contribution (http://www.oscommerce.com/community/contributions,1226/category,all/search,registry)? HTH Gunter
  10. guntersammet

    OSC super user login?

    Just saw your post while searching for my original post on the super user. check http://forums.oscommerce.com/index.php?showtopic=25153&hl= for more info. HTH Gunter
  11. guntersammet

    Gift Registry

    Can you please post a step by step instruction how I can reproduce this!? G.
  12. guntersammet

    Gift Registry

    Sorry. Didn't see this thread earlier. Haven't been around in the forum too much lately. If the cart looses the registry mode this is usually because it looses the session. Make sure your session paths and domains are set correctly in configure.php. Also make sure the tmp directory isn't shared with other osc installs. You may try to create a tmp directory in your web directory, give it world write permissions and then set the path in admin - configuration - sessions. Make sure it's an absolute path from root. HTH Gunter
  13. The code looks fine to me. You might can try to change if($_POST['ship_insurance']=='1'){ to if($HTTP_POST_VARS['ship_insurance']=='1'){ Otherwise I am not sure what it could be. HTH Gunter
  14. guntersammet

    Bundled Products Issue

    There is a little bug in the description of the install. You need to move the "update bundle contents" in categories.php a few lines down. It should look like this: if ($action == 'insert_product') { $insert_sql_data = array('products_date_added' => 'now()'); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); tep_db_perform(TABLE_PRODUCTS, $sql_data_array); $products_id = tep_db_insert_id(); tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$current_category_id . "')"); } elseif ($action == 'update_product') { $update_sql_data = array('products_last_modified' => 'now()'); $sql_data_array = array_merge($sql_data_array, $update_sql_data); tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'"); } // update bundle contents if ($HTTP_POST_VARS['products_bundle'] == 'yes') { tep_db_query("DELETE FROM products_bundles WHERE bundle_id = '" . $products_id . "'"); for ($i=0, $n=6; $i<$n; $i++) { if (isset($HTTP_POST_VARS['subproduct_' . $i . '_qty']) && $HTTP_POST_VARS['subproduct_' . $i . '_qty'] > 0) { tep_db_query("INSERT INTO products_bundles (bundle_id, subproduct_id, subproduct_qty) VALUES ('" . $products_id . "', '" . $HTTP_POST_VARS['subproduct_' . $i . '_id'] . "', '" . $HTTP_POST_VARS['subproduct_' . $i . '_qty'] . "')"); } } } $languages = tep_get_languages(); Also noticed a little typo in the if statement. It should read: if ($HTTP_POST_VARS['products_bundle'] == 'yes') { AND NOT if ($HTTP_POST_VARS['products_bundle'] = 'yes') { HTH Gunter
  15. guntersammet

    Gift Registry and Lay Buy (layaway)????

    That's not the registry contribution I have been talking about. Mine is at http://www.oscommerce.com/community/contributions,1226. Didn't understand the layaway functionality completely. Can you please show me some samples or describe the functionality a bit more? G.