Inventory Spreadsheet Guide Overview
The Merchant inventory Excel spreadsheets are used to create
and update your inventory in bulk. There are two spreadsheets: the New Inventory
Spreadsheet used for creating new inventory and the Update Existing Inventory
Spreadsheet used to update inventory already in Merchant. For more information
on creating and updating inventory, see the “Create & Update Inventory with Spreadsheets”
tutorial. This guide lists the columns found on both spreadsheets
and how to use them. For each column name, the following information is listed:
| Definition: | What
information is used in this column? | | Required
Field: | Is the field required for every item to successfully
upload the spreadsheet? | | Data Type: | What
characters are supported for this field? - Numeric - Numbers only
- Alphabetic
- Letters only
- Alphanumeric - Any combination of letters, numbers, spaces,
or special characters
| | Special
Data Format: | Must the data be in a specific format? |
| Behavior/Dependencies: | Does
this field produce any special behavior?
Does this field depend upon other
spreadsheet fields or information already in Merchant? | | Special
Instructions: | How is this field used correctly? |
New Inventory Spreadsheet
The following information describes the field names (column
headings) found on the New Inventory Spreadsheet. The names are listed in the
order they occur on the spreadsheet.
| Auction
Title | | Definition: | Item
title | | Required Field: | Yes |
| Data Type: | Alphanumeric |
| Special Data Format: | No |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Inventory
Number | | Definition: | SKU
number or code | | Required
Field: | Yes |
| Data Type: | Alphanumeric |
| Special Data Format: | No
Code
must be unique | | Behavior/Dependencies: |
- For new inventory, SKU number must NOT currently exist in Merchant.
If any SKU on the spreadsheet exists in the system, the spreadsheet upload will
fail.
- If 2 items on spreadsheet have the SKU number, the second item will
be ignored.
| | Special
Instructions: | If your eBay category supports Pre-Filled
Item Specifics, you can use the UPC, MPU, etc code as your SKU number. This will
allow you to easily use Pre-Filled Item Specifics. For more information on Item
Specifics, see the Items Specifics Guide. |
| Quantity |
| Definition: | Item
quantity | | Required Field: | Yes |
| Data Type: | Numeric |
| Special Data Format: | Integer |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Starting
Bid | | Definition: | Item
starting bid price or start price | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Reserve |
| Definition: | Item
reserve price | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Weight |
| Definition: | Item
weight | | Required Field: | No |
| Data Type: | Numeric |
| Special Data Format: | Integer
or decimal number | | Behavior/Dependencies: | Weight
assumed to be in pounds. | | Special
Instructions: | |
| Weight
Units | | Definition: | Weight
units | | Required Field: | No |
| Data Type: | Alphabetic |
| Special Data Format: | Only
‘LB’ is currently supported | | Behavior/Dependencies: | |
| Special Instructions: | |
| Description |
| Definition: | Item
description | | Required Field: | No |
| Data Type: | Alphanumeric |
| Special Data Format: | No |
| Behavior/Dependencies: |
- Supports HTML
- Length limited by Excel cell constraints. The maximum
number of characters allowed by Excel per cell is 32,767.
|
| Special Instructions: | Because
it is difficult to type text in Excel, you will want to create descriptions outside
Excel, copy, and paste them. When you paste into Excel, make sure you paste into
the formula bar above the spreadsheet. If you attempt to paste directly into the
cell, Excel will paste the text across multiple cells. |
| Classification |
| Definition: | Item
classification | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: | If
the classification does not exist in Merchant, it will be created. You can see
your existing classifications by going to Inventory > Classifications |
| Special Instructions: | Use
in combination with the AttributeName and AttributeValue
columns. |
| Seller
Cost | | Definition: | Item
cost | | Required Field: | No |
| Data Type: | Numeric |
| Special Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Take-it
Price | | Definition: | Item
Take-it or Buy-It-Now price | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Retail
Price | | Definition: | Item
retail price | | Required Field: | No |
| Data Type: | Numeric |
| Special Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Second
Chance Offer Price | | Definition: | Item
second chance offer price | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Picture
URLs | | Definition: | URLs
for item images | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | Comma delimited list of URLs or filenames |
| Behavior/Dependencies: |
- Images do not need to be in the system before you upload the spreadsheet.
- If
you do not include the image placement tag name, they will be associated with
the image placement tags in the order you list the URLs on the spreadsheet.
|
| Special Instructions: |
- If you are hosting your images with ChannelAdvisor, you only need to
include the image filename. For example:
imageFile1.jpg, imageFile2.jpg,
imageFile3.jpg - If you are hosting your images yourself, you will
need to include the full URL to the image. For example:
http://www.mydomain.com/images/imageFile1.jpg,
http://www.mydomain.com/images/imageFile2.jpg, http://www.mydomain.com/images/imageFile3.jpg - To
associate images URLs with image placement tags, you need to include the placement
tag name. For example:
ITEMIMAGEURL3=imageFile1.jpg, ITEMIMAGEURL2=imageFile3.jpg,
ITEMIMAGEURL1=imageFile2.jpg |
| TaxProductCode |
| Definition: | Tax
code for the item | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: | This
code does not affect the calculation of tax for the item. | | Special
Instructions: | |
| Supplier
Code | | Definition: | Code
of the item supplier | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: | Supplier
must already exist in Merchant. To see a list of existing suppliers, go to Tools
> Suppliers | | Special
Instructions: | |
| Warehouse
Location | | Definition: | Location
of warehouse | | Required Field: | No |
| Data Type: | Alphanumeric |
| Special Data Format: | No |
| Behavior/Dependencies: | This
field does not control the Distribution Center information for the item. |
| Special Instructions: | |
| Ad
Template Name | | Definition: | Ad
template to be used for the item | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: |
- Ad template must already exist in Merchant. To see a list of ad templates,
go to Inventory > Ad Templates
- If you specify an Ad Template, you
must also specify a Posting Template.
|
| Special Instructions: | |
| Posting
Template Name | | Definition: | Posting
template to be used for the item | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: | Posting
template must already exist in Merchant. To see a list of posting templates, go
to Inventory > Posting Templates | | Special
Instructions: | |
| Schedule
Name | | Definition: | Schedule
to be used to post the item | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: |
- Schedule must already exist in Merchant. To see a list of schedules,
go to Inventory > Schedules
- If you specify a Schedule, you must
also specify a Posting Template.
|
| Special Instructions: | |
| Category
List | | Definition: | eBay
category number used for the ad | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | No | | Behavior/Dependencies: |
- You are able to insert an invalid category number however, the item will
not post with an invalid category number. To determine valid eBay category numbers,
go to Inventory > Ads and click
and select a category. - If you specify a Category List, you must also specify
a Posting Template.
| | Special
Instructions: | |
| Store
Category Name | | Definition: | Name
of the eBay store category used for the ad | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: |
- Category name must match a category name for your store. You can find
your store category names under Settings > General Settings
- If
you specify a Store Category Name, you must also specify a Posting
Template.
| | Special
Instructions: | |
| Attribute1Name
- Attribute20Name | | Definition: | Attribute
names used with your classifications | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: |
- If you do not specify a Classification,
this field will be ignored
- If the attribute field does not exist in the
classification, it will be created.
- The order of the attribute names on
the spreadsheet is not important. However, the attribute names on the spreadsheet
should match the attribute names of the classification in Merchant.
|
| Special Instructions: |
- Attribute names are used in conjunction with Classifications
and Attribute Values.
- Use attribute names
to use eBay’s Item Specifics. The attribute name does not need to match the attribute
name eBay uses. For more information on Item Specifics, see the Items Specifics
Guide.
|
| Attribute1Value
- Attribute20Value | | Definition: | Attribute
data about an item for an Attribute Name |
| Required Field: | No |
| Data Type: | Alphanumeric |
| Special Data Format: | No |
| Behavior/Dependencies: | If
you do not specify a Classification, this field
will be ignored. | | Special
Instructions: | - Attribute values are used in conjunction
with Classifications and Attribute
Names.
- To use eBay’s Item Specifics, the data you provide for an attribute
must match the item specific data eBay is expecting to receive. For more information
on Item Specifics, see the Items Specifics Guide.
|
| Ship
Zone Name | | Definition: | Name
of the zone in which this item can be shipped | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: |
- Name must match shipping zones already configured in your account. To
see a list of valid shipping zones, go to Settings > Account Ship-To Zones.
The zones are listed in the box labeled “Shipping Zones.”
- If you specify
a Ship Zone Name, you must also specify a Ship Carrier
Code and Ship Class Code.
|
| Special Instructions: | |
| Ship
Carrier Code² | | Definition: | Shipping
carrier code | | Required Field: | No |
| Data Type: | Alphabetic |
| Special Data Format: | No |
| Behavior/Dependencies: |
- If you specify a Ship Carrier Code, you must also specify a Ship
Class Code.
- Must match a valid shipping carrier code enabled in your
account.
| | Special
Instructions: | To see a list of valid shipping carrier codes,
do the following: - Go to the All Items view (Inventory > All Items)
- Click
 - On
the left side of the page, select the blue "click here" link.
- Scroll down
to the bottom of the page and click the “here” link. This will launch a popup
window that will display valid values for your shipping settings. Valid values
are listed in the “Carrier Code” column.
|
| Ship
Class Code² | | Definition: | Shipping
carrier class code | | Required
Field: | No | | Data
Type: | Alphabetic | | Special
Data Format: | No | | Behavior/Dependencies: |
- If you specify a Ship Class Code, you must also specify a Ship
Carrier Code.
- Must match a valid shipping class code enabled in your
account.
| | Special
Instructions: | To see a list of valid shipping class codes,
do the following: - Go to the All Items view (Inventory > All Items)
- Click
- On
the left side of the page, select the blue "click here" link.
- Scroll down
to the bottom of the page and click the “here” link. This will launch a popup
window that will display valid values for your shipping settings. Valid values
are listed in the “Carrier Code” column.
|
| Ship
Rate First Item | | Definition: | Shipping
charge for the first item | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Ship
Handling First Item | | Definition: | Handling
charge for the first item | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Ship
Rate Additional Item | | Definition: | Shipping
charge for each item after the first | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Ship
Handling Additional Item | | Definition: | Handling
charge for each item after the first | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
¹
Currency data can be entered with or without a $, as an integer, or as a decimal
number. Integer values are assumed to be whole dollar amounts. If you exceed 2
decimal places, the value will be rounded to the nearest cent when you upload
the spreadsheet into Merchant. ²
For each additional Ship Carrier/Class combination for the item, copy and paste
the last 7 cells as new columns (starting with the Ship Zone Name and ending with
Ship Handling Additional Item). You should do this for every Carrier/Class combination.
It is not necessary to rename the column headings. However, it is important that
you copy all 7 columns even if you do not plan to include data for some columns.
Update Existing Inventory Spreadsheet The
following information describes the field names (column headings) found on the
Update Existing Inventory Spreadsheet. The names are listed in the order they
occur on the spreadsheet.
| Auction
Title | | Definition: | Item
title | | Required Field: | No |
| Data Type: | Alphanumeric |
| Special Data Format: | No |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Inventory
Number | | Definition: | SKU
number or code | | Required
Field: | Yes |
| Data Type: | Alphanumeric |
| Special Data Format: | No
Code
must be unique | | Behavior/Dependencies: |
- For new inventory, SKU number MUST currently exist in Merchant.
If any SKU on the spreadsheet does not exist in the system, spreadsheet upload
will fail.
- If 2 items on spreadsheet have the SKU number, the second item
will be ignored.
- If you include a SKU number but no information for any
other column, the system will accept the spreadsheet and will not change any information
for that SKU.
| | Special
Instructions: | |
| Quantity
Update Type³ | | Definition: | Way
in which the updated quantity is calculated | | Required
Field: | No | | Data
Type: | Alphabetic | | Special
Data Format: | The only acceptable values are: - Absolute
- Relative
- Available
- In
Stock
| | Behavior/Dependencies: |
- If you specify a quantity update type, you must also specify a Quantity.
- Absolute
sets the current inventory quantity in Merchant for the item to the value of the
quantity indicated on the spreadsheet.
- Relative adds the value
of the quantity uploaded in the spreadsheet to the current inventory quantity
in Merchant. Negative numbers are accepted in the upload and will decrement the
current inventory quantity.
- Available takes the quantity uploaded
value, subtracts out the quantity contained in any open auctions, and sets the
remaining value as the inventory quantity in Merchant.
- In Stock
takes the quantity uploaded, subtracts out any quantity contained in open auctions
and items pending checkouts, and sets the remaining value as the inventory quantity
in Merchant.
| | Special
Instructions: | |
| Quantity |
| Definition: | Updated
item quantity | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Integer | | Behavior/Dependencies: |
| | Special
Instructions: | |
| Starting
Bid | | Definition: | Item
starting bid price or start price | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Reserve |
| Definition: | Item
reserve price | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Weight |
| Definition: | Item
weight | | Required Field: | No |
| Data Type: | Numeric |
| Special Data Format: | Integer
or decimal number | | Behavior/Dependencies: | Weight
assumed to be in pounds. | | Special
Instructions: | |
| Weight
Units | | Definition: | Weight
units | | Required Field: | No |
| Data Type: | Alphabetic |
| Special Data Format: | Only
‘LB’ is currently supported | | Behavior/Dependencies: | |
| Special Instructions: | |
| Description |
| Definition: | Item
description | | Required Field: | No |
| Data Type: | Alphanumeric |
| Special Data Format: | No |
| Behavior/Dependencies: |
- Supports HTML
- Length limited by Excel cell constraints. The maximum
number of characters allow per cell by Excel is 32,767.
|
| Special Instructions: | Because
it is difficult to type text in Excel, you will want to create descriptions outside
Excel, copy, and paste them. When you paste into Excel, make sure you paste into
the formula bar above the spreadsheet. If you attempt to paste directly into the
cell, Excel will paste the text across multiple cells. |
| Classification |
| Definition: | Item
classification | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: | If
the classification does not exist in Merchant, it will be created. You can see
your existing classifications by going to Inventory > Classifications |
| Special Instructions: | Use
in combination with the AttributeName and AttributeValue
columns. |
| Seller
Cost | | Definition: | Item
cost | | Required Field: | No |
| Data Type: | Numeric |
| Special Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Take-it
Price | | Definition: | Item
Take-it or Buy-It-Now price | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Retail
Price | | Definition: | Item
retail price | | Required Field: | No |
| Data Type: | Numeric |
| Special Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Second
Chance Offer Price | | Definition: | Item
second chance offer price | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Picture
URLs | | Definition: | URLs
for item images | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | Comma delimited list of URLs or filenames |
| Behavior/Dependencies: |
- Images do not need to be in the system before you upload the spreadsheet.
- If
you do not include the image placement tag name, they will be associated with
the image placement tags in the order you list the URLs on the spreadsheet.
|
| Special Instructions: |
- If you are hosting your images with ChannelAdvisor, you only need to
include the image filename. For example:
imageFile1.jpg, imageFile2.jpg,
imageFile3.jpg - If you are hosting your images yourself, you will
need to include the full URL to the image. For example:
http://www.mydomain.com/images/imageFile1.jpg,
http://www.mydomain.com/images/imageFile2.jpg, http://www.mydomain.com/images/imageFile3.jpg - To
associate images URLs with image placement tags, you need to include the placement
tag name. For example:
ITEMIMAGEURL3=imageFile1.jpg, ITEMIMAGEURL2=imageFile3.jpg,
ITEMIMAGEURL1=imageFile2.jpg |
| TaxProductCode |
| Definition: | Tax
code for the item | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: | This
code does not affect the calculation of tax for the item. | | Special
Instructions: | |
| Supplier
Code | | Definition: | Code
of the item supplier | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: | Supplier
must already exist in Merchant. To see a list of existing suppliers, go to Tools
> Suppliers | | Special
Instructions: | |
| Warehouse
Location | | Definition: | Location
of warehouse | | Required Field: | No |
| Data Type: | Alphanumeric |
| Special Data Format: | No |
| Behavior/Dependencies: | This
field does not control the Distribution Center information for the item. |
| Special Instructions: | |
| Attribute1Name
- Attribute20Name | | Definition: | Attribute
names used with your classifications | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: |
- If you do not specify a Classification,
this field will be ignored
- If the attribute field does not exist in the
classification, it will be created.
- The order of the attribute names on
the spreadsheet is not important. However, the attribute names on the spreadsheet
should match the attribute names of the classification in Merchant.
|
| Special Instructions: |
- Attribute names are used in conjunction with Classifications
and Attribute Values.
- Use attribute names
to use eBay’s Item Specifics. The attribute name does not need to match the attribute
name eBay uses. For more information on Item Specifics, see the Items Specifics
Guide.
|
| Attribute1Value
- Attribute20Value | | Definition: | Attribute
data about an item for an Attribute Name |
| Required Field: | No |
| Data Type: | Alphanumeric |
| Special Data Format: | No |
| Behavior/Dependencies: | If
you do not specify a Classification, this field
will be ignored. | | Special
Instructions: | - Attribute values are used in conjunction
with Classifications and Attribute
Names.
- To use eBay’s Item Specifics, the data you provide for an attribute
must match the item specific data eBay is expecting to receive. For more information
on Item Specifics, see the Items Specifics Guide.
|
| Ship
Zone Name | | Definition: | Name
of the zone in which this item can be shipped | | Required
Field: | No | | Data
Type: | Alphanumeric | | Special
Data Format: | No | | Behavior/Dependencies: |
- Name must match shipping zones already configured in your account. To
see a list of valid shipping zones, go to Settings > Account Ship-To Zones.
The zones are listed in the box labeled “Shipping Zones.”
- If you specify
a Ship Zone Name, you must also specify a Ship Carrier
Code and Ship Class Code.
|
| Special Instructions: | |
| Ship
Carrier Code² | | Definition: | Shipping
carrier code | | Required Field: | No |
| Data Type: | Alphabetic |
| Special Data Format: | No |
| Behavior/Dependencies: |
- If you specify a Ship Carrier Code, you must also specify a Ship
Class Code.
- Must match a valid shipping carrier code enabled in your
account.
| | Special
Instructions: | To see a list of valid shipping carrier codes,
do the following: - Go to the All Items view (Inventory > All Items)
- Click
- On
the left side of the page, select the blue "click here" link.
- Scroll down
to the bottom of the page and click the “here” link. This will launch a popup
window that will display valid values for your shipping settings. Valid values
are listed in the “Carrier Code” column.
|
| Ship
Class Code² | | Definition: | Shipping
carrier class code | | Required
Field: | No | | Data
Type: | Alphabetic | | Special
Data Format: | No | | Behavior/Dependencies: |
- If you specify a Ship Class Code, you must also specify a Ship
Carrier Code.
- Must match a valid shipping class code enabled in your
account.
| | Special
Instructions: | To see a list of valid shipping class codes,
do the following: - Go to the All Items view (Inventory > All Items)
- Click
- On
the left side of the page, select the blue "click here" link.
- Scroll down
to the bottom of the page and click the “here” link. This will launch a popup
window that will display valid values for your shipping settings. Valid values
are listed in the “Carrier Code” column.
|
| Ship
Rate First Item | | Definition: | Shipping
charge for the first item | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Ship
Handling First Item | | Definition: | Handling
charge for the first item | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Ship
Rate Additional Item | | Definition: | Shipping
charge for each item after the first | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
| Ship
Handling Additional Item | | Definition: | Handling
charge for each item after the first | | Required
Field: | No | | Data
Type: | Numeric | | Special
Data Format: | Currency¹ |
| Behavior/Dependencies: | |
| Special Instructions: | |
¹
Currency data can be entered with or without a $, as an integer, or as a decimal
number. Integer values are assumed to be whole dollar amounts. If you exceed 2
decimal places, the value will be rounded to the nearest cent when you upload
the spreadsheet into Merchant. ²
For each additional Ship Carrier/Class combination for the item, copy and paste
the last 7 cells as new columns (starting with the Ship Zone Name and ending with
Ship Handling Additional Item). You should do this for every Carrier/Class combination.
It is not necessary to rename the column headings. However, it is important that
you copy all 7 columns even if you do not plan to include data for some columns. ³
The following example demonstrates how your inventory quantities will be affected
using the different Quantity Update Types. In this example, you have set the update
quantity in the Excel spreadsheet to "5". For that SKU, you have 10 items Available
in Merchant, 3 are Open in current auctions and 2 have closed and are awaiting
checkout. Therefore, you would have a total of 15 items currently in the system.
| Update
Quantity | Available | Open | Pending
Checkout | | 5 | 10 | 3 | 2 |
After you upload the spreadsheet, the number of
available items you will have will be:
| Quantity Update Type | Calculation | New
Quantity Available | Notes | | ABSOLUTE | None | 5 | Uses
only the Update Quantity | | RELATIVE | 10+5=15 | 15 | Adds
the Update Quantity to Available | | AVAILABLE | 5-3=2 | 2 | Subtracts
Open from the Update Quantity | | IN
STOCK | 5-3-2=0 | 0 | Subtracts
Open and Pending Checkout from the Update Quantity |
|
 |
|
