Has anyone used the V API to update order status - Ecommerce Forums
Results 1 to 3 of 3

Thread: Has anyone used the V API to update order status

  1. #1

    Has anyone used the V API to update order status

    I have custom service that uses the V API to retrieve orders that have been marked for ready to ship.
    After downloading the orders and sending it to the warehouse, I need the order status to change to Pending Shipment. The generic update method to the orders table comes back with an error stating that the orders table only supports inserts. I don't want to insert but essentially update the status so that it will save me time to go to each order and update that plus it removes errors in the work flow. can anyone help or state their V API experience which has obscured documentation.
    Here is the test snippet.

    string[] orderNumbers = orderIds.Split(',');
    string orderXML = "";
    string APIURL = Utils.GetAPIPostURL(ImportMode.Update, chkPreProd.Checked);
    XMLPostManager manager = new XMLPostManager();

    StringBuilder sb = new StringBuilder();
    sb.Append("<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
    sb.Append("<xmldata>");
    foreach (string item in orderNumbers)
    {

    sb.Append("<Orders>");
    sb.Append("<OrderID>" + item + "</OrderID>");
    sb.Append("<OrderStatus>" + "Pending Shipment" + "</OrderStatus>");
    sb.Append("</Orders>");

    }

    sb.Append("</xmldata>");

    orderXML = sb.ToString();

    string response = manager.SendXMLToURL(APIURL, orderXML);
    MessageBox.Show(response);

    Thanks.

    Super

  2. #2

  3. #3
    I realize this is close to 3 years old but I just want to state that this is possible but not in the manner in which the OP suggested. You would need to run an SQL update query via a custom ASP page.

Similar Threads

  1. How do these Products Work w/PO's "Link Stock Status with Product Code"
    By GentleBath in forum Inventory/Order Management
    Replies: 1
    Last Post: 02-01-2013, 06:32 AM
  2. Change order status from canceled to processing?
    By HOHD in forum Order Management
    Replies: 25
    Last Post: 08-15-2012, 05:38 AM
  3. New site update
    By MPPC in forum Ecommerce Industry
    Replies: 11
    Last Post: 07-02-2012, 08:18 PM
  4. Processor Update and IP Addresses
    By AWCthreads in forum Setup & Configuration
    Replies: 2
    Last Post: 07-02-2012, 10:44 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •