| Author |
 Topic  |
|
Barney Stone
Administrator
USA
5517 Posts |
|
|
Branin
New Member
17 Posts |
 Posted - 10/07/2009 : 6:36:57 PM
|
quote:
[i]Originally posted by Barney Stone[/i]
[br]Details at:
http://www.stoneedge.net/forum/topic.asp?TOPIC_ID=9546
When fixing the drop-ship email bug, it looks like one area was missed. Specifically, Case "PONumber" in the MergeFieldName function of the Email Functions module. As it currently stands in 5.904 you are looking for PO = 0 to show the dropship order number. If I replace the "PO = 0" test with a "drop = True" test, then everything seems fine and the [[PONumber]] tag starts working again. |
 |
|
|
coskevin
Member
194 Posts |
Posted - 10/07/2009 : 6:59:05 PM
|
| Did this release fix the bug with the residential indicator shipping bug. Once checked, the quote comes back as commercial rates and not residential rates with UPS? |
|
|
|
tclifesafety
Junior Member
USA
84 Posts |
Posted - 10/08/2009 : 09:53:29 AM
|
This update did NOT fix the drop ship issue - as Branin indicated, the PO number is coming in blank and PDF's will still not attach.
I have a ticket in. |
SEOM 5.904
Windows 7 Ultimate
Access 2003 w/SP3 + hotfix
Access 2007 Program File |
|
|
|
JaredSE
Senior Member
576 Posts |
Posted - 10/08/2009 : 10:31:18 AM
|
quote:
When fixing the drop-ship email bug, it looks like one area was missed. Specifically, Case "PONumber" in the MergeFieldName function of the Email Functions module. As it currently stands in 5.904 you are looking for PO = 0 to show the dropship order number. If I replace the "PO = 0" test with a "drop = True" test, then everything seems fine and the [[PONumber]] tag starts working again.
Thanks for the feedback. I'll make sure that's changed for the next release.
quote:
This update did NOT fix the drop ship issue - as Branin indicated, the PO number is coming in blank and PDF's will still not attach.
I made absolutely certain pdfs were attaching with the correct information while I was testing this release, so this may be a separate issue. Branin's post indicates that the issue with dropship was partially fixed as there were a LOT of fields not showing before. Not just the PONumber. If more tags are found to not work that previously did, please report them. |
|
|
|
JaredSE
Senior Member
576 Posts |
Posted - 10/08/2009 : 3:07:51 PM
|
quote:
Did this release fix the bug with the residential indicator shipping bug. Once checked, the quote comes back as commercial rates and not residential rates with UPS?
After reviewing the communication between Order Manager and UPS, I have found that Order Manager is functioning correctly in that it will send the residential indicator to the UPS servers if the box is checked and won't if it is not. I have also found that UPS checks the address and does an auto-correction based on whether it thinks the address is residential or commercial, regardless of what was sent in the request. Therefore you will always get the same rate for the same address. There is nothing we can do about this as the determination is completely made on the UPS server. |
|
|
|
coskevin
Member
194 Posts |
Posted - 10/08/2009 : 3:41:06 PM
|
Hmm.. after a couple of tests, I do see the auto-correction working on 5.902.
BUT, how come in SEOM 5.612 - the results are different. It does not auto-correct the address at manual order. Did something change?
quote:
[i]Originally posted by JaredSE[/i]
[br]quote:
Did this release fix the bug with the residential indicator shipping bug. Once checked, the quote comes back as commercial rates and not residential rates with UPS?
After reviewing the communication between Order Manager and UPS, I have found that Order Manager is functioning correctly in that it will send the residential indicator to the UPS servers if the box is checked and won't if it is not. I have also found that UPS checks the address and does an auto-correction based on whether it thinks the address is residential or commercial, regardless of what was sent in the request. Therefore you will always get the same rate for the same address. There is nothing we can do about this as the determination is completely made on the UPS server.
|
|
|
|
JaredSE
Senior Member
576 Posts |
Posted - 10/08/2009 : 3:51:56 PM
|
quote:
Hmm.. after a couple of tests, I do see the auto-correction working on 5.902.
BUT, how come in SEOM 5.612 - the results are different. It does not auto-correct the address at manual order. Did something change?
Don't know. I'm not in the habit of going back and testing previous versions if the latest ones work. |
|
|
|
coskevin
Member
194 Posts |
Posted - 10/08/2009 : 3:52:04 PM
|
I see it now, after checking the codes. In the newer version, you guys sending up Addr1 and Addr2 but in the older version, only the zip.
Param? :) |
|
|
|
Josh Bivouac
New Member
New Zealand
14 Posts |
Posted - 10/08/2009 : 6:33:02 PM
|
Hello
I'm not sure if this is the right place to suggest this. But in the next release would it be possible that when you maximise the SE window to full screen, it then stretches out the order detail window to fit your screen so that you don't have to constantly scroll along as much. Hopefully this would apply to all screens with the order detail window?
I think a few other people would like this as well?
Josh |
Josh
Bivouac Outdoor
www.bivouac.co.nz |
|
|
|
47CP
Member
236 Posts |
Posted - 10/08/2009 : 6:52:57 PM
|
I just downloaded 5.904 and am trying to install it on my system. Coming from 5.807 Beta, Enterprise version, SQL Server 2005.
Upon first open after getting asked if i want to upgrade the database and confirming backup, I get "At CheckTables: Error = 3146 [Microsoft][ODBC Sql Server Driver] Timeout Expired"
If I click OK, I get the standard "Store XXX Opened" and then "At ClearTempOrder: Error = 3061 Too Few Parameters. Expected 3"
Clicking OK through this brings the new main menu, but nothing seems to open. If I click Inventory>View, I get a "Enter Parameter Value" dialog box "Amazon Don't Upload"
I left a message with support.
DaveW |
|
|
|
Ocean
Junior Member
USA
75 Posts |
|
|
shoneen
New Member
USA
16 Posts |
Posted - 10/09/2009 : 12:38:02 AM
|
Multi Order Processor BUG--
The sequencing of the orders changes on many of the tabs. For instance, in the "Main" tab, orders are listed from oldest to newest. However, on the "Comments," "Shipping," and "Custom Order" tabs, the orders are listed in reverse, from newest to oldest.
And in some of the tabs, there appears to be a randomness as to how the orders are listed. ("Addresses" and "Payment" tabs) This is all very confusing when trying to work with a large list of orders. It is also time-consuming and easy to lose one's place.
Unfortunately this is a new bug, as it was not like this is the prior version of OM.
In my opinion, it would be most helpful to list the newest order on line 1, and the oldest order at the bottom. |
|
|
|
shoneen
New Member
USA
16 Posts |
Posted - 10/09/2009 : 12:40:02 AM
|
P.S. to above post.
I have version 5.903 --- not the very latest version. |
|
|
|
Barney Stone
Administrator
USA
5517 Posts |
Posted - 10/09/2009 : 08:06:19 AM
|
quote:
[i]Originally posted by Ocean[/i]
[br]expanding the screen as mentioned above would be nice. I also would like to see defaultbox added to the approval rule choices. For people shipping with FedEx or UPS, DIM weights are just as important as actual weight for determining shipping cost and method.
Do you know that you can set the default packing box for each product on the Misc tab of the View Inventory screen? |
Barney Stone, President
Stone Edge Technologies, Inc.
610-994-3699 ext. 111 |
|
|
|
Barney Stone
Administrator
USA
5517 Posts |
Posted - 10/09/2009 : 08:09:06 AM
|
quote:
[i]Originally posted by shoneen[/i]
[br]Multi Order Processor BUG--
The sequencing of the orders changes on many of the tabs. For instance, in the "Main" tab, orders are listed from oldest to newest. However, on the "Comments," "Shipping," and "Custom Order" tabs, the orders are listed in reverse, from newest to oldest.
And in some of the tabs, there appears to be a randomness as to how the orders are listed. ("Addresses" and "Payment" tabs) This is all very confusing when trying to work with a large list of orders. It is also time-consuming and easy to lose one's place.
Unfortunately this is a new bug, as it was not like this is the prior version of OM.
In my opinion, it would be most helpful to list the newest order on line 1, and the oldest order at the bottom.
I am not seeing that problem here. Please contact Support so they can look into this for you. |
Barney Stone, President
Stone Edge Technologies, Inc.
610-994-3699 ext. 111 |
|
|
|
47CP
Member
236 Posts |
Posted - 10/09/2009 : 09:45:30 AM
|
quote:
[i]Originally posted by 47CP[/i]
[br]I just downloaded 5.904 and am trying to install it on my system. Coming from 5.807 Beta, Enterprise version, SQL Server 2005.
Upon first open after getting asked if i want to upgrade the database and confirming backup, I get "At CheckTables: Error = 3146 [Microsoft][ODBC Sql Server Driver] Timeout Expired"
If I click OK, I get the standard "Store XXX Opened" and then "At ClearTempOrder: Error = 3061 Too Few Parameters. Expected 3"
Clicking OK through this brings the new main menu, but nothing seems to open. If I click Inventory>View, I get a "Enter Parameter Value" dialog box "Amazon Don't Upload"
I left a message with support.
DaveW
DUH. Rebooting the server fixed this problem and it installed/upgraded fine.
DaveW |
|
|
|
pete_notubes
Member
261 Posts |
Posted - 10/09/2009 : 2:33:07 PM
|
quote:
[i]Originally posted by coskevin[/i]
[br]I see it now, after checking the codes. In the newer version, you guys sending up Addr1 and Addr2 but in the older version, only the zip.
Param? :)
It is much better that UPS is auto correcting, If you dont use the UPS auto correction, UPS will add it to your bill anyways. |
Access Version: 2003 SP2
have used 4.411, 5.005,5.503,5.504,5.505
Running SEOM Ver. 5.612 |
|
|
|
coskevin
Member
194 Posts |
Posted - 10/09/2009 : 3:16:41 PM
|
This does not affect the printing of the UPS label and when printed, it should be auto corrected.
This is the process when we quote the customer the shipping rate during a manual order over the phone.
Example:
Stone Edge Technologies, Inc. (Commercial address)
920 Germantown Pike Suite 112
Plymouth Meeting PA 19462
Residential Rates:
In Volusion, UPS Ground is: $11.00
In SEOM, UPS Ground is: $10.00 (because UPS auto corrected it)
We want the data to be consistent. Residential indicator seems pointless after the auto correction. UPS is auto correcting because in the new version of SEOM it is sending the complete address via XML to UPS server and the older version is not. That is why I have hoping for a param to only send the zip code. I believe majority of the carts will send only the zip code to UPS for a quote.
quote:
[i]Originally posted by pete_notubes[/i]
[br]quote:
[i]Originally posted by coskevin[/i]
[br]I see it now, after checking the codes. In the newer version, you guys sending up Addr1 and Addr2 but in the older version, only the zip.
Param? :)
It is much better that UPS is auto correcting, If you dont use the UPS auto correction, UPS will add it to your bill anyways.
|
|
|
|
kevin
Administrator
USA
2405 Posts |
Posted - 10/09/2009 : 4:28:33 PM
|
quote:
[i]Originally posted by coskevin[/i]
[br]This does not affect the printing of the UPS label and when printed, it should be auto corrected.
This is the process when we quote the customer the shipping rate during a manual order over the phone.
Example:
Stone Edge Technologies, Inc. (Commercial address)
920 Germantown Pike Suite 112
Plymouth Meeting PA 19462
Residential Rates:
In Volusion, UPS Ground is: $11.00
In SEOM, UPS Ground is: $10.00 (because UPS auto corrected it)
We want the data to be consistent. Residential indicator seems pointless after the auto correction. UPS is auto correcting because in the new version of SEOM it is sending the complete address via XML to UPS server and the older version is not. That is why I have hoping for a param to only send the zip code. I believe majority of the carts will send only the zip code to UPS for a quote.
The Order Manager does send the full address to the UPS or FedEx rating system because it provides for a more accurate shipping rate than the zip code alone - is this not what merchant's want? To be able to get more accurate rating from their shipper?
We also set a flag in the request to do an address validation which auto corrects the residential flag. This was a result of a class action lawsuit against UPS for errant residential charges. UPS determines who is and is not residential - why should it be left to the merchant?
I would have you put the same data into UPS Worldship or FedEx Ship Manager and request a shipping rate.
If ALL settings are identical to the Order Manager, then your rate should remain at $10.00. If Volusion is telling you $11.00, then one of the following is occurring:
1) Volusion is not sending the same data as the Order Manager thus resulting in a less accurate rating - as you suggest, Volusion only sends the destination zip whereas we (and WorldShip) send the entire street address. This discrepancy is not our problem to address - I suggest you discuss this with Volusion.
2) The rate is padded - many carts allow the merchant to add handling charges to the rate. Remove the padding from Volusion or add it into the Order Manager.
|
Kevin Smith
Stone Edge Technologies, Inc.
920 Germantown Pike
Suite 112
Plymouth Meeting, PA 19462
610-994-3699 x112
kevin at stoneedge dot com |
|
|
|
coskevin
Member
194 Posts |
Posted - 10/09/2009 : 4:50:48 PM
|
To me Auto correct means if you send an address that is commercial with residential checked in SEOM, UPS will disregard the residential indicator and respond with a commercial address rate.
I do understand sending the full address up will get a more accurate quote.
However, majority of the shoppers will not enter their complete address for a shipping quote at cart. Instead, the cart requires only the zip code for a shipping quote; this applies to majority of the carts not just Volusion. So, if the customer purchases 5 items and the cart quoted them with a shipping of $50.00. Later, they decided to call in and place a phone order instead, they get a shipping quote of $40.00. Because of the complete address was provided, UPS gave them a commercial rate even with residential indicator checked. We lost an additional profit of $10.00 due to this.
If a param is in place, to only send the zip code, our sales rep will quote the customer $50.00 instead.
The param should not affect the printing of the UPS label but only at requesting a shipping quote.
|
|
|
|
ocpxc02
Member
USA
496 Posts |
Posted - 10/09/2009 : 5:03:24 PM
|
We would like the same thing in terms of quoting customers FedEx rates when taking phone orders. Our cart is configured (via a parameter) to always return the residential rate for the shipment. If we can ship commercial, that's great and as coskevin said, that's more profit on the shipping. When we actually go to ship, we'd like any type of autocorrect to be enabled so that we ship using the correct parameters. In the case of FedEx, this is even more important as commercial addresses are served by FedEx Ground and residential are served by Home Delivery.
Paul |
|
|
|
coskevin
Member
194 Posts |
Posted - 10/12/2009 : 4:07:56 PM
|
Exactly, I believe all carts only allow you to configure residential or commercial rates or let the customer choose during check out.
Kevin, I believe a param should be in place to be consistent with cart data. Please.
However, During the actual printing of the UPS/Fedex label, the full address should be sent up for correction.
quote:
[i]Originally posted by ocpxc02[/i]
[br]We would like the same thing in terms of quoting customers FedEx rates when taking phone orders. Our cart is configured (via a parameter) to always return the residential rate for the shipment. If we can ship commercial, that's great and as coskevin said, that's more profit on the shipping. When we actually go to ship, we'd like any type of autocorrect to be enabled so that we ship using the correct parameters. In the case of FedEx, this is even more important as commercial addresses are served by FedEx Ground and residential are served by Home Delivery.
Paul
|
|
|
|
shoneen
New Member
USA
16 Posts |
Posted - 10/13/2009 : 3:49:56 PM
|
ON HOLD Feature.
As a concept, I really do like the "On Hold" status and filter list. However, the "On Hold" orders still show up in the "Complete, Pending Orders" List. This is a contradiction in terms, and, I believe qualifies as a bug. If an order is "On Hold" for any reason, arguably, it is not also "Complete."
I mention this because it gets confusing when one has quite a number of "On Hold" orders showing up in the "Complete, Pending" List. One can never totally close out and 100% process the "Complete, Pending" list because there are a number of "On Hold" orders there. It is especially bad in the Multi-Order Processing page.
My request: Now that you have the "On Hold" status available, just eliminate all "On Holds" from the "Complete, Pending" filter search. |
|
|
|
shoneen
New Member
USA
16 Posts |
Posted - 10/13/2009 : 8:37:38 PM
|
ON HOLD and MULT-ORDER Processing--- Addendum
I realize that the "On Hold" status is available for view in the Multi-Order Processor, but it is way over to the right, and off the normal screen view. One has to scroll over on the horizontal bar to see the special status of the order. This is not very functional.
SUGGESTION: Put the special status (On Hold, Layaway, Quote, etc.) on the Main Tab --- and over on the left, where it is readily visible. Maybe some of the other columns could be streamlined, or made more narrow, in order to make room for a visible display of the "Order Status."
Of course, it would be preferable to not even display the "On Hold/Layaways/Quote orders in the "Complete, Pending Orders" pull-down filter results. But if you do keep it as is, please make those orders with a special status more visible to the processor. The current display is almost an invitation for shipping errors to occur. Inevitable an order will be shipped when that order was "on hold" for some reason. |
|
|
|
Ocean
Junior Member
USA
75 Posts |
|
|
Topic |
|
Version 5.904 Released, 10-7-09
