This article provides instruction and information on the following:

How to create a Sale List

To create a sale list:

  1. In Paladin, from the main menu, select File >Setup.
  2. Select the Sale List tab.
  3. In the Sales pane, click New.
  4. In the Name box, enter a name for the sale.
  5. In the ID box, enter a unique ID number and save it for future reference.
  6. Optional: In the Source box, enter the source of the sale.
  7. Click Save.

Back to Top

How to make an active Sale List inactive

When an invoice is started, it requires every line of every sale list to be loaded and analyzed. This can cause the first inventory item on an invoice/quote to load slowly, especially when there a large number of active sale lists.

To solve the slow-loading problem, you can make active sale lists inactive.

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Sale List tab.
  3. In the Sales pane, enable Active.
  4. Highlight a sale that should be inactive.
    Note: Using Shift allows multiple sales to be selected all at once. Using Ctrl allows selecting specific multiple sales. When multiple sales are selected, only the New, Remove, and Restore buttons are operational.
  5. Click Remove.
  6. Click Close.

Back to Top

How to make an inactive Sale List active

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Sale List tab.
  3. In the Sales pane, enable Inactive.
  4. Highlight a sale to activate.
    Note: Using Shift allows multiple sales to be selected all at once. Using Ctrl allows selecting specific multiple sales. When multiple sales are selected, only the New, Remove, and Restore buttons are operational.
  5. Click Restore.
  6. Click Close.

Back to Top

Sale List filters

Sale List filters let you manage active sales more efficiently. When you select a filter, only those types of Sale lLsts are displayed.

The following table shows the types of Sale Lists that appear for each filter.

Filter

Sale List

All

All Sale Lists.

Normal

All Sales Lists except for Instant Savings.

Instant Savings

Sale Lists for Instant Savings only.

To select a Sale List filter:

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Sale List tab.
  3. In the Sales pane, select a filter from the All list.
  4. Click Close.

Back to Top

How to export and import items in a sale (Sale List) using Excel

You can export sale item part numbers and prices into a tab-delimited text file that can be opened in Excel. Then, use this file to optionally add or edit items and prices and re-import it to update the sale or add to another sale. For example, you could create a new sale based off an existing one.

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Sale List tab.
  3. In the Sales pane, select the sale you want to export. 
  4. Click Edit and then click Export.
  5. Select a file location and enter a name that you will remember.
  6. A message will appear confirming that the tab-delimited text (.txt) file was created.
  7. To open the file in Excel:
    1. Open Excel.
    2. In Excel, on the File menu, click Open.
    3. Browse to the file location and make sure the file filter is set to All Files (*.*).
    4. Select the file you created (it will have a .txt file extension) and follow the prompts to import the file into Excel. 
  8. Optional: Edit the sale items and/or add new items and prices and save your changes. By default, the changes will save as a text (.txt) file which is required to reimport the data. Do not change the file type to an Excel file type (.xlsx) or the import will not work. 
    Important notes
    • Make sure the part #’s are accurate. The import process does not verify part #’s.
    • The import process can add new items or modify the prices of existing items. It will not delete items. If you delete items from the Excel file, the items will not be removed when you re-import the file. 
    • Close the file before you import it or the import will not work. 
  1. Optional: Import the file to update a sale.
    1. In Paladin, from the main menu, select File > Setup.
    2. Select the Sale List tab.
    3. In the Sales pane, select the sale you want to update. 
      Tip: If you want to create a new sale based on your edited list, you must first create the new sale. 
    4. Click Edit and then click Import.
    5. In the Import Sale List window, browse to the folder that contains the file that you created earlier.
    6. In the File name list, select the file that you want to import, and then click Open.
    7. When the file has been imported, the items will be updated in the Sale Items pane.

Back to Top

How to create the Sale List import file and import it into a Sale List

Tip: If you want to update an existing sale, you can use the export feature to edit the sale items in Excel and then reimport the file. To learn more, see: How to export and import items in a sale (Sale List) using Excel.

Note: Before you can follow this procedure, the sale list must be created. To learn more, see: How to create a Sale List.

  1. Open Excel.
  2. Open a blank workbook.
  3. In the upper left corner of the workbook, right-click the triangle symbol, click Format Cells.
  4. Click the Number tab, select Text, and then click OK. This format allows you to enter zeroes as prefixes to numbers.
  5. In the A1 cell, enter PARTNUMBER as one word, all caps.
  6. In the B1 cell, enter SALEPRICE as one word, all caps.
  7. For each column that you want to expand, click between two column headers. The left column will turn gray, and the cross symbol will appear. Drag the cross symbol to the right.
    For example, you may want to expand column A so that Part number fits.
  8. In the A2 cell, enter a part number.
    For example, enter 12345.
  9. In the B2 cell, enter a price for the part number.
    For example: enter 19.99.
  10. For each additional part number, enter it in a cell in column A.
  11. For each additional price, enter it in a cell in column B.
  12. Click the File menu, click Save As, browse to the location where you want to save the file, enter a name for the worksheet in the File name box, select Text (Tab delimited) in the Save as type list, and then click Save.
  13. In Paladin, from the main menu, select File >Setup.
  14. Select the Sale List tab.
  15. In the Sales pane, select the sale that you want to import items into. Click Edit and then click Import
  16. In the Import Sale List window, browse to the folder that contains the file that you created earlier.
  17. In the File name list, select the file that you want to import, and then click Open.
  18. When the file has been imported, it will appear in the Sale Items pane in Paladin.
  19. Click Close.

Back to Top

Automatic retirement of Sales Lists

Paladin automatically retires out-of-date Pricing Plans and Sale Lists. All sale data controlled by a specific start date and end date, and is observed to be 90 days past the end of the sale “Date Range End” specified in the Pricing Plan, will be marked as Inactive and no longer display in the list of Active sales.

The old sale data is not deleted or lost, it is simply moved. 

To enable this:

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Pricing Plan tab.
  3. In the Pricing Plans pane, enable the Inactive radio button to view the old sale data. Note: Should you want to add a sale back to the Active list, highlight the sale data desired and click Restore

Remember these sales are still inactive because of an expired end date. Use of your newly restored sale will require modification to the Date Range End date or unchecking Date Range.

Back to Top

If you have questions or suggestions about this information, contact support@paladinpos.com.

*Content is subject to change. For the most recent version, visit the Help Portal.
Printed on: 7/01/22