# 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

## 22 freelance font une offre moyenne de \$362 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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(312 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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 19 jours
(178 Commentaires)
8.3
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(366 Commentaires)
8.1
pytho

﻿Hi, I am managing a professional web agency for more than 8 years. You can check my Themeforest profile with ratings here: [url removed, login to view], as well as the marketplace I build recently for prom Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(52 Commentaires)
7.1
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(210 Commentaires)
6.9
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(183 Commentaires)
6.9
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(223 Commentaires)
7.0
joyzazaza

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(47 Commentaires)
6.5
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 999 jours
(15 Commentaires)
6.7
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(21 Commentaires)
5.9
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(9 Commentaires)
5.6
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 9 jours
(61 Commentaires)
5.9
digidreamstech

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(35 Commentaires)
5.6
magespider

HI, Some more extensions which I developed are as follow. 1. Customer Feedback Collection Extension (Developed this extension for client) [url removed, login to view] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(32 Commentaires)
5.3
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(47 Commentaires)
5.7
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(9 Commentaires)
4.3
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(19 Commentaires)
4.6
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(4 Commentaires)
2.9