add costprice to products - See earning pr. order

  • Posts: 25
  • Thank you received: 0
12 years 5 months ago #50714

Possible?

To add the costprice pr. unit and then get an overview of how much money is earned pr. order completed?

Please Log in or Create an account to join the conversation.

  • Posts: 82727
  • Thank you received: 13342
  • MODERATOR
12 years 5 months ago #50760

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 or Create an account to join the conversation.

  • Posts: 25
  • Thank you received: 0
12 years 5 months ago #50811

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 or Create an account to join the conversation.

  • Posts: 82727
  • Thank you received: 13342
  • MODERATOR
12 years 5 months ago #50869

There is no option for that.
You would have to develop such feature.

Please Log in or Create an account to join the conversation.

  • Posts: 6
  • Thank you received: 3
11 years 9 months ago #87421

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

Please Log in or Create an account to join the conversation.

  • Posts: 82727
  • Thank you received: 13342
  • MODERATOR
11 years 9 months ago #87696

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 or Create an account to join the conversation.

  • Posts: 25
  • Thank you received: 0
11 years 9 months ago #87740

Yes, exactly...

Wilkinson is this something you could do?

Please Log in or Create an account to join the conversation.

  • Posts: 6
  • Thank you received: 3
11 years 9 months ago #87761

@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, fjfelipetovar

Please Log in or Create an account to join the conversation.

  • Posts: 25
  • Thank you received: 0
10 years 8 months ago #146554

Did this feature ever progress..?

Wondering if Hikashop developers took this into their 'todo' list?

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
10 years 8 months ago #146847

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 or Create an account to join the conversation.

  • Posts: 25
  • Thank you received: 0
10 years 8 months ago #146852

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 or Create an account to join the conversation.

Time to create page: 0.074 seconds
Powered by Kunena Forum