Adding Products to a Warehouse Using a Spreadsheet

This article will show you how to use a spreadsheet to add products to a Warehouse or Vendor Inventory List.

 

Downloadable Templates for Adding Products to inventory
The template at the bottom of this article has two tabs to help you add products to a Warehouse or Vendor Inventory List.

 

What we'll cover:

  1. Before You Add Products to Inventory
  2. Key Fields
  3. Uploading a Spreadsheet
  4. Adding Products to Inventory As You Create Them
  5. Adding a Product to a Market List
  6. Related Articles
  7. Downloadable Templates for Adding Products to inventory

 

Before You Add Products to Inventory

Products need to exist in your Solid Commerce account before you can add them to a Warehouse. Please see the Related Articles section for articles about creating products and Warehouses/Lists.

 

Key Fields

Required Fields
results Leave this field blank. It will automatically populate if you upload the file using the Solid Commerce Excel Add-In Tool.
product custom sku The SKUs of your products. The maximum length is 50 characters.
warehouse id The Warehouse IDs of your products. The maximum length is 50 characters.
warehouse name The name of the Warehouse or Vendor Inventory List you want to add your product to.

qty

The number of individual units you have in stock.

 

The following table includes only the most popular optional fields.

To view the few optional fields not included in the table, click on the Manage Excel Columns in the Solid Commerce Excel Add-In Tool. For more information on using the Manage Excel help, please see Creating and Customizing a Solid Commerce Excel Template.

Optional Fields
cost The cost of acquiring the product from your supplier.
storage location
The product's bin location in your physical warehouse.
product name
Pasting your Product Names into your Inventory file can make it easier to see which products you are adding to inventory.

 

Uploading a Spreadsheet

To upload your file using our Excel Add-In Tool, click the Upload Data button and check only the Update Inventory box.

inventory_management_adding_products_inventory_update_excel_upload.png
 

 

To upload your file through our web uploader, go to the Products menu -> Import Products and Inventory. Check the Import Inventory box.

inventory_management_adding_products_inventory_update_web_uploader_ui.png

 

Adding Products to Inventory As You Create Them

Once people understand how to create products, and add them to a Warehouse, they usually populate their product and inventory data on the same spreadsheet. That way they can create new products, and add them to inventory, with just one upload.

The Products & Inventory tab of the attached file can be used as a template to create new products and add them to a Warehouse.

When you upload your populated file, select both the Product and Inventory updates.

 

Adding a Product to a Market List

In order to list your products on a marketplace, you need to add them to a Market List. Check out our articles about listing to the Marketplaces for more info.

 

Related Articles

 

Back to top

Downloadable Templates for Adding Products to inventory

  • Add to Inventory tab — Includes the required columns, and the two most popular optional columns, for adding existing products to inventory.
  • Products & Inventory tab — Includes the required columns, and some basic optional columns, for creating products and adding them to inventory. You need to modify the product attribute:{attribute name} and {marketplace} description column headers before using them. To learn how, see the instructions in the Optional Fields table of the Creating Products Using a Spreadsheet article.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.