--- title: SELL PRICES - Access / List Functionality description: inventory pricing sales --- [![company logo](https://cs.geminilogic.com/hs-fs/hubfs/Gemini-Logic-Logo%20(1).png?height=120&name=Gemini-Logic-Logo%20(1).png)](https://www.geminilogic.com/) [User Manual](https://cs.geminilogic.com/en/migrated/manual) - [Go to Gemini Logic](https://www.geminilogic.com/) - [New Ticket](https://cs.geminilogic.com/en/migrated/manual/kb-tickets/new) - [Go to Customer Portal](https://cs.geminilogic.com/tickets-view) Pricing - [Spire Systems - General Knowledge Base](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base) - [Tips and Tricks](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#tips-and-tricks) - [Spire Administration - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-general-ledger) - [Spire Administration - Sales](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-sales) - [Spire Administration - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-inventory) - [Analytics for Spire](https://cs.geminilogic.com/en/migrated/manual/analytics-for-spire) - [Spire User Manual - System Overview](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-system-overview) - [Spire User Manual - User Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-settings) - [Spire User Manual - Vendors](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-vendors) - [Spire User Manual - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory) - [Pricing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory#pricing) - [Spire User Manual - Price Matrix](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-price-matrix) - [Spire User Manual - Purchase Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-purchase-orders) - [Spire User Manual - Sales Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-sales-orders) - [Spire User Manual - Keyboard Shortcuts](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-keyboard-shortcuts) - [Spire User Manual - Company Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-company-settings) - [Spire User Manual - New Instal/Company Setup](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-new-instal-company-setup) - [Spire User Manual - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-general-ledger) - [Spire User Manual - Accounts Receivable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-receivable) - [Spire User Manual - Accounts Payable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-payable) - [Spire User Manual - Payroll](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-payroll) - [Spire User Manual - Production Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-production-manager) - [Spire User Manual - Service Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-service-manager) - [Spire User Manual - User Defined Fields](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-defined-fields) - [Spire User Manual - Job Costing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-job-costing) - [HubSpot](https://cs.geminilogic.com/en/migrated/manual/hubspot) - [Updates](https://cs.geminilogic.com/en/migrated/manual/hubspot#updates) - [Gemini Logic](https://cs.geminilogic.com/en/migrated/manual/gemini-logic) - [Shipping](https://cs.geminilogic.com/en/migrated/manual/shipping) - [Sales Taxes](https://cs.geminilogic.com/en/migrated/manual/sales-taxes) - [Spire User Manual](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual) - [Customers](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual#customers) [Back to home](https://cs.geminilogic.com/en/migrated/manual) 1. [User Manual](https://cs.geminilogic.com/en/migrated/manual) 2. [Spire User Manual - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory) 3. Pricing - [Spire Systems - General Knowledge Base](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base) - [Tips and Tricks](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#tips-and-tricks) - [Spire Administration - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-general-ledger) - [Spire Administration - Sales](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-sales) - [Spire Administration - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-inventory) - [Analytics for Spire](https://cs.geminilogic.com/en/migrated/manual/analytics-for-spire) - [Spire User Manual - System Overview](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-system-overview) - [Spire User Manual - User Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-settings) - [Spire User Manual - Vendors](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-vendors) - [Spire User Manual - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory) - [Pricing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory#pricing) - [Spire User Manual - Price Matrix](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-price-matrix) - [Spire User Manual - Purchase Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-purchase-orders) - [Spire User Manual - Sales Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-sales-orders) - [Spire User Manual - Keyboard Shortcuts](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-keyboard-shortcuts) - [Spire User Manual - Company Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-company-settings) - [Spire User Manual - New Instal/Company Setup](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-new-instal-company-setup) - [Spire User Manual - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-general-ledger) - [Spire User Manual - Accounts Receivable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-receivable) - [Spire User Manual - Accounts Payable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-payable) - [Spire User Manual - Payroll](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-payroll) - [Spire User Manual - Production Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-production-manager) - [Spire User Manual - Service Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-service-manager) - [Spire User Manual - User Defined Fields](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-defined-fields) - [Spire User Manual - Job Costing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-job-costing) - [HubSpot](https://cs.geminilogic.com/en/migrated/manual/hubspot) - [Updates](https://cs.geminilogic.com/en/migrated/manual/hubspot#updates) - [Gemini Logic](https://cs.geminilogic.com/en/migrated/manual/gemini-logic) - [Shipping](https://cs.geminilogic.com/en/migrated/manual/shipping) - [Sales Taxes](https://cs.geminilogic.com/en/migrated/manual/sales-taxes) - [Spire User Manual](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual) - [Customers](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual#customers) # SELL PRICES - Access / List Functionality ## Manage markup or margin settings for pre-established Selling Price Levels ![InventorySellPricesIcon-1](https://cs.geminilogic.com/hs-fs/hubfs/InventorySellPricesIcon-1.png?width=50&height=47&name=InventorySellPricesIcon-1.png) #### Setup access: (see also [Add Sell Price)](https://cs.geminilogic.com/en/manual/inventory-prices-and-units-tab#InventoryPricing) 1. Price Levels in Inventory Text Menu ![InventoryTextMenuPriceLevels](https://cs.geminilogic.com/hs-fs/hubfs/InventoryTextMenuPriceLevels.png?width=157&height=236&name=InventoryTextMenuPriceLevels.png) 2. Sell Prices tab in Inventory module ![InventoryListSellPricesTabLeft-1](https://cs.geminilogic.com/hs-fs/hubfs/InventoryListSellPricesTabLeft-1.png?width=508&height=279&name=InventoryListSellPricesTabLeft-1.png) #### **Sell Prices** **List Customization** - **![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-07-59-53-62-PM.png?width=17&height=22&name=image-png-Aug-01-2022-07-59-53-62-PM.png) Refresh** to load any newly entered Price Settings on this list - ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-07-59-58-19-PM.png?width=22&height=22&name=image-png-Aug-01-2022-07-59-58-19-PM.png) Filters - create a filter for this list   ![InventoryListSellPricesTabFilter](https://cs.geminilogic.com/hs-fs/hubfs/InventoryListSellPricesTabFilter.png?width=539&height=305&name=InventoryListSellPricesTabFilter.png) - - click on ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-07-59-59-86-PM.png?width=22&height=22&name=image-png-Aug-01-2022-07-59-59-86-PM.png) **Filters** - - choose from the **Any** or **All** selector - select from the list of fields to set the criteria (ie:  Product Code) - select from the operators ie: **is**, **is not**, etc - this operator list changes based on the field selected in the previous step - enter the criteria information (ie: 'PARTS') - if desired click ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-08-00-28-45-PM.png?width=28&height=28&name=image-png-Aug-01-2022-08-00-28-45-PM.png) to add a line of criteria - to remove the line click ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-08-00-34-12-PM.png?width=28&height=28&name=image-png-Aug-01-2022-08-00-34-12-PM.png) - make any column adjustments (see [Column Customization](https://cs.geminilogic.com/en/migrated/manual/sell-prices#column-customization)) - click ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-08-00-42-24-PM.png?width=22&height=22&name=image-png-Aug-01-2022-08-00-42-24-PM.png) **Filters** for save options:                ![FiltersMenu](https://cs.geminilogic.com/hs-fs/hubfs/FiltersMenu.png?width=167&height=160&name=FiltersMenu.png) - - - **Save as default** - will load this filter when the Filter button is depressed - **Remove default** to remove the previously set default Filter - **Save filter** - to save changes on a previously saved Filter - - - **Save filter as…** - will allow you to name the Filter with the following settings:![InventoryListSellPricesTabFilterSave](https://cs.geminilogic.com/hs-fs/hubfs/InventoryListSellPricesTabFilterSave.png?width=233&height=171&name=InventoryListSellPricesTabFilterSave.png) - - -  give this filter a name - select ![RadialButtonBlue](https://cs.geminilogic.com/hs-fs/hubfs/RadialButtonBlue.png?width=16&height=16&name=RadialButtonBlue.png) **User** if this filter will be used by you only - select ![RadialButtonBlue](https://cs.geminilogic.com/hs-fs/hubfs/RadialButtonBlue.png?width=16&height=16&name=RadialButtonBlue.png) Company if it is to be accessed by all users in the Company - **![CheckBoxCheckedBlue](https://cs.geminilogic.com/hs-fs/hubfs/CheckBoxCheckedBlue.png?width=16&height=16&name=CheckBoxCheckedBlue.png) Show in module list** to display beneath the module name:                  ![InventoryListSellPricesTabFilterModuleList](https://cs.geminilogic.com/hs-fs/hubfs/InventoryListSellPricesTabFilterModuleList.png?width=335&height=213&name=InventoryListSellPricesTabFilterModuleList.png) - - - **![CheckBoxCheckedBlue](https://cs.geminilogic.com/hs-fs/hubfs/CheckBoxCheckedBlue.png?width=16&height=16&name=CheckBoxCheckedBlue.png) Save column state** if you have removed or added columns, or have sorted the list by one of the columns - click **OK**  - the new Filter is also accessible in the Filter menu:                           ![SellPricesFilterMenu](https://cs.geminilogic.com/hs-fs/hubfs/SellPricesFilterMenu.png?width=167&height=194&name=SellPricesFilterMenu.png) - click on the ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-07-26-46-57-PM.png?width=20&height=22&name=image-png-Aug-31-2022-07-26-46-57-PM.png) **Filters** button to release the current filter in order to see entire list, or to start a new filter - **Icon Menu Customization ** - hover over the Icon Group handle ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Apr-24-2023-03-38-04-1075-PM.png?width=5&height=30&name=image-png-Apr-24-2023-03-38-04-1075-PM.png) until you see ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-08-04-07-56-PM.png?width=26&height=41&name=image-png-Aug-01-2022-08-04-07-56-PM.png) - drag the Icon Group to where you want it - **Column Customization**![InventoryListSellPricesColumnList](https://cs.geminilogic.com/hs-fs/hubfs/InventoryListSellPricesColumnList.png?width=202&height=286&name=InventoryListSellPricesColumnList.png) - drag and drop columns to desired positioning - right-click on any column heading for access to column chooser for display customization👉 - **![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-08-03-42-24-PM.png?width=32&height=18&name=image-png-Aug-01-2022-08-03-42-24-PM.png) Column Sort / Search** - click on any column heading to sort the list by that column - further narrow your search by just typing (‘pre’ in this example) and the list will highlight the closest match, in currently sorted column             ![InventoryListSellPricesTabColumnSortSearch](https://cs.geminilogic.com/hs-fs/hubfs/InventoryListSellPricesTabColumnSortSearch.png?width=515&height=230&name=InventoryListSellPricesTabColumnSortSearch.png) - ** ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-08-02-51-24-PM.png?width=90&height=33&name=image-png-Aug-01-2022-08-02-51-24-PM.png)** - type any character(s) into this field and the list will narrow to only records containing the character(s) typed, somewhere in the details - Open a Price record and use the **Navigate** buttons ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-08-03-05-33-PM.png?width=106&height=20&name=image-png-Aug-01-2022-08-03-05-33-PM.png) to page through Prices in the list, filtered or not filtered, in order of the current column sort - Sell Prices **Context Menu** - right-click on any line(s) to display               ![InventoryListSellPricesTabQuickMenu](https://cs.geminilogic.com/hs-fs/hubfs/InventoryListSellPricesTabQuickMenu.png?width=154&height=126&name=InventoryListSellPricesTabQuickMenu.png) - **![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-08-04-57-75-PM.png?width=24&height=24&name=image-png-Aug-01-2022-08-04-57-75-PM.png) Export** the Prices list (will export exact column layout) to Excel (.xlsx only) or CSV format          ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-08-05-21-39-PM.png?width=427&height=239&name=image-png-Aug-01-2022-08-05-21-39-PM.png) - - select Prices(s) from a filtered or unfiltered list (see Filters above) - click ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-08-05-04-12-PM.png?width=24&height=24&name=image-png-Aug-01-2022-08-05-04-12-PM.png) Export - choose the location File Name, and Save as type (.xlsx or .csv) - **Save**![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-01-2022-08-05-32-88-PM.png?width=226&height=104&name=image-png-Aug-01-2022-08-05-32-88-PM.png) - option to **Open File** right away - from excel, make any changes or build any desired formulas ![InventoryListSellPricesTabChangePriceIcon](https://cs.geminilogic.com/hs-fs/hubfs/InventoryListSellPricesTabChangePriceIcon.png?width=35&height=28&name=InventoryListSellPricesTabChangePriceIcon.png) **Change Price **- see [**Inventory Pricing**](https://cs.geminilogic.com/en/manual/inventory-prices-and-units-tab#InventoryPricing) ![OpenInventoryIcon](https://cs.geminilogic.com/hs-fs/hubfs/OpenInventoryIcon.png?width=35&height=38&name=OpenInventoryIcon.png) **Open Inventory** to view or edit inventory details for the price selected   for other pricing options, see  [**Price Matrix**](https://cs.geminilogic.com/en/manual/price-matrix-add-edit-delete) [![company logo](https://cs.geminilogic.com/hs-fs/hubfs/Gemini%20Logic%20-%20Black-1.png?height=120&name=Gemini%20Logic%20-%20Black-1.png)](https://www.geminilogic.com/) Gemini Logic - [![linkedin_social_link_icon_alt_text](https://static.hsstatic.net/TemplateAssets/static-1.329/img/hs_default_template_images/modules/Follow+Me+-+Email/linkedin_circle_color.png)](https://www.linkedin.com/company/2460588) - [![youtube_social_link_icon_alt_text](https://static.hsstatic.net/TemplateAssets/static-1.329/img/hs_default_template_images/modules/Follow+Me+-+Email/youtube_circle_color.png)](https://www.youtube.com/user/GeminiLogicInc/featured) - [![twitter_social_link_icon_alt_text](https://static.hsstatic.net/TemplateAssets/static-1.329/img/hs_default_template_images/modules/Follow+Me+-+Email/twitter_circle_color.png)](https://twitter.com/gemini_logic) - [Go to Gemini Logic](https://www.geminilogic.com/) - [New Ticket](https://cs.geminilogic.com/en/migrated/manual/kb-tickets/new) - [Go to Customer Portal](https://cs.geminilogic.com/tickets-view)