Show Menu
Cheatography

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.