Excel Add-In Tool FAQs

Q: Which versions of Excel are supported?

A: Excel 2010 or newer running on Windows operating system Windows 7 or newer.

Q: What is the latest version of the UPS Excel Add-In Tool?

A: The latest version is: 2016.12.1007.23330

You can find the version by selecting the UPS menu and clicking the About button.

The tool automatically updates itself. If you don't have the latest version, we recommend uninstalling and reinstalling the Add-In Tool. You can find instructions in the "Uninstall and Reinstall the Excel Tool" section of Troubleshooting the UPS Excel Add-In Tool When It's Not Visible.

Q: What are the required fields in Excel when performing an upload to my UPS account?

A: That depends on the kind of data you’re looking to upload.

To Create a New SKU

To create a new SKU on your account the two required fields are "Products Name" and "Product Custom SKU."

To Update an Existing SKU

If you are updating data for an existing SKU, required fields are determined by the level where the data will be entered:

  1. Update to Product data -> Requires “Product Custom SKU”.
  2. Update to Inventory data -> Requires “Warehouse ID” and “Warehouse Name”.
  3. Update to Marketplace data-> Requires “Product Custom SKU” “Warehouse ID” and “List Name”.


All other data fields are optional.


Q: Where do I find my “Warehouse Name”  and/or “List Name”?

A: The “Warehouse Name” value is the name of the virtual warehouse which you have created in your Inventory Manager.

To find that value:

Open your UPS account -> Products tab -> Inventory Manager -> Click on "+" by the Warehouses to expand the list of warehouse names -> select the desired list.


Vendor Inventory List names are also populated under the “Warehouse Name” column.


To find these:

Inventory Manager OR “My Vendors” -> Click on "+" by the desired vendor -> select the Vendor Inventory list name.


The Vendor Inventory list value, not the Vendor's name, should be populated in Excel.


Q: My Excel Add-in Tool was visible and it suddenly disappeared. How can I add it back?

A: Please follow the steps in Troubleshooting the UPS Excel Add-In Tool When It's Not Visible.


Q. Why can I not find the Add-In icon / why doesn’t it work?

A. Please follow the steps in Troubleshooting the UPS Excel Add-In Tool When It's Not Visible.


Q. Long numbers in my spreadsheet appear as 239457E+10, how can I change this?

A. This is because the spreadsheet is set for scientific notation.

To change this, you will need to view the data as text.  In Excel: select the desired column -> select the "Data" tab -> click "Text to Columns" -> click "Next" -> click "Next" ->> in the last window, choose the radio button marked "Text" -> click "OK."


Q. How can I work with just a few items during an upload from Excel?

A. The Add-In Tool uploads from top to bottom and stops when it reaches a blank row.  To limit the number of items you want to work with, simply add a blank row where you want the upload to stop.


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request



Article is closed for comments.