Guest Posted October 25, 2002 Share Posted October 25, 2002 Here's the deal, I'm using the August "loaded" snapshot of Ian's. It is set-up as follows: Table Shipping Rate, Based on Price, no handling fee: 0:0,1.00-9.99:4.50,10.00-19.99:6.00,20.00-29.99:7.50, 30.00-39.99:9.00,40.00-49.99:10.50,50.00-10000:12.00 Order Total Set-up: Discount Coupon (active) sort order: 599, include shipping: false Gift Vouchers (active) sort order: 299, include shipping: false Low Order Fee (inactive) Shipping (active), display shipping:true, sort order:899, free shipping: false Sub Total (active) sort order:150 Tax (inactive) Total (active) sort order:999 Members Discount (active) sort order:399, include shipping: false Gift Voucher set for immediate delivery. Coupon Name :: coupon test Coupon Amount :: 10% Start Date :: 10/22/2002 End Date :: 12/31/2003 Uses per Coupon :: 0 Uses per Customer :: 0 Number Used :: 1 Valid Product List :: NONE Valid Categories List :: NONE Date Created :: 10/24/2002 Date Modified :: 10/24/2002 With the coupon set this way it should be able to be used multiple times by the same customer, correct? So, using this set-up, I place a test as customer Testy Testor with "members discount" active on the account. Earlier I purchased a $10 GV that I am going to use along with the test coupon. I buy 1 item, a DVD movie. Here is the result: ------------------------------------------------------ 1 x A Bug's Life (DVD-ABUG) = $35.99 ------------------------------------------------------ Sub-Total: $35.99 Gift Vouchers: $10.00 Members Discount: $2.60 Best Way: $10.50 Total: $33.89 There are a couple of problems. The first is the discount coupon was not used and I did not receive an error that the code was wrong, it was, expired, etc. I realize this scenario is not like to happen but, it still needs to be addressed. Next is the shipping charge. According to the Table Rate it should be $9.00. It appears the program is adding the GV to the merchandise and charging on $45.99 total. So, I thought perhaps the Shipping needs to be re-ordered. I changed the shipping to the 199 position and still had the same problem. ------------------------------------------------------ 1 x A Bug's Life (DVD-ABUG) = $35.99 ------------------------------------------------------ Sub-Total: $35.99 Best Way: $10.50 Gift Vouchers: $10.00 Members Discount: $2.60 Total: $33.89 What do I do now???? Link to comment Share on other sites More sharing options...
Ian Posted October 25, 2002 Share Posted October 25, 2002 First the shipping problem, this is quite easily fixed. email me [email protected] and i'll send you some update files for the table rate method. The other one is unusual. Which version of the discount coupon are you using. When you entered the coupon code at checkout did you receive a message that it had been redeemed. Did you make sure you entered it in the redeem Coupon box and not the redeem Gift Voucher box Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
Guest Posted October 25, 2002 Share Posted October 25, 2002 Hi Ian, I used Discount Coupon V0.94. Yes, double checked to make sure that I had put the coupon number in the correct box. You can see the set-up at: http://www.bird-e-toys.com/osc/catalog/default.php If you decide to try the process, email me at [email protected] and I'll set you as a "member". Link to comment Share on other sites More sharing options...
Guest Posted October 25, 2002 Share Posted October 25, 2002 Well...the shipping fix has fixed the missing coupon problem and I still have a shipping problem. I have not made any changes in the set-up since my earlier post. The only change made was to apply the updated files in the catalog. ------------------------------------------------------ 1 x The Replacement Killers (DVD-RPMK) = $42.00 ------------------------------------------------------ Sub-Total: $42.00 Best Way: $12.00 Members Discount: $4.20 Total: $49.80 Shipping should be $10.50 ------------------------------------------------------ 1 x The Matrix (DVD-MATR) = $30.00 ------------------------------------------------------ Sub-Total: $30.00 Best Way: $9.00 Members Discount: $3.00 Discount Coupon: $2.70 Total: $33.30 This one is actually correct...???????? ------------------------------------------------------ 1 x Courage Under Fire (DVD-CUFI) = $29.99 ------------------------------------------------------ Sub-Total: $29.99 Best Way: $9.00 Discount Coupon: $3.00 Total: $35.99 This one is wrong...should be $7.50 Products ------------------------------------------------------ 1 x The Matrix (DVD-MATR) = $30.00 ------------------------------------------------------ Sub-Total: $30.00 Best Way: $9.00 Gift Vouchers: $30.00 Total: $9.00 This one is right again...I'm sure I'm going crazy!!! Products ------------------------------------------------------ 1 x The Replacement Killers (DVD-RPMK) = $42.00 ------------------------------------------------------ Sub-Total: $42.00 Best Way: $12.00 Gift Vouchers: $10.00 Members Discount: $3.20 Discount Coupon: $2.88 Total: $37.92 ...and of course, the shipping on this one is off again. Hopefully someone will see a pattern in the errors that will help us figure this one out.... :D Link to comment Share on other sites More sharing options...
Ian Posted October 29, 2002 Share Posted October 29, 2002 Kim, Have you resolved this yet. I think the problem is that the shipping cost is being calculated at a different point than you expect. As a matter of interest, for the examples above, what price do you want shipping calculated on? Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
Ian Posted October 29, 2002 Share Posted October 29, 2002 Oh, and don't take this the wrong way but in your first post, the table rates you give are not formatted properly Table Shipping Rate, Based on Price, no handling fee: 0:0,1.00-9.99:4.50,10.00-19.99:6.00,20.00-29.99:7.50, 30.00-39.99:9.00,40.00-49.99:10.50,50.00-10000:12.00 you seem to be using a mixture of - and : and , Is this really how you have entered it in admin. If not could you post exactly how it is entered. Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
Guest Posted October 29, 2002 Share Posted October 29, 2002 Hi Ian! No, It isn't fixed yet....Please explain how the shipping table should be formatted. The above example is cut and pasted from the admin. I am looking for the program to calculate the shipping on the subtotal (merchandise total before any credits or discounts). Link to comment Share on other sites More sharing options...
Ian Posted October 29, 2002 Share Posted October 29, 2002 Kim, Table Shipping Rate, Based on Price, no handling fee: 0:0,1.00-9.99:4.50,10.00-19.99:6.00,20.00-29.99:7.50, 30.00-39.99:9.00,40.00-49.99:10.50,50.00-10000:12.00 I think should be the following 0:0,9.99:4.50,19.99:6.00,29.99:7.50,39.99:9.00,49.99:10.50,10000:12 Note you just have to put the break point in, and not the range. HTH Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
Guest Posted October 29, 2002 Share Posted October 29, 2002 YIPPEE!!! The wrong format was the problem with the incorrect shipping amounts. Thank you!!! There is one other small problem...on the checkout_payment.php Link to comment Share on other sites More sharing options...
Guest Posted October 29, 2002 Share Posted October 29, 2002 Oooops...Here's the URL so you can look... http://www.bird-e-toys.com/osc/catalog/default.php Link to comment Share on other sites More sharing options...
Ian Posted October 30, 2002 Share Posted October 30, 2002 Kim, Sounds like I left a line of debug code in. Try searching /includes/modules/order_total/ot_gv.php for echo statements and remove the offending line. Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.