Add purchase price, cost and cost of goods to your products / variations. New prices are calculated and suggested based on these values using your Markup (profit margin). These values give you direct control over your store’s profits and revenue. With the included table editor and its bulk features, you can easily add and update all these values. In addition, you can seamlessly update inventory, see value at cost, sales value and total profit. NEW: You can now adjust prices inc. VAT, a new dropdown on the price field let you see your prices including and excluding VAT.
Cost & Reports includes valuable and unique sales reports. The reports show in detail your actual profits and income, not just bestsellers, but down to product or variation level. Retrieve reports by predefined or a selected date range, see your acceptable profit (green background marking) and unacceptable profit (red background marking). Download reports (CSV) for further processing in applications such as MS Excel or Apple Numbers.
Benefits of Cost & Reports:
- Adds vital information on your store profit and revenue.
- Add valuable fields to your product / variations like: purchase price, cost, shipping, cost of goods and Markup.
- Makes more accurate prices for your store (with cost of goods and Markup).
- History editable meta data is added to your order lines for purchase price and cost of goods.
- Table editor that can bulk add / update your costs, profit margins, prices, stock and more.
- Price selector for regular price and current price (inc. and ex. VAT) NEW
- Coloured border on products ON SALE NEW
- Coloured (blue) font on prices inc. VAT NEW
- Calculates Value at cost, Retail value and Profit based on the price selector NEW
- Reports per order, customers and product / variation (table view). Including:
- Search, date ranges, averages, profits, net sales, taxes, sidebar with summary information and bestsellers.
- Bestsellers with information like profit, sales and turnover.
- Product reports that dynamically calculates while filtering.
- Export as .csv file
- Export table to .xlsx (MS Excel or Apple Numbers)
- Live reports and counter (new orders)
- Compatible with Products, Variations, Subscriptions, Cost of goods, Bulk Table Editor, Order Status Manager and more
- POT file for translations (English, German NEW and Norwegian)
The table editor can bulk update: purchase price, cost, shipping cost, cost of goods, Markup, Price and Stock. It calculates a correct price (suggested price based on item cost and Markup). In addition:
- Displays cost value (per row and summed)
- Retail value (per row and summed)
- Profit (per row and summed)
- A number of search / filter options
- Show / hide ID and SKU NEW
- Sorting by column
- On Sale indicator – gold coloured border (price column) NEW
- Export to CSV file (opens in MS Excel or Apple Numbers)
- Export current table (.xlsx) NEW
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, Cost & Reports 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.
Option to adjust prices inc. VAT NEW
As a merchant you often want to see and adjust the price when it is including VAT, so we made a function for that. You can now select Regular price inc. VAT, this adjust the price inc. VAT and it converts it to the regular price ex. VAT in the New price column automatically. This means that you can now easy set up selling prices like $19.90 (inc. VAT). If you have prices in admin including VAT you can use the dropdown to see prices ex. VAT.
From vs 3.0.20 you have two more options: Current price (inc. and ex. VAT), this is the current price of your product (i.e the discounted sales price). In addition to this Cost & Reports calculates value at cost, retail value and profit for you based on the price selected (inc. or ex. VAT). NEW
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, net sales and taxes 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.
Reports 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), net 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.
Reports by Customer NEW
This report is set up so you can get some more information about the orders by customers. Here you will easy find the name, company, e.mail and phone if you need to contact the customer or want to export this information. In addition you find shipping, order total, total tax, items purchased, currency, country and the payment method. Use the row filter to sum up values for a customer or a company.
Row search and automatic calculations
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 product reports. 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.
The reports now give you an automatic counter for new orders, you also have the option to update the reports automatically (option in settings). You can use this view, for example, as a live report and see the numbers and sold products updated throughout the day.
History Added To Order Items
When customers purchase your products, Cost & Reports will add cost of goods and purchase price to each order line. This means that you will be able to see and edit 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)
There are two buttons for export Download (.csv) and Export table. The first one gets all your data from the database, the Export table will just export what you see in the table. This means that you can filter and sort, and when your selection is OK, just click export and you get a .xlsx file. This opens in MS Excel and Apple Numbers. Below image shows the export result.
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; Cost & Reports will use this value for cost of goods in related calculations. If you do not have this plugin, Cost & Reports 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.
- Option to use inc. VAT prices NEW
- 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.
- Undo changes NEW
- Download/Export (.CSV) file per category or all products. Includes calculations and last changed date.
- Supports multi-site network setup.
- Reports per order, customer and product.
- Reports per order.
- Reports per product/variation.
- Export to .csv file (database export).
- Export table (.xlsx)
- Color indicators for high and low profit percent.
- Search in rows with automatic calculations.
- Counter and option for automatic updates of new orders NEW
The extension is compatible with
- WooCommerce products and variations
- WooCommerce subscription and variations
- Cost of goods for WooCommerce
- Bulk Table Editor for WooCommerce
- Order Status Manager for WooCommerce
- Other plugins that uses purchase price and/or cost of goods fields
- English (default)
- POT file for easy translating to other languages