UPS XML Ready to Ship/Dimensional support

[bkpie]

Well it works without it and I added the extra contribution so UPS will calculate the difference on the fly of commercial and residential. I am not sure what is going to show up missing due to the missing code that I spoke of in previous post but this is a great add on for those who ship both comm and residential.

[fourmat]

Hi Bk,

I just installed the res/comm contrib and ran across the section that you had a problem with. You didn't find the exact code segment because it was changed in the original. The code that replaced the segment you were looking for was

$order_query = tep_db_query("select * from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

The function selects fields from database tables, and the old version selected the tables/fields individually. The new version of the code just selects them all using a wildcard, so it is unnecessary to change it, because it has selected all fields. as long as you updated the database with the new fields, you won't have a problem (and you didn't).

Thanks for the suggestion.

[JohnW]

Sorry I missed your previous posts Blayne, but I haven't been on this board much and I didn't get a notification email until Fourmat posted.

Anyway, sounds like it's working okay. I guess after you've had it for a while you'll be able to compare your shipping charges to your actual UPS charges and see how well it works out.

[bkpie]

Fourmat Sorry for taking long to get back. I figured that out and it actually makes it Easier. John so far pretty much right on to my UPS xml rates.
I changed the code as you stated to handle the COD option.

I am done and will be adding a shipping tracking contribution so customers can track there orders online and shop owners in admin orders section. I just have to finish packaging it. It works great for UPS,USPS and Fedex and is a great addition.
Also I just added a new CC module that is cool but need a bit of help with.
Have a great day.

[JohnW]

I use the Authorize.net Consolidated v1.7 by Austin519 CC module and it works very well. I used the AIM system since 2002 with OSC and it's been a great system the whole time. Except for a week a few years ago with Authorize.net had probelms with DDOS attacks it's been completely problem free. That's the only CC module I know but let me know how your other one works out.

The Batch Print tool you might want to look into also. It is basically installed in Max but needs tweaking to work is a great contribution. You can make a custom invoice that it generates with a PDF and you can email. If you are shipping a lot you can update a batch of orders at one time and it sends a different order update email than the regular order update.

[fourmat]

John/BKPie and anyone else,

I have the standard options working OK, but I'm needing to use the Ready To Ship option and I'm having a problem. For some reason when the RTS option is enabled, the product weight is not being delivered to the UPS XML module. Everything else is fine, including the price, quantity, address info, etc. But it is missing the weight. As a matter of fact, the total weight is being passed to the module, but the individual weight that it uses to calculate the separate package shipping is not.

I've done some looking and have identified some changes to the /classes/shopping_cart.php that have to do with the SPPC contrib where it involved the weight and I was wondering if anyone else could enable the UPSXML RTS function to see it it was working on their end.

Thanks for the help.

[fourmat]

Aw crap. Disregard the last question. I found that I borked the instllation of the dimensional features and had wiped out the weight SQL call during the modification. Figures...

[fourmat]

OK, I've run into another problem concerning the residential./commercial add on. Inside of OSCMax RC3, one things that the contribution doesn't take into account is the usage of the Purchase Without Account feature, which I use.

I haven't been able to figure it out quite yet because I can't get it to set the entry_residence_id toggle inside of the database. it appears that everything is identical to the changes that needed to be made in the core files, but for some reason it's not working.

I'm still plugging away. if anyone else has modded this contrib to use with the PWA package, let me know. I'll post the solution once I get it figured out.

[mithereal]

Originally Posted by JohnW

In order to make changing product dimensions easier I modified the Quick Updates with SPPC contrib to include length width height and RTS. I've uploaded the modified files to the project page here if you want to used it.

im looking for the modifications on the project page can you send a link??

[JohnW]

Sure, it's
Quick price updates for sppc with product dimension - osCMax - osCommerce Maximized

Also, after you have this working you can search "quick updates" on the main OSC site contributions section and you will see a newer version of "quick updates for sppc" by Jan Z that doesn't rely on register_globals. It doesn't have the dimensional support but you can use it to update your file pretty easily.