Price Inflation for Cash Discounting
Price Inflation for Cash Discounting Program
This program, printed documentation and documents should not be used as a substitute for professional advice in specific situations. The procedures, images and examples in this document are for illustrative purposes only and may not be applicable in your setting due to differences in preference, settings and/or state and local regulations.
This guide will help you in adjusting the retail prices on all of your inventory so you can utilize the benefits of our Cash Discounting Program.
Navigate to Inventory – Manage Inventory – Manage products.
1. Click Actions – Export
2. Download the Excel File
3. Once the file is open – insert a new Column to the right of Retail
Price Column
4. Now we are going to add the Formula to automatically
calculate your 3% Credit Card fee.
5. Click into the Column you inserted in row 2. Insert =Column
letter2 (Ex: J2) enter in the formula of ; =(old column letter & row
2) I2*1.03 – click enter. Drag down the formula to the bottom of your inventory
list and this will automatically Calculate.
6. Once you have applied the formulas – Highlight the Column –
Right Click Copy – Right Click and select the Paste123 option to lock the
formula in. Once you have done that you can remove the Column with the original
Retail Pricing and name the Column with the new pricing as Retail price
7. You can now save the
sheet after making these changes.
8. Once Saved - you
will go back into Inventory – Manage Inventory – Manage Products.
9. Select your Actions
Icon – Select “click to download Product import template.”
10. You will need to
copy and paste all required fields and the Retail Price from your Inventory Export file into this file. You can delete all other fields from this template prior to saving.
11. Once all required
fields are filled in, you will need to save this as a CSV file.
12. Once this file has
been Saved you will need to change the Import / Update drop down to reflect
Update Existing Products
13. Once you have the
file uploaded, Click Next – This will ask you what information you would like
to update *Note there are required fields that cannot be bypassed*
14. You can Use the
drop-down menu to select Skip this field for the ones not required.
15. Scroll to the bottom
– Click Next – Verify your Vendors are correct – Scroll down click next –
Validate Import.
16. Once the Validation is complete, select Begin Import
17. You will get a message on the screen letting you know that the update is running, you can choose to view the progress details, or you can let it complete and view the import data once completed.
18. Next you will want
to go into your Main POS to add a Discount button to your screen if your
customers are paying cash to take 3% off the total purchase.
To do this you will navigate to your Office – Back Office – Setup Options
Go to your Pricing/Sales Section Set your default Discount type to Percentage and enter 3 into the percentage section.
19. Once this is done,
in your Setup options you will need to turn on your “Discount Button” under
your Register section.
20. Scroll down to the bottom and click Update.
21. When you are back in your Main POS screen, click your
refresh icon, and you will now see a blue discount button next to your payment
options.
Label Printing
To print labels that have both the standard retail price and the Cash Price listed on the product, you can follow the steps below.
These labels will only print properly with the 2.5 X 3 size
1. Navigate to Settings > Setup Options > Labels and Printing
2. Turn on Show Price on Labels, Print Labels with Cash Discount Pricing, Print Labels with Discount Sale/Pricing and Select Dis/Price on the Print Labels with Serial Number Discount Price and click Update.
3. Now Go to Settings > Purchase Order Settings > Scroll to the bottom of the page and make sure that the default label size is 2.5X3 Inches
4. Now you should be able to see your label print with a Retail Price and a Cash Price
Related Articles
Naming Custom Price Levels
All parts have default price levels: Minimum Price, Retail, Sale Price, Package Price, and Preferred Customer. These price levels cannot be renamed. All parts have an additional three price levels available; their names are set by each store. Go to ...What are Price Levels?
Price Level Settings All parts have default price levels: Minimum Price, Retail, Sale Price, Package Price, and Preferred Customer. These price levels cannot be renamed. All parts have an additional three price levels available; their names are set ...Setting a Package Price
Packages are pre-bundled sets of products with a single retail price. In the package part details page: Retail (List) price is the default price of the package that will appear in Point of Sale when it is sold. If a package is discounted and you want ...Setting Default Price Formulas
Default price formulas allow you to set your preferred discount and mark up levels for any new inventory item and helps you establish your Retail price (as well as other available pricing levels). These defaults will be used if creating a single new ...Cash Drawer Setup and Options
If you have a single cash drawer at your business, you will not need to set up additional drawers; Orchid POS comes with one drawer by default. In Office > Back Office Settings > Setup Options, you will want to make sure that "Shared Drawer" is ...