To successfully export, edit, and re-import product or variant properties, certain guidelines must be followed. The properties must be created in advance in the dashboard under Products > Definitions > Properties.
Note: It is recommended to download the file as a CSV file and edit it using Google Sheets.
Exporting the properties:
-
Log into the ikas Dashboard:
Sign into your ikas Dashboard.
-
Access products:
Click on the Products tab in the left menu and select Products.
-
Select export option:
Click the Export button in the top right corner. A window will open where you can define export details.
-
Choose export format:
Select the desired file type for the export (CSV or XLS).
-
Select format and details:
Choose whether to export the properties of Products or all Variants.
-
Export:
Click Export to save the file to your computer.
Editing the file in Google Sheets:
-
Open Google Sheets:
Open Google Sheets and create a new blank spreadsheet.
-
Import the file:
Click on File > Import > Upload > Browse and select the downloaded CSV file.
-
Adjust import settings:
A window will open. Leave the separator type set to "Automatically detect" and check the box for "Convert text to numbers, dates, and formulas".
-
Import the data:
Click "Import data" to load the CSV file into Google Sheets.
Editing the product properties:
A table with all products or variants will appear. Columns will be shown for the individual existing properties. The column names consist of the property type and the name of the property:
Saving and importing the edited file:
-
Save the Google Sheets file in the correct format:
Go to File > Download > Comma-separated values (CSV).
-
Import the file into the ikas Dashboard:
- Go to Products > Products in the dashboard and click Import in the top right.
- Select Product Properties or Variant Properties and click Next.
- Then select the new file and upload it.
For any assistance or if you have further questions, please let us know. You can contact us by phone at +49 7361 3893012 or email us at support@ikas.de.