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.