Jump to content

  2. → Viewing Profile: oscommercecoders

Corporate Sponsors


Latest News: (loading..)

oscommercecoders

Member Since 25 Feb 2008
Offline Last Active Today, 09:16
-----

Posts I've Made

In Topic: IIS 5.3 (Win XP) Installation

30 April 2012, 20:34

Install xampp for windows from here

http://www.apachefriends.org/en/xampp.html

you can setup any php/mysql application there for development.

Cheers

In Topic: Incomplete shopping cart/no checkout

15 February 2012, 19:33

Recover Cart Sales

you can get it here http://www.oscommerce.com/community?contributions=&search=recover+carts&category=all and use the one depending on the oscommerce store version you have

cheers

In Topic: discount script in SQL

27 December 2011, 20:02

suppose price is 100

update products set products_price = (products_price * 1.20)

then price becomes 120 after 20% increase

update products set products_price = (products_price * 0.80)

then price becomes 80 after 20% increase


if you want to increase price by 20% then multiply it by 1.2 which is (100% + 20%)


% means out of 100 so 20% is 20/100 or 0.2

In Topic: discount script in SQL

27 December 2011, 17:03

To increase all prices by 20% use this..

update products set products_price = (products_price * 1.20)


To decrease all prices by 20% use this..

update products set products_price = (products_price * 0.80)

  1. osCommerce Support Forum
  2. → Viewing Profile: oscommercecoders
  3. Forum Rules