Configurator Spreadsheet Design
>>>>> gd2md-html alert: ERRORs: 0; WARNINGs: 0; ALERTS: 2.
Links to alert messages: >>>>> PLEASE check and correct alert issues and delete this message and the inline alerts. |
Configurator Spreadsheet Design
Create separate sheets for models and materials. You may also want to further subdivide items into different sheets, for example, sheets for different materials types. List the keys across the first row. Keys may include attribute names, metadata attribute names, tags, etc. Fill in the columns with the corresponding data for each item in the rows below.
Example of a models sheet:
Example of a materials sheet:
Export your sheets as csv files. In Google Sheets this can be done as follows:
File > Download > Comma-separated values (.csv, current sheet)
You can then follow the instructions for creating products from csv.
Depending on what keys you have included in your sheet, you may need to or want to include a data map for parsing your csv file to create products for import.
For example: