Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

betagirl

Archived
  • Posts

    16
  • Joined

  • Last visited

Profile Information

  • Real Name
    MLR

betagirl's Achievements

  1. Hello - I'm not sure if this is obvious and I've just not sorted it out, or if it cannot be done. My client charges a flat rate for shipping (ground), and an additional handling charge to all shipments to the contiguous 48 US states. They would like to charge twice that same flat rate to shipments to Alaska and Hawaii (air). Is there a way to configure the flat rate shipping options to have two rates like this? Thanks in advance for any tips!
  2. Hello Nmouns - It sounds like you're having the same problem I was having. First, make sure you've installed the Gift Voucher module in your admin --> Modules --> Order Total. Even if you don't intend to use gift vouchers, this has to be installed in order for the math to work (I don't know why). Here's my client's configuration (they similarly don't want to allow a discount on shipping): Display Total: true Sort Order: 2 Include Shipping: False Include Tax: False Re-calculate tax: Standard My sort settings are as follows: Sub-total: 1 Discount Coupons: 2 (this way, the discount will only get applied against the sub total of products) Shipping: 3 Tax: 600 Gift Vouchers: 740 Total: 900 With this configuration, the discount gets applied against the product subtotal; tax gets applied to the new (post-discount) subtotal plus full shipping charges (my client taxes shipping and handling). I don't know if this is how yours should function, but you get the idea. Hopefully, this will be helpful to you. Cheers, M
  3. Samppa - Thank you so much for this tip. You are correct - it seems Gift Voucher has to be installed whether is it utilized or not. I installed it, and now I'm able to use both types of coupons (flat rate and percentage based) under a single configuration, and the math works. Vger - as suggested by Samppa, installing the Gift Voucher module should probably be specified as required in your installation documentation, in case others encounter similar problems. Thanks again for the great contribution Vger, and for your help finding a solution to the problem I had with it Samppa!
  4. Hello Vger - I am not trying to use two different types of coupons at the same time. I understand that they are separate. The problem I am encountering, is specifically, that one module configuration will not work for both types. For example, if I have Modules-->Order Total-->Discount Coupons configured as: Display Total true Sort Order 2 Include Shipping false Include Tax true Re-calculate Tax Standard Tax Class Taxable Goods When I create a flat rate coupon (say, $20 off), everything works great. However, if I then try to create a percentage based coupon (say, 10% off) - the totals do not add up, as per my prior example. I am not trying to make both coupons work at the same time. I am trying to make separate coupons work under the same module configuration. And they don't seem to. For percentage based coupons to work, the configuration has to be this: Display Total true Sort Order 2 Include Shipping false Include Tax false Re-calculate Tax Standard Tax Class Taxable Goods Arguably, my work around is to change the configuration each time the client creates a new coupon. However this also limits their ability to offer different types of coupons to different customers at the same time, as both will not work under one configuration. I admit, it does not seem like most people encounter this problem, which is why I can't understand it myself. And I have thoroughly reviewed this board, the install and manual instructions, as well as searching the other CCGV forum in the event it has something to do not with your version, but with the original. Additionally, I have resorted and reconfigured for every possible combination of sort/configuration - to no avail. I'm not looking for a shortcut or for you to install and configure this for me, I always post as a last resort, once I've exhausted all my options. This is legitimately a problem I am encountering for which there is no clear solution in the install instructions or manual, or that I have otherwise been able to discern. The only variable I see, and I'm not sure if it is related to what samppa65 was talking about, is that I do not have the Gift Voucher module installed in the Order Totals section, as my client does not intend to use it. Now I don't know why that would make a difference here, but I'm throwing it out there in case it makes some sort of sense to you. I will go ahead and install it and again resort/reconfigure and see if that does indeed solve the problem. Thanks again for this contribution and any light you might be able to shed beyond the research I've already done.
  5. I don't mean to duplicate this post - but I think I first posted it in the general Contribution Support forum, and I meant to post it specifically here.... here it is (again) Hello - Thank you so much for the time and effort on this contrib - I was really dreading implementing the current CCGV until I found yours! I am having a problem with the configuration however. I can get the discount coupons module working fine if the coupon is a flat amount (e.g. $25 off), but if I try to have a percentage off coupon (e.g. 25%) - the totals don't add up or calculate correctly. Now I can get the % coupons to work too, but when they work, a flat rate coupon won't calculate totals correctly. And I can imagine situations where my client would offer different coupons to different customers, etc., and I assume they should work together anyway. The difference, in making each type of coupon work, is in how the coupon module is configured. Note, I do not have Gift Vouchers installed in the admin modules order totals section, as this won't be used by my client. I do not think this is causing the problem or is related, but please advise if it does, for some reason, need to be installed whether it is utilized or not. The store is setup so that shipping & handling charges are taxed, without any discounts being applied. Sales tax is set at 7.75%. The sort order (the only one that works for both flat rate coupons and percentage based coupons) is: Subtotal (1) Coupons (2) Shipping (3) Tax (800) Total (900) The coupons module configurations are below, where the only changes are with whether or not the Include Tax option is set to "True" or "False". The Recalculate Tax is always set to "Standard". ########### FALSE Shipping / TRUE Tax: Flat Rate Coupon *Correct Amounts* Sub-Total: $399.99 Discount Coupons:Test123: -$25.00 Flat Rate S&H (Shipping to California, United States ): $23.95 California sales tax: $30.92 COD (Cash on Delivery) Fee: $14.00 Total: $443.86 FALSE Shipping / TRUE Tax: Percentage Coupon *Incorrect* Sub-Total: $399.99 Discount Coupons:Test223: -$107.75 //Incorrect - s/b just 100.00 - 25% of 399.99 Flat Rate S&H (Shipping to California, United States ): $23.95 California sales tax: $25.11 COD (Cash on Delivery) Fee: $14.00 Total: $355.30 ############## FALSE shipping / FALSE Tax: Flat Rate Coupon *Incorrect* Sub-Total: $399.99 Discount Coupons:Test123: -$25.00 Flat Rate S&H (Shipping to California, United States ): $23.95 California sales tax: $30.76 //Incorrect Tax Amount s/b $30.92 COD (Cash on Delivery) Fee: $14.00 Total: $443.70 FALSE shipping / FALSE Tax: Percentage Coupon *Correct Amounts* Sub-Total: $399.99 Discount Coupons:Test223: -$100.00 Flat Rate S&H (Shipping to California, United States ): $23.95 California sales tax: $25.11 COD (Cash on Delivery) Fee: $14.00 Total: $363.05 ########### Does anyone have any tips on how to set this up so that I don't have to change the module configuration each time a different type of coupon is created; and so that we can use multiple coupons concurrently (some percentage based, some flat rate). I have spent more than about 5 hours trying to sort this out to no avail - trying all manner of combinations of configuration and sort orders. I appreciate any tips.
  6. Hello - Thank you so much for the time and effort on this contrib - I was really dreading implementing the current CCGV until I found yours! I am having a problem with the configuration however. I can get the discount coupons module working fine if the coupon is a flat amount (e.g. $25 off), but if I try to have a percentage off coupon (e.g. 25%) - the totals don't add up or calculate correctly. Now I can get the % coupons to work too, but when they work, a flat rate coupon won't calculate totals correctly. And I can imagine situations where my client would offer different coupons to different customers, etc., and I assume they should work together anyway. The difference, in making each type of coupon work, is in how the coupon module is configured. Note, I do not have Gift Vouchers installed in the admin modules order totals section, as this won't be used by my client. I do not think this is causing the problem or is related, but please advise if it does, for some reason, need to be installed whether it is utilized or not. The store is setup so that shipping & handling charges are taxed, without any discounts being applied. Sales tax is set at 7.75%. The sort order (the only one that works for both flat rate coupons and percentage based coupons) is: Subtotal (1) Coupons (2) Shipping (3) Tax (800) Total (900) The coupons module configurations are below, where the only changes are with whether or not the Include Tax option is set to "True" or "False". The Recalculate Tax is always set to "Standard". ########### FALSE Shipping / TRUE Tax: Flat Rate Coupon *Correct Amounts* Sub-Total: $399.99 Discount Coupons:Test123: -$25.00 Flat Rate S&H (Shipping to California, United States ): $23.95 California sales tax: $30.92 COD (Cash on Delivery) Fee: $14.00 Total: $443.86 FALSE Shipping / TRUE Tax: Percentage Coupon *Incorrect* Sub-Total: $399.99 Discount Coupons:Test223: -$107.75 //Incorrect - s/b just 100.00 - 25% of 399.99 Flat Rate S&H (Shipping to California, United States ): $23.95 California sales tax: $25.11 COD (Cash on Delivery) Fee: $14.00 Total: $355.30 ############## FALSE shipping / FALSE Tax: Flat Rate Coupon *Incorrect* Sub-Total: $399.99 Discount Coupons:Test123: -$25.00 Flat Rate S&H (Shipping to California, United States ): $23.95 California sales tax: $30.76 //Incorrect Tax Amount s/b $30.92 COD (Cash on Delivery) Fee: $14.00 Total: $443.70 FALSE shipping / FALSE Tax: Percentage Coupon *Correct Amounts* Sub-Total: $399.99 Discount Coupons:Test223: -$100.00 Flat Rate S&H (Shipping to California, United States ): $23.95 California sales tax: $25.11 COD (Cash on Delivery) Fee: $14.00 Total: $363.05 ########### Does anyone have any tips on how to set this up so that I don't have to change the module configuration each time a different type of coupon is created; and so that we can use multiple coupons concurrently (some percentage based, some flat rate). I have spent more than about 5 hours trying to sort this out to no avail - trying all manner of combinations of configuration and sort orders. I appreciate any tips.
  7. Hello - I've tried implementing this xsell addon, but the products selected to be cross sold are not getting into the database. I've double checked all the code, and implemented the code recommended above. I get the multi select dropdown list in the edit UI, but after selecting one or more products, hitting "preview" and then "update" - nothing. No changes to the products_xsell db are made. Am I missing something? Thanks for your help!
  8. Got it sorted out. I think what was happening was that whenever I went to "edit" a sale, the categories selected were ereased, so I would change the type of sale but wasn't reselecting the categories affected. Thus nothing was showing up in the catalog as being on sale. D'oh.
  9. I'm having the exact same problem. Everything installed fine, but the sale is not showing up in the catalog. Anyone have any ideas? Regarding this issue: I installed the update to the contribution that essentially just updates the SQL table - located here: http://www.oscommerce.com/community/contri...earch,salemaker dated 2/14/05 Hope that bit helps you out, if you haven't already gotten this sorted.
  10. Hi Steve - Thanks so much for getting back to me so quickly. Just now getting back to this issue myself as I was out of town. Your link to the osCommerce docs was right on track - I had posted the wrong file in the wrong directory. D'oh!! Good lesson learned. Again, love your contribution - is working great!
  11. Hi Steve - I've installed the most recent version of your contrib (it's fab btw) but I am having a problem - and I'm not entirely sure it's because of this contrib, but I've only installed a few others, and I went back and double-checked which pages were modified, and there are no apparent conflicts. Here's what's happening - everything works great with a user creating an account, etc. however, when logged in and attempting to acces the "My Account --> View or change entries in my address book" link, I get the following error: Fatal error: Cannot redeclare tep_db_connect() (previously declared in /usr/local/apache/htdocs/catalog/includes/functions/database.php:13) in /usr/local/apache/htdocs/catalog/includes/functions/database.php on line 13 I've read all posts re: your mod, and have not seen this issue pop up for anyone else, but thought you might have some insight on it anyway. Is this related? Any suggestions? I appreciate your contribution, and any light you might be able to shine on this issue.
×
×
  • Create New...