Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

HELP! GV & discount Coupons & Members Discount &


Guest

Recommended Posts

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

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

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

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

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

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

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...