Jump to content
Latest News: (loading..)


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. jimlongo

    Pay what you want pricing

    That's a great sounding way to handle these transactions. If I could issue credits that could be used in the course of a purchase that would handle most of these cases. Is there such a module?
  2. jimlongo

    Pay what you want pricing

    A sad fact of doing business indeed. We (a tennis club) have dozens of lesson programs of various prices. Customers regularly want to switch lessons they've paid for. That creates either a balance owing or a credit on their account. They need a way to pay the balance. Currently I get their CC information and enter it manually into our payment processor. I guess you're suggesting I don't allow them to switch lessons? That's a board decision, not mine. And it's not pennies, it's amounts up to hundreds of dollars and cents. PayPal sounds interesting, but we don't use it. I'm just trying to avoid the manual entry. Currently I have a product called "balance owing" and I change the price for the use case at hand. That's usually okay as this doesn't happen that often (and I could always create more than 1 of this "product"), but a text field for amount entry would allow the customer to pay $xx.xx for the balance owing on their account. Yes, they are notified they owe a balance. They need to pay it. I'm trying to make it easier for both of us. We don't ship any products, they are all virtual.
  3. jimlongo

    Pay what you want pricing

    Is there any support for, or addons that would enable a product with a variable price. That is a text input so the person could pay whatever amount they want. I often have customers who for one reason or another owe me a balance on some transactions. The amount always varies. Normally I have to send them a form so they can send me credit card details and I manually go to my Merchant account and charge the CC the amount owing . . . total pita. So what I'd like is a catalog item with a text input as a price, they could enter whatever that balance owing amount is.
  4. What my company has done in our API is to (simplified) encrypt all data fields such as name, address, email (anything identifiable) on the way into the db, and decrypt it whenever it comes out. So you never store anything in your db unencrypted. Makes it harder for searches from your app, but there you go. You don't need to delete data ever.
  5. Order Editor is the thing I want the most. Otherwise the backend is not really useful for reporting purposes. Outside of that I have so many custom additions to my store that updating is a nightmare. I have the concept of family accounts, with members inside that account, and items are purchased for the members in the account. Think "sports club". This has to touch so many files you literally have to search and replace dozens if not hundreds of files. Anyway I doubt this is very important to anyone, BUT if there was some system more like the WordPress "child" system where you could write your own functions and templates that hooked into the core, then of course this enables the core to be continually updated without damaging your theme. To me that is the only way to win. Non-update-ability is the road to getting hacked, and a platform that is easily hacked is not going to be extremely popular.
  6. jimlongo

    Upgrading to the latest version

    I've used Foundation quite a bit, but not Bootstrap. Can I install any version of Bootstrap into /ext/bootstrap? I want to use Less or Sass for my css. I'm thinking I can drop in a version of Bootstrap, install the appropriate components and make with npm to do this. Does that sound right? Thanks for any advice.
  7. As I said the database index you suggested adding only affects the Orders dashboard box, nothing to do with AOH.
  8. It has something to do with this query around line 40 in /admin/includes/modules/dashboard/d_orders.php $orders_query = tep_db_query("select o.orders_id, o.customers_name, greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modified, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by date_last_modified desc limit 14"); If I change it to take out the "greatest" function in the select section it is okay. $orders_query = tep_db_query("select o.orders_id, o.customers_name, o.date_purchased as date_last_modified, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by date_last_modified desc limit 14");
  9. Yes it is strange. It of course doesn't affect the database dates. And the Orders page is okay, it's only the Orders box on the admin front page. And every time I refresh the page there are different orders in the box, all dated 11-30-2036 . . . hmmmm
  10. Create Order - create_order.php in v2 PHP Fatal error: Call to undefined method mysqli_result::fetch_all() in /admin/create_order.php on line 89
  11. Hi, I'm back after i spent some time with getting it working properly with my mods before attempting yours again. For the most part it is working with your v2, except for a few things I will note below. First in the updates since v2 there seem to be a couple little things . . . Post #40 I believe has an extra } at the end which causes an error with the javascript. (error is an expected token ')' missing) Also the 2 SQL statements in #53, the second one really messes up my orders, changes order dates to 2036 Now to the few bugs I'm noticing. 1. If I open an order in the Quick Order Editor, then select a field like a price, the Enter New Value window opens. At this point I cannot enter a value (cannot select inside the input field). Now select OK or close the Enter New Value box, BUT NOW I can't close the Quick Order Editor window. The only way out is to refresh the browser. 2. If I edit an order and change a price of any item the Total goes to ZERO. Thanks again for all your hard work on this.
  12. Thank you that fixed the graphs issue. They are displaying now.
  13. I am also getting no action on delete or changes, etc., When I do as you requested on an edit to my product model# I get the url -> https://register.mydomain.com/admin/orders_ajax.php?action=update_product&pID=&order=4352&field=products_model&new_value=CT.1Mk On clicking the Delete icon I get -> https://register.mydomain.com/admin/orders_ajax.php?action=eliminate&pID=&order=4352&new_value=0 However, if I click the Delete button at the top of the page, I get a window which when I click Delete actually deletes the order. On clicking the Duplicate Order button in the top row I get the following url -> https://register.mydomain.com/admin/ajax_handler.php?page=1&get_order=4352&cID=&action=duplicate_order And the notification I get is -> Error: Not a Numeric Customer ID
  14. I've uploaded everything now. The graphs are not displaying. In case it was any modifications I've done to those 2 files d_total_revenue.php and d_total_customers.php I uploaded fresh copies from the package. Error: Time mode requires the flot.time plugin. ReferenceError: Can't find variable: goonload osCommerce PHP 5.4.27