# Price Calculation Extension

I need a price calculator extension asper attached excel sheet. In our store we have two types of customers Private and Company. The logic in excel sheet (attached) is as follows:

1. Cell A6: Net cost: This is cost to store from product supplier. This will be filled manually.

2. Cell A7: Cost mark-up: The cost mark-up %age will be filled manually and the value will be calculated as netcost*costmarkup %age (C6*D7)

3. Cell A8: Net out price: it is sum of net cost and cost mark-up (C7+C8)

4. Cell A9: VAT: This is tax applicable on net out price. The tax %age (D9) will be filled manually and it will calculate VAT value in C9 as C8*D9

5. Cell A10: Out Price: it is total price to client including VAT i.e. sum of net out price and VAT (C8+C9)

The prices to a private customer group is Out price i.e. cell C10. Whereas prices to company customers will be shown net out price (i.e. without VAT). Cell C8.

Now if the product is on sale the prices will be readjusted based on how much %age off on those products. As soon as admin selects the product is on sale for a particular period it will work as follows:

1. First admin will activate that product is on sale. In this case it will gray out all the rows for normal prices.

2. Cell A11: Sale Price: Admin will fill sale %age off in cell D11 manually and it will calculate how much would be the out price including VAT in C11. And formula is C10*D11

3. Cell A12: Readjusted Net price w/VAT: It will calculate the net price without VAT. (C11/(1+D9) in cell C12

4. Cell A13: Re-adjusted VAT: In cell C13 the system will calculate new Vat value based on re-adjusted net value i.e. C12*D9

5. Cell A14: Readjusted mark-up: In cell C14, system will calculated adjusted mark-up automatically as C12-C6 and in D14 it will show same in %age i.e. (C14/C6)%

6. Cell A15: Savings to company customer group if product is on sale in C15 as C8-C12

7. Cell A16: Savings to private customer group if product is on sale in C16 as C10-C11

The prices to a private customer group will be shown Sale price i.e. cell C11. Whereas prices to company customers will be shown Readjusted Net price w/VAT i.e Cell C11.

For other details excel sheet attached.

Compétences : Magento, PHP

Concernant l'employeur :
( 0 commentaires ) Norway

N° du projet : #8499568

## 23 freelance ont fait une offre moyenne de 353 \$ pour ce travail

wildCat

Hello, Thank you for a detailed project description. Our certified Magento developers have reviewed your requirements and can offer you the solution. As we scan see, for a product on sale the price for private c Plus

341 \$ USD en 3 jours
(308 Commentaires)
8.4
bdsiddhi

Hi, Greetings !! We have built many Magento Websites before too. And we can meet exactly the same your needs for Price Calculator Extension. We are a team of 25 full time, dedicated developers having expertise Plus

1210 \$ USD en 19 jours
(98 Commentaires)
7.6
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

206 \$ USD en 8 jours
(240 Commentaires)
7.7
pytho

﻿Hi, I am managing a professional web agency for more than 8 years. You can check my Themeforest profile with ratings here: http://themeforest.net/user/modeltheme, as well as the marketplace I build recently for prom Plus

457 \$ USD en 8 jours
(44 Commentaires)
7.0
VnBestSolutions

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Plus

357 \$ USD en 10 jours
(121 Commentaires)
6.5
zyeloncomputech

Hi sir, Thank you for giving opportunity for biding... we have gone through your requirements and we can build your Price Calculation Extension for magento according to your exact requirements. Please Before A Plus

894 \$ USD en 15 jours
(134 Commentaires)
6.6
NextBitseu

Greetings Employer, We are already done with some custom prizing solutions in Magento which we can customize for your expected Job. Go through below URL where you could able to see our already customized Extensio Plus

684 \$ USD en 999 jours
(10 Commentaires)
6.3
joyzazaza

Hello I have huge experience in Magento Please give me the Chance And I will return you quality work Thanks A lot!

736 \$ USD en 7 jours
(40 Commentaires)
6.3
technovation1

hi there I have gone through requirements and attached excel file carefully and I can design the Price calculation Plugin as per your requirements. I am a 6+ years experienced professional having expertise in web Plus

180 \$ USD en 3 jours
(161 Commentaires)
6.6
achieveseo

Hello, I am an 5 years experienced freelancer in the website design field and I have knowledge of various technologies like PHP, Joomla, Wordpress, Magento, CSS, Java Script, Ajax, jquery, Photoshop, this is why I am Plus

461 \$ USD en 8 jours
(6 Commentaires)
5.5
digidreamstech

Check attach Excel file [Description,Rate,%age,Total Savings] and also analyzed Extension detail very carefully.We will do it. If you provide me more detail about then we are ready to start the work right Now.we have a Plus

200 \$ USD en 12 jours
(34 Commentaires)
5.6
magespider

HI, Some more extensions which I developed are as follow. 1. Customer Feedback Collection Extension (Developed this extension for client) http://www.magentocommerce.com/magento-connect/customer-feedback-collectio Plus

247 \$ USD en 8 jours
(28 Commentaires)
5.2
kotharigaurav90

Hello, i have checked your project and would like to have your project. I am confident to fulfill your requirements in timely manner, along with quality work. Please check your pmb.

111 \$ USD en 3 jours
(40 Commentaires)
5.6
nitishthelegend

Hey, I will not write long copy and pasted messages as my trophies and my feedback speak for themselves. I saw your detailed excel table and I've read the logic and I build your Magento extension for it. I understan Plus

445 \$ USD en 7 jours
(16 Commentaires)
5.0
SamDevelopers

HELLO Thanks for giving me chance to submit my parposal on your task and taking a minute to read my profile brief.I have read project requirements and i assured you 100% completion and best quality in reasoanble p Plus

175 \$ USD en 3 jours
(13 Commentaires)
4.4
Websitemaestro

Hi I have gone through the details of your project and we find it well within our capabilities. I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excite Plus

88 \$ USD en 9 jours
(24 Commentaires)
3.8
itwebworld

Respected sir > , VI World is Indian base company. You can see our work at www.visainfoworld.com or in portfolio section. We provide best solution in low cost . So we want to discuss about your requirement. If you shor Plus

144 \$ USD en 3 jours
(45 Commentaires)
4.2
Tech9logyDev

Hi, I am Magento/PHP Expert and is feasible for me to Develop a Magento Calculator Extension as required. I have 4 years of experience and have Developed & Customized various Custom Magento Extensions. Calculato Plus

189 \$ USD en 2 jours
(4 Commentaires)
2.9
sidhartreetak100

Hallo, We are excited tell you the key points on why you should choose us to undertake the work on your site: - We appreciate the task at hand - the task is to display different prices: o depending on whether th Plus

250 \$ USD en 7 jours
(2 Commentaires)
2.8