asked on

help idea needed

i was asked to make a system for shop which use barcode to identify goods.

problem i have is

the owner buys goods lets say a soap, he buys same brand soap from one dealer a price of 10$ then he buys same brand from another dealer for 12$

but this brand has one barcode.

so when generating a report regarding profits etc.. report will not 100% accurate due to those prices.

what is the way to solve this?

Thanks

gavsmith

You must use (and store) an average cost price for the item, updated each time the item is purchased. Please let me know if you need more details.

pixalax

Hello 3xtr3m3d,
If you want it to be accurate then you will have to keep buying price each time a stock is added to the system / store and keep it in your database.

pixalax

@gavsmith;
Avarage cost will not make it 100% accurate. Storing buying price + stock amount is the only way to make it 100% accurate. 1 month from now, if those prices will change to $15 to - $17, putting an input on items page or stocks page where admin could define;

How many soap / product company bought

What was the buying price

This way, you can also prepare more detailed statistics if it is needed. Such as if you also keep dates, company names etc,;

How much products were bought last month / week / year etc..

What was the cost of the items for the last month / week / year etc...

You could keep adding more and more details, if you keep such details for each item / products is bought, this will definitely help you to have more accurate & detailed statistics.

pius_babbun

If you are able to find out the basic price for the products(with out any additional charges and tax) , you can easily update the find the difference between all the dealers.This way you can fine tune your code to get the additional prices and add it at the end of the barcode reading. Check if this suggestion is helpful to you.

gavsmith

I would love for you to explain why average cost is not accurate for a profit report... we use it all the time and it is accurate! Our prices change all the time. You seem to be talking about purchase order history not profit reports.

3xtr3m3d

ASKER

Hi

Thanks all for the information and for the quick replies.

in this case owner buy same product from several dealers for several prices and sell all at a fixed price.

so when sell there is no way to select the dealer and if i put option to select dealer it will not Suitable right?

so keep a average buying price is good?

ASKER CERTIFIED SOLUTION

gavsmith

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pixalax

Keeping average price is not good. Your statistics will not be accurate. If there is only 1 dealer or no dealer at all, I suggest you to keep exact buying price / cost in your database, each time a new stock is added.

Ray Paseur

If you want an exact price, you must record an exact price. Just because the UPC barcode is the same only means that the products are identical. What I would do with this situation would be to create a table of vendors, barcodes, and prices. Then you can easily see which vendor is giving you the best price.

Under the GAAP you are OK to report blended rates for the cost of commodity items. But as a businessman you should try to get the lowest overall cost, price and other factors considered.

3xtr3m3d

ASKER

Thanks all and Thanks gavsmith

seems like gavsmith's suggestion is works accurate for calculate profit

gavsmith

Your welcome... and even though I knew what you meant with the profit report (and your question).

It is still important to create detailed purchase order history for reasons others have already mentioned.

Regards
Gav