How to Export Price Codes to CSV File

Release Date: 6/16/17

Q -  Can you have Elliott produce the Price List Report with all price codes in a CSV format? We are trying to import it into Salesforce (through our Salesforce implementation team).

A -   Elliott provides a powerful utility to export the Price Code file to CSV.  

Price Codes Export

You can access it by going to Elliott Main Menu -> COP -> Maintenance -> Future Price Maintenance -> Price-Code -> Export.  See sample screen below:

The following is an example of the exported CSV file brought up in Excel:

The following is an explanation of each column:

Price-Code: This can be from price code 1 - 8 depending on what you define in Elliott.

Key-1 & Key-2: These two columns depend on the price codes you are using. In this example, it is price code 3, which is By Customer Type/Item.  Therefore, the Key-1 column is Customer Type and Key-2 column represents Item Number.

Pricing-Basis: This can be P=Price, D=Discount, M=Mark up.

Ignore Cust Disc: If this flag is set to "Y," then it means this price code will override the discount % defined in the customer file.  Sometimes the price code may be a very low price and you don't want to give them the additional discount % as defined in the customer file.

Minimum-Qty: This is always zero.  It shows in the CSV file just to match what's in the Price Code Maintenance screen.

Price-Or-Discount: This can be a fixed price (if Pricing- Basis = "P") or a percentage (if Pricing-Basis = "D" or "M").

Additional Columns: The additional columns to the right of Price-Or-Discount are the additional quantity-break pricing parameters.  If you use them, they will be in your CSV export.

Price Codes Import

Keep in mind that the same price codes can also be imported into Elliott. Therefore, you could edit your price codes information in Excel, and when you are done, import them back into Elliott to update. If you wish to delete a price code, specify "X" in the "Pricing-Basis" column.

EMK

• Related Articles

• Is There a Way to Export and Import Price Code Files?

  Q - Is there a way to export and import price code files? We would like to be able to edit price code information on a spreadsheet (CSV) if such a feature is available. A - Yes, there is such a feature in Elliott. It can be accessed from COP -> ...

• CPFUTMNU Customer Order Processing Future Price File Maintenance

  Future Price File Maintenance Application Overview Future Price function is used to update the price, standard cost and user-amount fields in the item master file. By using this function, the user can enter a date when the item price, cost, and ...

• Feature - Reorder Advice/User Defined CSV Export Introduction

  Release Date: 08/07/2020 Version: 8.0 & Up Introduction The User-Defined CSV Export is a specialized report writing tool and CSV creator for inventory information to allow you to analyze an Excel spreadsheet. This program allows access to ...

• Feature - Create Price Code 1 from Item Minimum Price Utility

  Release Date: 6/15/2016 This feature gives the user the ability to generate and update price code 1 based on the minimum price field in the Item Master file. The new utility is accessed thru I/M -> Maintenance -> Product Category File. The purpose ...

• Feature - Add Starting/Ending User-Defined Codes Selection to Item 3PL Export

  Release Date: 10/31/2023 Version: 8.5 & Up In Item File Maintenance, the "Export to 3PL" function has been enhanced to use starting and ending user-defined codes as the selection criteria. See sample screen below: For more information on Elliott 3PL ...