Website PHP and SQL shopping cart tweaks

In Progress

Description

Worked required is to make some tweaks to an existing website and shopping cart.

The existing code simply allows items with stock > 0 to be added to cart and ordered regardless of any potential stock shortage.

Tasks:

1) At time of adding to cart or cart qty update, If customer order qty is > than stock avilable then cart page needs to be refreshed, with order qty = stock avilable and clearly labeled to user in the cart.

i.e. in Red text below each product in cart "Note: Order qty has been ammended to max stock avilable"

2) Change cart so that at time of user submitting order, order qty (count) is subtracted from existing stock in SQL database 'stock_level'. i.e. Stock is kept current.

3) Im not a coder, so not sure what implcations there are for multiple customers ordering at the same time. i.e. Check again before submitting/lodging order?

Website uses SQL database for products, PHP and smarty.

At time of order submission this bit of code is used to fetch product details and may be the place to update stock ('stock_level'='stock_level-'count') back into SQL database? (2)

if (is_array($items)) {

foreach($items as $key => $value) {

$product = $productData->GetProduct($key);

if ($product) {

array_push($products, array(

'id' => $product_id,

'external_key' => $product['external_key'],

'name' => $product['name'],

'size_x' => $product['size_x'],

'size_y' => $product['size_y'],

'size_z' => $product['size_z'],

'weight' => $product['weight'],

'count' => $value,

'stock_level' => $product['stock_level'],

'price' => $product['price']));

Im not a coder so not sure what additional information would be required to bid or complete the job. Well, obviously more.

Skills: HTML, MySQL, PHP, Shopping Carts, Website Design

See more: php sql shopping cart website, php sql shopping cart, website price value, website code and design price, value website, sql price, sql database website design, shopping cart price, price for shopping cart, order design website, id design website, website php sql shopping cart tweaks, website with shopping cart, sql database website, sql code, Sql 2012, sql update text, update stock, php sql code, smarty shopping cart, php text array, update code sql, sql required, update text sql, shopping cart website complete

Project ID: #1443509

15 freelancers are bidding on average $264 for this job

tomydeveloper

Hello,We are php / mysql / smarty expert and already create many ecommerce / shopping sites.Please check pmb for more detail and demo.Thanks

$250 USD in 7 days
(359 Reviews)
7.9
phpdevindia

Hello sir,we can solve the problems. we have more than 7 years of experience and have strong portfolio in smarty and php.Kindly check your inbox for more details. THanks

$200 USD in 4 days
(167 Reviews)
7.4
thelogicgates1

Hi, Ready to start. Check PMB please.

$198 USD in 3 days
(78 Reviews)
7.0
canlan318

Dear sir. I sent you a private message. Please check it. Regards.

$180 USD in 3 days
(84 Reviews)
6.9
khanhhuyna

I'm familiar with shoppingcart script and smarty framework as well so that i'm very interested in working this for you. Thanks.

$250 USD in 4 days
(111 Reviews)
6.8
dotsaravanan

Thanks for your post, kindly have a look on our PMB

$250 USD in 5 days
(25 Reviews)
6.5
vipmerv

PHP developer with smarty experience (Dynamic Frameworks). Kindly please refer to PMB for my samples work and lets get started. -Merv-

$300 USD in 5 days
(111 Reviews)
6.1
westcowboy

hi,im ready

$175 USD in 2 days
(23 Reviews)
5.1
pritamdutta

Hello ,I have gone through your requirements and am interested in doing this project .

$180 USD in 6 days
(8 Reviews)
5.0
webwinger1

Dear Sir, Webwingtechnologies Software offers a wide range IT Services. We have over 23 programmers, all experts in their various respective programming disciplines plus a team of project and sales managers. Webwing More

$240 USD in 5 days
(3 Reviews)
4.4
devloperIT

php/mysql/shopping cart experienced

$500 USD in 4 days
(14 Reviews)
4.4
moovmoov1

can do the shopping cart tweaks for you.

$100 USD in 5 days
(6 Reviews)
3.5
whatjj

I can take care of this for you.

$280 USD in 2 days
(0 Reviews)
0.0
JonathanHarvey

Hi, I'm Jonathan Harvey, I'd like to start of by saying this isn't a "recycled" proposal. I'd like to secondly say, that I'd absolutely love to work on this project. I've sent you a private message with more details More

$250 USD in 2 days
(0 Reviews)
0.0
sijojohn7

Dear Sir, We are having a team of technologies expert working in different technologies like php,Joomla, Smarty,.net, C with our company. We are fully Profession Company and believe to give you full return for which More

$250 USD in 5 days
(0 Reviews)
0.0
Manvi73

we can do this project...have good experience on these type of projects...

$600 USD in 15 days
(0 Reviews)
3.6