AbleCommerce Shopping Cart Software

You can make modifications to the SETIService.ashx script though. Modify the SQL Statement that pulls the orders for download by looking for the following code:
=====================================================================================
If UCase(LastOrder) = "ALL" Then LastOrder = "0"
x = ""
If IsNumeric(LastOrder) Then
&nbsp&nbsp&nbsp&nbsp x = " OrderID > " & LastOrder & " AND "
ElseIf UCase(OrderDate) "ALL" Then
&nbsp&nbsp&nbsp&nbsp x = "OrderDate >= '" & Format(CDate(OrderDate), "MM-dd-yyyy HH:mm:ss") & "' AND "
End If
x = x & "StoreID=" & objToken.StoreId

If IsNumeric(StartNum) And IsNumeric(BatchSize) Then
&nbsp&nbsp&nbsp&nbsp colOrders = CommerceBuilder.Orders.OrderDataSource.LoadForCriteria(x, BatchSize, StartNum, "OrderID")
Else
&nbsp&nbsp&nbsp&nbsp colOrders = CommerceBuilder.Orders.OrderDataSource.LoadForCriteria(x, "OrderID")
End If
======================================================================================

You can tweak this code to limit which orders are pulled. Do keep in mind that customizing your script in this way will require the same modifications to any future releases that may become available.

Stone Edge wrote: The AbleCommerce API allows selection of orders based on a SQL Statement (the WHERE clause) is fed to the OrderDataSource object. The query (x) used by the SETIService.ashx file is built as follows:

Code: Select all

        If UCase(LastOrder) = "ALL" Then LastOrder = "0"
            x = ""
        If IsNumeric(LastOrder) Then
            x = " OrderID > " & LastOrder & " AND "
        ElseIf UCase(OrderDate) <> "ALL" Then
            x = "OrderDate >= '" & Format(CDate(OrderDate), "MM-dd-yyyy HH:mm:ss") & "' AND "
        End If

        x = x & "StoreID=" & objToken.StoreId

        (ADD YOUR CODE HERE)

        x = x & " AND Additional Criteria…"

        If IsNumeric(StartNum) And IsNumeric(BatchSize) Then
            colOrders = CommerceBuilder.Orders.OrderDataSource.LoadForCriteria(x, BatchSize, StartNum, "OrderID")
        Else
            colOrders = CommerceBuilder.Orders.OrderDataSource.LoadForCriteria(x, "OrderID")
        End If

The issue here is that you are limited to criteria specific to the Orders table. You cannot do Inner/Outer Joins on other tables, therefore, your order would need to have something in it to indicate it is for this specific vendor. Perhaps the billing name/address can be used?

To limit this vendor to their orders only, copy the SETIService.ashx file to a new file, edit the SQL then give the vendor the new service script name – be sure to set up the appropriate permissions for this new script in the web.config for AbleCommerce. This would minimize the need for additional edits in the script to restrict output based on login credentials.

kastnerd wrote:Only problem i see is if someone orders 5 products and only 1 is from that vendor?

        colOrders.CopyTo(myArray, 0);
        Order o = colOrders[0];
        o.Items[i].Delete();