All Collections
Data and reports
Import products from a spreadsheet (CSV file)
Import products from a spreadsheet (CSV file)

How to add products to your catalog by importing a CSV file

JD avatar
Written by JD
Updated over a week ago

Adding or updating products can be done in bulk using CSV files.

Before you begin

The file to import must be in CSV format. Software like Microsoft® Excel®, Google® Sheets®, or Apple® Numbers® supports CSV files. 

The following product attributes may be imported from a file:

  • SKU

  • Title

  • Short Description

  • Long Description

  • Unit Of Measure

  • Unit Cost

  • Unit Price

  • Tax Exempt

  • Labels/Manufacturer

  • Images

  • Barcode

The following updates may be performed on a product using a CSV file:

  • Add labels/manufacturer

  • Add images 

  • Change any other attribute except the SKU

  • Delete a product

How to format your file

 A sample CSV file is provided from the CSV import view.

Important note on attribute update vs. deletion

If you leave a cell empty, QuoteMachine will assume you want to remove the content.

On the example below, the title for the item with SKU "SAM-4K-HD" will be removed after the import. 

When reimporting/updating products, you should only keep columns with fields you would like to update.

Columns you can use in your CSV file

sku

  • The Product SKU. It's recommended to always provide one as it is the unique identifier. If you import a product with a sku already in the catalog, QuoteMachine will update the product in the catalog rather than creating a new one

title

  • The product title 

short_description

  • The product short description 

long_description

  • The product long description 

unit_of_measure

  • The unit of measure. The default unit to enter is "piece"

Unit of measure

Enter into CSV unit_of_measure field

Asset

asset

Centimeter

centimeter

Cubic meter

cubic-meter

Day

day

Episodes

episodes

Foot

foot

ft^2

square-foot

Gallon

gallon

Gigabyte

gigabyte

Gram

gram

Hour

hour

Hours & Minutes

hours-minutes

Inch

inch

Kilogram

kilogram

Kilometer

kilometer

Liter

liter

Megabyte

megabyte

Meter

meter

Mile

mile

Milliliter

milliliter

Minute

minute

Month

month

Ounce

ounce

Pages

pages

Participants

participants

Person

person

Pound

pound

Quarter

quarter

Servings

servings

Square meter

square-meter

Talents

talents

Ton

ton

Travels

travels

Unit

unit

Users

users

Yard

yard

Year

year

unit_cost

  • The product cost. Should be formatted without specifying a currency or thousand separators
    e.g.: 3125.15

unit_price

  • The product price. Should be formatted without specifying a currency or thousand separators
    e.g.: 3125.15

tax_exempt

  • Specify if the product is tax exempt by entering "TRUE" or "FALSE" 

labels

  • list of labels or manufacturers, comma-separated.
    e.g.: "red,fabric,samsung"
    By default, all the values here will be imported as labels. But you can turn any label into a manufacturer tag from the label interface after the import

image_links

barcode

  • The product barcode 

deleted  

  • If you want to delete the product (for a given SKU), enter "TRUE" 

Import your file

Click on the "CSV Import" button from the Catalog.

Upload your CSV file and click "Start now"

Your import will show in the list of imports with the status "started"

After some time, you can refresh the page.
If the import is completed, the status will change to "Completed".

 

Did this answer your question?