Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 1 of 1

Thread: How to Alter Shipping Method on FTP Orders?

  1. 09-26-2012, 04:05 PM #1
    webdbapps is offline Junior Member
    Join Date
    Sep 2012
    Posts
    3

    Default How to Alter Shipping Method on XML Orders?

    Hi,

    We have a process that uses a custom method to load and process orders from two third party XML files. These incoming orders need to be identified by a specific Shipping Method for certain affiliates.

    The XML orders are loaded into a holding table and then an update query adds the data to ASPDNSF table. We added two new ShippingMethodID values to the database. However, I need assistance in identifying the proper TSQL or stored procedure syntax that should be used to assign ShippingMethodID 1 to orders coming from XML feed 1.

    Thanks much for any help/guidance.
    Last edited by webdbapps; 10-11-2012 at 07:45 PM.