Master Project Spreadsheet Guide

Introduction

The Master Project Spreadsheet (MPS) gathers essential information required to initiate a project on Cylindo CMS. It acts as the project brief, defining the scope and providing a comprehensive overview of the project.

The responsibility for populating the MPS lies with the client, as they possess specialized knowledge about their own products. This task is crucial and must be completed for every project involving new products or materials, as well as for any subsequent updates. By diligently maintaining the MPS, clients ensure accuracy and efficiency throughout the project lifecycle.

MPS Product List

Before we can start a project on Cylindo CMS, you will need to list every product in the MPS with a code, name, family, and dimensions.

Product Code

Product codes must be unique, meaning the same code cannot be assigned to multiple products. It's crucial to avoid using spaces before or after the code, as well as special characters. This code serves as the value that your integration or web team will utilize to integrate the product on your website via the API. This means that even the tiniest typo, such as adding an unintended extra space before or after the code in the spreadsheet, can disrupt the connection to your site. Hence, meticulous attention to detail is necessary to ensure seamless functionality.

Product Name

The product names must be unique, but they do not affect integration therefore it’s not crucial to be exact. We recommend including the product family in the product name for clarity (e.g., Dreamer Two Seater instead of just Two Seater). Opting for descriptive names that indicate characteristics like orientation (left or right-facing), sectional design, or sleeper functionality is beneficial. These names will be reflected in filenames when exporting 2D images using the Create tool, aiding in clarity and organization.

Product Family

A grouping of items within a range or collection. By categorizing similar products together, we streamline processes and ensure consistency among products that share certain elements, such as sofa legs, armrests, and cushions, across all size variants within the family.

URL

When possible, you can provide a link to the specific product on your webpage, though it's not mandatory. This can be helpful when your website can offer additional information, but it's important to note that this does not substitute the necessity to upload references on the CMS.

Dimensions

The only essential measurement is the Bounding Box dimensions, but additional dimensions like Seat height, Seat depth, and Armrest width are appreciated and can be added as extra columns on the MPS. Fill in numbers only, using commas if needed (no periods). Choose between Inches or Centimeters from the dropdown menu. Please enter only one dimension per field to ensure the information can be transferred onto the Cylindo CMS without errors.

97dfbb5c-1896-48db-ae51-b75fe9656fc0.png

Product Class

At Cylindo, we are using 13 distinct Product Classes, each grouping product types with similar production complexity, which simplifies the evaluation of production effort and timelines.

Reference Product Class Categories included in the Product Class

Upholstered Seating

(Not Reclining)

 
Armchair, Accent Chair, Sofa, Sectional Module, Sectional Configuration, Chaise, Daybed, Lounge Seating, Accent Chair, Lounge Chair, Sofa Bed, Outdoor non-wicker Daybed, Outdoor non-wicker Sofa, Outdoor non-wicker Swivel Chair, Outdoor non-wicker Lounger

Seating Reclining 

Recliner Chair, Recliner Sofa, Recliner Sectional
 

Tables 

Coffee, Console, End, Side, Dining, Bistro, Desk, Outdoor non-wicker Tables, Outdoor non-wicker Table, Conference Desk 

Case Goods

Media Console, Sideboard, Nightstand, Dresser, Chest, Cabinet, Office Pedestal, Closet, Bookcase, Mirror, Bar Cart 
 

Beds

Bed, Bunk Bed 

Chairs & Non Upholstered Seating

Dining Chair, Stackable Chair, Bar, Counter Stool, Guest Chair, Rocking Chair, Outdoor non-wicker Dining Chair, Outdoor non-wicker Chair, Outdoor non-wicker Bar, Counter Stool, Outdoor non-wicker Sofas 

Seating Accessories 

Pouf, Ottoman, Footstool, Bench, Outdoor non-wicker Ottoman 
 

Product Add Ons 

Accent Pillow, Lumbar, Headrest, Armrest, Headboard, Footboard, Hardware 
 

Rugs & Wall Art

Rugs, Wall Art

Wicker Furniture

Ottoman, Chair, Sofa, Sectional,  Modular, Bar, Counter Stool,  Dining Table,  Table, Storage Box, Hanging Chair, Lounge 

Reusing Existing Products

Product Sets, Flipped Products

Office Chairs & Desks 

Office Chairs, Office Desks 
Custom 

Custom

Lights, Sheds, Pergolas, Call Booths, Mattresses, Sets (dining sets example) 

 

Features and Options

A feature refers to any product characteristic that provides users with multiple options to configure the product. Identifying the features and listing the options in the MPS is relatively simple if a product has only one or two features, such as fabric selection and a few leg finishes. However, this process can become more complicated if there are many features, especially if these features have specific rules and some options are incompatible with others. In such cases, we recommend taking some extra time to ensure that all details are included and correct to avoid incorrect product logic being set for the 3D models on Cylindo CMS.

Feature codes are crucial for integration with your website. In the example above, "Upholstery" and "Leg Finish" are feature codes representing specific choices users can make that affect how the product looks. If you used the feature code “Fabric” instead of “Upholstery” in your integration, the API will not be able to serve the correct images. 

Options refer to the available choices listed under each feature. If a feature has only one option, it won't be displayed unless specifically requested. Option codes play a vital role in integration. Typically, we use material codes as option codes, unless specified otherwise. 

For extensive lists of options, we suggest creating collections in a separate tab within the MPS and then using the collection name in the list of options. In the example below, a collection named "Upholstery Materials" has been established with 207 options in a separate tab, which is then linked to the product list.

MPS Material List

This list is the go-to for knowing exactly what 3D materials we need and the key info before we begin.

Material Code

Material codes must be unique and precise, avoid adding spaces before or after the code, or using special characters. These codes serve as the value utilized by your integration or web team to connect the viewer to your website, and any minor typographical error can disrupt this connection.

Material Name

A material name should be unique within its own family, but it can be duplicated if the material belongs to a different family, provided that you include the family name in the material name itself. For example, you might have materials named "Boucle Red" and "Helio Red," where "Boucle" and "Helio" are family names. While it's preferable for the material name to match your website or ERP system, it's not mandatory as the name doesn't impact integration processes.

Material Family

A material family in Cylindo refers to a grouping of materials that share the same texture. Within a family, there can be numerous color variations, provided that they maintain consistent properties such as surface roughness and sheen.

Material Type

Select the material type from the dropdown provided (Fabric, Leather, Plastic, Wood etc). This is crucial because the requirements and production processes differ between various material types, such as fabrics versus hard finishes.

Manufacturer

While it's not mandatory to fill in this field, providing the material manufacturer can assist us in identifying materials we have previously produced.

Pattern and Centerpoint

Check the boxes for materials that are patterned and specify if there is a specific point that should be centered on the 3D assets we will produce.

Sample Received

Cylindo Photo Studio will check the box for "Sample Received" upon delivery of the shipment.

Related to:

Was this article helpful?

1 out of 2 found this helpful
Have more questions? Submit a request