Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

De Dokta

Pioneers
  • Posts

    329
  • Joined

  • Last visited

  • Days Won

    15

Everything posted by De Dokta

  1. Next try - fixes the 'invalid zone' bug: get_shipping_quotes.php shipping_in_cart.php
  2. @@Tsimi Hi Lambros The tax issue seems to have something to do with your configuration or any modification you made. I just installed this interstate.php and the 'shipping quote in cart' files into a fresh, clean bs-gold store. Tax calculation is correct! And yes, there is a bug with the first display of the zones pulldown. It makes me crazy! :x J.J.
  3. @@Tsimi Hi Lambros Ah, this module seems something special. In this case you must replace $default_zone_id by $default_zone_code. Try this: get_shipping_quotes.php shipping_in_cart.php I suppose that will work ONLY with this module. J.J.
  4. Ok, next try - with a zones pulldown for those countries for which states/zones are stored in the database. Since I use no shipping module, which works with zones, I would very much appreciate it if someone with such a module would test if it works correctly. Only for bootstrap! shipping_in_cart.php get_shipping_quotes.php J.J.
  5. @@Tsimi Hi Lambros I'm not sure if I exactly understand what you mean. Do you want to display in the pulldown that part that appears in checkout process after the name of the shipping module in brackets, e.g. Flat Rate (Best Way) ? If so, look in both files for: $quotes_array[] = array('id' => $quotes[$i]['id'].'_'.$quotes[$i]['methods'][$j]['id'], 'text' => $quotes[$i]['module']); and replace it by: $quotes_array[] = array('id' => $quotes[$i]['id'].'_'.$quotes[$i]['methods'][$j]['id'], 'text' => $quotes[$i]['methods'][$j]['title']); also look for (2x in each file) $title_shipping = $quotes[$i]['module']; and replace it with: $title_shipping = $quotes[$i]['methods'][$j]['title']; For your zones/states problem I have no quick answer. I never saw a shipping module which works on the basis of states (probably because something like that is not needed in Europe :D ) - so I don't know how they work. I suppose they use the entry_zone_id!? But it should be possible - for example as in create account - to add a logic that checks to see whether a country has zones, and if so, will open a second pulldown for states.........A lot of effort for such a gimmick! J.J.
  6. @@Tsimi Hi Lambros, my current version - not finished yet, because I just don't have the time, but I've already fixed some bugs .... get_shipping_quotes.php shipping_in_cart.php Better? J.J.
  7. Hi, add to your user.css a new entry like this: @[member='media'] screen and (min-width: 768px) { body .modal-large { /* new custom width */ width: 750px; } } (or any other width you need) and in includes/modules/content/footer/templates/popup.php change <div class="modal-dialog"> to: <div class="modal-dialog modal-large"> J.J.
  8. This phenomenon appears, when you set in admin -> configuration -> sessions -> Force Cookie Use to true. Change Force Cookie Use to false! J.J.
  9. Hi, to fix the error messages try this in admin/orders.php: case 'update_order': $oID = tep_db_prepare_input($_GET['oID']); $status = tep_db_prepare_input($_POST['status']); $comments = tep_db_prepare_input($_POST['comments']); $order_updated = false; $check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased, pdf_invoice from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'"); $check_status = tep_db_fetch_array($check_status_query); if ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) { tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'"); $customer_notified = '0'; $invoice_sent = '0'; if (isset($_POST['notify']) && ($_POST['notify'] == 'on')) { $notify_comments = ''; if (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on')) { $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n"; } $link = EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n"; $email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . $link . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); if(tep_not_null($check_status['pdf_invoice']) && isset($_POST['notify_invoice']) && ($_POST['notify_invoice'] == 'on')) { $file = SAVE_FOLDER . $check_status['pdf_invoice']; $filename = $check_status['pdf_invoice']; $filetype = 'application/pdf'; $invoice_sent = '1'; tep_mail_pdf_attach($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, $file, $filename, $filetype); }else{ tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } $customer_notified = '1'; } tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments, invoice_sent) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments) . "', '" . tep_db_input($invoice_sent) . "')"); $order_updated = true; } And no, changes made in invoice editor are NOT stored in table 'orders' (and related tables). The tool is an INVOICE editor, not an ORDER editor. In the install.txt is clearly stated: "In contrast to the Order Editor, the tool does not affect the table 'orders' (and related tables), since it works with temporary copies of the original order." If you want to change orders, use the order editor! J.J.
  10. @@Gergely Thanks for the suggestion. I should really take the attributes into the product list. I'll do that! J.J.
  11. Support Thread for the Cancellation form for 2.3.4 and bootstrap-gold Download: http://addons.oscommerce.com/info/9136 Provides a cancellation form that meets the requirements of the EU Directive 2014 on consumer rights. Includes an automatically generated confirmation email to the consumer and an email notification to the shop owner and a print form function. Registered customers can easily select from a pull-down menu that lists all orders of the last 30 days, the order for which they wish to exercise their right of cancellation. To prevent abuse, the sending of the cancellation form in the Action Recorder is recorded. Versions for Osc 2.3.4 and bootstrap-gold available. Please report any problems here. J.J.
  12. pffffffffffffff - a lot of questions......... 1) yes! 2) invoice.sql has the same content as invoice_en.sql, but in German! 3) Look into your DB. If the column orders_date_finished is empty or NULL, then must must do nothing. If it contains any dates do as is described in the install.txt. 4) Did you create a pdf invoice? If yes, is it stored in the folder testshop/admin/invoices/? If yes, can you open it (e.g. button View Invoice)? 5) Use the $order_query from SPPC and simply add to the query the two entries num_invoice and pdf_invoice which are needed for the invoice editor. J.J.
  13. Hi Ralf instead of the new_tables.sql simply use the following sql which bypasses all problems with changed order_ tables: drop table if exists invoice_orders; create table invoice_orders LIKE orders; drop table if exists invoice_orders_products; create table invoice_orders_products LIKE orders_products; drop table if exists invoice_orders_products_attributes; create table invoice_orders_products_attributes LIKE orders_products_attributes; drop table if exists invoice_orders_products_download; create table invoice_orders_products_download LIKE orders_products_download; drop table if exists invoice_orders_total; create table invoice_orders_total LIKE orders_total; J.J. NS. There's already a thread for Invoice Editor. It would be nice if you would use it for further questions on this tool.
  14. Hi John Yes the popup should be displayed only once when a customer for the first time enters the shop. It would be annoying if the message would pop up on every page load or refresh! :x If you have stored different popups activate the one you want to be displayed by clicking the green button on the popup overview page. Only one popup can be active. J.J.
  15. Popup status is needed for the schedule and expire function. I found when changing to SSL (e.g. Login) the popup appears in certain browsers again and then it's impossible to login. :wacko: So I disabled the popup in SSL. J.J.
  16. New version uploaded with the changes proposed by multimixer - now no more files must be changed: Upload it to your shop, install it in your admin - done! Many thanks to multimixer for the right tip! (w00t) J.J.
  17. One never stops learning! (w00t) Thank you for that. J.J.
  18. Support Thread for the new content module Modal Info Popup Layer for osCommerce 2.3.4BS Note: This content Module is for the bootstrap version of oscommerce 2.3.4 only! Download Link: http://addons.oscommerce.com/info/9204 If you want your customers to take note of certain informations, there is one way to make them aware by using a popup window or a layer. This contrib uses a bootstrap modal for this purpose. When a customer enters the shop the first time, a info popup layer is once laid over the page - regardless on which site the customer enters the shop. The individual messages can be created via a pop-up manager as plain text, html-text and/or graphics in the admin area.There you can also specify a start and an expiration date for the display of messages. The add-on is designed as content module, which means that no changes to core files (in the frontend) are neccessary. Only in the admin area two files (admin\includes\boxes\tools.php and admin\includes\languages\english.php) must be changed to add a new entry to the tools box. Tested with bootstrap-gold and FF 35, Google Chrome 37.0.2062.124, Opera 26.0 and IE 8. Please report any problems here. J.J.
  19. @@Tsimi Hi Lambros Yes, you are right - apart from the conversion in BS, there is no big difference to standard Osc. The only (for me) something difficult enhancement was the conversion of the Ajax price update contrib, so that also prices of slaves are automatically updated.when the customer selects options. And yes, in that form it is commercial. But if I find the time, I will build it up again into an unmodified BS shop - without the gimmicks - and upload to the addon area. :D But for that I need to familiarize myself with the gold version. J.J.
  20. Ah! ça ira - as you can see here. (w00t)
  21. Hi, just tested it on your demo site. I have logged in with a Google account. Works flawlessly! But: In this Google account, only my email address is stored. After login with the tool I can go through the checkout process without having my name and my address stored somewhere. What does a shop owner do when an order comes in, where he has only an email address of the customer? Wouldn't it be better to add a routine to the tool, which verifies that all address details required for an order are available and if necessary ask customers to complement them? J.J.
  22. @@benwijns And if you create a pdf invoice (button 'Invoice PDF' in edit_invoice or if you display a single order) - is the num_invoice stored properly in table orders?
  23. @@benwijns I installed this contrib in several shops (2.2.MS2, 2.3.1. 2.34 and 2.3.4BS) and it works fine with any of these osc versions. So, there's NO bug. If it does not work for you, you made a mistake during installation. I guess that either the column "num_invoice" in table "orders" does not exist, or the invoice number is not correctly written into this column. Then you can not save the invoice and if the invoice is not saved, you can not attach it to a message. Is the file admin\includes\functions\invoice_num.php in place? J.J.
  24. Thanks for the note! I forgot to mention that. :blush: :-
×
×
  • Create New...