Devam Ediyor

Fees And Net Amount Based On Gross Calculations

Fees And Net Amount Based On Gross Calculations

OVERVIEW

We have a fully functional eccomerce website. When an order is placed, one record is submitted into the orders table. The "total" field, of course, is the grand total amount of the sale and many times referred as gross.

GOAL

I need two calculations based off of the "total" field. First, the "fee" field will be .05% of the "total" field. Second, the "netamount" field will be .95% of the "total" field. I want a PHP script or some SQL statement to create these calculations when the order is submitted at the verify page.

EXAMPLE

Product: Baldor Inverter Duty Gearmotor $250 + $50 shipping + $0 tax = $300 total

FIELD AMOUNTS

total----300

fee----15

netamount----285

See sample image of orders table fields.

ORDER SUBMITTED LOCATION

[url removed, login to view]

Scripting Language: PHP with MySQL Database

Shopping Cart: WebAssist eCart 4.1

Send me a private message regarding... whether you plan on using a PHP script or some SQL statement and the results of the work in completing this project here. I'm trying to understand the best approach to this.

----------------------------------------------------------------------------

INFORMATION PROVIDED:

Above, I have provided what I believe is all the information regarding this project with exception to login information to the FTP & database. Please base your bid on this but I will be happy to answer questions and exchange correspondence through this website's personal message board during the development of this work. Try to keep in mind of time zones differences if responses aren't immediate.

Beceriler: e-Ticaret, MySQL, PHP, SQL

Daha fazlasını görün: gross orders placed, sql fees, net amount gross mysql, zones, website development fees, project overview sample, personal shopping cart, pending amount, language overview, best website development language, base exception, baldor, best scripting language, website based net, try on, sql based, project fees, inverter, fees, development net, database calculations, calculations, board plan script, image net, work plan sample

İşveren Hakkında:
( 31 değerlendirme ) Antioch, United States

Proje NO: #723729

Seçilen:

nrifriends

Please check your pm.

1 gün içinde 50$ USD
(53 Değerlendirme)
7.0

17 freelancer bu iş için ortalamada 45$ teklif veriyor

ambar

Dear Sir/Madam, Please check my private message. Thanks Shome.

in 3 gün içinde45$ USD
(132 Değerlendirme)
8.0
brycep

Hi Marty,I am back to work again..would you like to display the changes on frontend or only database.Thanks,Bryce

1 gün içinde 55$ USD
(232 Değerlendirme)
8.0
kssoftphp

I can do your work

in 0 gün içinde30$ USD
(93 Değerlendirme)
6.9
cristisst

i can do it in seconds

in 0 gün içinde30$ USD
(102 Değerlendirme)
6.1
psxl88

I am ready to start

in 0 gün içinde30$ USD
(58 Değerlendirme)
5.8
panamaspace

Ready to go. See PM.

in 0 gün içinde30$ USD
(23 Değerlendirme)
5.4
tjpotts

Hi, I'm an independent/hobbyist web developer. I could easily provide this functionality for you in just minutes using a simple PHP script. I am looking forward to hearing from you.

in 0 gün içinde30$ USD
(7 Değerlendirme)
4.8
samarthsol

Samarthsol is an established Software Solution Company based in India,started by a group of dedicated professionals, who have more than seven years of extensive experience in the Software field. Our mission is to cons Daha fazlası

1 gün içinde 30$ USD
(16 Değerlendirme)
4.3
vrushabh

please check pmb

in 2 gün içinde30$ USD
(5 Değerlendirme)
3.2
sankethshah

Will be done successfully. Please check PM.

in 0 gün içinde30$ USD
(1 Değerlendirme)
1.2
srinivas2k77

Some of our work : Vijayaflorist.com cengohyderabad.com hrfoundation.com

in 6 gün içinde100$ USD
(0 Değerlendirme)
0.0
phpmast3r

Ready to start Sir. pls check inbox.

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
webglobalinfotec

We have a fully functional eccomerce website. When an order is placed, one record is submitted into the orders table. The "total" field, of course, is the grand total amount of the sale and many times referred as gross Daha fazlası

in 20 gün içinde150$ USD
(0 Değerlendirme)
0.0
sankalplondon3

Please let me know when I have to start the work for u , I could even show u my latest website I am available on skype add me as sankalpsaxena7

1 gün içinde 36$ USD
(0 Değerlendirme)
0.0
sanjaysavade

I am java an SQL developer. I have around 4 year experience. I would like to know in more depth about your requirement.

in 2 gün içinde30$ USD
(0 Değerlendirme)
0.0
CouchLizzard

I have a few solutions that could work well for you. Please check the PMB.

in 2 gün içinde30$ USD
(0 Değerlendirme)
0.0