mitchellds

I gotta tell ya, that was super simple. Upgrade went quick and without a single hitch! Good job, Al!

I am finally ready to upgrade. Anything special I should know before I click on the Upgrade Now button? Thanks for the help in advance! Darren Mitchell WARNING: Your store is not up-to-date, v5.2.4 is available, but you are running v5.1.4

Did a little research and here is the SQL command that I used (everything works as advertised now)! UPDATE `cube_CubeCart_inventory` SET `use_stock_level`=1 WHERE `status`=1

Wow! I can't believe it was that simple. I thought the purpose of a product's "Use Stock Level" flag was to flag the admin when stock levels are at or below the stock level warning. This flag would then appear in the stock warnings tab. But you are right on target, I checked the item with the red X and then checked it with a green "check." Now, to get everything updated correctly...is there a way to compose a SQL command that will find all records where "Status" is ENABLED - then, update the found records by changing the "Use Stock Level" field to ENABLED? I plan to use phpMyAdmin to run the SQL command. Again, thanks very much for your help! You are awesome!

Thanks for your quick feedback! I have attached a couple more screen shots of my current configuration.

V: CubeCart 5.1.4 Check out the attached screenshot. For many of the products in my inventory, I have entered a negative number (this number reflects the current inbound inventory - this is a one time solution as I initially populate my inventory). Here's the problem: for a given product with a negative number of products on hand, customers are still able to add this product to their shopping cart. For example (reference the attached screenshot), I have 35 of these antennas on order (thus the -35 count), yet a customer is still able to add this item to their cart. I am sure the software checks to make sure the number of items on hand for a given product is greater than zero in order for a customer to add it to his/her shopping cart (unless, of course, the system is set up to allow out of stock purchases - which my store is NOT). I also have the "Hide out-of-stock" product checkbox checked but, as you can see, if the inventory is a negative number, the item is not hidden. Any ideas?

Absolutely PERFECT! Thank you very much, bsmither...as usual, you have been a tremendous help!

V: CubeCart 5.1.4, clean I'm interested in appending the condition code to the product name on my site at XebraParts.com. I do realize that when you click on a specific product, the condition code is listed. I'm looking to make this improvement 'one level up' in the product catalog. For example: for each product, I need to display the product name plus the condition code in parenthesis. I have attached a screen shot of the way I am interested in making the improvement...unless someone out there has a much more simple, better idea that will allow me to accomplish the same goal.

V: CC 5.1.4 clean Recently, I have been noticing an elongated rectangle on my CubeCart admin pages. See the attached screenshot. When I pull up the code in Google Chrome, this is what I get: <div id="ui-datepicker-div" class="ui-datepicker ui-widget ui-widget-content ui-helper-clearfix ui-corner-all ui-helper-hidden-accessible"></div> Any ideas what is going on here?

Thanks, bsmither! I made this change as well. The mouseover capability was driving me nuts...the click functionality works much better.

V: CubeCart 5.1.4, clean It would be very nice if CubeCart had built-in functionality to do the following: About 14 days (or whatever value the administrator sets) after an order is marked Order Complete, CubeCart would automatically fire off an email message to the customer asking if everything is A-OK with their order. It would also be important that if the customer replies to the message, that the reply-to email address is automatically provided for them (like: [email protected]). Here is an example: Subject: Everything A-OK? Hey {customer's first name would go here}, I want to make ABSOLUTELY certain that your XebraParts.com order arrived on time and that you are happy with every item you purchased. Your feedback helps us improve our products and service. If there is ANYTHING I can do from my end, simply reply to this message just let me know. Thanks again for your order! Darren Mitchell [email protected] XebraParts.com Reference order # {order number would go here} placed on {order date would go here}.

V: CubeCart 5.1.4 Clean Go to Settings, Store Settings, Extra Tab. Where you set the options for Product Clone, I'm trying to figure out what the option Redirect to cloned product details actually does. Any ideas?

OK, got it. Thanks very much! Right now, I can't find any other problems that jumped up on the radar after my last database restore operation.

OK, now that was cool! I've never used Notepad++ until today. Why in the world did Notepad++ work while Notepad did not? You gotta know, bsmither, that you've been a HUGE help! I sincerely appreciate it!

OK, that did the trick. I did not insert that print_r function (or whatever it is called). More likely than not, it was either Al or someone on his team who inserted it while trying to figure out the duplicate Custom SEO URL problem. Only one more little glitch: if you check out http://XebraParts.com, at the very top of the screen, there appears to be a blank line that has mysteriously shown up (after I removed the print_r function). This blank line is throwing off the vertical size of the search box. Again, I made no changes to cubecart.class.php so I am guessing that whatever change was made by the CubeCart Jedi warriors has caused this little problem.

There's been no "peppering" on my end. I don't even know how to "pepper" code! I found only one instance of the "print_r" function in the code below. I would have attached my cubecart.class.php file but it appears that I have run out of attachment space! Here is [a portion of] my cubecart.class.php file: if ($latestProducts) { print_r($latestProducts); foreach ($latestProducts as $product) { $category_data = $GLOBALS['catalogue']->getCategoryStatusByProductID($product['product_id']); $category_status = false; if (is_array($category_data)) { foreach ($category_data as $trash => $data) { if ($data['status'] == 1) { $category_status = true;

Since performing a restore operation yesterday, I've run into a problem with featured items. I have turned off the "Include in Latest Products" for every single item in my store except ONE. Now (post backup recover phase), when you visit http://XebraParts.com, a "bunch of junk" text appears at the top of the screen that seems to be correlated to the one featured item in my store (the only item that has the green "Include in Latest Products" check mark). This "event" only happens on the home page of my store. Click on any link in the store and the "bunch of junk" text disappears. I am reasonably sure that this problem is a direct result of the "restore" operation I performed yesterday. Any ideas?

Awesome. Thank you very much! Encountered one more problem with "featured items" as a result of the "restore" operation I performed yesterday. I will start a new thread describing the problem.

I made a backup of a clean installation of CC 5.1.4.

This was EXACTLY the problem. After changing the filepath column to null, everything now works as advertised. So, how do I think this problem happened? I honestly believe (but it is very possible that I am wrong) that the filepath column was changed from null to "blank" during the restore operation I performed yesterday. Thanks for helping me get this squared away, bsmither. I really do appreciate it!

Thanks for the help, bsmither! Task 1: I looked in my System Error Log and it is 100% clean (meaning that there are zero entries). Task 2: I viewed the database table CubeCart_filemanager. Yes, all records (that have filenames that correspond to the files) exist. I have attached four screen shots for verification.

An interesting problem popped up this morning on my CC 5.1.4 installation. When I click on Images under File Manager, all of the image files that were once there are now gone. In addition, when I click on Downloads under File Manager, all of the download files that were once there are now gone. I have verified (through a web based file manager tool) that the actual files still exist and they are in the correct location; I have never moved these files. I tried clicking on the Update File List tab under both Images and Downloads - this did not work - the files that I know are there did not appear. Any ideas?

About a week ago, I prepared 400 new products for import. I imported these 400 items and found that I didn't have the data absolutely perfect. So, I went through the Remove Previous Import process. Yesterday, my game plan was to import 400 new products. I took the time and made the import data absolutely perfect. So, to start, I used the web interface to create a backup of the database and the files. I went through the Import Catalog process without a hitch - until I saw exactly 400 errors in my System Error Log. Each error recorded a duplicate Custom SEO URL. Apparently, when you go through the Remove Previous Import process, the corresponding Custom SEO URLs DO NOT get deleted...that's why I got the Custom SEO URL "duplicate" error times 400. So, the problem I was left with at this point is none of the 400 products I imported had a Custom SEO URL (which I spent a bunch of time getting really squared away). At this point, I thought...no problem - I will simply do a restore and start over. The first thing I tried to do was click on the "restore" icon that corresponded to the backed-up database that I wanted to restore. I thought...that was super-simple. However, when I went to look at the products in my store, I was alarmed that the restore did not work correctly. I tried it a couple of times...nothing worked. Then, I right clicked on the .zip restore file (that I wanted to use to restore my site) and downloaded this .zip file so I could see what was in the .zip file. Yikes, found that the .zip file was corrupted. Al (the CubeCart Jedi master) found that the .zip file was corrupted as well. So, I went to my hosting provider's control panel and used the web-based file manager to download the .zip file manually. I double clicked on the .zip file and, bam!, I could see everything inside it. I forwarded the .zip file over to Al and he immediately got my site restored. Finally, all was good. But I still had the problem of lots of Custom SEO URLs that were gonna give me a headache when I tried to do my 400 item import again. So, I went into the table manually with myPHPadmin and manually deleted all of the Custom SEO URLs that I knew would give me grief because of the "duplicate" problem. After I got the Custom SEO URL table all cleaned up, the 400 item import worked perfectly.

@ bsmither Thanks very much for following up with me on this matter. What a day... I will reply tomorrow with an entry that describes what happened, what I learned, and how I got things fixed. Bottom line: for now, my site at http://XebraParts.com is back up and running.

First, I did a complete database and files backup through the 5.1.4 interface. My goal this morning was to add 400 new products to my store via Import Catalogue. Everything went fine, but I messed up and checked the "Replace Existing Inventory" checkbox. I was having trouble importing these 400 items because of "duplicate SEO entries." I got exactly 400 of these errors; the custom SEO for each of the 400 items was unique. So I deleted the previous import because of the SEO errors. The result was that I lost my ENTIRE product inventory. So, I think to myself, "I'm Good, I did a complete backup first." I went to the maintenance area and clicked on the icon to restore the database that I backed up earlier. Problem: no products show up in my inventory now (even after the restore). Any ideas?