BTutt

I seems there will be no help on this problem. It is very disappointing to wait months without an answer. My clients think it is my fault. They want to switch shopping carts to some other cart. I lost one that moved to a different company because they wouldn't wait for a solution. So, at this point, I am sorry to say that I am going to investigate switching all my web dev. to another platform.

No one has an answer to this?

Free shipping is now showing up in the cart no matter what. I have altered translations in front office to show $0.00 instead, but free shipping continues to appear in the drop down cart and pop-up cart. Under shipping/preferences I set free shipping to 0 to disable it, but still free shipping appears. Does anyone have a clue as to how to fix this? I don't want to change a template, because the next update will negate the edited template. Thank you for your help.

I listed my fix above and it seems to have worked - the cart is functioning well. Your tables might be different, so be careful what you modify. That seemed to do the trick for me. I also updated to the latest PS in hopes that this bug was fixed. I don't know if what I did affects anything else, but it worked for me.

I attached a screen shot of one of the unrelated categories (see roque-category.jpg). I have searched through the categories and cant find it listed in the back office. So, I did a SQL query: select * from ps_category where id_category = 1843 It looks like it exists but doesn't show up in the category lists. I manually looked at the category table and there it was. I reported this as a bug, but have heard nothing back. I believe the cause was a bug in PS 1.6.0.1 that didn't delete categories properly, but that is just my best guess. I had added categories via CSV import using PS 1.6. Some of the categories I deleted. Finding this issue, I upgraded to 1.6.1 hoping that would fix the problem. It did not. Doing a manual search I found 22 categories that were in the category table that were not showing up in the back office. I am guessing there are more. So, I manually disabled these rogue categories by setting the active number from 1 to 0. That seems to have worked - so far. The rogue categories do not show up in the breadcrumb navigation and the disabling of them doesn't seem to have hurt all the work I have done. Since I don't know how PS works with the tables, I'm just trying to fix this by trial and error. I would delete them, but I am not sure if they are tied into other tables in the database. Does anyone know of a SQL query that will find all the categories that are not showing up in the BO? How about a SQL query or fix to delete these rogue categories safely without damaging the work I have done?

It seems the issue was not updating a product with an existing ID. The problem was my HTML code in the CSV file. I was using HTML in the descriptions. Some of the HTML had quotations. I changed those to single quotes and that seemed to solve the issue. So, you can update a product using ID if you select "force ID". Just be careful when using Quotes. Example: <a href="somelinkhere.html">The quotations messed this up</a> <a href='somelinkhere.htm'>Using single quote seemed to correct the issue.</a>

P.S. 1.6.1.1 The breadcrumb navigation (I believe that is what it is called) is not working properly. Here is an example of what the navigation should look like: This is the incorrect navigation generated when visiting the category: I can not find any issue in the categories. This error also happens when clicking on products. For some reason an odd insert is placed into the navigation. Does anyone know why? Is this a bug that I should report? I did create categories via CSV import. Some categories I deleted.

Thank you for the tip. I can try that, but I have been using ID when managing products because product combinations are applied based on product ID. There are thousands of products and all of them have tons of combinations. Categories can be easily updated using ID. Everything else seems to be tied into ID.

I have tried to import a product CSV file to update some existing products. If the ID exists (product already in PS), the CSV will not import for those items. This is a major headache. I don't want to keep creating new products every time I need to update a product. I also do not want to have to delete products before I import a revised product CSV. Does anyone have a solution?

More errors and issues with 500 errors... But I solved the problem. Symptoms: When importing a bunch of combinations in a CSV file the server was throwing a 500 Internal Server error. The cart was failing to process the combinations. Sometimes it was a complete failure, and occasionally it was only updating a few products. I looked at the web server logs and found that the issue was my request was timing out. The logs in my case were located here: /usr/local/apache/logs/error_log Here is the solution to 500 Server errors if you have access to your server using WHM: Via WHM C-Panel Navigate to Home » Service Configuration » Apache Configuration » Global Configuration Under Timeout set it to a higher rate. 300 was the default (5 minutes). I set a new timeout to 7200 (120 minutes). You may need more if you are uploading a lot of items in a CSV file. Via WHM navigate to Home » Service Configuration » PHP Configuration Editor Under max_execution_time set it to a higher rate. 30 was the default. I set a new time of 7200. I also tweaked the memory limit because I wanted to see if better performance would be key to good results. Under memory_limit I raised that value to 1024M (1G). I have 8G of ram so I thought I would have plenty of ram to do that. You may not have that much available. Looking at the server ram during a CSV import I noticed that the server was using about 1.3 G of memory. I do have multiple sites on the server, so some of that ram was being used elsewhere. I am guessing this helped the process, though. I hope this information helps anyone having CSV import problems. If anyone notices an issue with my recommendations, please suggest a better way.

PS Ver. 1.6.0.14 If you get a server 500 error - don't give up. Read on... I was doing a CSV import for product combinations of about 2,200 lines in a CSV file. After a few minutes I get a 500 server error. I was bummed... I took a look at my products to see what products were updated and which products failed. I noticed some had not been updated. As I continued to investigate, to my surprise, it appears the combination additions are still taking place after the 500 server error. More and more of my products are being updated AFTER the 500 error. Even 20 minutes later the additions are still happening! Hopefully all the products receive the new combinations. So, if you have a 500 error when importing a CSV, check for updates after you get your 500 error. There must be a bug in the import and it is taking way too long. I am thankful the bug is in my favor.

Awesome gabdara! Thank you for the reply. That appears it will do what I need - Add the custom "Members" group to the groups on each category that currently exists. However, I was hoping there was a way to add a new custom group to the default groups so that I do not have to keep checking the check box for every entry added to the shopping cart. The query would work, but I still have many categories to add and then hundreds of products. Clicking a check box on each item is kind of silly. I wish I knew how the default groups were set so that I could just add the new group to the defaults. I believe that solution would automatically check the box and all categories and products would be available to the new group. At least that is what I would expect to happen if I could add it to the default groups. Otherwise, I will have to do a SQL insert every time I add products and/or categories. By the way, I am not knocking your solution at all and I greatly appreciate your help. I import CSV files (products and categories) and I don't see a column for groups. Any other ideas?

I have created a custom group (for pricing purposes). I have thousands or products and hundreds of categories. Is there a fast way to set this group access on every product and every category without having to click the check box on each item? The image shows the painful way of clicking a check box in every category and product. I hope to avoid the manual click on all these items. Any ideas?

I was hoping it might be as easy as writing some PHP code into the PS product creation page when I create the product, but I guess that would make life way too easy.

Using PS version 1.6 I know you can manually assign a customer to a group. I am looking to automate the process. Here is the situation: The site wants to sell a product called "Membership". When the membership is purchased the buyer receives a discount on new purchases. Is there an existing module or a way to add code to a specific product so that the buyer is assigned to the group "Members" upon purchasing membership? Thank you for your help.