Website PHP and SQL shopping cart tweaks

Budget $30 - $250 USD
Bids 16
Average Bid $263

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.

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • tomydeveloper Profile Picture

    tomydeveloper

    Jaipur,  India

    We are dedicated to provide our clients with the best services in web development and web designing. We have expertise in web content development and publication, particularly in WordPress and Joomla. We also help the clients in their web designing needs with mediums like Cake PHP, Codeigniter, Zencart, Prestashop, XML, RETS feed and Opencart. Our excellence in an extensive assortment of services has helped us cater to a wide range of clientele. We offer all sorts of web hosting services. We also provide services in Logo creation and Video making. We deliver web designing which is responsive and hence compatible with all kinds of devices. Skills and Experience WordPress development with all device compatibility is our area of expertise. Just hire us for the WordPress responsive themes and you will get the best work. Services We offered 24/7 Support Free revisions 6 Months after sales support

    PHP, Javascript, Script Install, and Website Design

  • westcowboy Profile Picture

    westcowboy

    hamilton,  New Zealand

    We are a small company selling virtuemart joomla extensions, and seeking to spread our business out to other cms/ecommerce platform. Customer requirements and correct market direction are our souls. Your satisfactory are our highest aim.

    PHP, Javascript, AJAX, and Joomla

  • thelogicgates1 Profile Picture

    thelogicgates1

    Lahore,  Pakistan

    I am ready to be hired by you as a Android Developer. I have a firm technical experience and the apt educational qualification that would fit best all your Android jobs. I have been successful in jobs relating to Android, ASP and C# Programming. I will also be a live starter and provide my exceptional contribution in serving for your company and your customers. I also have a great experience working as a CSS Programmer and as a eCommerce Developer. If hired by you, I will deliver work of a high standard for your jobs.

    PHP, ASP, Visual Basic, and Website Design

  • sijojohn7 Profile Picture

    sijojohn7

    surat,  India

    PHP, Javascript, .NET, and Website Design

  • moovmoov1 Profile Picture

    moovmoov1

    Male,  Maldives

    I am good at what I do.

    PHP, Visual Basic, Training, and AJAX

  • khanhhuyna Profile Picture

    khanhhuyna

    Vinh,  Vietnam

    Im Huy, i'm working in an outsourcing team. We're working in web area ( php/mysql) with more than 5 experienced year. With our experience and sktill in web area we always provide quick and high quality web applications with after-sale supports. Let's start your project with us. I and my team is ready here..

    PHP, C Programming, Java, and Javascript

  • JonathanHarvey Profile Picture

    JonathanHarvey

    Portland,  United States

    "Don't aim for success if you want it; just do what you love and believe in, and it will come natural." Those are the words of the great David Frost and they are words that I have come to live by. I have been in love with the web from the very start; when I was about 12 years old I started building websites for friends of my family, and as the years continued my client base started to move to local businesses, and now, I have done work for clients all over the world. To me, there has been almost nothing better than beautifully crafting code, and watching it being constructed in front of my eyes in in a browser. From code that would seem to an outsider, foreign at best, but seemed to me so natural, into a modern and universal communication apparatus: the web. My love for web development has lead me many places but I believe that most importantly it has lead me to success. I love what I do, I'm able to put my heart and my soul into every project, creating sites clients love as well.

    PHP, Javascript, Website Design, and Internet Marketing

  • webwinger1 Profile Picture

    webwinger1

    Nasik,  India

    As an experienced IT Technology sales professional & management, it is my goal to provide work to my respected company thorough Bidding with respected client and good selection of clients. I would be interested in speaking with Respected clients about projects & technology to improve our business. I am an expert on management, coding and custom label solutions. Specialties Web designs & development, Graphics design, Application development ( IPhone, Android,Black berry),Software development , SEO

    PHP, ASP, Javascript, and XML

  • pritamdutta Profile Picture

    pritamdutta

    Kolkata,  India

    INTRODUCTION UCDS is working with the Indian Railway for last 50 years with their CIVIL Engineering skill and other government, semi government, public PSU companies. Now it evolves as an IT solution provider since last three years and based in INDIA. We are excel in Web Development, Portal Development, E-Commerce, Application and Component Based Software Solutions, Multimedia Presentations, 2D & 3D Animation Services,OFC,Networking and any other related work in the field of Information Technology. We focus on developing easy, efficient and effortless solutions for our clients. With our technical background and the help at our disposal we can provide high quality, cost effective and timely IT solutions and services to our clients through an environment of collective innovation. We do guarantee personalized attention, open communication, accuracy and delivery on time at competitive prices. Technology Our time tested, state-of-the-art and emerging technology solutions are backed by the highest level of quality assurance. We deliver robust and feature-rich IT solutions that result in increased brand awareness, sales and customer service. OUR SKILL SETS • For Database Handling we are fully conversant with MS-Access, MS-SQL Server, Oracle, MySQL and Sybase SQL Anywhere. • For Design and Development we use C, C++, Java, Power Builder, VB and VB.NET, ASP and ASP.NET, J2EE. • For Web Development we use HTML, DHTML, XML, PHP, ASP, ASP.NET, JavaScript, VBScript, Java, Servlet, EJB, and JSP. • For Multimedia anything from Photoshop to Flash to 3d MAX OUR INFRASTRUCTURE UCDS has an excellent infrastructure in the heart of city, Kolkata, INDIA, the largest metro police in the eastern region of the country, with the latest infrastructure required for IT industry. The facility is located in a posh commercial center with all essential amenities. There is a 100% power back up and foolproof security mechanism. UCDS IT infrastructure comprises of latest Hardware, Software. Dual Internet Backbone with high-throughput to support our requirements of high bandwidth ensuring us seamless connectivity with zero downtime. Our infrastructure is sufficient to support our customer. UCDS has Project Managers and Business Development Professionals who work as a team to deliver best-of-the-breed services to clients around the world. Our philosophy helps us better understand the client’s requirements along with synergized 24/7 communication which requires a dedicated team onsite. UCDS also has in place a Disaster Recovery Policy to manage and pre-empt any disaster. The DRP Policy will enable us to continue our business in cases of any major disaster with no loss to our client’s business. We understand the essentials of business continuity and have sound plans in place to take care of any disruptions that may affect our smooth functioning. UCDS has an adequate and well-protected Infrastructure that is built to take care of the scaling-up requirements of our partners/clients. UCDS Technologies offers to its Customers simple and convenient rules, which make working with the Company both pleasant and predictable. UCDS is a Company started operation at Kolkata (Calcutta) in 2004, INDIA. We have created the most simple client interaction scheme. If your company becomes our client, your specialists would not need to spend a lot of time communicating with us. Currently the Company employs about 40 people in which 2 are highly skilled M’Tech holder 25 people are B’Tech in Information & Technology and others are from various field. UCDS Technologies also uses the services of some government organization in India. We achieve very high product quality due to a well-structured and elaborate system of work organization for our employees. The principal features of our work organization system are shown at our Site so that our potential customers would understand how we achieve high product quality. OUR SERVICES INCLUDES Our main area of business is to develop Customized Software, Website Development, Portal Development, E-Commerce and Multimedia Applications in line with the latest trends that are user friendly, reliable and cost-effective, taking into account the available human expertise, technological levels and quality practices. In specific cases depending on client's requirement we also undertake re-engineering of existing software systems. On the whole we assure long-term commitment and seek relationship that would enable us to be accepted as a reliable associate who would take care of your entire system's problem with full assurance to achieve targets. In order that our clients get the best of the services, we continuously strive to adopt improved technologies for development of software solutions. Our repertoire of Software Conversion and Migration techniques makes it easy for us to add that extra value to our services. Other than that we also deal with • Search Engine Submission, Optimization & Promotion. • Direct Email Marketing. • Networking (LAN, WAN, OFC & wireless networking solution). • Live project training. • H.R. solution. AFTER SALES SERVICES AND SUPPORT UCDS service and support division is a well-knit outfit that takes care of market promotional activities and post-sale services. This strategic business exclusively deals with Software, Hardware and related issues, networking and maintenance. It leverages in house experience into an area of core competency. WHY SHOULD YOU CHOOSE US FOR YOUR NEXT PROJECT? We offer the best quality product at an extremely competitive price. Our products are user friendly. After completion of the project our team takes ultimate care to train the operators, who will use our Package. We also provide a fast, reliable and committed after sales services

    Game Design, Social Networking, Testing / QA, and SQL

  • phpdevindia Profile Picture

    phpdevindia

    Bongaon,  India

    Webgen Technologies (W.G. Technologies Pvt Ltd) is the up and growing pioneer and leader in the global market for IT solution. We are experts in web design and development, e-business application, e-business application,content management, process management and IT consultancy services. We believe that our customer is the king. Our solutions and services are spread across several business domains including the government sector, financial sector, healthcare industry, manufacturing industry and the corporate sector. Practically, our team of dynamic technocrats with their innovative ability sets the requisite target of the customers and by dint of infusing newer ideas and ways to improve the end result of the customers. There is no doubt the company has made a tremendous progress within a short period due to dedication and total integration besides speed, choice and security that it lends to its customers.

    PHP, Javascript, Adobe Flash, and .NET