Mass Inventory Update

If you want to update a lot of items and it is too time-consuming to find them and update them by browsing your My Inventory pages, you can Mass Update your inventory via an XML file. How you generate that file is up to you.

The following is a sample file containing 2 items to be updated. Detailed explanation of all tags follows. Each item in your file goes through thorough verification before being accepted for upload. If there is an error on an item, the verification process will show you the error and ask you to correct your file and re-submit it.

This page assumes that you are familiar with the different inventory fields and their constraints and therefore does not explain in detail how each of those fields works.

Sample File:
<INVENTORY>
    <ITEM>
        <LOTID>2516600</LOTID>
        <PRICE>.10</PRICE>
        <QTY>+50</QTY>
        <BULK>1</BULK>
        <CONDITION>N</CONDITION>
    </ITEM>
    <ITEM>
        <LOTID>2516602</LOTID>
        <PRICE>2.75</PRICE>
    </ITEM>
</INVENTORY>
Tags:
Each file must begin with a <INVENTORY> tag and end with a </INVENTORY> tag.
Each item you are updating must begin with a <ITEM> tag and end with a </ITEM> tag.

Each tag must begin with its own tag and end with a corresponding closing tag. The only required tag is the LOTID which is the ID of the lot to update. The system will update only those fields which you entered for each item in your file with the new values entered in those tags. If a a field you are updating is the same as the existing field for that lot then that field will not be updated. If a field is to be updated then the value of the field will show in bold on the verification page.

<LOTID> (Required) Lot ID (Field Explanation)
This is the ID of the lot which you want to update. If the lot does not exist, an error will show but you will still be able to submit your updates. This is due to the fact that a buyer might buy the lot at any time and thus delete it from your inventory.
<DELETE> (Optional) Enter Y to delete the lot.
<PRICE> (Optional) Price (Field Explanation)
<QTY> (Optional) Quantity (Field Explanation)
Has to have a + (plus) or - (minus) sign in front of it. You can only add or subtract quantity, not set it to a new value because quantity can change when buyers submit orders in your store.

If you are subtracting quantity and the current quantity minus the requested subtracted quantity is less than or 0 at the time the update is verified (step 2) OR at the time the update is posted (step 3) then the update for the whole lot WILL NOT be posted. If this happens, an error message will show alerting you of the items in question showing you the current quantity and the requested subtracted quantity.

<BULK> (Optional) Bulk Amount (Field Explanation)
<DESCRIPTION> (Optional) Description (Field Explanation)
Cannot be blank if item was not listed from catalog
Cannot exceed 255 characters.
<EXTENDED> (Optional) Extended Description (Field Explanation)
Only allowed on Sets and Unsorted Lots
<CONDITION> (Optional) Condition (Field Explanation)
Valid values are N (New) and U (Used).
<SUBCONDITION> (Optional) Sub-Condition (Sets Only) (Field Explanation)
Valid values are C (Complete), I (Incomplete) and S (Sealed).
<SALE> (Optional) Sale (Field Explanation)
<REMARKS> (Optional) Seller's Remarks (Field Explanation)
<STOCKROOM> (Optional) Stockroom Item (Field Explanation)
Valid values are N (No) and Y (Yes).
<STOCKROOMID> (Optional) Multiple Stockroom ID (Field Explanation)
Valid values are A, B or C. Can be used with or without the STOCKROOM field.
<RETAIN> (Optional) Retain After Sold (Field Explanation)
Retains an item in inventory after it is sold out. Valid values are N (No) and Y (Yes).
<MYCOST> (Optional) My Cost (Field Explanation)
<MYWEIGHT> (Optional) Custom Weight (Field Explanation)
<TQ1>
<TP1>
<TQ2>
<TP2>
<TQ3>
<TP3>
(Optional, you must generate all 6 tags or none) Tiered Pricing (Field Explanation)
Tiered Quantity 1
Tiered Price 1
Tiered Quantity 2
Tiered Price 2
Tiered Quantity 3
Tiered Price 3
Additional Notes:
  • The XML update doesn't support the ampersand (&). Use &amp; instead of &.
  • The XML update doesn't support HTML tags. Use &lt; instead of < and &gt; instead of >

  • Maximum file size is 204800 bytes.
  • If the upload errors out in the middle, the whole file is rolled back and your inventory is returned to how it was before the file was uploaded.