Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Jack_mcs last won the day on April 19

Jack_mcs had the most liked content!

About Jack_mcs

  • Rank

Profile Information

Recent Profile Visitors

246,871 profile views
  1. Jack_mcs

    quantity monitoring

    What you are trying to do is not a small job and is beyond the scope of support threads, in my opinion, but here is a way to do it. 1 - Get is a comma separate list of all of the product ID's in a category to give something like this. You can get the list from the products_to_categories table using the category ID to check. $product_ids = '1,2'3'; 2 - In the categories box, use code like this to get the minimum quantity of all of the products: SELECT MIN(products_quantity) FROM products where products_id in (' . $product_list . '); 3 - Change the category tree file so check the above result and if it is 0, returns 0, then don't add that category to the listing. 4 - Cycle through the products in the above list and set the status to 0. Note that if you do this, it will remove them from the site and that will affect SEO, if that matters. Otherwise, set their quantities to 0 and change the product page to not allow adding to cart when the quantity is 0.
  2. Jack_mcs

    quantity monitoring

    Assuming you have standard tables,. there isn't a categories_products_qty field. I assume by "category counter" you are referring to the product count that is shown in the categories box. If so, that number is calculated each time the page loads, which is why it is not recommended to be used. There also isn't a field to show or hide a category. You would need to edit the category_tree.php class file to check for products in the category to show or hide it. You should also install one of the call for prices addons that will mark products with a price of 0 as not available.
  3. Jack_mcs

    quantity monitoring

    There isn't a function for it. It is part of the code in checkout_process.php and paypal_standard.php (and maybe other payment modules). Search for stock in those files to find it.
  4. Jack_mcs

    quantity monitoring

    The QTPro addon does this for attributes if you can have all of the parts as attributes. If they are all different products, then you would need to check them on page load. So if there are 100 sandwiches showing but you only have 20 breads, you could have something like $db_query = tep_db_query("select count(*) as ttl from breads"); $db = tep_db_fetch_array($db_query); if ($db['ttl']) < 100) { tep_db_query("update sandwiches set quantity = " . $db['ttl']); } But that can cause problems since it might change the amount for another customer that has already entered more than the limit.
  5. No, it shouldn't be left is as is. You can leave it in but change the '1' to '0'. Otherwise all of your visitors will see errors.
  6. Is there an error_log file in the shop directory? If there is, it might indicate the problem. If not, try replacing the error_reporting line in includes/application_top.php with the following. Then try creating and account and see if any errors are displayed. error_reporting(1); ini_set('display_errors','1'); And clear the sessions table in the database and turn off the cache and gzip settings in admin.
  7. Jack_mcs

    Automatically send data feed to Froogle

    A new version has been uploaded with these changes: Added a localfeed option. Corrected code for php warnings.
  8. There are a number of mistakes in both files. I don't know if they will fix your original problem but they do need to be changed. Here are the edited files: define('HTTP_SERVER', 'https://www.sandraspetsparadise.nl'); define('HTTPS_SERVER', 'https://www.sandraspetsparadise.nl'); define('ENABLE_SSL', true); define('HTTP_COOKIE_DOMAIN', 'www.sandraspetsparadise.nl'); define('HTTPS_COOKIE_DOMAIN', 'www.sandraspetsparadise.nl'); define('HTTP_COOKIE_PATH', '/shop/'); define('HTTPS_COOKIE_PATH', '/shop/'); define('DIR_WS_HTTP_CATALOG', '/shop/'); define('DIR_WS_HTTPS_CATALOG', '/shop/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', '/var/www/vhosts/sandraspetsparadise.nl/httpdocs/shop/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); define('HTTP_SERVER', 'https://www.sandraspetsparadise.nl'); define('HTTP_CATALOG_SERVER', 'https://www.sandraspetsparadise.nl'); define('HTTPS_CATALOG_SERVER', 'https://www.sandraspetsparadise.nl'); define('ENABLE_SSL_CATALOG', 'true'); define('DIR_FS_DOCUMENT_ROOT', '/var/www/vhosts/sandraspetsparadise.nl/httpdocs'); define('DIR_WS_HTTPS_CATALOG', '/shop/'); define('DIR_WS_ADMIN', '/shop/admin/'); define('DIR_FS_ADMIN', '/var/www/vhosts/sandraspetsparadise.nl/httpdocs/shop/admin/'); define('DIR_WS_CATALOG', '/shop/'); define('DIR_FS_CATALOG', '/var/www/vhosts/sandraspetsparadise.nl/httpdocs/shop/'); define('DIR_WS_IMAGES', '/shop/images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
  9. Hi Jack i am wondering if you can help or give me some advice. I saw your Header Tags Controller and wondered how difficult it would be for a person who knows nothing about OSCOMMERCE other than to get into the admin area to install it. What is involved?

    The site I am working on is an OS COMMERCE site so is a data based site which needs specific SEO and which you seem to be an expert on. The site has been in existence for over 20 years with no SEO done to it and then all of a sudden for no reason it started ranking our posts on the first page of Google often in the top spot or top 5. We could almost guarantee to rank your ad on the first page.

    Approximately 12-18 months ago our host upgraded his servers and our site was no longer compatible with his server and the site was no longer visible or hosted. About 3 months ago I found hosting company in the USA and we started to set up the site in the exact same format. At this time our SA host managed to get the site live once again but we could not access the admin section and after 10 days our rankings started coming back but not as strong as before. Our SA host then switched the domain across to TMD hosting and the site went live. We are now sitting with 2 identical websites ranking different pages but nowhere near as powerfull as the site was before it was taken down

    I am looking at trying to do some SEO to get our original rankings back but because of the data base configuration you cannot do a lot of the normal SEO you would do with a wordpress site. Most people i talk to confuse oscommerce with an ecommerce site. Please find links below to the 2 sites.

     ORIGINAL SITE           http://www.xpressmedia.co.za/

    SECONDARY SITE      http://xpressme.sg08.tmd.cloud/

    1. oceanlee


      Also are there any tutorials where i can learn the basics of oscommerce

    2. Jack_mcs



      Regarding the installation, from your description I would say it would not be possible for you to install Header Tags. It requires changes to the files. They are too difficult as changes go but do require some experience in editing the code.

      Installing the addon, now named Header Tags SEO, can help with ranking and usually will. But it is a tool and what you get out of it depends on how much you put into setting it up. In other words, if you install it and then walk away it will probably help with ranking. But if you spend time setting things up in it, the chances of it helping increase a great deal. 

      From what you described with your ranking and in looking at your site, I think installing it would help and suggest that you do so. We charge $90 to install it but there is a 10% discount available. Ordering from us has two advantages:

      1 - You get the most recent version of the addon. The version I have here has changes to it that are not in the released version. 

      2 - I offer guidance in its usage. The addon has many options and not setting them correctly can make a big difference in the results.

      Another option is to move to our hosting. If you did that, we would install the addon for free. The advantages of hosting with us is that we specialize in oscommerce. So the problems you mention regarding both of your hosts would not happen with us. We also offer free support to our members for questions on how to use or make changes to their sites. Very few, if any, other hosts do this. 

      As for tutorials, there are none that I know of. There is this page. I'm not sure what version your shops are from looking at them but they are either 2.2 or 2.3. The basic parts of them are the same so most of the files on that page should apply. Of course, if you hosted with us, we would answer the questions about its usage for you. :)

      I hope this answers all of your questions. Please let me know if you have any others. 

  10. Please post your configure file here without the database details and someone will take a look.
  11. Jack_mcs

    Automatically send data feed to Froogle

    @PapancoAs mentioned, this is untested so I must be missing something. I will actually test it here and post once I have it working. I will try to get to it this week.
  12. Jack_mcs

    Automatically send data feed to Froogle

    @PapancoIn the googlefeeder.php file, change the OPTIONS_ENABLED_GOOGLE_UTM setting to 0 or 1, depending on if you are using that google option.. Then find this line define('OPTIONS_GOOGLE_UTM', '?utm_source=GoogleBase1&utm_medium=BaseFeed1&utm_campaign=products'); //see http://www.google.com/support/googleanalytics/bin/answer.py?hl=en&answer=55578 and replace it with this if (OPTIONS_ENABLED_GOOGLE_UTM == 0) { define('OPTIONS_GOOGLE_UTM', '?store={my_store_code}'); } else { define('OPTIONS_GOOGLE_UTM', '?store={my_store_code}&utm_source=GoogleBase1&utm_medium=BaseFeed1&utm_campaign=products'); //see http://www.google.com/support/googleanalytics/bin/answer.py?hl=en&answer=55578 } As before, be sure to change the "my_store_cde" with yours.
  13. When a page is blank, it usually means there is a coding error on one of the files it uses. Since those files are not normally changed, you can just upload the originals for your version. Or, if there is a file named error_log in the admin directory, check it to see if any are being reported.
  14. Jack_mcs

    Header Tags SEO

    I didn't have that version in a shop with multiple languages but I just tried a quick add to an existing shop and you are correct. To allow it to work until a proper fix is made, you can made these changes (untested). In categories.php find </div> <div class="tab-pane fade" id="section_images_content" role="tabpanel"> and change it to <?php require_once('includes/functions/header_tags_general.php'); include_once('includes/header_tags_seo/htc_products_display.php'); ?> </div> <div class="tab-pane fade" id="section_images_content" role="tabpanel"> In includes/hooks/admin/categories/headertags_seo_display.php change injectLanguageForm to injectLanguageFormXX
  15. Jack_mcs

    Header Tags SEO

    @revampI checked it here and they are showing. What version of oscommerce and this addon are you using?