Find Jobs
Hire Freelancers

Magento Code for attached price calulation sheet

$30-250 USD

Lezárt
Kiadva ekkor: több mint 8 évvel ezelőtt

$30-250 USD

Teljesítéskor fizetve
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
Projektazonosító: 8501309

A projektről

15 ajánlat
Távolról teljesíthető projekt
Aktiválva: 9 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
15 szabadúszó adott átlagosan $344 USD összegű árajánlatot erre a munkára
Felhasználó avatár
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 you, Govind sharma
$161 USD 3 napon belül
5,0 (190 értékelés)
7,4
7,4
Felhasználó avatár
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 project immediately. Your need is very much clear to me and we are very exited to work on your wonderful project. We build web application - Simple User Friendly Attractive Full Responsive. And Seo Ready. Hope you will give positive response to us and we will provide best service in a good cost and within time period. Thanks & Regards UBWebs
$210 USD 3 napon belül
5,0 (143 értékelés)
7,1
7,1
Felhasználó avatár
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 saving customers ? ~ Skilled in magento / php / mysql ~ Well aware of magento standards ~ Available to discuss Well experienced in developing custom template, extensions, API, performing various tasks related to magento core concepts, admin, payment gateways or any third party integration, optimizing site speed, caching as well as testing. Looking forward to hear from you. Regards
$210 USD 5 napon belül
4,8 (55 értékelés)
7,5
7,5
Felhasználó avatár
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 !! Looking forward to hear from you soon - GOD Bless You.
$284 USD 3 napon belül
4,9 (210 értékelés)
6,9
6,9
Felhasználó avatár
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. 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. 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. 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.
$1 051 USD 999 napon belül
4,8 (15 értékelés)
6,7
6,7
Felhasználó avatár
A proposal has not yet been provided
$200 USD 5 napon belül
4,9 (202 értékelés)
6,3
6,3
Felhasználó avatár
A proposal has not yet been provided
$178 USD 6 napon belül
4,4 (11 értékelés)
4,7
4,7
Felhasználó avatár
A proposal has not yet been provided
$777 USD 5 napon belül
5,0 (14 értékelés)
4,2
4,2
Felhasználó avatár
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 for us to provide you with a live demonstration, prior to award of the contract. Please add reetak101 on skype to discuss further (or anything else you may prefer). - We are based in the UK with an expert Magento team based in India – therefore we can be competitive and at the same time provide a high level of customer service. - We have a wide range of experience outside of freelancer in successfully completing large projects based on Magento, and we are looking to build our portfolio on freelancer. We will therefore dedicate our efforts to complete the project within 3 days but to accommodate for uncertainty we will deliver within 7 working days. - We are looking to build a sustainable relationship with you, to undertake any ad-hoc requests you may have in the future. I hope this offer is of interest to you, and I look forward to hearing back, Best regards, Reeta Business Development Manager
$155 USD 7 napon belül
5,0 (9 értékelés)
4,3
4,3
Felhasználó avatár
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 any issues. Pay when satisfied!! :)
$98 USD 4 napon belül
4,6 (5 értékelés)
3,1
3,1
Felhasználó avatár
A proposal has not yet been provided
$155 USD 3 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

NORWAY zászlója
Norway
0,0
0
Tagság kezdete: szept. 18, 2015

Ügyfél-hitelesítés

További munkák ettől az ügyféltől

Price Calculation Extension
$30-250 USD
Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.