[Skip to main content](#vessel-content) # add costprice to products - See earning pr. order ## - **[Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile")** - [![Symbiot's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6370-symbiot "View Symbiot's Profile") Topic Author - [ Offline](/forum/user/6370-symbiot) Less More - Posts: 25 - Thank you received: 0 - - 14 years 5 months ago [\#50714](#50714) by [Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile") *[add costprice to products - See earning pr. order](/forum/4-how-to/50714-add-costprice-to-products-see-earning-pr-order#50714 "Possible? To add the costprice pr. unit and then get an overview of how much money is earned pr. order completed?")* was created by *[Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile")* Possible? To add the costprice pr. unit and then get an overview of how much money is earned pr. order completed? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUwNzE0LWFkZC1jb3N0cHJpY2UtdG8tcHJvZHVjdHMtc2VlLWVhcm5pbmctcHItb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 14 years 5 months ago [\#50760](#50760) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: add costprice to products - See earning pr. order](/forum/4-how-to/50714-add-costprice-to-products-see-earning-pr-order#50760 "Possible? To add the costprice pr. unit and then get an overview of how much money is earned pr. order completed?")* Can you give more information on what you want to do ? Of course, you can add shipping methods with weight restrictions and have all your products weight the same and have an additional fees calculated like that on your checkout, but I'm not sure if that's what you want ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUwNzE0LWFkZC1jb3N0cHJpY2UtdG8tcHJvZHVjdHMtc2VlLWVhcm5pbmctcHItb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile")** - [![Symbiot's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6370-symbiot "View Symbiot's Profile") Topic Author - [ Offline](/forum/user/6370-symbiot) Less More - Posts: 25 - Thank you received: 0 - - 14 years 5 months ago [\#50811](#50811) by [Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile") Replied by *[Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile")* on topic *[Re: add costprice to products - See earning pr. order](/forum/4-how-to/50714-add-costprice-to-products-see-earning-pr-order#50811 "Possible? To add the costprice pr. unit and then get an overview of how much money is earned pr. order completed?")* Hi. What i'd like to do is add the costprice of each item,so I can see the amount earned pr. Transaction. LIke: Product 1 price: $5 Cost price: $2 user buys 6 product1 totalprice:$30 Earnings for order: $18 A quick way to see how much money is earned everytime someone orders something off the we shop.. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUwNzE0LWFkZC1jb3N0cHJpY2UtdG8tcHJvZHVjdHMtc2VlLWVhcm5pbmctcHItb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 14 years 5 months ago [\#50869](#50869) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: add costprice to products - See earning pr. order](/forum/4-how-to/50714-add-costprice-to-products-see-earning-pr-order#50869 "Possible? To add the costprice pr. unit and then get an overview of how much money is earned pr. order completed?")* There is no option for that. You would have to develop such feature. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUwNzE0LWFkZC1jb3N0cHJpY2UtdG8tcHJvZHVjdHMtc2VlLWVhcm5pbmctcHItb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Wilkinson](/forum/user/13124-wilkinson "View Wilkinson's Profile")** - [![Wilkinson's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13124-wilkinson "View Wilkinson's Profile") - [ Offline](/forum/user/13124-wilkinson) Less More - Posts: 6 - Thank you received: 3 - - 13 years 9 months ago [\#87421](#87421) by [Wilkinson](/forum/user/13124-wilkinson "View Wilkinson's Profile") Replied by *[Wilkinson](/forum/user/13124-wilkinson "View Wilkinson's Profile")* on topic *[add costprice to products - See earning pr. order](/forum/4-how-to/50714-add-costprice-to-products-see-earning-pr-order#87421 "Possible? To add the costprice pr. unit and then get an overview of how much money is earned pr. order completed?")* Ok, this is a very old post but just in case anyone searches for this same question... Although very new to HikaShop Business version I was also looking for the option to record and report on product cost price and therefore gross profit. It would seem as simple as adding a custom field to product table naming the column `cost_price` or similar to only be shown/displayed on the 'back-end'. This would then provide the data for a SQL query (via PHPMyAdmin or similar) to generate report on gross sales against cost of products... The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUwNzE0LWFkZC1jb3N0cHJpY2UtdG8tcHJvZHVjdHMtc2VlLWVhcm5pbmctcHItb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 13 years 9 months ago [\#87696](#87696) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[add costprice to products - See earning pr. order](/forum/4-how-to/50714-add-costprice-to-products-see-earning-pr-order#87696 "Possible? To add the costprice pr. unit and then get an overview of how much money is earned pr. order completed?")* Yes, having the data in the product and then doing the query in SQL via phpmyadmin is indeed possible. I guessed that Symbiot wanted to have the data displaying in the orders directly and that he was not a programmer (which is the case of most of our users). And what you're suggesting would require some coding in the orders display to load the statistics from the database and display them. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUwNzE0LWFkZC1jb3N0cHJpY2UtdG8tcHJvZHVjdHMtc2VlLWVhcm5pbmctcHItb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile")** - [![Symbiot's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6370-symbiot "View Symbiot's Profile") Topic Author - [ Offline](/forum/user/6370-symbiot) Less More - Posts: 25 - Thank you received: 0 - - 13 years 9 months ago [\#87740](#87740) by [Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile") Replied by *[Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile")* on topic *[add costprice to products - See earning pr. order](/forum/4-how-to/50714-add-costprice-to-products-see-earning-pr-order#87740 "Possible? To add the costprice pr. unit and then get an overview of how much money is earned pr. order completed?")* Yes, exactly... Wilkinson is this something you could do? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUwNzE0LWFkZC1jb3N0cHJpY2UtdG8tcHJvZHVjdHMtc2VlLWVhcm5pbmctcHItb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Wilkinson](/forum/user/13124-wilkinson "View Wilkinson's Profile")** - [![Wilkinson's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13124-wilkinson "View Wilkinson's Profile") - [ Offline](/forum/user/13124-wilkinson) Less More - Posts: 6 - Thank you received: 3 - - 13 years 9 months ago [\#87761](#87761) by [Wilkinson](/forum/user/13124-wilkinson "View Wilkinson's Profile") Replied by *[Wilkinson](/forum/user/13124-wilkinson "View Wilkinson's Profile")* on topic *[add costprice to products - See earning pr. order](/forum/4-how-to/50714-add-costprice-to-products-see-earning-pr-order#87761 "Possible? To add the costprice pr. unit and then get an overview of how much money is earned pr. order completed?")* @nicolas - totally agree @Symbiot - in theory yes, but I am very new to HikaShop and extremely busy learning as I go configuring for urgent project! Perhaps there is someone out there with more time... As a first step, you need to at least create the custom field in the product table - make sure you limit display to 'back-end' (admin) only. You will then see this in the Product add/edit admin forms and you can then start entering your cost prices. I personally would't attempt to code the reporting in to HikaShop - this may be a good feature for the 'wishlist'! I would just use PHPMyAdmin or other SQL tools to extract the data and create reports. If I get some time to dig deeper into this I will post my methods. The following user(s) said Thank You: [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile"), [fjfelipetovar](/forum/user/13477-fjfelipetovar "View fjfelipetovar's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUwNzE0LWFkZC1jb3N0cHJpY2UtdG8tcHJvZHVjdHMtc2VlLWVhcm5pbmctcHItb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile")** - [![Symbiot's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6370-symbiot "View Symbiot's Profile") Topic Author - [ Offline](/forum/user/6370-symbiot) Less More - Posts: 25 - Thank you received: 0 - - 12 years 8 months ago [\#146554](#146554) by [Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile") Replied by *[Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile")* on topic *[add costprice to products - See earning pr. order](/forum/4-how-to/50714-add-costprice-to-products-see-earning-pr-order#146554 "Possible? To add the costprice pr. unit and then get an overview of how much money is earned pr. order completed?")* Did this feature ever progress..? Wondering if Hikashop developers took this into their 'todo' list? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUwNzE0LWFkZC1jb3N0cHJpY2UtdG8tcHJvZHVjdHMtc2VlLWVhcm5pbmctcHItb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 12 years 7 months ago [\#146847](#146847) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[add costprice to products - See earning pr. order](/forum/4-how-to/50714-add-costprice-to-products-see-earning-pr-order#146847 "Possible? To add the costprice pr. unit and then get an overview of how much money is earned pr. order completed?")* It's not something we have been working on so far. We are focused on different other thing at the moment and it's not a feature that is requested a lot. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUwNzE0LWFkZC1jb3N0cHJpY2UtdG8tcHJvZHVjdHMtc2VlLWVhcm5pbmctcHItb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile")** - [![Symbiot's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6370-symbiot "View Symbiot's Profile") Topic Author - [ Offline](/forum/user/6370-symbiot) Less More - Posts: 25 - Thank you received: 0 - - 12 years 7 months ago [\#146852](#146852) by [Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile") Replied by *[Symbiot](/forum/user/6370-symbiot "View Symbiot's Profile")* on topic *[add costprice to products - See earning pr. order](/forum/4-how-to/50714-add-costprice-to-products-see-earning-pr-order#146852 "Possible? To add the costprice pr. unit and then get an overview of how much money is earned pr. order completed?")* Hi Eliot.. Thanks for your reply.. I would've thought that seeing your costprices in your shop would be one of the cornerstones of any shop.. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUwNzE0LWFkZC1jb3N0cHJpY2UtdG8tcHJvZHVjdHMtc2VlLWVhcm5pbmctcHItb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.105 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)