Jump to content
Latest News: (loading..)


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
    Matt Hartman
  • Gender
  • Location

Recent Profile Visitors

6,786 profile views
  1. The Feedmachine Solution

    DJ Viper, this is because you are probably running php 5.5 and there are deprecated functions in there. I have been working with this, but I'm still having a problem. I don;t know if it related to this particular issue or not: in feedmachine.php around line 335 you'll find this code: $mysqli = defined('MYSQL_EXTENSION') && MYSQL_EXTENSION == 'mysqli'; $i=0; $fields = array(); while( $i < ( $mysqli ? mysqli_num_fields($master_query) : mysql_num_fields($master_query) ) ) { ++$i; $cur_field = ( $mysqli ? mysqli_fetch_field($master_query) : mysql_fetch_field($master_query) ); $fields[] = $cur_field->name; } change it to read: $mysqli = defined('MYSQL_EXTENSION') && MYSQL_EXTENSION == 'mysqli'; $i=0; $fields = array(); $fields_cnt = mysqli_num_fields($master_query); while( $i < $fields_cnt ) { $fields[] = mysqli_fetch_field_direct($master_query, $i)->name; ++$i; } This won't if you don't have the mysqli extension enabled in PHP. Still have a problem where it won't list but 16 of the 10,000+ products I have, but at least it stopped that particular error. now have to debug the rest of the system.
  2. [Contribution] Database Manager

    I am having the same issue. This happened when we made the upgrade to php 5.5. Any ideas?
  3. Mail Manager

    Thanks! No wonder I missed it!. I wonder if it would be possible to modify the script and set up a cron job that could be accessed to run the sale_followup once a day. I have installed it and it works fine, but if we could automate it that would take away one more thing that someone has to remember to do.
  4. Mail Manager

    Hi All, I have probably missed this somewhere in the documentation, but I was wondering what triggers the sales_followup function once it has been enabled. Is it just someone going to the site and accessing a page, or does there need to be a cron job created to run this feature?
  5. I've been working on a lot of improvements to the SpecsPopulate code. I ran into a lot of bugs concerning the compatibility with Excel and how it handles quotes in the specifications values. I have been using a variation of EasyPopulate 2.76g with great success, and I went back through and built a whole new SpecsPopulate 1.3 based on that version of EP. These are the highlights: Again, this is stripped down to only focus on specs, but I did leave in the option to add fields from the products table like MPN and UPC in case you needed those as a cross reference. If you do not have those columns just remove them from the customer fields section in the code. Any changes to any of the fields will be uploaded and applied, so beware. This system will not add new products, and will skip rows with model numbers that are not currently in the database. I have added a Dummy row at the top of the export file which will also be ignored upon import. The system will only create an export file if a category is selected and there are specs applied to that category. You can still download all specs and products in one file by selecting the Top category, but if you have a lot of specs or products, I wouldn't recommend it. I have also included a utility to look at the specs that have been applied to a category. I changed the export file naming structure so that it would include the category name, and a more accurate time stamp so there aren't as many overwritten files. I made one other major modification to all of my specifications code, and some of that is included here. I had to build a special character translation and replace function that gets around problems with URL translation for values. If you would like to use this, just add it to your includes/general.php in both the admin and catalog side. (you will also need to modify a lot of other areas in your specs code to make this work also) function specs_special_char_replace($values_data){ $needles = array('ZslashZ', 'ZinchZ', 'ZcommaZ', 'ZfeetZ', 'ZpercentZ','ZquestionZ','ZpipeZ','ZampZ','ZexclamationZ','ZhashtagZ','ZdollarZ','ZasteriskZ','ZcolonZ','ZsemicolonZ','ZltZ','ZgtZ','ZatZ','ZcaretZ','ZtildeZ'); $haystack = array('/', '"', ',','\'','%','?','|','&','!','#','$','*',':',';','<','>','@','^','~'); $values_data_clean = str_replace($needles, $haystack, $values_data); return $values_data_clean; } function specs_special_char_reverse($values_data){ $needles = array('/', '"', ',','\'','%','?','|','&','!','#','$','*',':',';','<','>','@','^','~'); $haystack = array('ZslashZ', 'ZinchZ', 'ZcommaZ', 'ZfeetZ', 'ZpercentZ','ZquestionZ','ZpipeZ','ZampZ','ZexclamationZ','ZhashtagZ','ZdollarZ','ZasteriskZ','ZcolonZ','ZsemicolonZ','ZltZ','ZgtZ','ZatZ','ZcaretZ','ZtildeZ'); $values_data_clean = str_replace($needles, $haystack, $values_data); return $values_data_clean; } if you do not want to use this, just do a search within the SP file for specs_special_char_replace and specs_special_char_reverse and comment out the lines with those functions in them. SP should work fine without them. Another addition feature I have been using is the integration of the Select 2 jQuery dropdown plugin to help with searching for categories more easily. Go here to find out more: http://ivaynberg.github.io/select2/ Otherwise just remove the script codes to prevent any javascript errors in your installation. I hope this will help someone out. specspopulate.php
  6. Hello All, I have taken the easypopulate file that bruyndoncx so generously uploaded and stripped it down to just include the specifications. I'm calling it SpecsPopulate. I found it was much simpler to separate everything and to only focus on the specifications once the individual products, categories etc have been created. It seems to work very well, but the biggest hurdle that I have found is that it's difficult to determine what the specifications_value_id and the specifications_value pair actually are to be able to enter them into the spreadsheet. If the specification hasn't been assign to a product, the value doesn't show up in the column anywhere, and you are left to search out the spec value. My thought was to build the code that would add the id/value pair to the first row or last row in the SP spreadsheet. This row would be for reference only, and would not include a model number. Without the model number, the row would be skipped. By having the id/value pair on the sheet already, it would make it very easy to just copy the values down to the rows they are needed in. My problem I'm running into a coding mind block on how to make this happen. I'll upload my current version of the file and would welcome anyone to come along and add or modify it. specspopulate.php
  7. FedEx - Web Services v9

    I have a customer who is using all three services, FedEx, UPS (UPSXML) and USPS as choices for shipping. I have FedEx Web services 9.4.2 installed and working fine. One of the things that they have asked about was the ability to tack on insurance for the shipment for FedEx, like they can for the other 2 modules. I see that the WSDL has mentions of insurance, but not sure in what capacity. Would it be possible to add an insurance option to this module?
  8. FedEx - Web Services v9

    I have a question about Insurance using the FedEx Web Services v9 module. I see that there is code included in the module with an apparent defined constant: @[member='definedmedia']('MODULE_SHIPPING_FEDEX_WEB_SERVICES_INSURE', 0); and further down: function _setInsuranceValue($order_amount){ if ($order_amount > (float)MODULE_SHIPPING_FEDEX_WEB_SERVICES_INSURE) { $this->insurance = sprintf("%01.2f", $order_amount); } else { $this->insurance = 0; } } The _setInsuranceValue function is called in the module, but it doesn't appear that it changes the value of the returned quote when we change the package value or the value of the defined constant from 0 to any other number. In the previous module/API we were able to define the insurance amount that triggered insurance addition. Can someone confirm or deny that the insurance option is or isn't functioning with the v9 module?
  9. The Feedmachine Solution

    Love the feedmachine, but I have a configuration issue. I have another URL parameter that I have been using to track what particular item is being clicked to produce the click conversion. I have been using another feed generator and had coded it to return the additional URL parameter of &utm_term="model number" where model number is pulled from the $products['products_model'] in the database. How can I structure or modify FM to return that parameter? I have tried adding it to various locations in feedmachine.php where PRODUCTS_URL is generated, but it doesn't seem to be picking it up. I also tried creating a separate function in the configuration file, but it's not picking up the url parameters spec'd in the admin. Any help would be appreciated.
  10. [Development] Products Specifications

    I should clarify the previous post by saying that I have the MySQL error issue on the Filter Module or Box the public side.
  11. [Development] Products Specifications

    Thanks for the push in the right direction. I'm having another problem and I wonder if I found a bug. I have built a filter with a multi select box. Whenever I select multiple items within the same box, and submit I get the following SQL error. Is anyone else seeing this?
  12. [Development] Products Specifications

    Thanks for the prompt reply Jim. I thought that was the answer but I miss things sometimes. I'm trying to consolidate the display of various bits if information about the products, and this system would be a great place to put it. For instance I have added UPC, ISBN, Manufacturer Part Number fields as well as the already existing fields. To bring the site up to the standards of a Grainger or Fastenal, I'll need to be able to display all of this information in a fast easy to digest manner. The dilemma I have is that my customers who admin the site see the "display on products info page" setting and are disappointed when I tell them that they can't do that. Correct me if I'm wrong. In glancing at the code, I'm thinking that if I add an additional MySQL query to the /includes/modules/products_specifications.php code, which ignores the restrictions from the products_specification table, I'll be able to bring in the information from the products_column_name field, and reference that to the products_id to be able to display the info stored in the field. I'll just have to rejigger some of the if statements (and grow some talent). Any thoughts?
  13. [Development] Products Specifications

    Another questions guys, I want to display the weight on the product info page, but not as a filter and not in the comparison page. I have set up the spec and have selected the Products Weight from the drop down. It is not displaying in the products information page along with the other specs. I have a couple of questions: Is this even possible with this feature? If so, what would the criteria be that I need to meet to make it happen? Thanks for the help. Matt
  14. [Development] Products Specifications

    I am using the BTS with the infobox admin contribution. I'm not sure how STS handles the info boxes, but I did have to do some custom stuff with BTS to get the new box in the right place so the template would pick it up. But even after I had everything all set up and working "as it should have" I didn't have the Products Specs set up correctly to allow the box to actually display. This was very confusing to me at first because nothing showed up where I though it should have. Have you set up any filters or specifications in admin? You must have something set up, and be in the proper category with products that fall into the filter/specification criteria otherwise the filter box will not show up at all. As a test you can open up the /includes/boxes/products_filter box.php file and comment out the code that says if ($count_filters >= SPECIFICATIONS_FILTER_MINIMUM) { and the corresponding close brace } toward the bottom of the file. At least then it will display a blank box for you so you know you have it in the right location.
  15. [Development] Products Specifications

    Jim, I'm running into a problem where I have set up a "Call For Price" system in my cart. Basically, I created another column in the products table that just sets a flag, 1 or 0, to display "Call For price" for each item. I don't want those items to show up in the products filter (or filter count) when I filter based on final price or products_price. I was going through the SQL logic in catalog\includes\functions\products_specifications.php, and have tried to insert a and p.products_call_for_price != '1' into the 'where' statements, to no avail so far. Is there some specific place you can point me to where I can place this logic where the products with no prices won't show up in the filter list? I think I may not have placed the p.products_call_for_price in the right select statement, but I'm a bit stuck as to where the columns are actually selected. I'm looking at around line 392-398, but I'm not sure.