Calculate Your Price for WooCommerceDeveloped by Consortia AS
Use Cost of Goods, Markup, See Profit, Revenue and Sales reports
This extension adds purchase price, cost, and cost of goods to your products/variations. It will calculate a suggested new price based on these values using your selected markup (profit margin). The suggested new price can have a set profit margin and will put you in better control of your stores profit and revenue. The included bulk functions let you edit and set all these values easily. In addition, you can update stock values and see value at cost, retail value, and profit all in one easy to navigate location!
The extension even includes valuable and unique sales reports. These reports show, in detail, your actual profit and revenue. You can see not just best sellers, but information down to a product or variation level. Get the reports by any date range, see acceptable profit (shown with a green background) and not acceptable profit (shown by a red background). Download reports (as a .csv file) for further processing in applications like MS Excel or Apple Numbers.
Cost Of Goods And Profit
As an example we use our purchase price, then set other cost (which can include factors like handling and shipping), these combined fields now equal “cost of goods.” Let us say our t-shirt cost of goods is $10 and we want to have a profit margin of 50%; we just enter 150 in the input field for markup + enter. The new price field shows $15 as the suggested price. Now the value at cost, retail value, and profit have values as well. Compare the new price with the current price and if it is good, just click the save all button. Use the handy bulk functions to do this fast for multiple products. The plugin also comes with a built-in control mechanism that checks for negative profit.
If you already have the cost of goods field filled in and do not want to fill in the other cost values, just set the markup and prices will be calculated automatically.
Easy Access to Bulk functions!
Most of the columns have bulk functions available to use, here is an example: we type 10 in the input field for “other cost,” select “increase fixed amount” and 10 is now added to every row. When this is done, Calculate Your Price adds this value to the cost of goods then calculates every row and suggests a new price. If you are satisfied with the new price, just use the “save all” button and this is now the current price on the selected products. If a price comes out with a number like 12.37 you can use the round function on the new price to make a cleaner price like 12.40, the markup is then automatically adjusted to your new price.
Sales Reports per Order
This report view shows all sales in a date range, set your own range using the date selectors or use the predefined ranges. In the table, you will find order ID (links to the order page), customer, role, date, status, quantity of items, profit, cost of goods, and gross sales for the selected period. On the right side of the table you find the key values and averages from the period. Color indicators in the table for high and low profit are also included, these can be easily adjusted in the settings. Use the “search in rows” to filter the reports, filter in order id, customer, role and date. The role column is added to support role-based extensions like Roles & Rules B2B.
Sales Report per Product/Variation
The products view has the same features for selecting date ranges and the download .csv button. This table starting by showing averages then order id, category (link to edit products in category), product/variation name, SKU, quantity, price (when purchased), gross sale and profit (including percent). Sort the columns as you like. On the right side of the table is a top products in period based on quantity and profit. And other key values and averages from the selected period.
Row Search And Automatic Calculations – NEW
Use the “search in rows” filter to get your selection of products/variations in the Products report. You can use order id, category, product and SKU when you want to filter in your sales. When you filter you the plugin automatically update averages, best sellers, totals and more so you easy can se your gross sales and profit for your selection.
History Added To Order Items
When your customers purchase your products, Calculate Your Price will add Cost of goods and purchase price to each order line. This means that you will be able to see what you bought the item for and cost of goods when you sold your products. This means that historically correct profits will be shown in the extension reports. (Cost of goods and purchase price on order items is for internal use)
Download Calculations and Reports
Download the calculated product list and reports by simply using the download buttons. It is possible to download per category or download all categories. For sales reports you can download per orders or per products for a date range. This (.csv) file can then be opened in applications like MS Excel and Apple Numbers.
Already Using Cost of Goods for Your Products?
If you are already using the cost of goods field for your products, then just go to settings > integration and enter the cost of goods field; Calculate Your Price will use this value for cost of goods in related calculations. If you do not have this plugin, Calculate Your Price by default creates a cost of goods field that is used on all your products. More information about this integration is available in the documentation.
Using Bulk Table Editor for WooCommerce?
If you work with prices in one category and want to set up sales, the “set up sales” link lets you jump to Bulk Table Editor and set up sales in the same category. More information about your prices and profit will enable giving you the ability to make better decisions when setting up sales on your products. Integration is done automatically.
- Bulk functions for every price field, markup field, and stock quantity.
- Automatically calculate as you enter values in the table or use bulk functions.
- Control mechanism for prices and negative profit values.
- Adds purchase price and cost of goods fields to your existing products.
- Use Shipping cost to calculate cost of goods.
- Totals for stock, value at cost, retail value, and profit are shown in table.
- Search and filter functions that enable you to bulk set prices for a selection of products.
- Function to erase input fields for calculations.
- Progress bar when saving.
- Clear 0.00 values when in-focus (mouse over), this makes it fast to set correct values when null
- Bulk delete products and variations.
- Download (.csv) file per category or all products. Includes calculations and last changed date.
- Supports multi-site network setup.
- Sales reports per order and product.
- Reports per order.
- Reports per product/variation.
- Download as a .csv file.
- Color indicators for high and low profit percent.
- Search in rows with automatic calculations. NEW
The extension is compatible with
- WooCommerce products and variations
- WooCommerce subscription and variations
- Cost of goods for WooCommerce
- Bulk Table Editor for WooCommerce
- Other plugins that uses purchase price and/or cost of goods fields
- English (default)
- POT file for easy translating to other languages