Creating / Editing Database Items

• Distressing Option
• Door Option
• Door Profiles - Applied
• Door Profiles - Inside
• Door Profiles - Outside
• Door Profiles - Panel
• Door Styles
• Drawer Box Type
• Drawer Front Styles
• Finish Option
• Material - Exterior
• Material - Interior
• Material Sheet
• Modifications
• Products
• Reveal Option
• Size Restrictions
• Users

Distressing Option

Getting to the Distressing Option List

Navigate to the list of distressing options by clicking Bidding > Distressing Options on the database admin dashboard. Clicking on the name of any distressing option in this list will allow you to edit that distressing option.

Distressing Option Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of distressing option.
  • Available: When false, will not show up in the list of distressing options on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this distressing option.
  • Description: Description of the distressing option, shows up on the site.
  • Price Per Sq Ft: Price per square foot for this distressing option.
  • Image Original: Can upload a single image this distressing option.

• XML Export

  • Export Value: This will overwrite the name of the distressing option that is exported to Microvellum. If blank, the name of the distressing option will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.
    

• Availability

  • Product Line: This distressing option will be available in all of the selected product lines.
  • Material Exterior Categories: This distressing option will be available to any of the exterior materials in the selected categories.
  • Material Exterior: Select any specific exterior material that this distressing option should be available on.

Door Option

Getting to the Door Option List

Navigate to the list of door options by clicking Bidding > Door Options on the database admin dashboard. Clicking on the name of any door option in this list will allow you to edit that door option.

Door Option Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of door option.
  • Available: When false, will not show up in the list of door options on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this door option.
  • Description: Description of the door option, shows up on the site.
  • Price Per Door: Price per door for this door option.
  • Price Per Door: Price per drawer front for this door option.
  • Category: Which category is this door option a part of.
  • Image Original: Can upload a single image this door option.

• XML Export

  • Export Value: This will overwrite the name of the door option that is exported to Microvellum. If blank, the name of the door option will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.
    

• Availability

  • Product Line: This door option will be available in all of the selected product lines.
  • Door Styles: This door option will be available to any of the selected door styles.

Door Profiles - Applied

Getting to the Applied Molding List

Navigate to the list of applied profiles by clicking Bidding > Door Profiles - Applied on the database admin dashboard. Clicking on the name of any applied molding in this list will allow you to edit that applied molding.

Applied Molding Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of applied molding.
  • Available: When false, will not show up in the list of applied moldings on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this applied molding.
  • Upcharge Per Door: Price per door for this applied molding.
  • Description: Description of the applied molding, shows up on the site.
  • Image Original: Can upload a single image this applied molding.

• XML Export

  • Export Value: This will overwrite the name of the applied molding that is exported to Microvellum. If blank, the name of the applied molding will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.
    

• Availability

  • Product Line: This applied molding will be available in all of the selected product lines.
  • Door Styles: This applied molding will be available to any of the selected door styles.

Door Profiles - Inside

Getting to the Inside Profile List

Navigate to the list of inside profiles by clicking Bidding > Door Profiles - Inside on the database admin dashboard. Clicking on the name of any inside profile in this list will allow you to edit that inside profile.

Inside Profile Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of inside profile.
  • Available: When false, will not show up in the list of inside profiles on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this inside profile.
  • Description: Description of the inside profile, shows up on the site.
  • Upcharge Per Door: Price per door for this inside profile.
  • Image Original: Can upload a single image this inside profile.

• XML Export

  • Export Value: This will overwrite the name of the inside profile that is exported to Microvellum. If blank, the name of the inside profile will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.
    

• Availability

  • Product Line: This inside profile will be available in all of the selected product lines.
  • Door Styles: This inside profile will be available to any of the selected door styles.

Door Profiles - Outside

Getting to the Outside Profile List

Navigate to the list of outside profiles by clicking Bidding > Door Profiles - Outside on the database admin dashboard. Clicking on the name of any outside profile in this list will allow you to edit that outside profile.

Outside Profile Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of outside profile.
  • Available: When false, will not show up in the list of outside profiles on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this outside profile.
  • Description: Description of the outside profile, shows up on the site.
  • Upcharge Per Door: Price per door for this outside profile.
  • Image Original: Can upload a single image this outside profile.

• XML Export

  • Export Value: This will overwrite the name of the outside profile that is exported to Microvellum. If blank, the name of the outside profile will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.
    

• Availability

  • Product Line: This outside profile will be available in all of the selected product lines.
  • Door Styles: This outside profile will be available to any of the selected door styles.

Door Profiles - Panel

Getting to the Panel Profile List

Navigate to the list of panel profiles by clicking Bidding > Door Profiles - Panel on the database admin dashboard. Clicking on the name of any panel profile in this list will allow you to edit that panel profile.

Panel Profile Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of panel profile.
  • Available: When false, will not show up in the list of panel profiles on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this panel profile.
  • Description: Description of the panel profile, shows up on the site.
  • Image Original: Can upload a single image this panel profile.

• Pricing

  • Upcharge Per Door: Price per door for this panel profile.
  • Material Type: Which type of material is used (hardwood, veneer, or custom). Determines which material factor should be used.
  • Custom Material Factor: Custom material price if Material Type is custom.

• Availability

  • Product Line: This panel profile will be available in all of the selected product lines.
  • Door Styles: This panel profile will be available to any of the selected door styles.

• XML Export

  • Export Value: This will overwrite the name of the panel profile that is exported to Microvellum. If blank, the name of the panel profile will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.

Door Styles

Getting to the Door Style List

Navigate to the list of door styles by clicking Bidding > Door Styles on the database admin dashboard. Clicking on the name of any door style in this list will allow you to edit that door style.

Door Style Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of door style.
  • Available: When false, will not show up in the list of door styles on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this door style.
  • Buyout: Mark as true if this is a buyout door.
  • Description: Description of the door style, shows up on the site.
  • Base Price: Base cost per door, not including finishes and other options.
  • Wood Type to Use: Required Veneer or Hardware, used to determine if the hardwood factor or the veneer factor should be used.
    
  • Image Original: Can upload a single image for this door style.

• Options

  • Allow Inside Profile: Makes inside profiles available for this door style.
  • Allow Outside Profile: Makes outside profiles available for this door style.
  • Allow Panel Profile: Makes panel profiles available for this door style.
  • Allow Applied Molding: Makes applied moldings available for this door style.
  • Allow Stile and Rail: Makes stile and rail widths available for this door style.
  • Allow Door Options: Makes door options available for this door style.
  • Available Drawer Fronts: List of drawer fronts available for this door style.
  • Available Inside Profiles: List of inside profiles available for this door style.
    
  • Available Outside Profiles: List of outside profiles available for this door style.
    
  • Available Panel Profiles: List of panel profiles available for this door style.
    
  • Available Applied Moldings: List of applied moldings available for this door style.
    
  • Available Door Options: List of door options available for this door style.
    
  • Available Stile Widths: List of stile widths available for this door style.
    
  • Available Rail Widths: List of rail widths available for this door style.
    
  • Available Thicknesses: List of door thicknesses available for this door style.

• Availability

  • Product Line: This door style will be available in all of the selected product lines.
  • Material Exterior Categories: This door style will be available to any of the materials in the selected exterior material categories.
  • Material Exterior: Select any specific exterior materials that this door style should be available on.

• Defaults

  • Default Drawer Front: Default drawer front for this door style.
  • Default Rail Width: Default rail width for this door style.
  • Default Stile Width: Default stile width for this door style.
  • Default Inside Profile: Default inside profile for this door style.
  • Default Outside Profile: Default outside profile for this door style.
  • Default Panel Profile: Default panel profile for this door style.
  • Default Door Options: Default door options for this door style.
  • Default Thickness: Default door thickness for this door style.
  • Default Applied Molding: Default applied molding for this door style.

• XML Export

  • Export Value: This will overwrite the name of the door style that is exported to Microvellum. If blank, the name of the door style will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.

Drawer Box Type

Getting to the Drawer Box List

Navigate to the list of drawer boxes by clicking Bidding > Drawer Box Types on the database admin dashboard. Clicking on the name of any drawer box in this list will allow you to edit that drawer box.

Drawer Box Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of drawer box.
  • Available: When false, will not show up in the list of drawer boxes on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this drawer box.
  • Description: Description of the drawer box, shows up on the site.
  • Product Line: This drawer box will be available in all of the selected product lines.
  • Base Price: Base price for this drawer box.
  • Bottom Material Factor: Square footage price for the bottom material of this drawer box.
  • Side Material Factor: Square footage price for the side material of this drawer box.
  • Drawer Glide Choices: The selected drawer glides will be available for this drawer box.
  • Image Original: Can upload a single image this drawer box.

• XML Export

  • Export Value: This will overwrite the name of the drawer box that is exported to Microvellum. If blank, the name of the drawer box will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.

Drawer Front Styles

Getting to the Drawer Front Style List

Navigate to the list of drawer front styles by clicking Bidding > Drawer Front Styles on the database admin dashboard. Clicking on the name of any drawer front style in this list will allow you to edit that drawer front style.

Drawer Front Style Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of drawer front style.
  • Available: When false, will not show up in the list of drawer front styles on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this drawer front style.
  • Buyout: Mark as true if this is a buyout drawer front.
  • Description: Description of the drawer front style, shows up on the site.
  • Base Price: Base cost per drawer front, not including finishes and other options.
  • Image Original: Can upload a single image for this drawer front style.

• XML Export

  • Export Value: This will overwrite the name of the drawer front style that is exported to Microvellum. If blank, the name of the drawer front style will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.

• Availability

  • Product Line: This drawer front style will be available in all of the selected product lines.
  • Door Styles: Select any specific door style that this drawer front style should be available on.

Finish Option

Getting to the Finish Option List

Navigate to the list of finish options by clicking Bidding > Finish Options on the database admin dashboard. Clicking on the name of any finish option in this list will allow you to edit that finish option.

Finish Option Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of finish option.
  • Available: When false, will not show up in the list of finish options on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this finish option.
  • Description: Description of the finish option, shows up on the site.
  • Price per Sq Ft: Price per square foot for this finish option.
  • Category: Which category is this finish option a part of.
  • Image Original: Can upload a single image this finish option.

• XML Export

  • Export Value: This will overwrite the name of the finish option that is exported to Microvellum. If blank, the name of the finish option will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.
    

• Availability

  • Product Line: This finish option will be available in all of the selected product lines.
  • Material Exterior Categories: This finish option will be available to any of the exterior materials in the selected categories.
  • Material Exterior: Select any specific exterior material that this finish option should be available on.
    

Material - Exterior

Getting to the Exterior Material List

Navigate to the list of exterior materials by clicking Bidding > Material - Exteriors on the database admin dashboard. Clicking on the name of any exterior material in this list will allow you to edit that exterior material.

Exterior Material Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of exterior material.
  • Available: When false, will not show up in the list of exterior materials on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this exterior material.
  • Description: Description of the exterior material, shows up on the site.
  • Shop Notes: Any custom office / shop notes, only visible to shop staff users.
  • Product Line: This exterior material will be available in all of the selected product lines.
    
  • Solidwood Factor: Price per square foot for hardwood items.
  • Veneer Factor: Price per square foot for veneer items.
  • Category: Which category this exterior material belongs to.
  • Image Original: Can upload a single image to this exterior material.
  • Material Sheet: Can select multiple sheets sizes that this material is available in.

• Options

  • Material Door Styles: These are the door styles that are available to this exterior material.
  • Allow Finishes: When checked, this material allows for finish options to be added.
  • Material Finishes: These are the finish options that are available to this exterior material.
  • Allow Distressing: When checked, this material allows for distressing options to be added.
  • Material Distressing: These are the distressing options that are available to this exterior material.
  • Allow Sheen: When checked, this material allows for a sheen to be added.
  • Material Sheens: These are the sheens that are available to this exterior material.
  • Allow Finished Ends: Deprecated When checked, finished ends are allowed for this exterior material.
  • Available Interiors with Fin Ends: Deprecated These are the available interior materials for finished ends.

• XML Export

  • Export Value: This will overwrite the name of the exterior material that is exported to Microvellum. If blank, the name of the exterior material will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.

• Unused...

  • Three Quarter Veneer Price Per Sheet: Deprecated Price per sheet.
  • Three Quarter Veneer Price Per Sq Ft: Deprecated Price per square foot.
  • Solidwood Price Per Bd Ft: Deprecated Price per board foot.

Material - Interior

Getting to the Interior Material List

Navigate to the list of interior materials by clicking Bidding > Material - Interiors on the database admin dashboard. Clicking on the name of any interior material in this list will allow you to edit that interior material.

Interior Material Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of interior material.
  • Available: When false, will not show up in the list of interior materials on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this interior material.
  • Description: Description of the interior material, shows up on the site.
  • Shop Notes: Any custom office / shop notes, only visible to shop staff users.
  • Product Line: This interior material will be available in all of the selected product lines.
    
  • Adj Factor: Price of material interior, this is calculated based on the sheet cost of the material, marked up by 30%, then divided by the average item base price ($300).

    • adj_factor = ((sheet_price * markup_percent) + sheet_price) / average_base_price

  • Image Original: Can upload a single image to this interior material.
  • Material Sheet: Can select multiple sheets sizes that this material is available in.

• XML Export

  • Export Value: This will overwrite the name of the interior material that is exported to Microvellum. If blank, the name of the interior material will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.

Material Sheet

Getting to the Material Sheet List

Navigate to the list of material sheets by clicking Bidding > Material Sheets on the database admin dashboard. Clicking on the name of any material sheet in this list will allow you to edit that material sheet.

Material Sheet Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of material sheet.
  • Available: When false, will not show up in the list of material sheets on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this material sheet.
  • Description: Description of the material sheet, shows up on the site.
  • Shop Notes: Any custom office / shop notes, only visible to shop staff users.
  • Category: Which category this material sheet belongs to.
  • Size Restrictions: Min / Max width, height, thickness of this material sheet.
  • Special Order Sheet: Check if this material sheet is special order.
  • Override Size Restrictions: When checked, the size restriction for this material overrides the size restrictions of the product.

• Sheet Info

  • Width: Width of sheet.
  • Height: Length of sheet.
  • Thickness: Thickness of sheet.
  • Priority: Priority of sheet between 1 and 10, 1 being high priority 10 being low priority. This is used when determining which sheet size restrictions to check first.
  • Stock Quantity: The amount of sheets we have in stock for this material sheet (not currently used).

• Vendor

  • Vendor: Select which vendors we can get this sheet size from (will be removed and moved to the Material Interior / Material Exterior).
  • Purchase Price: Price we are purchasing for the sheet (will be removed and moved to the Material Interior / Material Exterior).
  • Vendor Lead Time: Lead time for material sheet in days (will be removed and moved to the Material Interior / Material Exterior).
  • Vendor Item Number: SKU / Vendor ID of material sheet (will be removed and moved to the Material Interior / Material Exterior).
  • Web Link: URL to material sheet (will be removed and moved to the Material Interior / Material Exterior).

• XML Export

  • Export Value: This will overwrite the name of the material sheet that is exported to Microvellum. If blank, the name of the material sheet will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.

• Availability

  • Material Exterior: Selected exterior materials that this material sheet applies to.
  • Material Interior: Selected interior materials that this material sheet applies to.

Modifications

Getting to the Modification List

Navigate to the list of modifications by clicking Bidding > Modifications on the database admin dashboard. Clicking on the name of any modification in this list will allow you to edit that modification.

Modification Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of modification.
  • Available: When false, will not show up in the list of modifications on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this modifications.
  • Description: Description of the modification, shows up on the site.
  • Category: This is the category of the modification, the modification will show up in this category on the site.
  • Size Restrictions: Min / Max width, height, and depth of this modification.
    
  • Display Images: Can upload a single image or multiple images to a modification. Descriptions of images will show up under the image when the image is clicked. The order number of the image is used to determine the order the images are displayed.

• Pricing

  • Total Price: This price is generally used to cover the cost of manufacturing the most basic version of this modification.
  • Flat Rate Mod: When checked, no markups will be applied to this modification's price (no dealer markup).
  • Price Formulas: Here you can add any existing price formula to this modification. For more information on price formulas, see the pricing articles.

• Behavior

  • On/Off Behavior: JavaScript formula that determines if this modification should be auto added to a product.
  • On/Off Qty: JavaScript formula that returns the qty of the mod when it is auto added to a product.
  • Behavior Products: Select any product that this mod should be auto added too. The On/Off Behavior still has to evaluate to true for the mod to be auto added to these products.
  • Behavior Reason: This should be a short description of why a modification is auto added to a product, it will show up anytime the modification is auto added.
  • Allow Custom Quantity: When true, the user can input their own quantity for this modification. If this is false, the modification quantity will be locked.
  • Locked Qty Formula: This formula returns the quantity of the modification. If Allow Custom Quantity is true, the user can unlock the quantity and put in their own value.

• Availability

  • Product Line: This modification will be available in all of the selected product lines.
  • Product Categories: This modification will be available to any of the products in the selected product categories. This applies down through any of the sub categories, for example, if you select cabinet the modification will be available on any category that starts with cabinet (cabinet -> base, cabinet -> base -> door/open, etc.)
  • Products: Select any specific product that this modification should be available on.

• Attributes

  • Attribute Templates: List of attributes on this modification, this should only be used to remove / check which attributes are on a modification, not to add them to the modification.

• Vendor Info

  • Vendor: Dropdown list of which vendor we purchase this modification from.
    
  • Item Number: The vendor item number of this modification.
  • Web Link: URL to modification on vendor's site.
  • Purchase Price: How much we pay for this modification.

• Other

  • Labor Hours: Number of hours spent in labor for this modification (doesn't currently do anything).
  • Labor Rate: Dollars per hour rate of labor for this modification (doesn't currently do anything).
  • Labor Cost: Total labor cost for this modification (doesn't currently do anything).

• XML Export

  • Export Value: This will overwrite the name of the modification that is exported to Microvellum. If blank, the name of the modification will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.

Products

Getting to the Product List

Navigate to the list of products by clicking Bidding > Products on the database admin dashboard. Clicking on the name of any product in this list will allow you to edit that product.

Product Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of product.
  • Available: When false, will not show up in the list of products on the site.
  • Shop Staff Only: When true, only shop staff users can see / add this product.
  • Product Line: This product will be available in all of the selected product lines.
    
  • Cabinet Type: This is the category of the product, the product will show up in this category on the site.
  • Description: Description of the product, shows up on the site.
  • Shop Notes: Any custom office / shop notes, only visible to shop staff users.
  • Display Images: Can upload a single image or multiple images to a product. Descriptions of images will show up under the image when the image is clicked. The order number of the image is used to determine the order the images are displayed.

• Width, Height, Depth

  • Default Width (X): Default width of product.
  • Default Width (Y): Default height of product.
  • Default Width (Z): Default depth of product.
  • Allow Zero: When checked, a value of zero will be a valid input for width, height, and depth.
  • Lock Width: Doesn't allow user input for width (locked at default value).
  • Lock Height: Doesn't allow user input for height (locked at default value).
  • Lock Depth: Doesn't allow user input for depth (locked at default value).

• Pricing

  • Base Price: This price is generally used to cover the cost of manufacturing the most basic version of this product.
  • Flat Rate: When checked, no markups will be applied to this product's price (no dealer markup).
  • Formula Alias: Deprecated This was previously used to map the product to one of the built-in pricing formulas. This has been replaced by the Price Formulas field.
  • Num Doors: Number of doors on this product.
  • Num Drawers: Number of drawer boxes on this product.
  • Num False Drawer Fronts: Number of false fronts on this product (no drawer box attached).
  • Num Panels: Number of door panels on this product (wainscot).
  • Width (X) Adjustment Factor: For cabinets only. Used to adjust the base price of the cabinet based on the difference between the width of the product being ordered is to the default width. For example, a adjustment factor of 1.2 for a product ordered 2" larger than the default value will add $2.40 to the base price.
  • Height (X) Adjustment Factor: For cabinets only. Used to adjust the base price of the cabinet based on the difference between the height of the product being ordered is to the default height. For example, a adjustment factor of 1.2 for a product ordered 2" larger than the default value will add $2.40 to the base price.
  • Depth (X) Adjustment Factor: For cabinets only. Used to adjust the base price of the cabinet based on the difference between the depth of the product being ordered is to the default depth. For example, a adjustment factor of 1.2 for a product ordered 2" larger than the default value will add $2.40 to the base price.
  • Oversize Width Threshold: Number value, when the product width is larger than this value, the Oversize Width Charge will be added.
  • Oversize Height Threshold: Number value, when the product height is larger than this value, the Oversize Height Charge will be added.
  • Oversize Depth Threshold: Number value, when the product depth is larger than this value, the Oversize Depth Charge will be added.
  • Oversize Width Charge: Dollar value added to product when width exceeds the Oversize Width Threshold.
  • Oversize Height Charge: Dollar value added to product when height exceeds the Oversize Height Threshold.
  • Oversize Depth Charge: Dollar value added to product when depth exceeds the Oversize Depth Threshold.
  • Price Formulas: Here you can add any existing price formula to this product. For more information on price formulas, see the pricing articles.

• Defaults / Options

  • Num Shelves: Default number of shelves on the product. When set to zero, shelves will not be available in this product.
  • Use Hinges: When true, hinges will be available on this product.
  • Use Toe Kick: Check if the product you are adding has a toe kick.
  • Allow Modifications: When true, users will be able to add mods to this product.
  • Available Hinging: Any selected value will be an available hinging option for this product.

• Size Restrictions

  • Size Restrictions: Default size restrictions. Min / Max width, height, and depth of this product.
  • Use Material Size Restrictions: When checked, the material size restrictions will override the product size restrictions.
  • Use Interior Material: Check if this product is made of the cabinet box interior material and should use that material's size restrictions.
  • Size Relations: This is a list of any size restrictions that apply to this cabinet. Each size restriction can have a formula that determines when it should be used. If no formulas evaluate to true, the default size restrictions are used.

• Modifications

  • Item Modifications: Can be used to specify which modifications are available to this product.
  • Exclude Modifications: Can be used to exclude any modifications that were added to this product from any of it's Cabinet Types.
  • Behavior Modifications: These are modifications that will be added automatically to this product if their behavior formula evaluates to true. An example of this is the Lateral Stabilizer mod for cabinets with drawer boxes that exceed 36" wide.

• Attributes

  • Attribute Templates: List of attributes on this product, this should only be used to remove / check which attributes are on a product, not to add them to the product.

• Labels

  • Required These are all self-explanatory, you can use them to override the default label for any built-in product fields. 

• Misc

  • Default Finished Interior: When checked, the product will always start with a finished interior.
  • Need Width for Blind: Check if this is a blind cabinet that should ask for the door width.
  • Need RPE Info: Check if this product needs stile / rail information.
  • Equivalent Units: Needed for the "Equivalent Units" shipping formula. Not needed if you're not using that shipping formula.
  • Lock Quantity at 1: When true, the product will remain locked at a quantity of 1.
  • Reveal Type: Base, Wall, Tall, or None. Will determine which room level default reveals will be used for this product. If None, the reveals fields will not show on the product.
    
  • 3D Model: 3D Model file (.GLTF) that will display in the 3D cabinet viewer (.GLTF and .BIN are required).
  • 3D Model Bin File: 3D Model file (.BIN) that will display in the 3D cabinet viewer (.GLTF and .BIN are required).

• XML Export

  • Export Value: This will overwrite the name of the product that is exported to Microvellum. If blank, the name of the product will be exported.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.

Reveal Option

Getting to the Reveal Option List

Navigate to the list of reveal options by clicking Bidding > Reveal Options on the database admin dashboard. Clicking on the name of any reveal option in this list will allow you to edit that reveal option.

Reveal Option Editor

This section will explain what each field means.

• Main

  • Available: When false, will not show up in the list of reveal options on the site.
  • Name: Required Display name of reveal option.
  • Decimal Value: Value of reveal as a decimal.
  • Description: Description of the reveal option, shows up on the site.
  • Shop Notes: Description of the reveal option, only shows up on the site to shop staff users.
  • MV Prompts: This is a list of properties that will be exported to Microvellum. Can use any of the variables shown on this tab.
  • Product Line: This reveal option will be available in all of the selected product lines.

Size Restrictions

Getting to the Size Restriction List

Navigate to the list of size restrictions by clicking Bidding > Size Restrictions on the database admin dashboard. Clicking on the name of any size restriction in this list will allow you to edit that size restriction.

Size Restriction Editor

This section will explain what each field means.

• Main

  • Name: Required Display name of size restriction.
  • Minimum Width (X): The minimum width that an item can be.
  • Minimum Height (Y): The minimum height that an item can be.
  • Minimum Depth (Z): The minimum depth that an item can be.
    
  • Maximum Width (X): The maximum width that an item can be.
  • Maximum Height (Y): The maximum height that an item can be.
  • Maximum Depth (Z): The maximum depth that an item can be.
  • Priority: This is the level of priority assigned to this size restriction (1 being highest priority and 10 being lowest priority).
  • On/Off Behavior: This JS code is used to determine if the size restriction should be used. This needs to return either null, true or false. If true then the size restriction will be used, if false, the other size restrictions will be evaluated until a true value is returned. This is only used for products that have more than one size restriction linked to it.

Users

Getting to the User List

Navigate to the list of users by clicking Authentication and Authorization > Users on the database admin dashboard. Clicking on the name of any user in this list will allow you to edit that user

User Editor

This section will explain what each field means.

• Main

  • Username: Required Display name / login of user.
  • Password: Required Secure hashed password, raw passwords are not stored.

• Personal Info

  • First Name: User first name.
  • Last Name: User last name.
  • Email Address: User email address.

• Permissions

  • Active: When true, the user will be able to login.
  • Staff Status: When true, the user is a shop staff member and will have full access to all dealership orders.
  • Superuser Status: Designates that this user has all permissions without explicitly assigning them.
  • Groups: Used to group users into specific groups. As of right now, there is only a project managers group.
  • User Permissions: This can be used to set database admin permissions that can limit how much a shop staff user can do / see in the database admin.

• Important Dates

  • Last Login: Date and time of the last time the user logged in. This get set every time the user logs in with their username / password.
  • Date Joined: Date and time that the user first logged in / created their account.

• More Info

  • Phone Number: User's phone number.
  • Avatar: User's profile image, can be set by the user on the site.

• Admin Settings

  • Shop Staff: When true, the user is a shop staff member and will have full access to all dealership orders.\
  • Is Developer: When true, the user has additional access to developer only tools on the site.
  • Database Administrator: When true, the user has access to the database admin site.

• Dealership

  • Dealership: Select which dealership this user belongs to.
  • Dealer Membership Approved: This gets set to true once a user's request to join a dealership has been approved.
  • Dealer Admin: When true, this user can see / edit all the orders at their specific dealership. They also have the ability to deactivate and add new user's to their dealership.

• Notifications

  • CC Emails: List of carbon copy emails that will be included with any email that is sent to the main email address.
  • Dealer Submitted: Send an email when an order is submitted.
  • Shop Approved: Send an email when an order is shop approved.
  • Dealer Approved: Send an email when an order is dealer approved.
  • Resources: Send an email when a document is added to the resources page.