osCommerce News
Recent posts
post item
Success Case: Resolving oscb156 Migration Tool Error
February 17, 2025
Success Case: Resolving oscb156 Migration Tool Error ...
post item
Success Case: Optimizing V2 URLs for SEO and Compatibility
February 14, 2025
Success Case: Optimizing V2 URLs for SEO and Compatibility ...
post item
Success Case: PHP Error on Conversion
February 12, 2025
Success Case: PHP Error on Conversion ...
post item
Success Case: Fixing the "Create-sec-file Failed Completely" Issue
February 10, 2025
Success Case: Fixing the "Create-sec-file Failed Completely" Issue ...
post item
Success Case: Resolving Import Errors in OSCB157
February 07, 2025
Success Case: Resolving Import Errors in OSCB157Success Case: Resolving Import Errors in OSCB157 ...
post item
Success Case: Importing Process and Order Statuses
February 05, 2025
Success Case: Importing Process and Order Statuses ...
post item
Success Case: Resolving Admin Area Error (#2)
February 03, 2025
A customer encountered an Error (#2) Internal Server Error after running an import script. This prevented access to the admin area , delaying their website launch. After reviewing the log files, our team identified the issue: Logging was enabled, but the log file name was invalid: Store Page Parse Time – False Log Destination – /var/page_parse_time.log The issue has been fixed and will be resolved in the next version. Since the customer could not access the admin area , they needed an alternative way to apply the fix. To resolve the issue, the support team advised to update the setting using SQL or a configuration file: Option 1: Update via SQL Run the following query: UPDATE configuration SET configuration_value = 'false' WHERE configuration_key = 'STORE_PAGE_PARSE_TIME';   Option 2: Modify Configuration File Add the following line to admin/includes/local/configure.php: define('STORE_PAGE_PARSE_TIME', 'false');   The customer applied the fix and successfully regained access to the admin area , allowing them to proceed with their website launch. Always remember about the importance of proper logging configuration. This success case provides a clear, accessible solution for users who may encounter similar issues. ...
post item
Success Case: Seamless Migration from osCommerce v2 rc2 to the Latest Version
January 31, 2025
Success Case: Seamless Migration from osCommerce v2 rc2 to the Latest Version ...
post item
Success Case: Creating a Security Key During Migration
January 29, 2025
Success Case: Creating a Security Key During Migration ...
post item
Success Story: Enhancing Security for the Admin Directory in osCommerce v4
January 27, 2025
Success Story: Enhancing Security for the Admin Directory in osCommerce v4 ...
Products
Tags

Management

Ecommerce

Integrations

newsite

launch

grant

fund

replatforming

osCommerce 4.x

shopping cart

hosting

Installation

New PayPal Module (Latest API 2.0)

osCommerce 2.2

osCommerce 2.3

Shopping cart customizations

Manually

PayPal Express

APM (Alternative Payment Method)

Standard Variant

Advanced Variant

Configuration

Testing

Front End

Install osCommerce for Me

Let me install myself

Multiple sales channels

Single active sales channel

Installation on your own server

Connect

App Shop

Adding Free Module

Admin Area

Adding Paid Module

Installing Module

Opayo Pi Module

Development Mode

Email Verification Before Registration

Managing Languages

Managing phpMussel

Managing Orders

oscommerce.com account

Creating Manual Orders

Managing Customers

Managing Customer Groups

Managing Brands

Managing Categories

Managing Filters on Categories

Managing Products

Managing Stock

Assigning Products and Categories to Front Ends

Assigning and Moving Products to Categories

Managing Default Sort Order on Product Listing and Category

Managing Cross-Sell and UPSell

Managing Reviews

Managing Attributes

Managing Product Groups

Managing Properties

Managing Suppliers

Managing Warehouses

Managing Sales Statistics and Purchase Report

Managing Stocktaking Costs

Managing Deleted Orders

Managing Coupons

Managing Virtual Gift Cards

Managing Sales Price

Managing Giveaways

Managing Featured Products

Managing SEO

Managing Meta Tags

Managing XML Sitemap

Settings of E-commerce Tracking for Google Tag Manager

Setting up GA4

Managing Pages

Managing Menus

Assigning Theme to Sales Channels

Deleting Sales Channels

Managing Translations

Managing Email Templates

Managing Catalog Pages

Managing Shipping Modules

Managing Payment Modules

Managing Order Structure

Managing Socials

Managing Extensions

Managing Managers

Managing Access Levels

Managing Back End Menu

Managing Configuration

Mail Sending via SMTP

Setting up SMTP

Status Groups

Order Statuses

Comment Templates

Stock Indication

Notify Me when in Stock

Stock Delivery Terms

Cross Sell Type

Cache Control

Filters

Managing Countries

Managing Counties and States

Geo Zones

Managing Cities

city settings

Postal Codes

Managing Taxes

Managing Currencies

Backups

Viewing Who is Online

Managing IP Restriction

Error Log Viewer

Creating Installation

Address Formats

Sales Tags

Managing Front Ends

Managing App Shop

Going Live with osCommerce

Affiliate Module

Awin Module

B2B Module

Business To Business module

Bazaarvoice Module

Managing Blog

Collection Points

Managing Competitors

Customer Code Module

Customer Modules Module

Customer Multi Emails Module

Customer Products Module

Delayed Despatch Module

Delivery Options Module

Fraud Address Module

Frontend Session Module

Invoice Number Format Module

Maximum Order Quantity

Merge Customers Module

Merge Orders Module

Minimum Order Quantity

Neighbour Module

One Trust Module

Order Flags and Markers

Pack Units

Covered by Coupon Module

Klarna Module

LiqPay Module

Mollie Pay

Pay360 by Capita Module

pxPay Module

RBS WorldPay Module

Tyl by NatWest Module

Personal Catalog

Personal Discount Module

Product Bundles

Product Collections

Product Easy View

Product Global Sort

Product Ignored Payment Methods

Product Ignored Shipping Methods

Product Press Reviews

Product Relocation

Managing Refer Friend

Bookkeeping Detail Report

Changes History Report

Compare Report

Deficit Product Report

Emails History Report

Report by Email Module

Expected Products Report

Managing Freeze Stock

In Cart Stock Report

Low Stock Report

Manufacturer Sales Report

Ordered Products Report

Purchase Report

Stock by Manufacturer Report

Summary Report

Updating Opayo Pi Module

Updating Opayo Server Module

Temporary Stock Report

Universal Log Report

Managing Search Plus

Managing DHL Shipping

Managing FedEx Shipping

Managing German Post Shipping

Managing Google Zones Shipping

Managing Nova Poshta Shipping

Managing Personal Rate UPS Shipping

Managing TNT Express Shipping

Managing UPS Shipping

Managing United States Postal Service Shipping

Managing USPS Shipping

Opayo Server Module

Managing Support System

Managing Trustpilot Module

Managing VAT On Order

Zero Price Module

User Group Extra Discounts

Installing Opayo Server by Elavon for osCommerce 2.2 via Installer

Installing Opayo by Elavon for osCommerce 2.2 via Installer

Installing Opayo Server for osc2.2 via Zip File

Installing Opayo for osc2.2 via Zip File

Click & Collect Shipping

Configuring Opayo by Elavon Module for osc 2.2

Configuring Opayo Server for osc 2.2

Testing Opayo Module for osc 2.2 on Front End

Testing Opayo Server for osc 2.2 on Front End

Installing Opayo Server for osc 2.3 via Installer

Installing Opayo for osc 2.3 via Installer

Installing Opayo Server for osc 2.3 via Zip File

Installing Opayo for osc 2.3 via Zip File

Configuring Opayo for osс 2.3

Configuring Opayo Server for osc 2.3

Testing Opayo Module for osc 2.3 on Front End

Testing Opayo Server for osc 2.3 on Front End

Updating to the Newest osc v4 with AppShop

Store Locator Module

Order Additional Fields Module

Products Sort in Stock First

Brand Estimated Delivery

Platform Restrict Login

Plain Product Description

Cron Scheduler

Success Cases

osCommerce v4

Theme Customization

Product Customization

Text Fields

Customer Personalization

RemoveDemoProducts

DatabaseBackup

RefineSearch

ProductFilters

InternalOrdering

IntranetCustomization

CrossSell

UpSell

XAMPP

Windows Server

Linux Server

Apache

Error Message

PHP File Replacement

ProductsPropertiesFilter

App Update

PHP Compatibility

PHP Version

Software Update

Submenu Image

Header Customization

Menu Widget

Demo Website Limitations

AJAX Error

Error Logs

SQL Fix

Search Function Error

Debian Installation

MySQL Setup

PHP Extensions

Apache mod_rewrite

URL Redirects

404 Error

Custom Module

Module Installation

PHP Development

Back In-Stock Notification

Template Fix

HTTPS to HTTP

URL Configuration

Disabling HTTPS in OSC4 Install

Free Shipping

Category-Based Shipping

Contributions Category

Custom Shipping

Shipping Settings

Product Assignment

Customer Groups

Product Visibility

Attribute Values

Product Attributes

Option Names

Custom Extension

Custom Development

Backend Customization

Internal Product Name

Order Processing Screen

Product Details Display

Tawk.to

Live Chat

Widget Setup

Chat Integration

Move Test Shop to Root

Root Directory Setup

Test Shop

Who's Online Extension

Store Launch

Sales Channel Configuration

Widget Export

osCommerce Widgets

Theme Designer

Widget Management

Loyalty Points

Bonus Actions

Reward System

Ecommerce Loyalty Program

Extension Development

Widget Integration

My Account Page

URL Path Fix

Product Options

Customizable Products

Product Configurator

Stock Management

Inventory Control

Stock Visibility

Product Availability

High-Traffic Sites

Database Performance

Site Optimization

Shipping Solutions

Packaging Features

Ready to Ship

Ecommerce Logistics

Shipping Quotes

Shipping Optimization

Search Optimization

Slow Search Fix

Product Search

Pre-indexed Tables

Cron Jobs

Search Settings

Site Speed Improvement

QuickBooks Integration

DataLink Integrations

Accounting Software Integration

ERP Software Integration

eCommerce & Accounting Sync

Automated Data Synchronization

Admin Order Creation

Payment Processing

Update and Pay Module

Order Management

Add to Wishlist

Wishlist Integration

Wishlist Button Fix

Theme Editor

Design Troubleshooting

Subfolder Configuration

Theme Designer Fix

Data Protection

Runtime Logs

Password Security

Checkout Page

CSS Fix

Responsive Design

Product Images

Command Line Tools

Image Regeneration

Domain Transition

License Key Transfer

Reinstall Process

Access Control

Custom Pricing

Language Settings

Bilingual Support

Translation Management

Multilingual Store

Google Merchant Center

GTIN

Custom Products

Product Identifiers

MPN

Google Integration

Translation Module

German Language

Multilingual Support

PayPal Integration

Shopping Cart Display

Payment Module Configuration

SQL Commands

Customizing Buttons

Payment Options

German Translation

Frontend Localization

Enable Languages

System Translate Module

Shipping Configuration

Zone Table Rate Shipping

Weight and Price Restriction

Shipping Module Setup

Shipping Price Cutoff

Shipping Compensation Limits

Customer Details Validation

Custom Validation Rules

Mandatory Fields Setup

Address Validation

Minimum/Maximum Values Settings

Order Status Notifications

Email Templates Setup

Customer Communication

Automated Notifications

Product Listing

Image Display

UpSell Module

Widget Settings

Cash On Delivery

Prepayment

Payment Via Invoice

Click And Collect

Shop Local

Plugin Customization

Address Configuration

Promotions

Tailored Offers

Shipping Options

Custom Promotions

Automated Imports

CSV Import

XML Import

Extension Generator

Custom Extensions

Backend Controller

Development Tools

Product Export

Data Management

Database Export

Supplier Data

Custom Exports

Pricing Automation

Supplier Pricing

Retail Pricing

Inventory Management

Automated Workflows

Database Update

Customer Data

Data Migration

Ecommerce Security

Admin Directory

File Permissions

Database Migration

Secure Admin Access

Ecommerce Migration

Security Key

404 Error Fix

Web Server Setup

Website Upgrade

Data Import

Admin Error Fix

Internal Server Error

Tech Support

Import Process

XML Fix

Database Management

PHP8

Web Development

Dev Support

PHP Errors

Software Upgrade

URL Rewriting

Website Optimization

SQL

Search Ranking

Migration

oscb156

PHP

Secure Key

Dev Solutions

Issue #23: February 6, 2003

By Harald Ponce de Leon

February 6, 2003

Announcements Mailing List Fix
Checkout Procedure Chicken And Egg Problem
Order Total Shipping Module Tax Update
Administration Tool -> Invoice Update
Default Text Updated
Control Characters In The Database Dump Removed
Blank Records Being Inserted In Orders Table
Free Shipping Feature Completed
Shipping Module Tax Assignment
USPS International Shipping Fix
Order Total Low Order Fee Module Fix
Warnings Now Shown With Disabled Products
Order Comment And Status Updates
..And The Release Date For Milestone 1 Is..

Announcements Mailing List Fix

There was a slight problem with new subscriptions occuring on the announcements mailing list, which was fixed last week.

If problems are experienced, please be sure to report the problem to a team member.

Team members are shown here:

https://www.oscommerce.com/about/team

Checkout Procedure Chicken And Egg Problem

The checkout procedure was broken since the introduction of the dynamic module status feature, as the payment modules could not access the order information and were not passing the hidden fields (module parameters) to their gateway.

This was reported fairly late by David Garcia Watkins (thanks!).

The chicken and egg problem included the order class and the payment modules, each needing information from each other when the classes were being instantiated.

The order class needed the payment module title, and the payment modules needed the order destination information for the new dynamic status feature when the payment module was assigned a zone.

The solution to the problem was to instantiate the payment modules first, then the order class afterwards. A call to the new update_status() method (in the payment module) is made manually to set the status of the payment module dynamically if it has been assigned a zone. The logic used in the update_status() method was otherwise executed in the module/class constructor when being instantiated.

The update_status() method does not break the payment modules in the contributions section as the main payment class uses logic to detect if the method exists or not - if the method does not exist then that module has obviously not been updated to take advantage of the new dynamic status feature and is thus made available on a global scale.

The logic keeping the "compatibility" with contributed modules may be removed once 2.2 goes gold.

Order Total Shipping Module Tax Update

The tax class assigned to the order total shipping module is now being described with the tax rate title instead of the tax rate value, which matches the previous changes mentioned in the last weekly report.

For this to work properly, the default sort order of the order total modules has changed from:

subtotal
tax
shipping
total

to:

subtotal
shipping
tax
total

Administration Tool -> Invoice Update

A problem with the Invoice feature on the Administration Tool has been fixed, which was only displaying the first attribute of a product regardless if more attributes for that product existed.

Thanks go to Gabriel Levy for pointing this out.

Default Text Updated

The default text shown on the front page of a newly installed osCommerce store has been updated to inform the store administrator or developer where the default text can be changed.

This should lower the amount of questions asked on the forums of how to modify the text shown on the catalog.

Control Characters In The Database Dump Removed

For some reason two control characters existed in the oscommerce.sql database dump, which prevented some versions of phpMyAdmin from successfully importing the data.

Thanks to the person who submited the bug report (#920; sorry, could not find your name anywhere).

Blank Records Being Inserted In Orders Table

A problem was fixed with the product downloads feature with blank records being inserted in the orders_products_download table when products ordered contained attributes.

This only occured when the product downloads feature was enabled.

Free Shipping Feature Completed

The free shipping feature has been completed now that the shipping quotes are no longer displayed on the checkout shipping page when free shipping is active for that order.

Shipping Module Tax Assignment

The above mentioned update to the order total shipping module tax update has been overruled with the tax class assignment being moved to the shipping module level.

This provides more control and flexibility when only certain shipping modules should be assigned a tax class. (Previously it was set at a global level affecting all shipping modules)

The updated sort order of the order total modules remains unaffected and is still needed.

USPS International Shipping Fix

Brad Waite forwarded an update to the USPS shipping module which fixed a problem when international rates were used.

The checkout confirmation page had shown the first international rate shown on the shipping method selection page instead of the selected rate the customer chose.

Order Total Low Order Fee Module Fix

Günter Sammet reported (#455) a problem with the tax calculation made on the order total low order fee module.

The tax calculations were being based on the customers address instead of the shipping destination address.

Warnings Now Shown With Disabled Products

Warnings are now shown when a customer clicks on a link to a disabled product.

The warnings will be enhanced later in the 2.2 Milestone path to be user friendly and to show other products in the same category which the customer may be interested to look at.

This is important with stores being indexed by search engines and when guests click on a search result link which leads to a currently disabled product.

Order Comment And Status Updates

The order comments are now stored at the order status history level, allowing for multiple comments to be displayed on the Administration Tool.

With this update, the comment box that was shown on the checkout success page has been moved to both shipping selection and billing selection checkout pages.

Due to technical reasons, the comment box is not able to be placed on the checkout confirmation page (by default) due to dynamic payment modules which need to contact their gateway over a secure connection. This can be overruled when using cURL or native openSSL features found in PHP 4.3 releases, which is not done by default due to the projects compatibility goals.

..And The Release Date For Milestone 1 Is..

All of the Milestone 1 entries found on the Workboard have been completed (some entries are still pending commit or pending to be reviewed, one has been moved to MS2), which leaves the question "when will Milestone 1 be released?".

Bug reports will be looked into over the weekend to make sure the main features and logic existing are known-bug free. No target date is set, though Sunday looks to be the perfect candidate.

The Workboard can be found at:

https://www.oscommerce.com/community/workboard

 

You can further discuss it on our Forum