Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by 14steve14

  1. 14steve14

    Email queuing system

    Whilst I have not seen what you are doing I have been following this thread with anticipation for anything better than is originally available. It sound like you are getting somewhere Gary. Well done. I would love to see a system where order status update emails could be written specifically for the update status replacing the standard 'your order has been upgraded to' emails. And the same with the 'new customer' or other emails. They are all a bit plain and do nothing for future sales. Like I say, cant wait to see where this leads as it sounds good.
  2. I enter my weights for products as 0.300 for 300g as that's the way the carrier does their weights. It just seemed easier to keep everything the same. I increased the decimal places to four in the database. Easy enough to change.
  3. Why not get rid of the Also Purchased box and use a cross sell mod that will only list the items you allocate. Seems much easier and may create more business. If you remove the product from the also purchased box what happens if someone buys a totally non compatible product for another reason, and you have the same trouble again.
  4. 14steve14

    Email queuing system

    Interesting idea if it could be made to work. I would like to send a pdf invoice say 5 days after the items were posted which could be used to ask for a review or what ever just to extend the sales process and to check to make sure that everything was ok with the order. I bet there are more ideas.
  5. @zefeena Love your rant. Most of us small businesses are in the same position. I certainly am. Here's what I did to get a development / test sore. First I created a new database and remembered the details that I used from within my hosting cpanel I then created a new folder in my root folder on my current live server. I installed the latest oscommerce version in to this folder which is possible using the standard oscommerce install files and the database details that were just created. I then password protected that complete folder using cpanel from my hosting. That stops the likes of google and other people accessing that folder. I have a host where its possible to setup different php versions on different files so I used php7.2 on this whole folder. I can now sit and play with the latest code. I can add and remove modules and code as I please and not affect my main site. I assume that eventually I wil lhave to update the database with all the products, customers and what ever when the store goes live, but that should be done quickly. If you feel unable to create the folder, database and install oscommerce try asking one of the better coders in this forum. It wont cost you as much as you think and will remove all the possible problems and stress. When the time comes I am sure for a small cost the database details can be transferred also. I did that last time and it was relatively cheap.
  6. Why dont you use headertags SEO which is supported, updated and maintained by the same person that also does the ultimate url addon. There is also a great support forum for that addon should you need any help. Hundreds use it and have no problems so it may be something for you to consider.
  7. What bit of the code are you actually having problems with. If my memory serves me right there is only a small amount of code to add to the htaccess file. This is the code from the install file # Begin Ultimate SEO V2.2d Options +FollowSymLinks RewriteEngine On # RewriteBase instructions # Change RewriteBase dependent on how your shop is accessed as below. # http://www.mysite.com = RewriteBase / # http://www.mysite.com/catalog/ = RewriteBase /catalog/ # http://www.mysite.com/catalog/shop/ = RewriteBase /catalog/shop/ # Change the following line using the instructions above RewriteBase /YOU HAVE TO CHANGE ME/ RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-m-(.*).html$ index.php?manufacturers_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pi-(.*).html$ popup_image.php?pID=$2&%{QUERY_STRING} RewriteRule ^(.*)-by-(.*).html$ all-products.php?fl=$2&%{QUERY_STRING} RewriteRule ^(.*)-t-(.*).html$ articles.php?tPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-a-(.*).html$ article_info.php?articles_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-au-(.*).html$ articles.php?authors_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pr-(.*).html$ product_reviews.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pri-(.*).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-f-(.*).html$ faqdesk_info.php?faqdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-fc-(.*).html$ faqdesk_index.php?faqPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-fri-(.*).html$ faqdesk_reviews_info.php?faqdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-fra-(.*).html$ faqdesk_reviews_article.php?faqdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-i-(.*).html$ information.php?info_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-links-(.*).html$ links.php?lPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-pm-([0-9]+).html$ info_pages.php?pages_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-n-(.*).html$ newsdesk_info.php?newsdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-nc-(.*).html$ newsdesk_index.php?newsPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-nri-(.*).html$ newsdesk_reviews_info.php?newsdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-nra-(.*).html$ newsdesk_reviews_article.php?newsdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-po-([0-9]+).html$ pollbooth.php?pollid=$2&%{QUERY_STRING} # End Ultimate SEO V2.2d I put this bit of code near the top of the htaccess file after all the marked out oscommerce stuff at the top. I have also removed all the bits that I dont use like the faqdesk and newsdesk stuff but I dont think you have to. Which bit is tripping you up. If its the bit you have to alter you said in another post that your files are in the root folder so you just need to change the line to RewriteBase / Hope this helps.
  8. Is there such an addon that will show on the product page that a quantity of the product are on order, and when they should be received. I have done a quick search through the addons area and tried with google but nothing comes up. Does anyone know of such a thing.
  9. 14steve14

    Addon to show items that are on order and quantity

    Yes it is. Gary asked me a few questions about my ideas and what I wanted and has coded something. Not tried it yet but will soon.
  10. I am often told that there is no such thing as a silly question. I believe that I have found that silly question. For what ever reason I am trying to add a tracking number from Royal Mail and a couriers into the comments box when updating orders in admin. That bit is easy using Gary's 'Canned Comments' code , and it all works fine and as I hoped it would. The canned comments are added in the orders page after you have clicked to see the order. I want to show the customers zip/post code on the main orders page or front screen of the orders to make it easy which orders need the tracking number listed. The post office receipt matches the tracking code to the postcode, which cant be seen until the order is actually opened and viewed. That means I have to click on every order to find the postcode to find the tracking number, when it is only needed on certain orders. In my view that's a waste of time with 40+ orders a day. I hope this is all making some sort of sense to someone. On the main orders page things like customers, order total, order date and order status are shown. I have added customers IP and order number there so I have a basic idea on how to alter that page to show a heading and can figure out how to show the postcode I hope, but have no idea on how to incorporate the order and a section of the delivery address to get the data needed to show relative to the customers order. This is where I need help. I need to know the sql statement to get that info please and where it would be best placed in the orders page code. Any help greatly appreciated.
  11. If you are using bootstrap version have a look in the language files for the page you want to alter. In the latest version of Frozen in the index language file you have // seo if ( ($category_depth == 'top') && (!isset($_GET['manufacturers_id'])) ) { define('META_SEO_TITLE', 'Index Page Title'); define('META_SEO_DESCRIPTION', 'This is the description of your site to be used in the META Description Element'); /* keywords are USELESS unless you are selling into China and want to be listed in Baidu Search Engine */ define('META_SEO_KEYWORDS', 'these, are, the, comma, separated, keywords, used in the META keywords Element'); } Its in lots of other pages, and if you create new pages it is easy to add.
  12. 14steve14

    How to show customers zip code/postcode in orders

    Best 15 minutes of my time making this change. Already it has saved that when entering tracking numbers. Thanks for all the help and advice.
  13. 14steve14

    getting 'easy' csv import to work

    Generaly its accepted that using all caps on a forum is classed as shouting as it is on most forums. Insulting people here will get you no where apart from on a load of blocked lists which means you will get no help from those people. As you seem quite capable you dont need peoples help or advice even when they do not know your skills and you never tell them.
  14. Search the addons area for them. They are easy enough to find.
  15. You seem to be forgetting that without those very people we would not have what we have today. Some of us shop owners want to help push oscommerce forward and to do that we need to pay developers to get what we want. Those developers are found on and through this forum. They always have been and they always will. Lets not push away the very hand that feeds us, which may happen if we are not careful.
  16. 14steve14

    How to show customers zip code/postcode in orders

    That is what I am doing now. Hopefully having delivery information will also stop those people that will say an item has not arrived and hope to get a refund.
  17. 14steve14

    How to show customers zip code/postcode in orders

    It's only a certificate of posting. Not needed once the item has been delivered.
  18. 14steve14

    category control in Admin

    I use it in a B.S. gold sore no problems. Also added it to a latest frozen store and with small ateations that even I can do it worked.
  19. 14steve14

    How to show customers zip code/postcode in orders

    I only started thinking about this after I had a customer ask where his order was 3 months after I posted it. No proof of posting or anything as after 30 days I bin them if I have heard nothing from the customer. Saying that I have had one phone call this week asking where an order is and the order was never made. Items were still in the customers cart and he had not even started the checkout process apparently. This is the trouble I have when my customers are on the older generation. May be we should start a thread somewhere about silly customer experiences to bring a bit of light relief.
  20. 14steve14

    category control in Admin

    As stated above i use the addon that I linked to. Does everything I need it to.
  21. 14steve14

    How to show customers zip code/postcode in orders

    Hi Dan @Dan Cole I do still manually enter the tracking numbers as I take all my post to the local post office and pay over the counter. Not the cheapest way I know. I would be interested in seeing or hearing more about how you do this. Its something that is so labour intensive, although not so much now. I am currently waiting for a call back from Royal Mail about their click and drop service, when I may have to do something different. This has only come about since I had two customers claim non arrival of orders after the 30 days that I keep the certificate of Postings for.
  22. 14steve14


    On other version of oscommerce if you don't enter a weight, there will be no shipping charges. Don't know about what you are using though.
  23. 14steve14

    How to show customers zip code/postcode in orders

    Found some time to try this and everything works as I hoped it would. Tomorrow will be the test to see whether it makes entering the tracking numbers easier which I hope it will. It took ages today without the postcode being visible. Thanks Rainer.
  24. 14steve14

    How to show customers zip code/postcode in orders

    Thanks Rainer @raiwa I will take a look later when time allows. Sounds really simple now.
  25. 14steve14

    Paypal App - Fee

    Whilst not really connected to this how many here have read about Geo blocking in the EU. These regulations state that no customer within the EU can be put in a position that discriminates against that person on price, amongst other things. Search for Geo blocking regulations that came into effect on the 3rd December 2018 as they make interesting reading if you have the will to live.