Thank you for purchasing ADV Profit Module for OpenCart. If you have any questions that are beyond the scope of this documentation, you've found a bug or need new feature, please use our support email: opencart.reports@gmail.com.
ADV Profit Module is must-have extension for all sellers looking for a complete solution to accurate calculation of product cost, payment cost and shipping cost in OpenCart environment. These cost data are the basis for calculation of sales, revenue, expenses and profit in ADV Profit Reports. Currently there are three reports working with this cost data (sold separately):
ADV Sales Profit Report
ADV Products Profit Report
ADV Customers Profit Report
This module is configured on admin side and makes hidden calculations of product cost, payment cost and shipping cost on catalog side in checkout process. This cost data are added to the order at time the product is sold, so every change of costs in future will have no impact on previously made orders. This will always provide accurate data for profit reporting. Customers of course will not see cost data in checkout during purchase.
ADV Profit Module allows you to choose between two costing methods:
This method does not take into account difference in costs of product you already have in stock. What does this mean? Product cost are usually changing in time or you have more suppliers for the same product and they don't have the same purchase price. Let's say you bought from supplier 10 pieces of product for $100 per piece, later you bought another 5 pieces of the same product for $90 per piece. Your new product cost is now $90 and this value will be used when customer buy one or all 15 pieces you have in stock. But this is not accurate because you have 10 pieces of product in stock in cost price $100! Cost data used in profit reports will be not accurate. If this scenario fit to your business you should use Average Cost Methods.
Fixed Cost Method method is convenient when your costs for product are ALWAYS THE SAME or you restock product AFTER you sell ALL pieces you have in stock.
This method take into account your previous product costs associated with current stock quantity and new product cost with restock quantity. Formula used in this method: average product cost is equal to total stock value of product divided by total stock quantity. The easiest way to understand this method is show it on previous example:
((10 * 100) + (5 * 90)) / 15 = 96.67
Your new product cost is now $96.67 and this value will be used when customer buy one or all 15 pieces you have in stock. Let's go further. Customer bought 7 pieces. Now you have 8 pieces in stock with cost price $96.67. You bought from supplier another 5 pieces of the same product for $110 per piece. Your new product cost will be:
((8 * 96.67) + (5 * 110)) / 13 = 101.80
Your new product cost is now $101.80.
Now we will try to describe in details every part of ADV Profit Module.
$110.90 | round down to the whole number minus ten hundredths |
$110.95 | round down to the whole number minus five hundredths |
$110.99 | round down to the whole number minus one hundredth |
$111.00 | round down to the whole number |
$111.10 | round down to the nearest tenths place |
$111.11 | without rounding - default |
$111.20 | round up to the nearest tenths place |
$111.90 | round up to the whole number minus ten hundredths |
$111.95 | round up to the whole number minus five hundredths |
$111.99 | round up to the whole number minus one hundredth |
$112.00 | round up to the whole number |
Now we will describe every field in spreadsheet file.
DO NOT edit Product ID, Option ID, Product Name, Product Option, SKU and Model.
Subtract: set it to "Y" (yes) if quantity of sold products and product options will be subtracted from the stock, or set it to "N" (no) if quantity will be not subtracted from the stock.
Actual Quantity: actual quantity of product or product option in time of export to spreadsheet file, DO NOT edit.
Restock Quantity: set amount to restock quantity of product or product option, value can be positive or negative.
New Stock Quantity: this value will be calculated automatically (New Stock Quantity = Actual Quantity + Restock Quantity), DO NOT edit.
Costing Method: set it to "FXCO" if costing method for product or product option will be Fixed Cost Method, or set it to "AVCO" if costing method for product or product option will be Average Cost Method.
Actual Cost: actual cost of product or product option in time of export to spreadsheet file, DO NOT edit.
Restock Cost: set cost associated to restock quantity of product or product option.
New Cost: this value will be calculated automatically and is based on selected costing method, DO NOT edit.
Actual Price: actual price of product or product option in time of export to spreadsheet file, DO NOT edit.
Cost Multiplier: set value of the multiplier to calculate retail price, e.g. for 25% profit on product, set value of the multiplier to 1.25 (New Price = New Cost * 1.25).
Price Multiplier: set value of the multiplier for retail price increase or decrease, e.g. for price increase of 5% set value of the multiplier to 1.05 (New Price = Actual Price * 1.05), for price decrease of 5% set value of the multiplier to 0.95 (New Price = Actual Price * 0.95).
Set Price: set retail price value directly (New Price = Set Price).
New Price: this value will be calculated automatically and will be rounded by selected rounding method (selected before export to spreadsheet file), DO NOT edit.
Profit: this value will be calculated automatically (Profit = New Price - New Cost), DO NOT edit.
NOTE: You cannot add or delete products and product options using this import/export function.
Please read Requirements and Limitations related to export.
ADV Sales + Profit Report have Shipping Balance column where you can verify if you have charged for shipping enough or insufficient.
If you are using OpenCart v1.5.x this module will not work without installed vQmod. You must download and install vQmod before you install this extension. Make sure you select the vqmod-2.x.x-opencart.zip file.
Further information can be found:
Also not required for this module but it is recommended also installing a FREE module: VQMod Manager & Editor. This allows you to easily view vqmod errors and much more in the admin area without login via FTP.
Note: if you have changed the directory of the admin folder, when installed vQmod you will need to open: vqmod/install/index.php and edit:
$u->addFile('admin/index.php');
If you are using OpenCart v2.x and v3.x you don't need to have vQmod installed. You can install extension via OCMod Extension Installer.
Installing ADV Profit Module requires some knowledge of uploading files through FTP. If you would prefer us to install the module, we offer an install service for fee $15.
Please follow installation steps in exact order and don't use both OCMod and vQmod installation steps together, otherwise extension will not work a you will get errors!
Note: When you install this module some required tables will be automatically added into your database and indexes for better performance of database queries.
Note: When you install this module some required tables will be automatically added into your database, some columns into existing tables and indexes for better performance of database queries.
Note: When you install this module some required tables will be automatically added into your database, some columns into existing tables and indexes for better performance of database queries.
Please follow upgrade steps in exact order, otherwise extension will not work a you will get errors!
WARNING: Always back up your website files and database before applying updates to modules.
WARNING: Always back up your website files and database before applying updates to modules.
PLEASE DO NOT POST ANY CODE RELATED TO THE EXTENSION IN THE COMMENTS AREA OR FORUM.
Please use our support email opencart.reports@gmail.com for direct help..
Things to note when asking for help.
Free support service is provided for unchanged OpenCart installations with the default theme. Resolving conflicts with other third party extensions/modules or any customization to the extension is a paid service with negotiable price.
Please describe your problem in as much detail as possible. This will make problem solving much faster.
As a bare minimum please state the following information when contacting:
Any additional information that you can give about the problem is greatly appreciated and will speed up the solving of the issue.
Below is a list of 3rd party checkout extensions we have already tested and work with ADV Profit Module. If you are using checkout extension not listed here, please send us request for modification.
Below is a list of Joomla modules we have already tested and work with ADV Profit Module. If you are using Joomla module not listed here, please send us request for modification.
Many 3rd party extensions work with ADV Profit Module after additional modification. It is paid service, please send us request for this kind of modification.
Memory requirements and execution time requirements to export (especially PDF) can be quite high. If you see error message in export process, it means your web host does set too low values for memory access and time limits to execution of scripts and this values should be increased. If here described methods to increase this values don't help, it is recommend set narrower date range for export.
The server settings that should be modified are:
memory_limit
- this setting affects the export functionality. You should increase it in case you receive error like Fatal error: Allowed memory size of XX bytes exhausted...max_execution_time
- it is recommended to use a higher value in case your database has lots of entries. It is estimated that database with thousands of orders takes several minutes to get exported. You should be fine if you set this setting at 600 seconds. This value should be increased in case you receive error like Fatal error: Maximum execution time of XX seconds exceeded...upload_max_filesize
- this setting affects the import functionality and sets the maximum file size your server can accept. Set it accordingly to the file you need to uploadpost_max_size
- usually a bit higher than upload_max_filesize
Method 1: Check your hosting Control Panel to modify this values.
Method 2: Modify your php.ini file with the following entries:
memory_limit = 256M
max_execution_time = 600
upload_max_filesize = 200M
post_max_size = 201M
Note: It is possible that modification of php.ini will not change your memory limit because your host does not allow it. Create a file in your root called phpinfo.php and copy this code in there:
<?php
// Show all information, defaults to INFO_ALL
phpinfo();
?>
Go to your www.website.com/phpinfo.php, this will show you everything including your memory limit.
Method 3: In your /admin/ folder of OpenCart, create a .htaccess file with the following entries:
php_value memory_limit 256M
php_value max_execution_time 600
php_value upload_max_filesize 200M
php_value post_max_size 201M
Method 4: Contact your web-host for assistance.
Method 5: If you really need PDF export, you can export to HTML and print to PDF file on your local computer.
PDF Printer must be installed on your computer: https://www.google.com/search?q=print+to+pdf
You can find additional information in php.net
You should carefully read the following Terms and Conditions. Your purchase or use of this extension implies that you have read and accepted these Terms and Conditions.
ADV Reports & Statistics, personally Mario Blazo (the "Developer") grant you (the "Licensee") a revocable, non-transferable, non-exclusive license, without right to sub-license, to use this extension (the "Product") in accordance with these Terms and Conditions.
In consideration of the mutual promises set forth herein, Developer and Licensee agree as follows:
Developer hereby grants to Licensee a revocable, non-transferable, non-exclusive license, without right to sub-license, to use the Product as set forth in this Terms and Conditions. Developer reserve ownership of all intellectual property rights inherent in or relating to the Product and hereby represents and warrants to Licensee that Developer is the owner of the Product or otherwise has the right to grant to Licensee the rights set forth in this Terms and Conditions.
In consideration for the grant of the license and the use of the Product, Licensee agrees to pay Developer the sum of the license fee. Payment of the license fee shall be made before delivery of the Software.
Developer do not warrant nor guarantee that the Product will meet Licensee requirements or operate error free. Developer cannot guarantee that the Product will function with 3rd party products. The Product is provided "as is" without warranty of any kind, either expressed or implied. In no event shall Developer be liable for any damages including, but not limited to, direct, indirect, special, incidental or consequential damages or other losses arising out of the use of or inability to use the Product.
Developer shall provide to Licensee any new, corrected or enhanced version of the Software as created by Developer during time of subscription. Such enhancement shall include all modifications to the Software which increase the speed, efficiency or ease of use of the Software, or add additional capabilities or functionality to the Software, but shall not include any substantially new or rewritten version of the Software.
Since Developer offer non-tangible irrevocable digital goods, Developer do not issue refunds after the purchase, which Licensee is responsible for understanding before buying the Product.
Developer reserve the right to change or modify these Terms and Conditions at any time with no prior notice. Therefore, Developer encourage Licensee to review the Terms and Conditions every time Licensee install or update the Product.
Designed and developed by ADV Reports & Statistics © 2011 - .