Show Menu
Cheatography
  1. Home >
  2. Business and Marketing >

PLM's Cheatsheet to Complete Prices Cheat Sheet (DRAFT) by

Please review all steps to make sure the Price Lists for your Products are correct and up to date.

This is a draft cheat sheet. It is a work in progress and is not finished yet.

OVERVIEW

Use this support to review Price Lists (price) for your products and make sure prices are up to date.

1 - Price List Tabs in Excel File

 
Price for the product should be created in 'Price List' tab in the same Excel file used for Config­ura­tion. You should not create new files.
 
1 product = 1 Excel file = 1 produc­tio­n/s­amp­le/ship from location
 
If a product has defined prices only in one currency, it should only have one price list tab, for example 'Pricelist EU' or 'Pricelist US'. If a product has defined prices in both EUR and US currencies, 2 separate tabs are required: 'Pricelist EU' and 'Pricelist US'.
 
If the price is the same for EUR and USD, and the only difference is the currency, we still need 2 separate tabs.
 
Every option in DRAFT tab
 

GROUND RULES

1
For each product, indicate both Direct Customer Price and Distri­bution Price. If Direct and Distri­bution prices are the same, duplicate the same lines. For US, 2 types of distri­bution prices should be indicated - Gold and Diamond.
2
Every option in DRAFT tab should have its corres­ponding line in 'Price List'.
3
If the option does not have a price upcharge, it should still have a line in 'Price List' indicating '0'.
4
If there is no predifined price for an option, and PLM should be alerted every time this option is quoted, this option line in 'Price List' should indicate 'N/A' and not '0';
REMINDER:
- 'N/A' will trigger a notifi­cation to PLM to ask for the price for this option every time it's quoted
- '0' does not trigger any notifi­cation to PLM

REVIEW PRICES FOR 2024

 
Every option in DRAFT tab should have the corres­ponding line in the 'Price list' tab.
 
For each product, indicate both Direct Customer Price and Distri­bution Price. If Direct and Distri­bution prices are the same, duplicate the same lines. For US, 2 types of distri­bution prices should be indicated - Gold and Diamond.