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
url of images to import, comma-separated
e.g.: "https://www.example.com/image3.png,https://www.exemple.com/image4.png"
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".
