Jump to content
Latest News: (loading..)

Dan Cole

  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by Dan Cole

  1. Dan Cole

    SPPC - for 2.3.4

    This query isn't right but it has me wondering where it came from...I can't image that it was in the add-on. It should probably be something like... $price_query = tep_db_query("select customers_group_price from products_groups WHERE products_id = ' " . (int)$products_id . " ' AND customers_group_id = ' ". (int)$customers_group . " ' "); Dan
  2. Can you call/ask the customer what was happening and if they can recreate it? That is probably what I would do. Dan
  3. Dan Cole

    Pay what you want pricing

    I think the problem was they were buying a more expensive package so they owed him the difference...he is just looking for an easy way to handle that. I think Tim's solution is a good one. Dan
  4. Dan Cole

    Pay what you want pricing

    Phil...I think the customer has already purchased a package but wants to buy a different one so CCGV will probably work. You give them a credit for the package they purchased and don't want...they order the package they do want...apply the credit and pay the balance. I think that is what the OP was saying. Dan
  5. Dan Cole

    TEP STOP error when changing to PHP7.2

    That's the right answer. Keeping the old version running will be a continued source of problems. Dan
  6. Dan Cole

    Report or tool to show when product was sold

    @14steve14 Steve I use the one that you had trouble with. As I recall it needed a fair bit of work and I may have tweaked it some for my purposes but it was well worth the effort. It is probably the add on that I use the most....it is very helpful to see where your inventory goes, who bought what as well as for cross sell, recalls, warranty stuff etc. It is invaluable to me. You might find it helpful to get the information you want in some other way, for the time, being but don't give up on that add-on. As I said, for me it was well worth the effort and I'd be happy swap files with you for comparison purposes if you want. Dan
  7. Dan Cole

    Discount Modules - Any Views?

    Just FWIIW, I believe the Discount Code add-on was a collaboration between Lambros and Rainer and there is a 2.3.1 version but I haven't used it and just wanted to give you another option. I wasn't pushing one or the other and in fact I use the Discount Coupon add-on referenced by Jack. Dan
  8. Dan Cole

    Discount Modules - Any Views?

    You should also have a look at Discount Codes by @Tsimi and @raiwa but there may or may not be a pre-BS version. Dan
  9. Dan Cole

    Managing your Products

    I've been chewing on this a bit more and have decided that this approach is probably the most appropriate one for me given the information I can access and the way I like to work. It'll probably be awhile before I get much of a pay back, if I get one at all, but if I don't get started on something I know it'll never happen. At this point I think I'll need a module to control or monitor the process with the ability to add and update a last reviewed date for products, categories and manufacturers. Obviously I'll need a table to hold that information too. The routine should allow me to display the manufacturers and then drill down to the categories associated with each manufacturer and then to the products associated with each those categories. With the ability to add and sort on the last reviewed date it should give simple way to manually manage the process. From there I can start to add checks to see products that don't meet my review criteria....ie prices are outside of a particular margin, images are too small, descriptions are short or missing etc, etc. That's the basic plan. As I make progress I'll come back and update this thread from time to time. Wish me luck...I'm not a coder but I can usually find my way along by cutting, pasting and hacking up existing code. I'm just very slow at it. Dan
  10. Dan Cole

    Managing your Products

    Just wondering what everyone is doing to make sure their product information, images, prices etc etc are kept current and up-to-date. Has anyone developed a systematic method of reviewing and keeping on top of their items, categories etc. For me it seems to be quite a hit and miss process. I usually spot something amiss, take a quick look and update an item or two and get back to what I was doing. With hundreds or thousands of products there must be a better way. What are you doing? Dan
  11. Careful...you might end up with a bug! Dan
  12. I think he had in mind something like...size 12, color blue, v neck or whatever. Dan
  13. If they're chocolate coated I'm in. Dan
  14. Those must be pretty big bugs! 😁 Dan
  15. @Tsimi Lambros this may have been reported before...I didn't see but it might have been. The use of this code in /includes/modules/content/header/templates/catmenu.php... <?php if(MODULE_CONTENT_HEADER_CATMENU_XS_STATUS == 'True') { echo '<div id="catMenu" class="col-sm-12 hidden-xs hidden-sm">'; } else { echo '<div id="catMenu" class="col-sm-12">'; } ?> Will result in an undefined constant warning if Categories Menu XS is not installed. Obviously it's not a big deal but since I noticed it I thought I'm mention it FWIW. Dan
  16. Dan Cole

    Managing your Products

    I've done something similar too. I added a "Vendors' field to my product table and modified some of the reports so I could easily see stock levels, out of stocks etc. It has been very helpful. Did this too....it's either set to the UPC or the suppliers part number. I use it for matching against their data files if they have one or for bar code reading when entering in-store purchases. The vendors part number is also included in a PO system that I use so if there is a UPC I tend to use that in the products table. Again it has proved to be very helpful. I update my prices as POs are received and entered. So stock, currency and prices get updated fairly often. I could have it update my selling price automatically but I've stopped short of doing that, at this point, and its one of the reasons I want to get some sort of product review system in place. I've done a little bit of this over the years too but have never found it particularly helpful. I'm in a niche market and tend to deal though distributors so the data is often limited and suspect. I find I'm better off just cutting and pasting from the manufacturers website, for the most part. A "PIM" is out of the question for my market. I do this too. Never found much valve in using attributes. Interesting how we have moved in similar directions in dealing with these issues. I hope that is a case of great minds think alike.😂 Dan
  17. Dan Cole

    Managing your Products

    I'm sure there must be others here besides Steve and I who tend to manage there products in a bit of a hit and miss way. I'd like to change that, and as I think about this a little more, the task probably needs to be chunked up a bit. As they say how to do you eat an elephant? With that in mind I think I need a way to... 1. Develop a list by either Category or Manufacturer to give a bit of structure to the process. It might be useful to add a last checked date so you can focus on the categories or manufacturers in the greatest need of review. 2. Develop a report so show me any products (by Category or Manufacturer) that don't meet certain criteria. ie price is outside of a specified margin, images are too small or don't exist etc. I currently use Gary's Products Monitor, from a few years back, to do some of this but it can probably to modified to add additional criteria and perhaps just display the exceptions. 3. Source or develop tools to make changes to any exceptions that are identified, in a bulk or managed way. Is anything else needed? Dan
  18. Dan Cole

    Managing your Products

    Vadym that is very interesting and could be quite helpful. I've tried a module like that, at one point, that was under development but it used some proprietary code that wasn't flexible enough to get the data from several of my competitors sites so I abandoned that idea. If the "price spider" its an available osC module I'd love to have a look at it. Dan
  19. For the life me I don't understand why everyone insists on things being added to the core. IMO, less is better...keep the core lean and mean. Modules can and should be used and developed for anything that is required. That gives us the best of both worlds. Why is it so difficult to get that idea across? Dan
  20. Dan Cole

    Telemarketer & Robo calls in the world

    I get boat loads of those calls. I usually answer them so I can have a bit of fun with whoever is on the other end but it can be annoying. Google Maps Marketing (so called) are responsible for most of the calls I receive. I often wonder why someone hasn't taken the Google approach to these calls....add a feature where you can mark them as spam and after getting a required number of votes...they can't make calls any more. I use Net talk on one of my phones and they actually let you know if a call is considered spam or not...if so, they hang up on it but unfortunately your phone still rings once of twice. I assume we'll see more of this sort of thing in the future. Dan
  21. Dan Cole

    KissIT Image Thumnailer

    Per the instructions... Find these lines ( lines 74-76 in a standard osCommerce 2.3.4 ) .. /// // The HTML image wrapper function function tep_image($src, $alt = '', $width = '', $height = '', $parameters = '', $responsive = true, $bootstrap_css = '') { Replace with the following: //// // New HTML image wrapper function modified for KISS Image Thumbnailer by FWR Media function tep_image($src, $alt = '', $width = '', $height = '', $parameters = '', $responsive = true, $bootstrap_css = '') { // Include the Database installation file if executed for the first time. if ( !defined('KISSIT_SHARPEN_THUMBNAIL') ) require_once 'includes/modules/kiss_image_thumbnailer/db_install.php'; // If width and height are not numeric then we can't do anything with it // If original image width and height are less than KISSIT_MIN_IMAGE_SIZE, we do not need a thumb if ( is_file($src ) ) { $original_img_size = getimagesize($src); if ( !is_numeric ( $width ) || !is_numeric ( $height ) || $original_img_size[0] < KISSIT_MIN_IMAGE_SIZE || $original_img_size[1] < KISSIT_MIN_IMAGE_SIZE ) return tep_image_legacy( $src, $alt, $width, $height, $parameters, $responsive, $bootstrap_css ); } else { if ( !is_numeric ( $width ) || !is_numeric ( $height ) ) return tep_image_legacy( $src, $alt, $width, $height, $parameters, $responsive, $bootstrap_css ); }
  22. Dan Cole

    KissIT Image Thumnailer

    @ce7It has been a long time since I installed this add-on but don't you need to add that function when you install it? Dan
  23. Dan Cole

    Help on backend

    Post in the Commercial forum Dave. Someone should come forward. Dan
  24. A real interesting read. Death of Retail: Fact vs. Fiction While I wasn't surprised to see brick and mortar closings exceeding the new starts, I was surprised by the number of new starts in the dollar store type businesses. Removing those it becomes a really sad picture. What can we do to stand out and offer a different experience as more and more customers shop on-line? In particular, what are you doing or planning to do? For those with repeat customers, what can we do to keep them coming back? Dan
  25. I use to think that but if you're selling standard commodities, based on what I'm seeing, I think price now rules, if the service isn't too bad. I guess you could say that I subscribe to the "race the bottom" theory now. As that article points out traditional retail is in big trouble, for a number reasons including on-line sales, which I think will offer lots of opportunity for those who get it right...whatever right is. I was hoping this thread might generate some discussions around that. What can we do to take advantage of those opportunities and minimize of the impact from giants like Amazon. Dan