Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

thor101

Archived
  • Posts

    8
  • Joined

  • Last visited

Profile Information

  • Real Name
    B T

thor101's Achievements

  1. This is a followup to my earlier post about the problem I am having on my order total page. The following should be self explanatory. I went diving into my database: mysql> select title,text,value,class,sort_order from orders_total where orders_id={MY_ORDER_NUM}; +------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------------------+------------+ | title | text | value | class | sort_order | +------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------------------+------------+ | Discount Coupon CD2007 applied: | -$7.40 <!-- Discount Coupons DEBUG order Object ( [info] => Array ( [order_status] => 2 [currency] => USD [currency_value] => 1.00000000 [payment_method] => Authorize.net AIM [cc_typ | -7.4000 | ot_discount_coupon | 1 | | Sub-Total: | $66.60 | 66.6000 | ot_subtotal | 3 | | VA TAX 5.0%: | $3.33 | 3.3300 | ot_tax | 5 | | Free Shipping (For orders of $0.00 or more. ): | $0.00 | 0.0000 | ot_shipping | 8 | | Total: | <b>$69.93</b> | 69.9300 | ot_total | 10 | +------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------------------+------------+ 5 rows in set (0.00 sec) As you can see, it looks as if the debug stuff got inserted into the database. WHOO WHOO!! I'm going to go try to extract it. update orders_total set text='-$7.40' where orders_total_id=809 The line above fixed the problem. I'll have to wait until I get another customer to see if this fixes it for good. I'm guessing the only reason it got stuffed in there was because I was in debug mode. *SHRUG* I'm just happy to be able to edit my invoices again! --Brett
  2. I've been trying to debug this on my own, but the data appears to be stuck inside an array somewhere. I found my bug after I upgraded to 3.3 I couldn't edit invoices anymore (change the status). I went from 2.1 to 3.3 (so maybe I fudged something). I turned on debug mode to test. I thought I turned it off, but... The first customer (after upgrade) came rolling through and completed a transaction. Now when I look at the order on the orders.php page (in edit mode) I get this: <--snip--> PRODUCT TABLE (tax, price, price, total, total) 2308 5% $18.00 $18.00 $18.00 $18.00 Discount Coupon C007 applied: -$7.40 [INVOICE BUTTON]..... <--snip--> Notice how it doesn't have more of the subtotal in there. Just the coupon then straight to the invoice button. It also skips over letting me edit comments, and changing the status of the order. So I looked at the source code of the page: <td class="smallText" align="right">Discount Coupon C007 applied:</td> <td class="smallText" align="right">-$7.40 <!-- Discount Coupons DEBUG order Object ( [info] => Array ( [order_status] => 2 [currency] => USD [currency_value] => 1.00000000 [payment_method] => Authorize.net AIM [cc_typ</td> </tr> <tr> <td align="right" class="smallText">Sub-Total:</td> <td align="right" class="smallText">$66.60</td> </tr> <tr> There is this strange HTML comment in there about debug mode, which essentially omits most of the rest of the page until it gets to a full set of comments below, at which point the unbalanced comments are cleared. I am no longer in debug mode (I even switched into it, and out of it, to make sure that I was out of it). So is this stuck in my database now that I have to go edit? Cheers! --Brett P.S. On a completely different note. Any thought of creating a new Topic for 3.3? I tried to download the entire topic so I could search for this problem, but it doesn't download the whole thing, just a small chunk of it. Just a thought.
  3. Excellent diagnosis, and excellent code. I upgraded from 2.1 striaght to 3.3. I had all of the update instructions available, so when it said to replace A with B, and then another version said to replace B with C, I just went from A to C. It took a bit to get it all straight in my head, but once I started updating code it went REALLY smoothly. Thanks for the great code, oh, and the fixed discounts work GREAT! Thanks for the module. --Brett
  4. If this is somewhere in the 76 pages of posts, let me know and I'll go hunt it down. My goal is to offer 50 & 100 $ gift cards. I thought I could do this by offering a fixed discount (50) on a min value of 50 and a max value of 50. The problem is that depending on the final value I get results of a discount (credit) of anything from 45 to other odd amounts. The problem amplifies with the 100 credit as well. 100 discount comes up as $92 discount Is this part of the rounding issue? Are you going to tell me that I should use the CCGV module? Thanks much! --Brett
  5. Hello, I installed the import a while ago, and just got my first order. YAY! Then I got the dreaded, transaction not in balance. Once I figured out that I didn't have the shipping setup correctly, and then I had to create an account for discounts. So that was cool. But then I still got that error. So I opened it up in a spreadsheet, and it had negatives for the revenue (product and shipping) and as well as the discount coupon. So I multiplied all the places where I saw the amount for the discount by -1 and then it imported correctly. So I suppose I could do this for all of my discounts as I don't have very many of them, but I am wondering if I setup something incorrectly. For discounts, I am using ot_discount_coupon_codes_2.1 Thanks much. --Brett
  6. Hello, I installed the import a while ago, and just got my first order. YAY! Then I got the dreaded, transaction not in balance. Once I figured out that I didn't have the shipping setup correctly, and then I had to create an account for discounts. So that was cool. But then I still got that error. So I opened it up in a spreadsheet, and it had negatives for the revenue (product and shipping) and as well as the discount coupon. So I multiplied all the places where I saw the amount for the discount by -1 and then it imported correctly. So I suppose I could do this for all of my discounts as I don't have very many of them, but I am wondering if I setup something incorrectly. For discounts, I am using ot_discount_coupon_codes_2.1 Thanks much. --Brett
  7. There is a bug with the free amount. It could be other modules having an effect on it. Don't know, but I did find a hack to fix it. Problem.. When Free Amount, UPS and USPS are all enabled and displayed in that order. If you qualify for free shipping, no problem, all is good. If you don't qualify for free shipping, you get this: This is currently the only shipping method available to use on this order. Free shipping on orders over $75.00 United States Postal Service (1 x 8lbs) United States Postal Service Priority (2 - 3 Days) $8.75 () <-Radio Button ------------------ You also don't get the arrow that says, "Hey pick one" ---------HACK TO FIX------- Don't display free amount as the first item. This way, if they do or don't qualify, all the shipping options show up correctly. Kind of a bummer that it gets buried in with the rest of the options, but oh well. Please select the preferred shipping method to use on this order. Please Select United States Postal Service (1 x 8lbs) United States Postal Service Priority (2 - 3 Days) $8.75 Free shipping on orders over $75.00 I don't have a fix, just the hack. Thanks for the contrib, back to my customization. 7 days to grand opening. Then thankfully, I won't find any more bugs. Ha ha ha.
×
×
  • Create New...