Fermé

Magento Code for attached price calulation sheet

Hi

We need a price calculator extension as per attached excel sheet. In our store we have two types of customers Private and Company. The logic in excel sheet 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

Compétences : Magento, PHP

Voir plus : how to calculate prices on excel, code group, c12, code magento square meter price calculator, shipping price zip code magento, code magento design, correction price html code, price rule categorie magento, price excel code, price php code, magento cart price rules code, coupon code magento, code magento themes

Concernant l'employeur :
( 0 commentaires ) Norway

N° du projet : #8501309

15 freelance font une offre moyenne de $344 pour ce travail

bestworkontime9

Hello, I understand your requirement and have experience to do this type of work. I assure you that we complete your product on time with quality. Please check your Private Message Box for more details. Thank yo Plus

161 $ USD en 3 jours
(190 Commentaires)
7.4
sandyagg

Respected Buyer I have read your requirements and we are very much comfortable with this. We have an experienced team that will provide best services to you and will deliver project on time. We are ready to start your Plus

210 $ USD en 3 jours
(143 Commentaires)
7.1
mrinal981

Hello, I have gone through an attached excel sheet and have some question regarding cells. = > Can you please provide some detailed information on Cell A15 & Cell A16 i.e. what concept will be followed in savin Plus

210 $ USD en 5 jours
(55 Commentaires)
7.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

763 $ USD en 15 jours
(183 Commentaires)
6.9
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

382 $ USD en 5 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

284 $ USD en 3 jours
(210 Commentaires)
6.9
NextBitseu

you posted same project again, we ready to work on our given budget. you posted same project again, we ready to work on our given budget. you posted same project again, we ready to work on our given budget. yo Plus

1051 $ USD en 999 jours
(15 Commentaires)
6.7
NayaPakistan

A proposal has not yet been provided

200 $ USD en 5 jours
(202 Commentaires)
6.3
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

382 $ USD en 5 jours
(9 Commentaires)
5.6
saraca29n0v

A proposal has not yet been provided

178 $ USD en 6 jours
(11 Commentaires)
4.7
longthanh

A proposal has not yet been provided

777 $ USD en 5 jours
(14 Commentaires)
4.2
sidhartreetak100

Hallo, We are excited tell you the key points on why you should choose us to undertake the work on your site: - We have already implemented similar functionality for an existing customer, the customer is happy fo Plus

155 $ USD en 7 jours
(9 Commentaires)
4.3
CheapGoodWork

This is very much possible and I will do this in 2 3 days based on swift communication between us. I am an experienced magento developer with 5 years of experience so can configure this setup you have asked without an Plus

98 $ USD en 4 jours
(5 Commentaires)
3.1
phpdesprog

Hello Sir, How are you? Hope you are doing well. We already have gone through your requirements and we are very interested in doing this project for you. we are well versed with Web Designing & development technique Plus

155 $ USD en 3 jours
(0 Commentaires)
0.0
thecodejarvis

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0