Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

petercascio

Pioneers
  • Posts

    125
  • Joined

  • Last visited

Everything posted by petercascio

  1. I tried that but am not getting any quotes at all now from FedEx, and UPS still gives me everything, both US and Canada :(
  2. Hi, We use UPS to ship to Canada and FedEx to ship to the US. (Don't ask.) UPS Ground shows up for both Canada and US shipping, which we do not want. How can I filter out shipments to the US either in checkout_shipping or, more likely, in the UPS module? Looked at the code but can't find an obvious way to do this. Any help would be much appreciated! Peter
  3. Hi, thanks, that line is in there, the whole block is just like you have it. Anything else you can think of?
  4. Not getting ground quotes for Canada, only International Economy and Priority Yup, I checked, and International Ground is enabled, in fact all quotes are enabled and we have no problems with US Ground. Any suggestions would be very much appreciated. Peter
  5. Hi, just switched to FedEx from UPS and can't get quotes for Canada, they all return $0.00 in ACCOUNT only. When I use LIST I get quotes, but that's not so good, obviously. FedEx swear it's nothing to do with them and won't help because they don't support OSC, of course. I'm using OSC 3.1 Any ideas? Peter
  6. Wow. I really messed this up. Ignore the code in the message above. There's a whole bunch of older adjustments I had commented out and I forgot that we have the adjustments turned off in the test store version! D'UH. Here's the real thing for FedEx that's in our live store. I changed line 119. I have no clue why I did this. Maybe because I was working on this at 4am? I only did this in the FedEx version. $mystate = $state; Then I added the mod at around line 254 after if(strlen($this->handling_fee)>0) { if(strstr($this->handling_fee,'%')) { /* mod: adjust Fedex shipping quotes for some states up or down by percentage; this mod requires handling fee to be set to % in Fedex module admin. 15 = 15% increase and -15 = 15% decrease */ $state_discounts = array ('AK' => -15.00, 'HI' => -15.00, 'CA' => -15.00, 'OR' => -15.00, 'WA' => -15.00, 'AZ' => -10.00, 'NM' => -10.00, 'TX' => -10.00, 'CO' => -10.00); //original was $cost += $cost*(str_replace('%','',$this->handling_fee)/100); $cost = $cost/100 * (100 + $state_discounts[$mystate]) + 2.75; // + 2.75 is the $ handling fee /* end mod */ And here is the UPS version I used before we switched over to FedEx. We didn't charge a $ handling fee on top of the adjustments. I didn't do that strange $mystate thing I did in FedEx. I added the mod at around line 460 after function _upsDest($city, $stateprov, $country, $postal) { $this->_upsDestCity = $city; $this->_upsDestStateProv = $stateprov; $this->_upsDestCountryCode = $country; /* mod: adjust UPS shipping quote up or down by a set percentage; this mod requires handling fee to be set to % in UPS module admin. 15 = 15% increase and -15 = 15% decrease */ $state_discounts = array ('CA' => -7.00, 'OR' => -7.00, 'WA' => -7.00, 'AK' => 18.00, 'AL' => 18.00, 'AR' => 18.00, 'AZ' => 18.00, 'CO' => 18.00, 'CT' => 23.00, 'DC' => 23.00, 'DE' => 23.00, 'FL' => 18.00, 'GA' => 18.00, 'HI' => 13.00, 'IA' => 18.00, 'ID' => 18.00, 'IL' => 18.00, 'IN' => 18.00, 'KS' => 18.00, 'KY' => 18.00, 'LA' => 18.00, 'MA' => 23.00, 'MD' => 23.00, 'ME' => 23.00, 'MI' => 18.00, 'MN' => 18.00, 'MS' => 18.00, 'MT' => 18.00, 'NC' => 18.00, 'ND' => 18.00, 'NE' => 18.00, 'NH' => 23.00, 'NJ' => 23.00, 'NM' => 18.00, 'NV' => 18.00, 'NY' => 23.00, 'OH' => 23.00, 'OK' => 18.00, 'PA' => 18.00, 'PR' => 13.00, 'RI' => 23.00, 'SC' => 18.00, 'SD' => 18.00, 'TN' => 18.00, 'TX' => 18.00, 'UT' => 18.00, 'VA' => 18.00, 'VT' => 23.00, 'WI' => 18.00, 'WV' => 18.00, 'WY' => 18.00); if ($country=='US' and tep_not_null($state_discounts[$stateprov])) { $this->handling_fee = +$state_discounts[$stateprov]; } // end mod Use at your own risk.
  7. I put this in at line 256. Shouldn't be hard to adjust if you don't ship to too many countries. You can also keep whatever % you already charge as a handling fee. If you charge a flat handling fee just hard code the amount below. We have to change the shipping adjustments frequently -- we have FIERCE competitors in a small niche wholesale market -- so I use a spreadsheet and copy and paste the adjustments. BTW, we used this in the UPS module before we switched to Fedex. /* mod: adjust Fedex shipping quote up or down by a set percentage; this mod requires handling fee to be set to % in Fedex module admin. 15 = 15% increase and -15 = 15% decrease */ //$state_discounts = array ('CA' => -7.00, 'OR' => -7.00, 'WA' => -7.00, 'AK' => 18.00, 'AL' => 18.00, 'AR' => 18.00, 'AZ' => 18.00, 'CO' => 18.00, 'CT' => 23.00, 'DC' => 23.00, 'DE' => 23.00, 'FL' => 18.00, 'GA' => 18.00, 'HI' => 13.00, 'IA' => 18.00, 'ID' => 18.00, 'IL' => 18.00, 'IN' => 18.00, 'KS' => 18.00, 'KY' => 18.00, 'LA' => 18.00, 'MA' => 23.00, 'MD' => 23.00, 'ME' => 23.00, 'MI' => 18.00, 'MN' => 18.00, 'MS' => 18.00, 'MT' => 18.00, 'NC' => 18.00, 'ND' => 18.00, 'NE' => 18.00, 'NH' => 23.00, 'NJ' => 23.00, 'NM' => 18.00, 'NV' => 18.00, 'NY' => 23.00, 'OH' => 23.00, 'OK' => 18.00, 'PA' => 18.00, 'PR' => 13.00, 'RI' => 23.00, 'SC' => 18.00, 'SD' => 18.00, 'TN' => 18.00, 'TX' => 18.00, 'UT' => 18.00, 'VA' => 18.00, 'VT' => 23.00, 'WI' => 18.00, 'WV' => 18.00, 'WY' => 18.00); $state_discounts = array ('AK' => -15.00, 'HI' => -15.00, 'CA' => -15.00, 'OR' => -15.00, 'WA' => -15.00, 'AZ' => -10.00, 'NM' => -10.00, 'TX' => -10.00, 'CO' => -10.00); /* end mod */ $cost += $cost*(str_replace('%','',$this->handling_fee)/100);
  8. We need a mod which is partly site specific but also has better error reporting which could be useful to other people as well. We are in a very small wholesale niche market and have just 4 competitors so we need to adjust shipping rates to areas where our competitors are located. The first part of the mod is probably specific to our store: we want to adjust shipping quotes up or down by a different percentage for each method. We'd also like better error reporting so people may find sections 2, 3 and 4 useful and I'm happy to post the code once this is done. The details of the mod we need is below. Can anyone help or have a suggestion how we could find someone who can do this for us? We already have a small mod I wrote which lets us adjust all shipping rates to specific US states up or down. I assume this could be customized to work anywhere if someone needs to adjust rates to different locations. It is very basic. We've used it with both UPS and FedEx and I'd guess it would work with other shipping modules as well. I'm happy to pass it on. Thank you! We get a variable from FedEx called $quotes. It contains the array below. xx.xxx stands for actual numbers, i.e. 2.45 lbs and cost $ 7.808. Tax is an existing variable. Numbers are rounded later. Array ( [0] => Array ( [id] => fedexwebservices [module] => FedEx: x package(s) with a total weight of x.xx lbs [methods] => Array ( [0] => Array ( [id] => FEDEXGROUND [title] => Fedex Ground [cost] => xx.xxxx ) [1] => Array ( [id] => FEDEXEXPRESSSAVER [title] => Fedex Express Saver [cost] => xx.xxxx ) [2] => Array ( [id] => FEDEX2DAY [title] => Fedex 2 Day [cost] => xx.xxxx ) [3] => Array ( [id] => STANDARDOVERNIGHT [title] => Standard Overnight [cost] => xx.xxxx ) [4] => Array ( [id] => PRIORITYOVERNIGHT [title] => Priority Overnight [cost] => xx.xxxx ) [5] => Array ( [id] => FIRSTOVERNIGHT [title] => First Overnight [cost] => xx.xxxx ) ) [tax] => xx.xxxx [icon] => ) ) (1) For each of these shipping methods let me increase or decrease the cost $ xx.xxxx by a set percentage. We'll hard code the percentages ourselves as we don't want to make further changes to the store so we can upgrade more easily. (2) If one of the 6 shipping methods is missing continue and display the available methods to the customer. Send me an email with the customer's name, address, email address, order and the name of the missing shipping method plus the names and $ cost of the available shipping methods so we can contact the customer if he does not complete the order. (3) We have to assume that the name of one or more of the shipping methods may change. If that happens we are stuck. Send me an email with the customer's name, address, email address, order and the names of all available shipping methods and cost. Display a message to the customer saying "Sorry, shipping quotes are not available right now. We will contact you as soon as possible with shipping quotes." (4) If Fedex sends an error message send me an email with the customer's name, address, email address and order. Display a message to the customer saying "Sorry, shipping quotes are not available right now. We will contact you as soon as possible with shipping quotes." `
  9. Hi, we need to discount the Fedex air rates only to stay competitive. We are a small wholesale niche company and have only three competitors in the US, so this is really important to us. I can't see how I would 'unpack' $quotes within the module to adjust the air rates rates only. BTW, we already adjust all quotes (up or down) for individual states but as we do it to the whole quote at the discount stage it shouldn't interfere with whatever we need to do to pick out the air rates. Peter
  10. Anyone using this module should check their database for complete plain text credit card numbers. Some versions of the module do NOT obscure the first numbers with XXX so you get 1234567812345678 instead of XXXXXXXXXXXX5678 Not only is this really bad for your costumers should someone hack your site but it is also a major violation of your credit card acceptance contract.
  11. Has anybody else had problems with sales tax not being applied to shipping and the low order fee being ignored? The order confirmation the customer gets has all the correct info: sales amount + shipping + low order fee + tax on all three items = total amount charged However, in PayPal we get sales amount + tax on sales amount only + shipping = total amount charged Help!
  12. Hi, this looks like a great contribution. If my question is answered in your installation and other instructions then I missed it, apologies. We sell cardboard boxes that can be screen printed in three colors if a customer so desires. We have two charges for that, a setup charge for each color and then a printing charge for each box. Can this contribution link the number of boxes and printing charges so that if a customer buys 15 boxes and selects screen printing they then are charged printing x 15 without having to type in the number purchased again? We found that if people have to type in the figure again then many forget to do so, selecting 15 boxes and just one printing charge! Peter
  13. Unfortunately I'm having problems with this. UPS quote for CA is $9.25. When I put in 10 for 10% discount the result is $ -0.75, when I put in 1% it comes to $8.25. So it looks like it is deducting the amount instead of figuring out the percentage :-(
  14. Do people generally have success with the dimensional shipping part of the UPS module? I'm having problems with it. When a customer has a large order then the cart will start by using the smallest box and quote for something like 26 boxes at 3 pounds each instead of using three or four of the largest boxes. The quote for 26 small boxes is much higher than a quote for three or four heavy boxes, of course. Any idea how to get around this problem?
  15. Great, thanks, I'll save that. For now UPS is back on... <sigh>
  16. I have a solution that gives you NY taxes by jurisdiction rather than by ZIP code as that's the way the tax people want it. Send me a private message -- not on the forum -- if you want it. Peter
  17. Found the answer: I installed Enable Free Product Downloads http://addons.oscommerce.com/info/4136 All I had to do was change the COD module from this example from the contribution: // disable the module if the order only contains virtual products //MJA - 3/28/06 - Following lines are modified to ALLOW COD for //orders with $0.00 price. if ($this->enabled == true) { if ($order->content_type == 'virtual') { if ($order->info['total'] > 0) { $this->enabled = false; and change it to // disable the module if the order is in the main store where we don't take COD and PO orders if ($this->enabled == true) { if ($order->info['total'] > 0) { $this->enabled = false; That's all !! :-)
  18. We run two stores from the same database, sharing stock and customer details. The only difference is that one shop is for longstanding customers who get invoiced which we handle as COD, while everybody else pays by cc through Skipjack. Just did an upgrade to the store to add a bunch of stuff we needed and I need to hard code COD into the one store as we do not want to offer it as an option in the main store. So I see two possibilities: hide COD in the main store, but I don't know how or hard code COD into the secondary store. Any help would be much appreciated!
  19. A funny request (for anyone in the right state of mind to find this funny). I've been setting up two stores running from the same database but with different products for different markets. I have UPSXML working in both stores. Now the boss has decided he wants to offer UPS in only one of the stores for now, but may change his mind again (he does that). Is there a quick and easy fix for disabling UPS temporarily?
  20. OK, that's going to confuse the heck out of our customers. So I could either change the text to read "3 packages at approx 59lbs each" or somehow change the code. The actual total weight would be better as our cardboard product is relatively heavy and a larger order would be cheaper by truck than by UPS.
  21. I do use dimensional support. Does that mean the code would be different?
  22. The default tare (the empty weight of a package) is 3lbs. You can change that weight in Administration > Configuration > Shipping/Packaging.
  23. Hi, I have an odd problem. Up to 59lbs the weight in the UPS price quotes looks right. Above 59lbs the number of boxes increases in proportion but the listed weight continues to be always quoted as 59lbs in total, which is obvious nonsense. Is it possible that this is the individual box weight rather than the total weight? If so, where should I look for an error? Peter
  24. Whew -- that flew right over my head. I just did that and I got an error message for alter table products add column products_qty_blocks int not null default 1; That's here already because we hve QPB in the old store and are using the same database. Could I just drop that line and do the other tables?
×
×
  • Create New...