bruyndoncx

Today I decided I got angry for the last time updating a table rate based module. Afer several tryouts to change the shipping rates just to see I had a typo in the values string  -damned colons- and having to manually calculate the net prices for each row from the gross that came from the table provided by the courier... I had enough and modified the table rate module to show a real table where you can see what you're doing. Uses some javascript to update net/gross, add or remove rows and do some basic checks.
It can be adapted to any other module that uses the same system.
Note: The net pice is caclulated based on the tax class from the module. It will apply only to the countries in the module's zone and it's not savet to database but calculated on the fly. For this column to work you need to set up the tax rate first, save and enter the module configuration again.
Here is the file: https://apps.oscommerce.com/wyYLv&sgipping-table-module-update
@burt you can replace the stock one if you consider it fits the community project.

This Addon adds a horizontal menu bar in the header of every store page. This menu bar contains the names of each of your top-level categories. When a customer clicks on a category name, a Megamenu expands below the menu bar. This Megamenu contains a category image and name for each of the top-level category's subcategories, or the top-level category image and name and a list of links to the products in that category if there are no subcategories.
The Addon code is available here.
 

To list specifications by specifications group, you don't need a group by statement as you are not performing any aggregate functions for the particular group.
You just need to add the specification group name (or sort order if you have any) to the order by clause (and make sure the table is joined in the whole construction)
 
Then when outputting results, just show the specification group name if it is different from the previous one for the spec/value combo.
 
HTH

for the colors you have to set the filter type to for instance exact
 
for the prices, you define brackets eg 5, 10, 20
the range is shown automatically
products price is a database field,
 
These are my settings Column Name: final_price Filter Class: range Display the Filter as: links Filter Show All: True Enter Specification Values as: text

fyi
https://mobiforge.com/design-development/html5-mobile-web-forms-and-input-types
this triggers the appropriate mobile keyboard

Just a quick heads up for anyone trying to optimize seo wise and possibly saving some server load (as I am trying to)
 
I'm adding the rel=nofollow to the generation of the links in the includes/functions/products_specifications.php file.
I'm assuming google doesn't do any form submissions on my site
 
and have added to robots.txt (-fc- is the string matching the url-rewrite for my products_filter.php file).

Disallow: /*-fc-
This way, it is keeping search engines out of the filter result pages, but the category and manufacturer listings are still available to the search engines.
 
Should I want google to index specific pages, I believe I can still write-out the native format of the url with products_filter.php in the url and not the rewritten version, as I only added disallow to the robots.txt file for the rewritten url and not the actual filename.

it looks like it is very easy, at least on my site it seems to work fine
In catalog/includes/modules/products_specifications.php
find at the top of the file

$specifications_query_raw = "select ps.specification,
replace with

$specifications_query_raw = "select group_concat(ps.specification) as specification,
 
find a little further down in the same sql query:

order by s.specification_sort_order, sd.specification_name
add this group by line, just above it:

group by sd.specification_name

@raiwa
Well done!
We appreciate all the hard work you put into your addons and projects but please do me a favor and don't work too much/hard. In the past I/we  have lost 2 very good friends from this forum and the last thing I remember was, they were working hard on some addons/projects and it could have been just mere coincidence or just fact that they overworked themselfs till their body gave up. You maintain multiple addons, you work with me on the Point and Rewards module, Sloppy words cleaner and, and, and....
Long story short, watch your health and take enough rest so that we will be able to enjoy you and your work for many years to come.
That goes for all of you out there. osC is nice and all but it won't bring you anything if you work yourself to death.
Now back to work....

After years of dealing with having to change permissions on newly uploaded files from 664 to lower (I use  600 on php) I finally found how to change the umask for sftp on my server.  Apparently, this is how Cpanel is set up because it's discussed in their forums.  Someone posted the solution for SFTP in the SSHD config.  I still have to change the php file permissions, but at least folders are automatically set at 755 and files at 644.  I believe CPanel will be changing the default when using suPHP. 
 
Using Beyond Compare to connet to the server I can easily set the file mask to only show php files then sort by permissions, so it's easy to find files and folders with too loose of permissions.

Personally I think the only reason this is a question is because of the number of releases and various versions of osC that exist....if we had an up to date official release, the user base would be using relatively common code and coders would, by demand, end up updating their code to work with it.  The support on the forums here would be much simpler too. 
 
As Jim points out having coders revise or even keep up with changes between releases isn't likely to happen for the reasons he mentions. 
 
Dan 

Support Thread for "Index Nested - Product Listing" for osCommerce 2.3.4 (bootstrap)
 
Report problems here.
 
Feedback and comments appreciated.
 
Download link:
http://addons.oscommerce.com/info/9514 
 
Easy module install.
(minor core change required using hooks)
 
This module applies to categories containing sub-categories (i.e. index -> nested), where currently only the sub-Category Listing and New Products module appear. Use this module when you would also like to list all-at-once the products within the sub-categories of the current category, therefore becoming a nested product listing (default behaviour is that no product listing appears in nested categories).
 
Demo (scroll down to see nested product listing):
http://www.auzcommerce.com.au/osc234bs_test/index.php?cPath=3
 
cheers

so if you modualarize the (advanced)search page, you can plugin whatever you want searched ?

so if you modualarize the (advanced)search page, you can plugin whatever you want searched ?

so if you modualarize the (advanced)search page, you can plugin whatever you want searched ?

Sorry, can't help here , everything in our store is shown with tax always ...
(we only sell online to consumers within the EU, so it is all with sales tax)

Search add-on Reviews

While working on a new store, I've been exploring the different Search add-ons available. I hope that others may find this useful.
 
I looked at four different Search add-ons:

A) Store Search (BS)
   http://addons.oscommerce.com/info/9328

B) SiteSearch Plus v1.4
   http://addons.oscommerce.com/info/6351

C) SmartSuggest - Self-learning Ajax Search Suggestion    v1.0.3
   http://addons.oscommerce.com/info/8926

D) Twitter Typeahead Autocomplete Search v1.6
   http://addons.oscommerce.com/info/9351


All of these have support pages on the forum.

I installed these individually on a clean installation of osCommerce v2.3.4bs - Edge. The tests were run on the stock database. For comparison, I used the search phrase 'mic' in each of the tests.

All of these either enhance the stock Search box in the header, or replace it. If replaced, the new Search box can have the bootstrap column width adjusted in Admin, just like the stock one.


------------------------------------------------------------------------------------------------------------------+
                                                                           |      A      |         B        |        C       |      D      | 
========================================================================
Requires core file edits                                       |     No     |      Yes *      |     Yes      |     No     |
------------------------------------------------------------------------------------------------------------------+
# of hits searching for 'mic'                                 |     6 *      |        3         |      3 *       |      5      |
(using as-installed default settings)                    |               |                   |                  |              |
-------------------------------------------------------------------------------------------------------------------+
When clicking on a result, are you sent to the    | Product  | Advanced  | Advanced | Product |
Product page, or to Advanced Search Results   |               |req. 2 clicks|                  |              |
-------------------------------------------------------------------------------------------------------------------+
Shows Product Image in Search Results            |     No      |       No        |      Yes      |    Yes    |
------------------------------------------------------------------------------------------------------------------+
Shows Product Description in Search Results    |     No      |       No        |       No      |    Yes    |
------------------------------------------------------------------------------------------------------------------+
Can select what pages to include in Search       |    Yes     |        No       |        No      |    No     |
------------------------------------------------------------------------------------------------------------------+
Records Searched for Words                             |     No      |       No        |      Yes      |    No     |
------------------------------------------------------------------------------------------------------------------+
Emails Store Owner if Search Not Found           |      No     |       Yes       |       No      |     No    |
------------------------------------------------------------------------------------------------------------------+
Pretty ranking (1=best) (in my opinion)              |       3      |         4         |        2       |      1      |
========================================================================


Comments and thoughts:
-----------------------------------------------------------------------------------------

A) Store Search (BS)


Plug and Play. Highly configurable. I like the 'Search Results Highlight' feature. Changing the configuration can alter the number of search hits. Using the 'out of the box' configuration, this gave the most number of search hits:

1 category
3 products
2 'other' pages

If you want your Search to be able to include searching pages other than just products, this is the one.

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

B) SiteSearch Plus
 


If your server has PHP in strict mode, there are additional edits needed in a file. This is mentioned on the support thread, but is not included in the downloaded package.

This is the only package that has the email option.

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

C) SmartSuggest - Self-learning Ajax Search Suggestion
 

This is the only package that records the Searched for words. Personally, I find this feature very useful.

Changing the configuration can alter the number of search hits.

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

D) Twitter Typeahead Autocomplete Search
 

Plug and Play. This is clearly the prettiest of the add-ons. There are *many* options one can adjust and configure. Using the 'out of the box' configuration, this gave the second highest number of search hits.

============================================================================

Final thoughts:
 
I like the search functions that allow the user to go directly to the product or page, without having to make a detour through Advanced_Search_Results.
 
If I could pick-and-choose features, I'd start with D, add the ability to select the searched pages from A, and the recording of the searched for words in C

Your results may vary. Only you can decide what is important for your shop.

HTH

Malcolm

@@valquiria23,
 
The module in product info is not a ht (header tag) module. It is a content module. Header tag modules are in includes/modules/header_tags/.
Both are needed.
 
See instructions:
 
A.  Admin > Modules > Header Tags:
    Install Module: Recently Viewed
NOTE: Installation of this Header Tags Module is required to register the visited products.
      The other 3 modules will not work without it.

o:)

Found it. A change to the compatibility functions caused the copy from the $_GET array to the old $HTTP_GET_VARS to not work reliably. Some of the variables were getting set and others not. The solution was to change all of the variable names in the Paypal App to the modern versions.
 
I don't understand why we are keeping these deprecated forms. The short form superglobals have been around since PHP 4.1. It's long past time to let go of the long variable names.
 
Regards
Jim

Modular Shopping Cart BS
Version 1.0
 
Developer Team:
Dan Cole - @@Dan Cole
James Keebaugh - @@kymation
Lambros - @@Tsimi
Rainer Schmied - @raiwa

Testers:
Steve Kleiner - @@altoid
Juanma - @@piernas

Suggestions - Survey:
Gary Burton - @@burt


This is a modular re-design of the existing shopping cart that is used in the responsive version of osCommerce.
It replaces the existing shopping cart with content modules so that you can control the order and placement of the various components that appear on the shopping cart page.

The modular design will allow you to easily add and set up additional modules that have and will be developed by the community.  
Current modules that are available include the ship in cart estimator, discount coupon codes and an X-sell module.  

In time additional product listing formats and other enhancements are expected.

Included Modules:
- Product Listing
- Order SubTotal
- Checkout
- Alternative Checkout
- Out of Stock Notice
- Empty Cart Message

English, Spanish and German language files included.

Download:
http://addons.oscommerce.com/info/9466
Compatibility:
OsCommerce 2.3.4 Bootstrap

PHP 7.0 tested
 

This module installs an horizontal CSS menu for the admin side.
It also disables the standard stock left menu and adds the correct descriptive title to the page, so you can find the tab you're searching for in your browser.

I made this menu because we use tablets for preparing orders on a daily basis, and even cell phones when we are out of the warehouse, and we have to continuously zoom in/out because the screen does not fit well. Now without the side menu there's a lot more room for small screen devices.

Tested on 2.3.4 responsive but should work with standard version.
 
Link: http://addons.oscommerce.com/info/9463

Support thread for "Ajax Product Listing (bootstrap)".
 
Report problems here.
 
Feedback and comments welcome.
 
Download link:
http://addons.oscommerce.com/info/9455
 
 
This add-on enables faster loading of product listing content, without re-loading the whole website, when using either the manufacturer/category filter drop down list, next/prev page and sort order.
 
Useful, especially if you have other content above the product listings, where the current vertical scroll position is kept on the page when using the filter drop down list, next/prev page and sort order. For example, you may have "Category New Products Carousel" or "Category Popular Products Carousel" above category product listing content.
 
Works for product listings on the following pages:
 
- Category Product Pages
- Specials Page
- New Products Page
- Search Results Page
 
Note: content loaded via ajax is based on the stock osCommerce product listing content.

Jim
 
You are one of only a few coders that have finally embraced the whole concept of the bootstrap version and are trying to reduce core code changes, and make the whole system modular. Congratulations, the work you are doing must be helping to move the BS version of oscommerce forward. Thank you for the great work.
 
I have added both the modular product and index pages to my test store and they seem to work very well. Hopefully others will produce even more modules and ideas to enhance what is already available.

This addon is designed to make changes to the product pages of an osCommerce store easy and simple. It is particularly intended for new users of the software, but can be used by anybody.
 
Elements in the center section of the page can be added, removed, and reordered from the Admin panel. There is only one core file to change; the rest is done from your Admin.
 
The initial Addon contains all of the modules needed to replace the stock Product Info page. More modules are planned (I have an improved Reviews module already coded).
 
The Addon is here.
 
Regards
Jim

Just thought I'd mention 2 additional modules designed to work with this add-on:
 
Category New Products Carousel for osC 2.3.4 bootstrap
Category Popular Products Carousel for osC 2.3.4 bootstrap

Support thread for the "Modular Category Page for osC 2.3.4 bootstrap" add-on.
 
Report problems here.
 
Feedback and comments appreciated.
 
Download link:
http://addons.oscommerce.com/info/9448
 
 
This add-on modularises "top level/nested" category pages by replacing current content with separate modules.
Use it to replace the current "top level/nested" category content so as to enable easy install of future category modules, that either have enhancements to current category content or to add modules with new features. It works similar to kymation's "Modular Front Page Module".
 
Modules are installed as new separate modules for each section of content that normally appears in "top level/nested" category pages.
It includes Category Name, Message Stack, Category Description, Category Images and New Products as well as Upcoming Products (new) where the content displayed is targeted to that particular category and its subcategories.
 
NOTE: "top level/nested" categories are categories that contain no products themselves but have sub-categories with products, and the "Sub-Categories" and the "New Products" (for the sub-categories) currently appear. If a "top level" category itself contains products (with or without sub-categories), then the contents of these modules will not appear. This is currently standard osCommerce behaviour of the existing category pages. This separate add-on "Category New Products Carousel (bootstrap)" http://addons.oscommerce.com/info/9445 can display on all category pages. Future versions of other modules may also do this.
 
FYI: The content modules in this add-on use this folder structure "modules/content/category".