In Magnetiq you can use a 'comma-separated values' file or 'CSV' - so called because it ends with .csv - to import, update and export products in bulk and their details at a time.
Before you begin
CSV files can be edited in many ways, including:
cloud software like Google Sheets
installed software like Libre Office
Microsoft Excel
Note: make sure it's saved as a CSV file (ending with the .csv suffix). Some software - notably Excel - will attempt to change format to its own file format, ending in something else eg .xlsx.
If you want more information about CSV files, how they work, and how to use them with the different softwares, read the article: How to use CSV files
Starting with the Template
You can download and view our template CSV file here:
The sample file contains some example products and some related variants (if you use the sample file to create your own import file, then make sure that you remove the example products).
Product CSV format
CSV header: the first row must include the field headers described in the sample file, in the same order.
Product data: subsequent rows in the file should contain data for your products.
Each product must have 2 (or more) rows:
1. One row with the general product data
Item SKU: The SKU of the product. Visually it's a box in the line sheet. Each Item SKU can have multiple variants. If you want to show the variants as boxes in the line sheet, you can repeat the same Item SKU in the CSV file with a dedicated variant for each item.
Line: You can assign a Line to each product. For example, Clothing, Accessories etc.
Category: You can assign a Category to each product. For example, T-Shirts, Tops, Trousers, Jeans, etc.
Name: The name of your product. For example, Satin Blazer
Description: The description of the product. You can break lines inside the text to create paragraphs.
2. At least one row, or multiple rows, with the variants related to the product
Variant SKU: The SKU of the Variant. This will be used to associated media files related to the product. The Variant is represented by the combination of the value you will enter in the following fields: Color, Option 1, Option 2.
Color: Variant color. For example, Black.
Option 1 Name: If the variant has a first option, then enter its name. For example, Size
Option 1 Value: If the variant has a first option, then enter its value. For example, M
Option 2 Name: If the variant has a second option, then enter its name. For example, Length
Option 2 Value: If the variant has a first option, then enter its value. For example, 32
Multilingual content
If your showroom is set to be multilingual, you can add translations of product names and descriptions.
Translations must be added in the CSV file with the following syntax:
Item SKU | Line | Category |
1234567890 | #fr#Vêtements pour Hommes | #fr#PANTALONS |
Each translation must begin with #, followed by the 2-letter ISO 639 language code (https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes), and then another #.
All translations must be in the same cell divided by line breaks. The line break can be created with the symbol ↵, if you create the CSV with a text editor, or inside Excel with Alt+Enter (https://support.microsoft.com/en-us/office/start-a-new-line-of-text-inside-a-cell-in-excel-33e41eab-8b5e-4193-93d6-9a06ecf812b3#ID0EBBF=Windows).
If you don't translate a term (like French in the Color example below), Magnetiq will use the text of the default language (eg #en#)
Variant SKU | Color | Variant 1 Name | Variant 1 Value |
1234567890_B | #en#0194-Navy blue | #fr#Taille | XS |
If you don't specify any translation (like in the Variant 1 Value above), Magnetiq will use the existing text for all languages.
Updating existing product data
If you want to make changes to your products, you need to export your products first.
In the Products section, go to the "Manage Products" box, select a collection (if you want to work on the data of a specific collection), then click on "Download CSV with current data".
Before you change the CSV file, make sure you make a copy of it, so that you have a backup of your product data.
Adding product or variants: To add Products or Variants, simply add the desired rows inside the CSV, while paying attention not to delete any data.
Modifying products or variants: If you want to modify one or more items or variants, modify the pertinent rows with the new data.
Deleting products: Identify the row related to the Item SKU you want to delete, and then delete it.
Uploading the CSV file
Once you've completed your CSV file, go to the Products section > Manage Products box:
select the Collection you want to update
select your CSV file (make sure it's been saved in .csv format)
click "Import Products"
Importing product prices
The following step might be to import your product prices. You can do it with a CSV file, as explained in the related article: Importing prices with a CSV file