MyAtOnce Web Service

Update Product Inventory:

URL: https://myatonce.com/data/services/api/products/inventory

HTTP Request Method: POST

Required Fields: sku,quantity.

Sample JSON request

Sample XML request

Update Order Status / Shipping information:

URL: https://myatonce.com/data/services/api/orders/status

HTTP Request Method: POST

Required Fields: ref_num is required, and either an order status value or tracking number must be provided. All other fields are optional.

Sample JSON request

Sample XML request

Create Order:

URL: https://myatonce.com/data/services/api/orders/status

HTTP Request Method: POST

Required Fields:

SalesOrder field must be specified or it will be treated as an order update

AccountNum field must match with an account number stored on MAO OR if field is empty will try to account using name field

Collection AND Delivery fields must be specified to obtain particular product data

OrderStatus MUST be a VALID status

Notes:

Mode: UPC OR SKU OR STYLEID (will default to SKU if not set)

ShipDate will default to -8 hours (GMT time) if left blank or field not defined

Canceldate will default to +30 days (GMT time) if left blank or field not defined

OrderDate will default to -8 hours (GMT time) if left blank or field not defined

If BillingID and Account number matches, will use default billing address

If BillingID wasn't defined, Street, City and Zip will be used to look up billing address

If ShippingID and Account number matches, will use default shipping address

If ShippingID wasn't defined, Street, City and Zip will be used to look up shipping address or will otherwise use the default shipping address

Sample JSON request

{
    "SalesOrder": {
        "Mode": "SKU",
        "ShipDate": "2016-03-01 17:45:38",
        "CancelDate": "2016-03-31 17:45:38",
        "OrderDate": "2016-02-22 05:33:22",
        "CustomerPO": "PWL-442",
        "Comment": "Please notify when shipped",
        "Orderstatus": "Submitted",
        "Customer": 
            "AccountNum": 752344,
            "Name": "Socon boutique",
            "Billing": {
                "BillingID": 576234,
                "Address": {
                    "Street": "555 21st NE St",
                    "Street2": "Suite A3301",
                    "City": "Flushing",
                    "State": "New York",
                    "PostalCode": 11372,
                    "Country": "US"
                }
            },
            "ShipTo": {
                "ShippingID": 886744,
                "Address": {
                    "Street": "555 21st NE St",
                    "Street2": "Suite A3301",
                    "City": "Flushing",
                    "State": "New York",
                    "PostalCode": 11372,
                    "Country": "US"
                }
            }
        "SalesOrderDetail": {
            "SalesOrderItem": [
                {
                    "Collection": "IN-STOCK",
                    "Delivery": 9,
                    "SKU": 56456546,
                    "Quantity": 2
                },
                {
                    "Collection": "IN-STOCK",
                    "Delivery": 9,                
                    "SKU": 25475677,
                    "Quantity": 5
                }
            ]
        }
    }
}

Sample XML request

<xml>
    <salesOrder>
        <mode>103974</mode>
        <shipdate>2016-03-01 17:45:38</shipdate>
        <canceldate>2016-03-31 17:45:38</canceldate>
        <orderdate>2016-02-22 05:33:22</orderdate>
        <customerpo>PWL-442</customerpo>
        <comment>Please notify when shipped</comment>
        <orderstatus>Shipped</orderstatus>
        <customer>
            <accountnum>752344</accountnum>
            <name>Socon boutique</name>
            <billing>
                <billingid>576234</billingid>
                <address>
                    <street>555 21st NE St</street>
                    <street2>Suite A3301</street>
                    <city>Flushing</city>
                    <state>New York</state>
                    <postalcode>11372</postalcode>
                    <country>US</country>
                </address>
            </billing>
            <shipto>
                <shippingid>886744</shippingid>
                <address>
                    <street>555 21st NE St</street>
                    <street2>Suite A3301</street>
                    <city>Flushing</city>
                    <state>New York</state>
                    <postalcode>11372</postalcode>
                    <country>US</country>
                </address>
            </shipto>
            <salesorderdetail>
                <salesorderitem>
                    <item>
                        <collection>IN-STOCK</collection>
                        <delivery>9</delivery>
                        <sku>56456546</sku>
                        <quantity>2</quantity>
                    </item>
                    <item>
                        <collection>IN-STOCK</collection>
                        <delivery>9</delivery>                
                        <sku>25475677</sku>
                        <quantity>5</quantity>
                    </item>
                </salesorderitem>
            </salesorderdetail>
        </customer>
    </salesOrder>
</xml>

Get Order Listing:

URL: https://myatonce.com/data/services/api/order/list

HTTP Request Method: GET

Sample JSON request

[
    {
        "orderId": "452858",
        "purchaseOrderNumber": "TEST ORDER #06",
        "shipDate": "2024-05-07 00:00:00",
        "stopDate": "2024-06-06 00:00:00",
        "shippingMethod": "FX GROUND",
        "specialInstructions": "",
        "discountAmount": "0.00",
        "totalAmount": "75.00",
        "currency": "USD",
        "createdDate": "2024-05-07 18:14:33",
        "currencyName": "US Dollars",
        "customerId": "CUSTOMERIDXX",
        "billAddressId": "",
        "billTo": {
            "name": "BILL TO NAME",
            "contactName": "CONTACT XXXXX",
            "street1": "XXX Village Blvd",
            "street2": "",
            "city": "Madison",
            "state": "MS",
            "postalCode": "39110",
            "country": "USA",
            "phone": "0000000000"
        },
        "shipTo": {
            "name": "SHIP TO NAME",
            "shipAddressId": "",
            "contactName": "",
            "street1": "XXX Village Blvd",
            "street2": "",
            "city": "Madison",
            "state": "MS",
            "postalCode": "39110",
            "country": "USA",
            "phone": ""
        },
        "collectionName": "Future Stock - MARCH 25, 2024",
        "departmentName": "",
        "items": [
            {
                "sku": "SKU-TEST-1",
                "name": "ITEM-NAME-1",
                "notes": "",
                "quantity": "3",
                "discount": 0,
                "originalUnitPrice": "12.50",
                "discountedUnitPrice": "12.50"
            },
            {
                "sku": "SKU-TEST-2",
                "name": "ITEM-NAME-2",
                "notes": "",
                "quantity": "3",
                "discount": 0,
                "originalUnitPrice": "12.50",
                "discountedUnitPrice": "12.50"
            }
        ]
    }
]

MyAtOnce REST Web Service

Request Headers:

Additional Product Inventory Header:

Available Functions: