Importing Products
Introduction
To import products via CSV, you will need to upload your products using the Convictional Products CSV template.
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 |
Type | The type of product. Can also be category. | Hats, Bicycles |
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" |
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. “,”)
- All Option Names need to be consistent across the full column.
Uploading
You can upload your Products CSV in the Products tab.
Updating Inventory by CSV
To update your inventory, simply upload another copy of your Products CSV but with updated inventory figures. This is also uploaded 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.
