Importing Products

Jessica Powell Updated by Jessica Powell

Introduction

To import products via CSV, you will need to upload your products using the Convictional Products CSV template.

Note: If you are connecting with a modern ecommerce platform then your products will automatically sync into the Products tab.

Template

You can find a template for uploading products here.

To make a copy, select File > Make A Copy, and that will create an editable template. To create a local copy, select File > Download.

Once completed, your Products CSV should have lines that look like this:

12345,A Great Product,Vendor,Beauty,“Tags, Tags, Tags”,54321,A Great Variant,4,9.99,https://img.url.com, <p>Product description.</p>, Size, 2, Color, Black

A description of each of these elements is outlined below:

Elements

Element Name

Description

Example

Code (required)

Your unique code for this product

12345

Title

A short description of your product

A Great Product

Vendor

Your brand or the product brand

Company Name

Tags

Tags for the product

Toronto, Handmade

SKU

Unique SKU for the variant

shirt-blue-xl, 12345678

Title

Description of the the variant

Handmade Blue Shirt XL

Inventory

The current stock level

0 or greater

Price (required)

The retail price for the variant

$0 or greater

Image URL

The URL for this variant's image

https://img.url.com/

HTML Body

The HTML body for the website display

<p>Product Description</p>

Option1 Name

The name of the first option

"Size"

Option1 Value

The value for the variant

"Size 4" or "4"

Option2 Name

The name of the second option

"Color"

Option2 Value

The value for this variant

"Black"

Option3 Name

The name of the third option

"Folded?"

Option3 Value

The value for this variant

"Yes"

Remember to leave empty spaces for optional fields if you do not want to complete them.
Retail price is the price the product sells for.
Base price is the price you offer to your buyer.

Requirements

  • Code is required and determines the product. All the variants of a product should have the same code.
  • If the upload fails, check the format or ask support to review the file.
  • The file type must be CSV. Excel (.xls) format is not allowed. 
  • Send variants up in the order you want them to appear (ie. Small, Medium, Large)
  • Leave empty spaces for empty or optional fields (ie. “,”)

Uploading

You can upload your Products CSV in the Products tab.

Next Steps

Once you're done uploading your products, you'll have to create a price list for your products.

Here's how you upload a price list.

How did we do?

Adding a Buy Button to a Shopify Store

Contact