i need to track cost/price by history so that exact numbers can be generated in a report
in other words, right now, if you enter a cost of $0.05 for a widget, but then later change that cost to $0.06, then all sales calculations are now based on $0.06, the sales generated when the cost was $0.05 are now no longer accurate
rather, it would be way more accurate if the system could track product costs and pricing by time and calculate reports as such. in other words:
from point A to point B, the cost was $0.05 and the price was $0.10
from point B to point C, the cost was $0.05 but the price was $0.11
from point C to point D, the cost was $0.06 and the price was $0.12
from point D to point E, the cost was $0.04 and the price was $0.08
...and so on
you could then generate a profit report, for example, from point A through point E and each cost and price would be accounted for
this would be outstanding
thanks
in other words, right now, if you enter a cost of $0.05 for a widget, but then later change that cost to $0.06, then all sales calculations are now based on $0.06, the sales generated when the cost was $0.05 are now no longer accurate
rather, it would be way more accurate if the system could track product costs and pricing by time and calculate reports as such. in other words:
from point A to point B, the cost was $0.05 and the price was $0.10
from point B to point C, the cost was $0.05 but the price was $0.11
from point C to point D, the cost was $0.06 and the price was $0.12
from point D to point E, the cost was $0.04 and the price was $0.08
...and so on
you could then generate a profit report, for example, from point A through point E and each cost and price would be accounted for
this would be outstanding
thanks
Wrong approach.
What you need is a cost field in the product table to record the cost of the product. Another cost field is added to the order_product table. The cost of the product is then added to the order_product table at the time the order is placed along with the price of the product.
Reporting of product costs can then be retrieved from the order_product table, the same table that product sales information is retrieved from. Since the product cost is included at the time the order is placed, later changes in product costs will not impact historical data.
What you need is a cost field in the product table to record the cost of the product. Another cost field is added to the order_product table. The cost of the product is then added to the order_product table at the time the order is placed along with the price of the product.
Reporting of product costs can then be retrieved from the order_product table, the same table that product sales information is retrieved from. Since the product cost is included at the time the order is placed, later changes in product costs will not impact historical data.
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
i know whatchu mean, was thinking the same, but what if you had the following:
1. add 10,000 units to inventory at $0.05 each, sell half of them at $0.10 each, now 5,000 remaining
2. add another 10,000 units to inventory, but now cost $0.06 each, so change the cost in opencart to $0.06 each
but wouldn't the first 5,000 now be costed incorrectly at $0.06 each when they are finally sold, even though they originally cost $0.05 each?
now:
5,000 @ $0.05 ea
10,000 @ $0.06 ea
thanks
1. add 10,000 units to inventory at $0.05 each, sell half of them at $0.10 each, now 5,000 remaining
2. add another 10,000 units to inventory, but now cost $0.06 each, so change the cost in opencart to $0.06 each
but wouldn't the first 5,000 now be costed incorrectly at $0.06 each when they are finally sold, even though they originally cost $0.05 each?
now:
5,000 @ $0.05 ea
10,000 @ $0.06 ea
thanks
I understand what you're saying. But, an increase in cost usually reults in an increase in price and, while it may be "standard business practice" to update your inventory (and prices) when you update your stock on hand, it is not exactly "honest".
Sure, after a few price rises, you might have a sale with prices advertised as "below cost - while stocks last". All that means is the sale price is below the current cost of the product, which is not necessarily the cost at the time you purchased the stock. And the "while stock last" part only relates to the amount you had in stock at the time you increased your levels.
Sure, after a few price rises, you might have a sale with prices advertised as "below cost - while stocks last". All that means is the sale price is below the current cost of the product, which is not necessarily the cost at the time you purchased the stock. And the "while stock last" part only relates to the amount you had in stock at the time you increased your levels.
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
i'm trying to track all numbers so that all my reports are as exact as possible
people increase inventory cuz they are anticipating sales but the costs can vary widely
historical costing would be extremely helpful to all site admins
people increase inventory cuz they are anticipating sales but the costs can vary widely
historical costing would be extremely helpful to all site admins
just found an old old addon:
http://www.opencart.com/index.php?route ... rch=profit
maybe this could help
http://www.opencart.com/index.php?route ... rch=profit
maybe this could help
Who is online
Users browsing this forum: No registered users and 30 guests