Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Osommerce bug fix help


webkom

Recommended Posts

Hi,

 

There is a bug with OsCommerce storing the incorrect Exclusive GST (tax) price, causing all calculations to be off. Im not sure where the bug is being introduced or why.

 

thanks, a detailed description is below.

 

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

Hosting server information is as follows:

Operating system: Linux

Kernel version: 2.4.21-27.0.2.ELsmp

Machine Type: i686

Apache version: 1.3.36 (Unix)

PHP version: 4.4.2

MySQL version: 4.1.19-standard

cPanel Build: 10.8.2-RELEASE 119

 

The current contributions installed on OsCommerce are:

- "Quantity Price Breaks Per Product"

http://www.oscommerce.com/community/contributions,1242

- "Australian Shipping Module"

http://www.oscommerce.com/community/contributions,648

- "WebAdvantage payment module"

http://www.oscommerce.com/community/contributions,3693

- "Switch between Displaying Prices Inc./Ex. VAT"

http://www.oscommerce.com/community/contributions,2899

- "Add Weight To Product Attributes v0.1"

http://www.oscommerce.com/community/contributions,1622

- "Product Sort"

http://www.oscommerce.com/community/contributions,911

 

As there were a number of files that were common to both packages, it is likely that some of these contributions are not installed properly, or have introduced interoperability problems. An analysis would need to be under taken to determine which code needs to be merged into a single file, rather then each time over writing the one file.

 

The current system has a button that allows switching between GST inc. and GST ex. prices. This results in different prices being displayed between inclusive and exclusive prices in shopping cart.

 

On occasion, when there are many products in the shopping cart, the incorrect price is passed to the payment gateway (WebAdvantage). This is a small discrepancy and is likely due to one of the prices (probably the ex. GST) being rounded off.

 

Once again, there is a rounding error in admin/invoice.php and admin/orders.php which results in the exclusive and inclusive prices in not being comparable. It seems that in this situation that the exclusive price is not correct and is being used to work out the inclusive price. This value is derived from the table ?orders_products? and the column ?final_price?. Furthermore, the inclusive price seems to be almost the same as the exclusive price.

 

Another bug is that there is a discount given to customers for multiple product specials, but this price is not carried through to the shopping cart. The price range is also not displayed when browsing the products.

Link to comment
Share on other sites

  • 4 weeks later...
Hi,

 

There is a bug with OsCommerce storing the incorrect Exclusive GST (tax) price, causing all calculations to be off. Im not sure where the bug is being introduced or why.

 

thanks, a detailed description is below.

 

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

Hosting server information is as follows:

Operating system: Linux

Kernel version: 2.4.21-27.0.2.ELsmp

Machine Type: i686

Apache version: 1.3.36 (Unix)

PHP version: 4.4.2

MySQL version: 4.1.19-standard

cPanel Build: 10.8.2-RELEASE 119

 

The current contributions installed on OsCommerce are:

- "Quantity Price Breaks Per Product"

http://www.oscommerce.com/community/contributions,1242

- "Australian Shipping Module"

http://www.oscommerce.com/community/contributions,648

- "WebAdvantage payment module"

http://www.oscommerce.com/community/contributions,3693

- "Switch between Displaying Prices Inc./Ex. VAT"

http://www.oscommerce.com/community/contributions,2899

- "Add Weight To Product Attributes v0.1"

http://www.oscommerce.com/community/contributions,1622

- "Product Sort"

http://www.oscommerce.com/community/contributions,911

 

As there were a number of files that were common to both packages, it is likely that some of these contributions are not installed properly, or have introduced interoperability problems. An analysis would need to be under taken to determine which code needs to be merged into a single file, rather then each time over writing the one file.

 

The current system has a button that allows switching between GST inc. and GST ex. prices. This results in different prices being displayed between inclusive and exclusive prices in shopping cart.

 

On occasion, when there are many products in the shopping cart, the incorrect price is passed to the payment gateway (WebAdvantage). This is a small discrepancy and is likely due to one of the prices (probably the ex. GST) being rounded off.

 

Once again, there is a rounding error in admin/invoice.php and admin/orders.php which results in the exclusive and inclusive prices in not being comparable. It seems that in this situation that the exclusive price is not correct and is being used to work out the inclusive price. This value is derived from the table ?orders_products? and the column ?final_price?. Furthermore, the inclusive price seems to be almost the same as the exclusive price.

 

Another bug is that there is a discount given to customers for multiple product specials, but this price is not carried through to the shopping cart. The price range is also not displayed when browsing the products.

 

 

I have the AUssie shipping module installed and I have no taxes setup anywhere. The only thing I have is tax zones which is needed to separate Australia to the rest of the world. I have spent hours trying to workout why every single one of my shipments is quoted at 10% less than it should be. On a local shipment which should be $6.40 it is charging $5.83.

 

I wonder if this is a related issue, is something up with the aussie shipping module?

 

Stephen

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...