Skip to main content

Managing Pricing Policies in PartsLedger

Adam Gurley

Pricing policies allow for items that are purchased from suppliers to be organized by the pricing that is set by suppliers. These policies include any discounted price periods, markups, or better buying options for bulk purchases from various suppliers that your company may work with.

 

Pricing Policy

  1. Go to ledger.partsledger.io and log in with your PartsLedger username and password
  2. Click on the Tools tab then click Imports and Exports
  3. Select Pricing Policies then click “Download CSV Template”
  4. Open the downloaded template
  5. There are a multitude of fields within this template that you are required and also not required to fill in
    • Product Name: The part number that your company recognizes the item as
        • For example, if a supplier has a part named “10lb Extinguisher” and your company names the part “Extinguisher 10lb”, you would type in the “Extinguisher 10lb” name into this field
    • Supplier_Company_Name: The name of the suppliers that you are purchasing parts and items from
    • Break_quantity: Amounts for parts from suppliers
    • Measurement_unit: Unit of measurement of part
      • Note: Most commonly used unit of measurement (UOM) is EA or each. EA is a single unit of a specific part. Another UOM is a Pack or PK, when entering a pack or bundled like pricing policy, you would enter the quantity of the packs then the amount within a pack (PK12)
    • Price: The value the supplier sells the items for
    • Percentage: Any discount that the supplier may offer for the part
    • Pricing Basis Type: The pricing model that is used for each item. The PartsLedger team recommends entering Listing Price for this column  
    • Currency_code: Currency being used for parts from suppliers
    • Supplier_part_number: The part number that the supplier recognizes the part as
    • Supplier_primary: Determines if the supplier is the main company that the part will be purchased from
      • If the supplier name in this field is the main supplier, type in TRUE. Otherwise, type in FALSE
    • Starting and Ending date: The start and ending date for the pricing policy

Related articles