ENHANCEMENT - Order Products Tab - Refund Button
- 1390
- 11685
- 8/10/2012
- United States
I think what he was saying is that most times, it is necessary to refund only the cost of one of the items in the order...not the whole order total or shipping. So I think he means to ask for a method of refunding ONLY the cost of any of the items in the order...individual or multiple items.
I would also suggest that an option to easily refund the shipping cost for an order would be useful.
And while we are on the subject of refunds, my bookkeeper has asked for a way to be able to track refunds...order ID, date issued, total, etc. If the refund was for $50, for example, she also wants to know exactly how much of the refund was for the product, and how much of the refund was for the shipping. This is critical information when performing a "Cost of Goods Sold" report.
Currently, the refunding process only updates the existing order totals, and keeps no record of the refund activity.
I'd suggest a new table for RefundActivity which store all activity and can be queried.
I would also suggest that an option to easily refund the shipping cost for an order would be useful.
And while we are on the subject of refunds, my bookkeeper has asked for a way to be able to track refunds...order ID, date issued, total, etc. If the refund was for $50, for example, she also wants to know exactly how much of the refund was for the product, and how much of the refund was for the shipping. This is critical information when performing a "Cost of Goods Sold" report.
Currently, the refunding process only updates the existing order totals, and keeps no record of the refund activity.
I'd suggest a new table for RefundActivity which store all activity and can be queried.
MVP
- 741
- 8299
- 9/14/2010
- United States
embryo wrote:
Yes, thanks for clarifying Embryo. We have been busy and laser focused with the MobSocial plugin and hadn't had the chance to respond.
Andrei, we definitely need the ability to refund just a single item because sometimes it's out of stock and the customer just wants the rest of the items and money back for the OOS item.
embryo wrote:
I would also suggest that an option to easily refund the shipping cost for an order would be useful.
And while we are on the subject of refunds, my bookkeeper has asked for a way to be able to track refunds...order ID, date issued, total, etc. If the refund was for $50, for example, she also wants to know exactly how much of the refund was for the product, and how much of the refund was for the shipping. This is critical information when performing a "Cost of Goods Sold" report.
There is cost on the Admin Product screens. Isn't the Cost of Goods Sold always the same regardless of partially or fully refunding shipping or product? Also, would you be able to provide your bookkeeper/accountant with your bank statement and map transactions to COGS?
embryo wrote:
Currently, the refunding process only updates the existing order totals, and keeps no record of the refund activity.
I'd suggest a new table for RefundActivity which store all activity and can be queried.
Agree. This would definitely be required when multiple refunds have occurred for the order and the store owner needs to know which item had been refunded. As you suggested, it would be nice to know if the refund was for shipping.
I think what he was saying is that most times, it is necessary to refund only the cost of one of the items in the order...not the whole order total or shipping. So I think he means to ask for a method of refunding ONLY the cost of any of the items in the order...individual or multiple items.
Yes, thanks for clarifying Embryo. We have been busy and laser focused with the MobSocial plugin and hadn't had the chance to respond.
Andrei, we definitely need the ability to refund just a single item because sometimes it's out of stock and the customer just wants the rest of the items and money back for the OOS item.
embryo wrote:
I would also suggest that an option to easily refund the shipping cost for an order would be useful.
And while we are on the subject of refunds, my bookkeeper has asked for a way to be able to track refunds...order ID, date issued, total, etc. If the refund was for $50, for example, she also wants to know exactly how much of the refund was for the product, and how much of the refund was for the shipping. This is critical information when performing a "Cost of Goods Sold" report.
There is cost on the Admin Product screens. Isn't the Cost of Goods Sold always the same regardless of partially or fully refunding shipping or product? Also, would you be able to provide your bookkeeper/accountant with your bank statement and map transactions to COGS?
embryo wrote:
Currently, the refunding process only updates the existing order totals, and keeps no record of the refund activity.
I'd suggest a new table for RefundActivity which store all activity and can be queried.
Agree. This would definitely be required when multiple refunds have occurred for the order and the store owner needs to know which item had been refunded. As you suggested, it would be nice to know if the refund was for shipping.
- 1390
- 11685
- 8/10/2012
- United States
breakskater wrote:
There is cost on the Admin Product screens. Isn't the Cost of Goods Sold always the same regardless of partially or fully refunding shipping or product? Also, would you be able to provide your bookkeeper/accountant with your bank statement and map transactions to COGS?
You're right...I was confusing another issue we're having with processing returns. My bookkeeper has also asked for a report of which products are actually returned into stock so that she can apply that against COGS (cost of goods sold) each month. Most products returned are not acceptable for resale, but some are, and evidently, adding them back into stock affects the COGS.
https://www.nopcommerce.com/boards/t/45931/questions-about-return-request-status.aspx#182272
Can we get some up-votes on these Refund processing suggestions??
There is cost on the Admin Product screens. Isn't the Cost of Goods Sold always the same regardless of partially or fully refunding shipping or product? Also, would you be able to provide your bookkeeper/accountant with your bank statement and map transactions to COGS?
You're right...I was confusing another issue we're having with processing returns. My bookkeeper has also asked for a report of which products are actually returned into stock so that she can apply that against COGS (cost of goods sold) each month. Most products returned are not acceptable for resale, but some are, and evidently, adding them back into stock affects the COGS.
https://www.nopcommerce.com/boards/t/45931/questions-about-return-request-status.aspx#182272
Can we get some up-votes on these Refund processing suggestions??
- 1390
- 11685
- 8/10/2012
- United States
Here's a graphic depicting how the partial refund screen could be extended according to these suggestions.
Below the option for choosing "Refund cost of particular item(s)" would be a grid showing each of the items in the order, with checkboxes adjacent.
This would eliminate the possibility of an admin accidently calculating the refund incorrectly.
In my graphic I made the label say "Refund cost of particular item(s)"
It should be: "Refund price of particular item(s)"
Below the option for choosing "Refund cost of particular item(s)" would be a grid showing each of the items in the order, with checkboxes adjacent.
This would eliminate the possibility of an admin accidently calculating the refund incorrectly.
In my graphic I made the label say "Refund cost of particular item(s)"
It should be: "Refund price of particular item(s)"
- 1390
- 11685
- 8/10/2012
- United States
embryo wrote:
Currently, the refunding process only updates the existing order totals, and keeps no record of the refund activity.
I'd suggest a new table for RefundActivity which stores all activity and can be queried.
To clarify, I am not suggesting that the current logic change in regards to updating the totals in the original order record when a refund is given. I am just suggesting that an "archival" table be added to store each refund action and be queryable for administrative/bookkeeping purposes.
Currently, the refunding process only updates the existing order totals, and keeps no record of the refund activity.
I'd suggest a new table for RefundActivity which stores all activity and can be queried.
To clarify, I am not suggesting that the current logic change in regards to updating the totals in the original order record when a refund is given. I am just suggesting that an "archival" table be added to store each refund action and be queryable for administrative/bookkeeping purposes.