Configurator Spreadsheet Design

>>>>> gd2md-html alert: ERRORs: 0; WARNINGs: 0; ALERTS: 2.

See top comment block for details on ERRORs and WARNINGs.
In the converted Markdown or HTML, search for inline alerts that start with >>>>> gd2md-html alert: for specific instances that need correction.

Links to alert messages:

>>>>> PLEASE check and correct alert issues and delete this message and the inline alerts.

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:
Screen Shot 2020-11-13 at 11.05.40 AM.png

Example of a materials sheet:
Screen Shot 2020-11-13 at 11.05.52 AM.png

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:

async function createItemsFromCsv(csvFile, assetType) {
 const assets = await getAssetList(orgId, authToken, { type: assetType });

 const results = [];
 fs.createReadStream(csvFile)
   .pipe(csv())
   .on('data', (data) => results.push(data))
   .on('end', () => {
     const importData = results.map((row) => {
       const metadata = Object.entries(DATA_MAP.metadata).reduce(
         (acc, [key, val]) => {
           if (row[key]) {
             acc.push({ ...val, defaultValue: row[key] });
           }
           return acc;
         },
         []
       );

       const attributes = Object.entries(DATA_MAP.attributes).reduce(
         (acc, [key, val]) => {
           if (row[key]) {
             acc.push({ ...val, values: row[key].split(', ') });
           }
           return acc;
         },
         []
       );

       const product = {
         name: row[DATA_MAP.name],
         type: 'item',
         metadata,
         attributes,
         tags: row[DATA_MAP.tags] ? row[DATA_MAP.tags].split(', ') : [],
       };

       const asset = assets.find(
         ({ product }) => product.name === row[DATA_MAP.assetName]
       );
       const assetId = asset && asset.product.id;
       if (assetId) product.asset = { assetId, type: row[DATA_MAP.assetType] };
       return { query: { name: product.name }, product };
     });
     fs.writeFileSync(`${assetType}Items.json`, JSON.stringify(importData));
   });
}

Menu

In this article

Menu

Configurator Spreadsheet Design

In this article

Related articles