This article provides information on how frame markup formulas are applied within My Vision Express.
| The Frame Markup screen allows you to specify the formulas used to calculate the retail price of frames being added into your frame inventory.
- To access the Frame Markup screen, navigate to File > Setup > Frame Markup.
- From here, you can add a new markup formula by clicking the 'Add' button, delete an existing formula by clicking the 'Delete' button, or modify an existing formula by selecting it from the list and then modifying it under the Frame Markup Details section.
Utilizing this process will allow you to manually override the retail price calculated by the system for any given frame. These formulas will then automatically calculate the retail price for the frame.
The frame markup formula will apply to any frames that fall within the 'Start Group Cost' and 'End Group Cost'.
- For example, if the Start Group Cost is $50.00, and the End Group Cost is $300.00, any frames that fall within that price range will have the frame markup applied.
In addition, you can further narrow down the frames selection that you wish the formula to be applied to by specifying a frame collection in the 'Collection' drop down.
| NOTE- If the 'Collection' field is left blank, the formula will then apply to all frames within that range.
Amount - The amount, if any, you wish to be added to the retail price of any frames this formula applies to.
Ceiling Up - Selecting this option will round the price of the frame up to the next whole dollar amount.
Ceiling Down - Selecting this option will round the price of the frame down to the next whole dollar amount.
Multiplier - Multiplies the 'amount' of the group cost of the frame times whatever this field is set to.
Ends with - Determines what the final cost of the frame will end in based on what amount is entered here. For example, if the retail cost is $150.00 and 'Ends With' is set to 0.99, the final retail cost will be $150.99.
Next Multiple of Ten - When this option is selected, it will round to the nearest value of '10' (either up or down, depending on the 'Ceiling' selected). Using this field disables the 'Ends With' field.
Based on the formula shown in the screenshot above, if the group cost of the frame was $36.00, the final retail price would be as follows:
|| Ends With'
|| Retail Price
| $36.00 x
|| 2 +
|| $50.00 +
Once the Frame Markup formula is configured, you can then apply it to the collection (or, if the collection is left blank, all frames within that group cost range) by clicking on 'Update Pricing'.
For additional assistance please contact My Vision Express Support
1-877-882-7456 ext 3