👍
Endpoint

Method: POST/PUT

URI: https://api.jooraccess.com/v2/bulk-inventory

Params

Accept: application/xml OR application/json

Content-Type: application/xml OR application/json

Authorization: OAuth2 [Base64 encoded token]

Parameters

PARAMETERS	REQUIRED	TYPE	NOTES
overwrite	N	Integer	Value of “1” enables overwrite of inventory for account with values in API call.
dec_pending	N	Integer [0,1]	Value of "1" makes JOOR's pending quantities deducted from the available to sell received in the API call. If not included in the request, the default is dec_pending = 0

Request Field Details

FIELD NAME	REQ	TYPE	DESCRIPTION
+ inventory_items			node : 1-1
+ inventory_item			node : 1-n
warehouse	Y	String	The warehouse name in which the inventory positions should be stored. Must be set up in JOOR before loading.
inventory_date	N	String	Date assigned to the inventory positions. Can be in YYYY-MM-DD or MM-DD-YYYY format.
style_number	X	String	Code used to signify style.
style_identifer	X	String	The client designated ID or key used to identify a particular style.
style_id	N	Integer	The JOOR unique internal ID for a style.
color_code	X	String	The client color code. Recommended as 3 digit (padded).
style_color_id	N	Integer	The JOOR unique internal ID for a style/color combination.
size	X	String	The individual size names available for purchase.
size_code	N	String	A client specified code or identifier for the size (usually a size run code).
inventory	Y	Integer	The quantity available for the SKU.
upc	X	String	The universal product code for the designated SKU (Style Number, Color, Size).
made_to_order	N	Boolean	Indicates whether the specified SKU should be listed on JOOR as made to order. If True, clears any existing inventory for the SKU.

Bulk Style Inventory POST/PUT Request Examples

POST/PUT | https://api.jooraccess.com/v2/bulk-inventory
Updates inventory listed in data per warehouse and date.

POST/PUT | https://api.jooraccess.com/v2/bulk-inventory/?overwrite=1
Overwrites existing inventory stored in JOOR for warehouse specified in call and replaces with listed data.

POST/PUT | https://api.jooraccess.com/v2/bulk-inventory/?dec_pending=1
Updates inventory listed in data per warehouse/date and deduct the stock from pending orders in the quantities received.

Request Example

<inventory_items>
    <inventory_item>
        <warehouse>New York</warehouse>
        <inventory_date>IMMEDIATE</inventory_date>
        <style_number>DM142A2101</style_number>
        <style_identifier>DM142A210191</style_identifier>
        <color_code>HPRVTG</color_code>
        <size>32</size>
        <inventory>26</inventory>
    </inventory_item>
    <inventory_item>
        <warehouse>New York</warehouse>
        <inventory_date>IMMEDIATE</inventory_date>
        <upc>822508068753</upc>
        <inventory>200</inventory>
    </inventory_item>
    <inventory_item>
        <warehouse>New York</warehouse>
        <inventory_date>IMMEDIATE</inventory_date>
        <style_id>707901</style_id>
        <style_color_id>1517829</style_color_id>
        <size>28</size>
        <inventory>10</inventory>
    </inventory_item>
    <inventory_item>
        <warehouse>New York</warehouse>
        <inventory_date>2014-12-01</inventory_date>
        <style_number>DM142A2101</style_number>
        <style_identifier>DM142A210191</style_identifier>
        <color_code>HPRVTG</color_code>
        <size>32</size>
        <inventory>26</inventory>
    </inventory_item>
    <inventory_item>
        <warehouse>New York</warehouse>
        <inventory_date>2014-12-01</inventory_date>
        <upc>822508068753</upc>
        <inventory>200</inventory>
    </inventory_item>
    <inventory_item>
        <warehouse>New York</warehouse>
        <inventory_date>2014-12-01</inventory_date>
        <style_id>707901</style_id>
        <style_color_id>1517829</style_color_id>
        <size>28</size>
        <inventory>10</inventory>
    </inventory_item>
    <inventory_item>
        <warehouse>Los Angeles</warehouse>
        <inventory_date>2014-12-01</inventory_date>
        <style_number>XXXXXX</style_number>
        <style_identifier>DM142A210191</style_identifier>
        <color_code>CC2</color_code>
        <size>S</size>
        <made_to_order>true</made_to_order>
    </inventory_item>
</inventory_items>

{
  "inventory_items": [
    {
      "warehouse": "New York",
      "inventory_date": "IMMEDIATE",
      "style_number": "DM142A2101",
      "style_identifier": "DM142A210191",
      "color_code": "HPRVTG",
      "size": "32",
      "inventory": 26
    },
    {
      "warehouse": "New York",
      "inventory_date": "IMMEDIATE",
      "upc": "822508068753",
      "inventory": 200
    },
    {
      "warehouse": "New York",
      "inventory_date": "IMMEDIATE",
      "style_id": 707901,
      "style_color_id": 1517829,
      "size": "28",
      "inventory": 13
    },
    {
      "warehouse": "New York",
      "inventory_date": "2014-12-01",
      "style_number": "DM142A2101",
      "style_identifier": "DM142A210191",
      "color_code": "HPRVTG",
      "size": "32",
      "inventory": 26
    },
    {
      "warehouse": "New York",
      "inventory_date": "2014-12-01",
      "upc": "822508068753",
      "inventory": 200
    },
    {
      "warehouse": "New York",
      "inventory_date": "2014-12-01",
      "style_id": 707901,
      "style_color_id": 1517829,
      "size": "28",
      "inventory": 13
    },
    {
      "warehouse": "Los Angeles",
      "inventory_date": "2014-12-01",
      "style_number": "SELVD12",
      "style_identifier": "SELVD12",
      "color_code": "HPRVTG",
      "size": "32",
      "made_to_order": "true"
    }
  ]
}

Response Example

<bulk_inventory>
    <response>
        <code>0</code>
        <comment />
        <log_id>1d4cb115-cb2c-4ee5-9f96-440a48e3ef04</log_id>
    </response>
    <items_updated>
        <inventory_item>
            <warehouse>New York</warehouse>
            <inventory_date>IMMEDIATE</inventory_date>
            <style_number>DM142A2101</style_number>
            <style_identifier>DM142A210191</style_identifier>
            <color_code>HPRVTG</color_code>
            <size>32</size>
            <inventory>26</inventory>
        </inventory_item>
        <inventory_item>
            <warehouse>New York</warehouse>
            <inventory_date>IMMEDIATE</inventory_date>
            <upc>822508068753</upc>
            <inventory>200</inventory>
        </inventory_item>
        <inventory_item>
            <warehouse>New York</warehouse>
            <inventory_date>IMMEDIATE</inventory_date>
            <style_id>707901</style_id>
            <style_color_id>1517829</style_color_id>
            <size>28</size>
            <inventory>10</inventory>
        </inventory_item>
        <inventory_item>
            <warehouse>New York</warehouse>
            <inventory_date>2014-12-01</inventory_date>
            <style_number>DM142A2101</style_number>
            <style_identifier>DM142A210191</style_identifier>
            <color_code>HPRVTG</color_code>
            <size>32</size>
            <inventory>26</inventory>
        </inventory_item>
        <inventory_item>
            <warehouse>New York</warehouse>
            <inventory_date>2014-12-01</inventory_date>
            <upc>822508068753</upc>
            <inventory>200</inventory>
        </inventory_item>
        <inventory_item>
            <warehouse>New York</warehouse>
            <inventory_date>2014-12-01</inventory_date>
            <style_id>707901</style_id>
            <style_color_id>1517829</style_color_id>
            <size>28</size>
            <inventory>10</inventory>
        </inventory_item>
        <inventory_item>
            <warehouse>Los Angeles</warehouse>
            <inventory_date>2014-12-01</inventory_date>
            <style_number>XXXXXX</style_number>
            <style_identifier>DM142A210191</style_identifier>
            <color_code>CC2</color_code>
            <size>S</size>
            <made_to_order>true</made_to_order>
        </inventory_item>
    </items_updated>
    <items_not_updated />
</bulk_inventory>

{
  "response": {
    "comment": "",
    "code": "0",
    "log_id": "209d86b0-f596-45ce-a3ef-f7dff4db7ed2"
  },
  "items_updated": [
    [
      {
        "warehouse": "New York",
        "inventory_date": "IMMEDIATE",
        "style_number": "DM142A2101",
        "style_identifier": "DM142A210191",
        "color_code": "HPRVTG",
        "size": "32",
        "inventory": 26
      },
      {
        "warehouse": "New York",
        "inventory_date": "IMMEDIATE",
        "upc": "822508068753",
        "inventory": 200
      },
      {
        "warehouse": "New York",
        "inventory_date": "IMMEDIATE",
        "style_id": 707901,
        "style_color_id": 1517829,
        "size": "28",
        "inventory": 13
      },
      {
        "warehouse": "New York",
        "inventory_date": "2014-12-01",
        "style_number": "DM142A2101",
        "style_identifier": "DM142A210191",
        "color_code": "HPRVTG",
        "size": "32",
        "inventory": 26
      },
      {
        "warehouse": "New York",
        "inventory_date": "2014-12-01",
        "upc": "822508068753",
        "inventory": 200
      },
      {
        "warehouse": "New York",
        "inventory_date": "2014-12-01",
        "style_id": 707901,
        "style_color_id": 1517829,
        "size": "28",
        "inventory": 13
      },
      {
        "warehouse": "Los Angeles",
        "inventory_date": "2014-12-01",
        "style_number": "SELVD12",
        "style_identifier": "SELVD12",
        "color_code": "HPRVTG",
        "size": "32",
        "made_to_order": "true"
      }
    ]
  ],
  "items_not_updated": []
}