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.
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.