Creating and Customizing a Solid Commerce Excel Template

Using spreadsheets is a fast and flexible way to manage your data.

Solid Commerce processes files by reading our unique column headers. Below we'll show you how to add column headers to a template.

 

Downloadable Templates:

 

What we'll cover:

  1. Creating or Customizing a Template Using the Manage Excel Columns Tool
  2. Using Inline Help for Additional Guidance
  3. Populating, Uploading, and Saving Your Template
  4. Related Articles

Creating or Customizing a Template Using the Manage Excel Columns Tool

If you know which columns you want to include in your file, you can type the headers into a blank excel spreadsheet. You can also paste the headers from another file.

If you aren't sure which columns are available, or would like some assistance building your template, we have dynamic help built right into our Solid Commerce Excel Tool. Here's how you use Manage Excel Columns to create or customize an Excel template:

1) In Excel, create a new workbook, or open an existing template.

2) Go to the Solid Commerce menu -> Click on the Manage Excel Columns button.

ecommerce_excel_tool_manage_excel_columns_v2.png

 

3) In the Select field groups pane on the left of the Manage Excel Columns window, check the box next to the type of data you need to upload.

4) In the list of Available Fields that appears, select any field you may want to use.

  • A description of the field and any required valid values will appear below.
  • Click the Add button to include the field in your Selected Fields list.

ecommerce_excel_tool_manage_excel_columns_window_amazon_price_fields.png

 

5) Use the Remove and Replace buttons to refine your Selected Fields list.

6) You can customize the order of the columns by clicking on the name of a field in the Selected Fields list and dragging it to a new position.

7) Click the Save button to add the Selected Fields to your file.

ecommerce_excel_tool_manage_excel_columns_window_save_button.png

 

8) The order of your columns does not matter. You can cut and insert the columns in any order you like.

Using Inline Help for Additional Guidance

To turn on the Inline Help tool, go to the Solid Commerce menu -> Click on the Turn inline help ON button.

ecommerce_excel_tool_turn_inline_help_on_button_v2.png

 

Here is what turning the Inline Help on does:

  • Adds color-coded backgrounds to your column headers. Product fields are yellow. Inventory fields are orange. Marketplace fields are green.
  • Adds descriptions to your column headers as notes.
  • Provides drop-down lists of valid values for any fields that need to be populated from a set list of choices.

ecommerce_excel_tool_inline_help_field_description_drop_down.png

 

A NOTE ON SEARS: If you sell on Sears Marketplace, turning Inline Help on also adds the Convert Sears file to SC format button to the Solid Commerce menu. This button will convert the files you download from Sears into a format Solid Commerce can read. See the Related Articles for more details about Sears.

Populating, Uploading, and Saving Your Template

1) To populate your template, add information into the appropriate columns. Each product gets its own row on the spreadsheet.

2) To upload your file, go to the Solid Commerce menu -> Click on the Upload Data button.

ecommerce_excel_tool_populated_upload_v2.png

 

3) Once you finish your template, save it so you can use it next time you need to update more products.

Related Articles:

 

Back to top

 

The attachments from the top of the 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.