Understanding How Solid Commerce Organizes Data - The Three Levels of Information: Product, Inventory, and Marketplace

Solid Commerce 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:

  1. Overview of the Three Levels of Information
  2. Product Level Information
  3. Inventory Level Information
  4. Marketplace Level Information
  5. Examples of Each Level of Information
  6. 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 Solid Commerce Excel Tool. Product fields are yellow. Inventory fields are orange. Marketplace fields are green.

  • Click the Turn inline help ON button in the Solid Commerce Excel menu to automatically add the color coding to your column headers.

Product_Inventory_and_Marketplace_Pyramid.png

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 Solid Commerce, 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 Solid Commerce 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 Solid Commerce menu.

Level Key Fields
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
Marketplace

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)

Related Articles

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

Comments

0 comments

Please sign in to leave a comment.