UPS organizes information into three distinct levels: Product, Inventory, and Marketplace. The three levels are a fundamental concept. They have influenced the layout of the site, the steps for creating products, and the process for uploading files. Understanding the three levels makes the platform easier to use.
What we'll cover:
- Overview of the Three Levels of Information
- Product Level Information
- Inventory Level Information
- Marketplace Level Information
- Examples of Each Level of Information
- Related Articles
Overview of the Three Levels of Information
It helps to think of the three levels as a pyramid.
The Product information is the foundation. Inventory information is added to Product info. Marketplace information is added to control your listings.
To help differentiate the three levels, we use color coding in the UPS Excel Tool. Product fields are yellow. Inventory fields are orange. Marketplace fields are green.
- Click the Turn inline help ON button in the UPS Excel menu to automatically add the color coding to your column headers.
Product Level Information
Product Level information is info that characterizes your products. Product Level information doesn't change, regardless of which Warehouse or marketplace you add the products to.
Examples of Product Level fields include: UPC and Model Number.
To create a new product in UPS, the only required fields are: product custom sku and product name.
Products can be created without assigning them a quantity or listing them to a marketplace.
Inventory Level Information
Inventory Level information includes data specific to a Warehouse or Vendor Inventory List.
You can add a product to multiple Warehouses, with each Warehouse having a different quantity, storage location, and acquisition cost.
Marketplace Level Information
Once your products are loaded to a Warehouse, you are ready to list them. To do so, you add your marketplace specific details and save them in a UPS Market List.
Marketplace Level information varies for each marketplace, but examples include: price, title, and category.
When active listings are imported from a marketplace, we automatically save all of the imported data in the correct level of information.
Examples of Each Level of Information
This table contains some key fields. It is not exhaustive. If you would like a comprehensive list, open an Excel spreadsheet and click on the Manage Excel Columns button in the UPS menu.
|Product||Product Name, SKU, UPC, Weight, custom Product Attributes (such as Size, Color, etc.), image URLs, descriptions for each marketplace|
|Inventory||Quantity, Warehouse Name, Cost, Storage Location|
All Marketplaces: Market Auto Rule, List Name, PO Sources, Quantity Expression
eBay: eBay BIN, eBay Start Bid, Apply eBay Template, eBay Category, eBay Store Category, Shipping Fees, Parent SKU, eBay Variation Group
Amazon: Amazon Sell Price Exp, Amazon Comments (Condition Notes), Amazon Catalog (for creating new listings using Amazon's Flat Files)
- Creating Products Using a Spreadsheet
- Adding a Product to a Warehouse Using a Spreadsheet
- Creating a Product Through the User Interface
- Adding a Product to a Warehouse Through the User Interface
- Updating Quantity, Cost, and Storage Location
- Listing a Product to eBay Using a Spreadsheet
- Listing a Product That Exists in Amazon's Catalog Using a Spreadsheet
- Creating and Customizing a UPS Excel Template