Jump to content

bws

Member
  • Content Count

    33
  • Joined

  • Last visited

Community Reputation

0 Neutral
  1. Yes, that will work great. I've already tested it out. Then when the order is actually completed (check has cleared), I'll just email them myself with their tracking number.
  2. I'm doing a quick check of my store, and was checking out the email templates. There's one there called Cart:Payment Received, that I would like to be able to send out. I only accept checks, so it's important to send the customer a payment received notice. Because after it's received, will be another 10 business days (two weeks) that the customer will need to wait for the check to clear. So important he gets the payment received notice so it's easy to keep track of the expected shipping date. The way my store is set up now, after purchase the customer receives an Order Confirmation by email right after the online purchase. He gets a copy of the order with the Print Order Form extension. Then I wait for the paper order + check to arrive. After check arrives, I go to the back-end orders section and select the order. There's a selection drop-down menu there, I can select from Pending, Processing, Order Complete, Declined, Failed Fraud Review, and Cancelled. I select Processing since there is no Payment Received selection. After I select Processing and Save, the customer receives another email, but it's the same as the first one he already received, Order Confirmation. I would like that he be sent an email using the Cart:Payment Received email template/contents instead, so it's clear that the email is about his payment being received. Does anyone know how I can change my settings or customize something to do this? It would be neat to change the drop-down selection in the orders section to say: Payment Received, but I can also use what's there already, Processing, as long as it sends a Payment Received email and not another Order Confirmation email..
  3. I think I just fixed this error. For this doc_privacy column, I originally set it as in the v 6.2.1 default, first row 1, with remaining rows 0. I knew it indicated the home page doc as privacy doc, but those were the initial settings in the latest version. I decided to go to the back end under documents and take a look. I selected the 4th document "Privacy Policy" as the radio button selection. Saved that and had a look at the documents table in the db. The 4th doc was now set as 1, all the others 0. Went and purchased another item from my store and checked the errors. It's gone! Yay! I'm not messing with the last error 'latest' in document table at this time. I will ignore that although I know the cause, I'm not technical enough to do that one. Instead I will thoroughly check the store out some more and if it appears okay will download a copy using filezilla + some high-speed internet. [21-Aug-2018 09:49:08 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 09:49:08 Canada/Mountain] PHP Warning: str_replace() expects at least 3 parameters, 2 given in /home/user4087/public_html/shop6.2.1/classes/gui.class.php on line 915 [21-Aug-2018 10:04:35 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 10:04:35 Canada/Mountain] PHP Warning: str_replace() expects at least 3 parameters, 2 given in /home/user4087/public_html/shop6.2.1/classes/gui.class.php on line 915 [21-Aug-2018 10:18:51 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 10:18:51 Canada/Mountain] PHP Warning: str_replace() expects at least 3 parameters, 2 given in /home/user4087/public_html/shop6.2.1/classes/gui.class.php on line 915 [21-Aug-2018 10:24:56 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 10:27:40 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 10:27:58 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 10:37:58 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 10:47:41 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 11:41:36 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 11:41:39 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 11:41:40 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 11:52:10 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 11:52:13 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 11:52:15 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 11:55:24 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 11:55:28 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 11:55:31 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 12:29:15 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 12:51:12 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 Since I'm downloading my cubecart database so often, and I don't have high speed internet at home, I'm trying to get the db to a smaller size. Yesterday I checked and it was just under 1 MB. I emptied a few tables which were long and I didn't need: admin_log, cookie_consent, search, sessions, and system_error_log. It's now down to 670K. I was also interested in emptying out the fairly long tables: order_history, order_inventory, and transactions, but I was afraid the store might stop working correctly if these were emptied. Would it be safe to empty these tables out, if I don't need this info? I will keep the unneeded info in these tables, until I hear from someone who knows more than I do, if they are required for cubecart to work correctly!
  4. I wanted to fix these errors before downloading a good copy of my store. I'm down to the last error now, latest in inventory table. But I may just leave it alone, since no problems, other than the error message. Yesterday I gave my geo_zone the status column it so desperately wanted to have, and that was easy. I just deleted my slightly outdated table and inserted a fresh table + data from the downloaded v 6.2.1 database I have. Today, I added the doc_privacy column to my documents table. I only have 9 documents, 5 English and 4 in a foreign language. But it wasn't easy to do, had to modify my current data with the new column, and was getting error messages after trying to update, "column count doesn't match value count at row 1." Then I realized the new table also had a hide_title column it it! I managed to get the new table data uploaded with no problems, and everything works. Right after, I checked the error log, I was expecting to see only one last error, latest in inventory table. I no longer received the doc_privacy error, but it was replaced by another error! [21-Aug-2018 10:04:35 Canada/Mountain] PHP Warning: str_replace() expects at least 3 parameters, 2 given in /home/user4087/public_html/shop6.2.1/classes/gui.class.php on line 915 And it's repeating itself just like the doc_privacy error it replaced. I have about 100 rows of products in my inventory table, and see MORE than one or two new columns there, so for now I think I will not worry about the last error message. The latest one I must have created is a warning, not just a notice, so I think I'll stop while I'm ahead. Here's the latest sequence of errors, showing the doc_privacy error has now been replaced with a warning! [21-Aug-2018 07:12:50 Canada/Mountain] PHP Notice: `doc_privacy` is not allowed as a key in 'CubeCart_documents' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 08:10:51 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 08:10:52 Canada/Mountain] PHP Notice: `doc_privacy` is not allowed as a key in 'CubeCart_documents' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 08:30:21 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 08:30:21 Canada/Mountain] PHP Notice: `doc_privacy` is not allowed as a key in 'CubeCart_documents' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 09:49:08 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 09:49:08 Canada/Mountain] PHP Warning: str_replace() expects at least 3 parameters, 2 given in /home/user4087/public_html/shop6.2.1/classes/gui.class.php on line 915 [21-Aug-2018 10:04:35 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 10:04:35 Canada/Mountain] PHP Warning: str_replace() expects at least 3 parameters, 2 given in /home/user4087/public_html/shop6.2.1/classes/gui.class.php on line 915 [21-Aug-2018 10:18:51 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 10:18:51 Canada/Mountain] PHP Warning: str_replace() expects at least 3 parameters, 2 given in /home/user4087/public_html/shop6.2.1/classes/gui.class.php on line 915 [21-Aug-2018 10:24:56 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 10:27:40 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [21-Aug-2018 10:27:58 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914
  5. Thanks for the hint re global.inc.php prefix. I know what the problem is now, will correct it next time I go to the library and access the high-speed internet. I noticed a bug today in the modified store when I went to the back end to change material pricing. I figured out what was causing the problem and modified a custom file called products.materials.inc.php and that took care of it. I went there because I also saw in the error list, "unable to load content for products: materials." Hopefully by tomorrow all the errors will be finished. I'm glad I checked in the cpanel error folder as well as the cubecart admin system error log, as the errors only showed up in the folder. Then I'll download the entire store and upload it again to a test2 folder, using the library's high-speed internet.
  6. Yes it does have the new store folder specified there, I didn't write it in! shop6.2.1.test is the exact name of the folder. I may just go to the library where I can access high speed internet, and start fresh with a test2 folder, that way I can test filezilla to make sure both my downloaded copy is good and can also upload correctly. I would have to do that anyway if my store ever went kaput, so I might as well try it now to see if will even work. If it does, then I will keep a good and current copy downloaded on my computer knowing it will work if I ever have to upload it back. Since I've never actually uploaded my entire store back online before, I'm not even sure at this point if the downloads are good, so will be testing this out soon. Thanks for the info on the .htaccess file, I will check and make sure that it's updated afterward. I also have another .htaccess file same level as the old index.html file, that one just redirects from my website url to website url/shop6.2.1 and then to the storefront. I don't think that one affects cubecart, only web surfers who type in the url and don't know anything about the store folder, redirects to the store. ## Default store 404 page ErrorDocument 404 "<html></html> ##### START CubeCart .htaccess ##### ### GZIP Compression ### <ifmodule mod_deflate.c> AddOutputFilterByType DEFLATE text/text text/html text/plain text/xml text/css application/x-javascript application/javascript </ifmodule> ### Files Expiration ### <IfModule mod_expires.c> ExpiresActive On ExpiresByType text/html "access 0 seconds" ExpiresDefault "access 7 days" </IfModule> ### File Security ### <FilesMatch "\.(htaccess)$"> Order Allow,Deny Deny from all </FilesMatch> ### Apache directory listing rules ### DirectoryIndex index.php index.htm index.html IndexIgnore * <ifModule mod_headers.c> Header always append X-Frame-Options SAMEORIGIN </ifModule> ### Rewrite rules for SEO functionality ### <IfModule mod_rewrite.c> RewriteEngine On RewriteBase /shop6.2.1.test/ ##### START v4 SEO URL BACKWARD COMPATIBILITY ##### RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule cat_([0-9]+)(\.[a-z]{3,4})?(.*)$ index.php?_a=category&cat_id=$1&%1 [NC] RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule prod_([0-9]+)(\.[a-z]{3,4})?$ index.php?_a=product&product_id=$1&%1 [NC] RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule info_([0-9]+)(\.[a-z]{3,4})?$ index.php?_a=document&doc_id=$1&%1 [NC] RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule tell_([0-9]+)(\.[a-z]{3,4})?$ index.php?_a=product&product_id=$1&%1 [NC] RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule _saleItems(\.[a-z]+)?(\?.*)?$ index.php?_a=saleitems&%1 [NC,L] ##### END v4 SEO URL BACKWARD COMPATIBILITY ##### RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteCond %{REQUEST_URI} !=/favicon.ico RewriteRule ^(.*)\.html?$ index.php?seo_path=$1 [L,QSA] </IfModule> ### Default store 404 page ### ErrorDocument 404 /shop6.2.1.test/index.php ## Override default 404 error document for missing page resources ## <FilesMatch "\.(gif|jpe?g|png|ico|css|js|svg)$"> ErrorDocument 404 "<html></html> </FilesMatch> ##### END CubeCart .htaccess #####
  7. Decided to go ahead and create a duplicate store for testing. I went to cpanel to try copying my entire cubecart version 6.2.1 folder into a test folder, cubecart-store-test. I selected all, copied, and gave the new folder name. Everything looked good, so I also created a new db and then uploaded my current db into that. And I went to global.inc in the new folder and gave it the name of the new db to use. Then I went to log in at the new folder admin and there was no login screen. I checked again, and saw that all the subfolders had copied over except one, the admin folder. So I went back and copied just the one folder over. I thought that the first folder which was admin had not been selected with the select all and that was the problem. But after I copied over the one folder, I could see that it disappeared once again. It says 755 like the other folders but it didn't want to be copied over! Then I went to filezilla and uploaded it that way. I've got the login page now, but after I entered my password, I received a can't connect page error. Softaculous says they can copy or clone a store so it can be tested this way, called staging. I was going to try that way, but this way seemed simpler to me. Is the way I'm trying to do it not going to work, or do I just have to tweak some more files besides just the global.inc ? By the way, I am getting no more errors in the back end error tab, but while I was in cpanel, I saw an error_log folder and checked it. I am getting some errors there, as listed below, but I guess they can't be that big or I would see them listed in the back end error tab. [17-Aug-2018 16:41:19 Canada/Mountain] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914 [17-Aug-2018 16:41:19 Canada/Mountain] PHP Notice: `doc_privacy` is not allowed as a key in 'CubeCart_documents' table! in /home/user4087/public_html/shop6.2.1/classes/db/database.class.php on line 914
  8. Softaculous installed the correct version, 6.2.1. But soon after it was installed, I continued the testing I was doing with a working modified 6.0.12 version, trying to pass the mods over to version 6.1.13. I created a new db and then inserted a db I had been using into the new one, and tried to get it working with version 6.1.13. After a certain period of time I realized I was not going to get the calc mod to function properly there, and I decided to learn more about why most of my pictures were not appearing in the listings, only a few pictures were showing up. After finding some info online about this, it appeared that there were 3 tables involved - inventory, image index, and filemanager. I started studying the index numbers in all these, comparing a product in that db with same product in the original version 6.0.12 where everything worked, including the pictures. I never really figured out how it all worked, but I noticed that some numbers in file manager were different for same product in both versions. Since the original version was working just fine, I decided to take the file manager table from 6.0.12 and insert into version 6.1.13 after clearing the table. I had nothing to lose since the half baked calc program wasn't going anywhere, nothing to lose if things didn't go right. After I did this, what a surprise, all the pictures showed up! This modified db also gave me about 100 products, arranged in multiple categories and subcategories, and in two languages. Only the calc didn't work, and the db part of the calc did work. The link on the back end didn't show up, but I knew what the url was that the link would have generated, and when I pasted it into url in the back end, I was able to access the 2 materials prices and change prices.. After that success I decided to download the latest cubecart version which was about a year ahead of the one I was trying to modify.. I did receive the correct db with latest version, and as soon as I saw there was one test product and one test category, I decided to keep that db in a safe place and create a brand new db, after which I inserted a copy of the db from version 6.1.13. I then re-adjusted the global.inc file and Voila! All products all neatly arranged in their proper category. Test item and test category vanished! I really didn't want to delete that one or manually add all my stuff.. So I was very pleased about it, and that's when I decided to get serious about getting the calc mod to work! I requested and received good documentation about all changes made by the programmer, I just had to go one step at a time, and try to make sense of it and what each part did to the program. I re-documented everythng, and also have my own mods documented. After a month or two I succeeded in getting things to work exactly as they did in version 6.0.12, including the search error. After your last post, and another before it regarding db schema, I realize what the problem is. The db schema gets changed periodically, and the one I have from version 6.1.13 is missing some tables the current version has, or some columns in some tables.. Today I went and found the original version 6.2.1 db that I kept in a safe place and copied the order summary table. Then I deleted the order summary table in the test db. Then I added the latest version order summary table into test db. Now everything works fine when I checkout and no errors in error log! Probably took care of the Mr T vs Superman error I received a few days ago too.. Contains the "custom_oid" in two places.. 09 Aug 2018, 17:43 File: [orders.transactions.inc.php] Line: [79] "SELECT SQL_CALC_FOUND_ROWS DISTINCT `T`.`order_id`, `T`.`time`, `T`.`amount`, `T`.`gateway`, `T`.`trans_id`, `S`.`id`, `S`.`custom_oid`, `S`.`cart_order_id` FROM `cctest_CubeCart_transactions` AS `T` INNER JOIN `cctest_CubeCart_order_summary` AS `S` ON `T`.`order_id` = `S`.`cart_order_id` LIMIT 20 OFFSET 0;" - Unknown column 'S.custom_oid' in 'field list' Taking a couple days off to celebrate, then will see about setting up a duplicate store to experiment on further, and see about getting the search page to work properly.
  9. After I talked with server people I found out Softaculous was automatically saving about 250 MB of files for me on a daily basis, for older versions I was about to delete. So I turned those off and will check back in a day or two and make sure it's stopped, then delete the 250 MB from softaculous_backups folder. While I was in Softaculous I saw some other icons and it looks like I can make an extra copy of installation there, so I will go back after I take care of deleting the unneeded backups. I added the extension info table and cookie consent table to the db, because of the error messages I was getting in admin System Error Log, and those errors went away. Today I did a sample purchase from the store and checked the error log, 2 errors came up while I was checking out, Today, 11:02 File: [settings.index.inc.php] Line: [231] "SELECT SQL_CALC_FOUND_ROWS id FROM `cctest_CubeCart_order_summary` WHERE `custom_oid` <> '' LIMIT 1;" - Unknown column 'custom_oid' in 'where clause' Today, 11:01 File: [settings.index.inc.php] Line: [231] "SELECT SQL_CALC_FOUND_ROWS id FROM `cctest_CubeCart_order_summary` WHERE `custom_oid` <> '' LIMIT 1;" - Unknown column 'custom_oid' in 'where clause' Does anyone know what's causing these and the remedy?
  10. My older version cubecart won't work to test the calc because it was never 100% functional. I went there and saw the full price in the store but during checkout the total price displayed was only the "material price * material weight" part of the formula, the opposite of the search error which displays only the premium-price part. I'm going to get in contact with the server people and find out how to duplicate my latest version of cubecart folder and make another folder with .b at the end. That way I can experiment with the identical cubecart while leaving the original online and safe. If the changes work out okay, then I can move them over to original cubecart, or switch folders and put the modified folder online and use the other one for further modifications.
  11. Good Afternoon I'm building a new sitemap today and updating my new and improved seo with shorter links. I was going and copying each new link from the url of each product, from the Generic category, and while I was doing this I realized more about what the code snippet was doing. I actually have only 22 items in that category as I originally thought. These all show initially with the code snippet switched on. The part that's a little confusing is at the bottom the More button also shows. So one would think there are more to show. After the button is pressed, 44 items appear! But the additional 22 are a repeat of the first 22! As a seller I really don't care as a buyer could very well see something they like out of the 44 as easily as having 22 to look at.. But if you wanted to polish this one up a bit, I would also have it remove the More button! About changing the calculator code, well since my latest cubecart is now working with the calculator, I'm not going to change stuff there but I will go back to another older version I have that's had the calculator engine installed and working, and has same issue with search results, and experiment over there with calc code changes first. I will experiment with the older version sometime this weekend. Thanks for your interest and expertise.
  12. Update #2 on show all items in category code snippet. Checking front end today category 1 Generic showing 22 out of 44 items on initial view, .html in browser and More at bottom. Clicking More shows all 44 items, with .html#2 in url. Category 2 North American showing 16 out of 32 items on initial view, .html in browser and More at bottom. Clicking More shows all 32 items, with .html#2 in url. Going to other categories and returning to overstocked ones shows .html#2 remaining in url and all items displayed. Even though not showing all items until More at bottom is clicked, this is working way better than before the modification code was installed, and I'm giving it 5 stars. Regarding my calculator mod, does anyone know how I can get it to calculate the full price after a search (/search.html)? The calculator engine appears to be in shop/classes/catalogue.class.php $product = $this->getProductPrice($product); was commented out and formula for calculating full price was added below that. 1) shop/classes/catalogue.class.php 1.1) Find $product = $this->getProductPrice($product); and comment it out // //$product = $this->getProductPrice($product); 1.2) Find foreach ($GLOBALS['hooks']->load('class.cubecart.product_price') as $hook) include $hook; and add below if (($materials = $GLOBALS['db']->select('CubeCart_materials', array('price'), array('id' => (int)$product_data['material']))) !== false) { $surcharge=$product_data['product_weight']*$materials[0]['price']; if ($product_data['sale_price']) { $product_data['sale_price']+=$surcharge; } $product_data['material_price']=$surcharge; $product_data['price']=$product_data['price']+$surcharge; } I'm not a programmer but it looks to me that there is another cubecart file associated with the search page, that needs to have price of product commented out and formula added below that. What is the search file that I should start experimenting with? I get the full price everywhere in the catalog and thru checkout, however after doing a search with multiple results, the "price" shows as only the price (=premium) part of the formula and leaves out the material price * material weight part of the formula to be added giving a total.
  13. I probably should have just pasted it in and pushed the button. But I saw the enable box so I ticked it, entered the 99 manually, etc. I guess if you paste and push, it reads in that top bit and then deletes it. But since it was already filled in, it probably didn't delete it so I went back and deleted that bit myself, and the code now starts with the commented section. I'll try paste and push next time to test. Update on category code snippet: I went to the front end of my store to check on how many items would display, and it didn't seem to be working. Then I found another category that had even more items in it, so I went back to the code and increased the number to 32. After going back to the first category I realized I had a lot more in there, more than the 22 items I had thought, as that was all I could see after I tapped the more button.. I actually have 44 items in the category I thought had 22, so I increased the number again, to match 44 now visible, which appeared out of the blue. Now both categories "show everything" and I have a nice #2 at the end of url in each.. I'm really glad I decided to fix this, because if I don't know how many items are in these categories, then I know the shopper/buyer isn't going to know.. My categories are no longer embarrassed to "show everything," so I hope shoppers appreciate that as much as I do.
  14. I tested the code. I could see it was trying to work because when I went to view a category I got this bit at the top of the page.. Enabled: Checked Unique ID: [email protected]+ Execution Order: 99 Description: Shows all products on one page if count is X or less. Trigger: class.catalogue.pre_search Version: 1.0 Author: Forum Conversation PHP Code: So I went back and removed that part. I changed the number to 24 to allow for some new products, but still only showed the 12. Then I decided to get an exact count of how many products were in that category, 22 and changed the number to 22. Now it works perfectly. If I ever add more stock in that category then I will just update the number. Do you know if it's possible to remove the pricing from products, only after a search which displays multiple items? I have had a programmer add a nifty calculator to my cubecart, but have not been able to contact him so I'm on my own with upgrading the calculator into version 6.2.1. He provided some good documentation of his work, and I've been trying to upgrade the calc into the latest version of cubecart, at the time was v6.1.13 but could not get everything to work properly. I decided to start fresh with cubecart v6.2.1 and took the time to not use the older pages, but only the actual changes into the current v6.2.1 pages, and finally I have got it to work. Although I'm getting a few error messages, probably they are unrelated to the calc mod. V6.2.1 works fine now with the calculator. Anyway there is one bug in the calc program which was in the original program he did, and I did not have enough time to notify him because I didn't notice it until some time after the work was done. We have an extra table in the db for material, and I set the material, for instance silver, at the current market price periodically. The db knows which product is associated with which material and cubecart does a calculation to arrive at item price = material price * item weight in ozs + the normal cubecart price which is actually the premium representing manufacturing and other costs + profit. So with silver set at $16 and $5 premium, the cost shows as $21 in catalog and thru checkout. The minor bug which I would like to solve is that if a search is done, it's fine if only one product is found because it goes to the product page and only adds this colored box at the top - Just one product was found matching 'search item' - and price is calculated as usual. But if several items show in the results, then what it does is displays the prices as only the premium price of $5! Of course when the item is clicked on, the next page will show the full price, so no way a customer could buy at the $5 price. I've never even had any customers notice this or at least say anything about it before. But I would like to figure out a way to correct it. Either by causing the search results page to show no prices, or figure out how to get the calculator function to also work on that page. I think not showing the price there might be the easiest way without the programmer's help. Thanks a lot for the code snippet. That will really help when a customer views the overstocked category, to see all, not just half!
×