Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

spencerb

Pioneers
  • Posts

    60
  • Joined

  • Last visited

Everything posted by spencerb

  1. Love this mod! For being such a powerful mod, it was very easy to install. FYI I use USPS Methods. I have some questions/suggestions: 1) I would like to disable the logged-in functionality. Basically I want it to function like the guest cart even when logged in. I like the simplicity of the estimator with just the zip code entered. When logged in, you can select a shipping address from the book, but it doesn't save it through checkout. This might be confusing for customers. Also, the selection menu doesn't show the full address. You could have two addresses to the same city and zip and they look identical in the pull down. Since you only have to put in the zip once per session (and change it anytime you like), I don't see a need to pull address book entries. 2) Is there a way for it to show the zip code entered? If a customer puts in the wrong zip or forgets what zip they put in, there isn't a way to know. Along these lines, if you put in an invalid zip, nothing happens. 3) Where is the text for "Post Code"? I want to change it to "ZIP Code." I can probably figure this out, but couldn't find it at first. 4) I'll be taking out the text and menu for "Products quantity" and the country selector (I only ship to the US). I don't see a need for a visual total of items. The quantities are displayed in the cart contents. GREAT contribution! Any ideas on addressing any of my issues?
  2. Here's the deal. I made up an order total contribution that lets me set the shipping insurance fee for each product and it's added in the order total (see my contribution). Some of my products are rather expensive, and the customer gets a surprise fee at the end of checkout. I do rentals, so no insurance contribution that calculates based off the product's price will work, since the rental fee is nowhere near the value. That's why I set the insurance for each product. What I would like to do is to set the insurance fee per product and add it to the actual shipping charge (I use USPS Methods). That way the customer sees the shipping fee and it includes insurance. I don't want insurance to be visible as a separate line item in the total. It could be added as a handling fee per item. Anyone know how to accomplish this? I searched and couldn't find a solution. I thought about just adding the fee into the rental price, but that would make my prices appear noncompetitive (even though in the end it's all the same). My competitors add insurance into the shipping fee. Some of them have flat-rate shipping. Others add it in somehow, either as per-product or they just levelize it. Some of my products have very low insurance costs, and some are rather high.
  3. Here's the deal. I operate a rental site, and customers can check out and pay normally for any in-stock item for immediate shipping. I accept reservations if the customer needs the item in the future (say, a month from now). I have them send me an email so I can confirm if I will have it available. Once I confirm, I would like for the customer to be able to enter their CC info on the site and then I could charge/capture the payment at the time of shipment. Currently, I have to call the customer to get their card number and then I enter it manually in the a.net virtual terminal. I use manual order entry, so I won't know the total until I enter it, likewise, the customer won't know the exact total either, so I would email them the order reciept before capturing funds. So when they enter their card, I would like for it to just pass it on the a.net where I can charge it later. Here's the steps I'd like: Reservation confirmed via email Customer enters card details on site I enter order and send email for confirmation I go to a.net and charge the card. The only way I've thought of that will work would be to create a "product" that is a $5 or so reservation fee. They check out and it captures that $5, then later I could rebill in a.net for the full amount. I don't want to have a reservation fee, though, even it if applies to the rental. I can't think of any other way since I doubt a.net will record a $0 charge that is rebillable. One advantage to the way I'm doing it now is that I get the personal contact with customers via phone, but it is a hassle for me.
  4. Here is a revision to psylencer's fix you may need. There are three scripts in the order editor, and we need to exclude calling the individual shipping function from all three: Find (around line 32) in indvship.php: $shiptot = $cart->get_shiptotal(); Replace with: $currpage = $_SERVER['PHP_SELF']; if ($currpage == "/admin/edit_orders.php") { } elseif ($currpage == "/admin/edit_orders_ajax.php") { } elseif ($currpage == "/admin/edit_orders_add_product.php") { } else { $shiptot = $cart->get_shiptotal(); } I know many people have been having problems with Order Editor and Individual Shipping playing together, and this should get you going.
  5. There is a problem using Order Editor and the Individual Shipping contributions. I posted this thread seeking help: http://www.oscommerce.com/forums/index.php?sho...0&p=1201199 I never found a solution. It appears to be rather complicated and beyond my php expertise. If anyone finds a solution, please share it with me.
  6. I gave up. With hundreds of thousands of zip+4 codes, the amount of data is unmanageable. Too much to handle in one Excel file, and even MS Access runs out of memory on my computer just working with the data table. Not to mention all those records having to be put into the sql database. I could import, but what a mess! There are actually only 75 counties and 268 cities that have sales tax. I'm going to try and find a way for the customer to select their county, then select their city (or no city if out of city limits).
  7. That mod worked! Now I have two things to work through: 1) Arkansas customers must enter their zip+4 code. If they put in just the 5-digit zip, this mod goes all squirrely (it would work fine if all I had were 5-digit zips in the database). The simple way around this is to somehow force them to enter their zip+4 and provide a link to usps so they can find it. The better way is to use usps's api web tools that automatically verifies the zip+4. 2) How do I populate the online database with all 525,239 zip+4 tax records? Any suggestions on these two items?
  8. Look at what I found: http://www.oscommerce.com/community/contributions,1240/ The 2/4/08 update looks like what I need. I searched around before I posted and didn't see this until I dug deeper. I'll try installing it and see what happens. I'm wondering how I will get all 525,239 zip+4 codes into the database, and if it can handle all that data. I would also want a simple bit of code that forces Arkansas residents to enter a zip+4. It seems that the mod would just default to the 5-digit (or state default) rate if no +4 is given.
  9. Well, Arkansas has changed their sales tax code. As it is with some states, you now charge tax based on the ship-to destination. And it's not just the destination county. It's also the destination city, too. I can't just set up county zones, because there are multiple tax rates within a county (inside and outside of city limits). Five digit zip codes won't work either, since a zip code can span multiple counties and cities. The state publishes a table in MS Access format of tax rates for zip+4 codes. This table is loooong. There are 525,239 zip+4 codes in Arkansas. Of course, there aren't that many actual tax rates. Within a certain city there can be many zip+4 codes. You can now see my dilemma. One way would be for the customer to enter their normal 5-digit zip, and then a following page would force them to select their correct county and city. The database I have lists all the zips, rates, cities, and counties. The other way would be to force Arkansas residents to enter their zip+4 (with a link to the usps site to find it, or in a perfect world an auto-lookup based on the given address), then use that zip+4 to lookup the rate. I guess the easiest option would be to charge everybody the state tax rate, and I later calculate the city and county rates and just eat the cost difference. Any ideas or suggestions?
  10. If someone makes a partial payment for an item through the store (using the new a.net module), such as a deposit, how do you charge them for the remaining balance when the item is available? I could think of many scenarios when this could happen: A deposit is made on an item, with the full balance to be paid later. A reservation fee is taken for a rental item. A repeat customer calls you up and wants to order more products without going online. I know that we can't save the CC number on the server. I assume that we don't ever even see the full CC number. Can we go into the merchant interface and make additional charges in the future? Or do you have to call the customer for their CC number again, or have them go to the store and purchase an item set up specifically for them?
  11. This is the posted solution to fix the error undefined function get_shiptotal when using the order editor and individual shipping contribs. It doesn't work for me. Could you (or someone) explain the methodology of this solution?
  12. I got it all working, and I have uploaded it as a contribution. Hopefully my efforts can help someone in the future. Individual Product Order Total Fee http://www.oscommerce.com/community/contributions,5461
  13. The Individual Product Shipping was a bust. I tried to implement it as an order total module. I got it to install, but during checkout there were errors I just don't have the smarts to deal with. I gave it my best shot. So I guess I'm back to square one. I haven't found any relevant contribution. It seems like a rather simple mod, but I wouldn't really know. Any help would still be appreciated.
  14. I'm looking at the contribution Individual Product Shipping Prices to see if I can take the guts of it and make it an order total module. Instead of shipping prices, it would be insurance prices. I could manually calculate the insurance cost and enter it into each products' info. I think using an earlier and simpler version, such as 3.2, might be better. The installation instructions are poor; they don't tell you what to change. It just includes the files to drop into a fresh OSC install. I'll have to find the code to change and change all the variable and module names.
  15. Using the gross value won't work. I didn't know how it behaved until I looked at it. The products' price is actually set to zero; the rental costs are all in options (product attributes). So it looks like I need to set up a field in the table for the products' value, then somehow calculate insurance based off of that. It's doesn't sound too hard, but I'm in over my head.
  16. Side issue: I use a duplicate of the shipping insurance contribution (with variables renamed) to add a damage waiver module. It needs to calculate the same way based on values, not order total. I figure whatever changes we make to the shipping insurance module can be duplicated for the waiver module. Additional change: I want the price of the waiver to be displayed on checkout_payment (as is written it had a checkbox for the customer to select the waiver, but it doesn't show the cost until checkout_confirmation).
  17. I have the Shipping Insurance contribution installed (http://addons.oscommerce.com/info/1069). It works great, but I have a unique situation. I rent items, so the product's price is not the value. For example, a widget may cost $1,000, and should be insured as such, but the customer only pays, say, $50 to rent it for a week. The insurance module calculates insurance based off the $50. What I had planed on doing was to adjust the insurance rates to compensate. In the example, I can just multiply the actual shipping rate by 20. But the problem is that the rental rate is only loosely based on the retail value of the item. And if they rent it for 4 weeks, the order cost may be $150, but the actual insurance cost is the same whether they rent it for 1 or 4 weeks. So they would pay more for insurance. What I would like is a way to enter the products' value into the database (I don't use the "gross value" field so that one is available), and have the insurance module total up the values of the items in the order and calculate insurance based on that. I figure this has never been done before, and my php and db knowledge is limited. If someone can guide me through it, that would be great. Otherwise, I'd be willing to pay for help. I don't expect any problems with the current method of estimating insurance, but I'd rather avoid customer confusion and possible complaints by charging the actual insurance costs. Thanks in advance.
  18. The solution can be found in this thread: http://www.oscommerce.com/forums/index.php?showtopic=276299
  19. So I'm setting up a rental store. I installed USPS Methods contribution, and it works great. But I'm stumped on something. The shipping rates from USPS are for one-way. I need the rate to basically be doubled; I will be including a prepaid return shipping label with my products. I'm sure there is a way to insert a mathematical operator, but I'm no PHP whiz. But there is one more thing. I want the customer to have the option of selecting Express mail or Priority mail, but the package will always be returned Priority, which means that if they select Express I don't want it to just be doubled. Here is what I want my shipping rates to be: Option 1: Cost of Express + Cost of Priority Option 2: Cost of Priority x2. Like I said, I have USPS Methods installed and running, and it gives the customer the option between Express and Priority. All I need is the cost of Priority shipping to be added to both of those quotes. I have done a lot of major customizations to my site and installed a lot of contributions. This forum has been invaluable! Unfortunately, I found no contribution nor forum topics to solve my problem. Thanks in advance for your help!
×
×
  • Create New...