vampira

Thank you for the reply! I know that your interest is that I'll buy the module , but would the SQL query: UPDATE ps_customer SET id_default_group = '3' WHERE is_guest =0; be correct, if the aim is to get all the customer accounts, who are not guests, into the Customer Group 3? Edit: Or there should probably be another field, as manually I do change two fields: Group Access and Default customer group...

Found an answer myself. The table is ps_customer and the field I was looking for is is_guest.

I do not want to track the visitors but want to filter out the customers who have created an account. Background: Due to a f***-up the default Customer Grouping had been incorrectly set up. And because of that, the registered customers did not end up in the Customer group, but as Guests/Visitors. As I have now applied a discount % for the Customer Group, the persons who have an account should receive an automatic price drop, but as the system has assigned them to the wrong group, the discount is not applied. So I'm looking for a SQL query, with which I can get the full list of registered account owners, so I can correct the issue. I know that I can go through all the customer profiles one by one, but I was hoping that I can at least get the necessary information with less labour. I'm aware that the group assignment correction will most likely have to be done manually.

How should I put together an SQL query if I want to know which customers have an account? I'm not interested in which group the customer is in, but I need the info if they have a customer account or not.

Figured it out. During the migration, the automatic group assigment had been messed up. Need to find a way to correct this, but it is another topic :). Thanks for your input!

And back to unresolved :(. Why do some of the Guest accounts have Group 3 and others have Group 1 id number in the ps_customer table column id_default_group? It's really confusing :(. Is there any other way I could get the correct information if this email has been used for creating a customer account or not? In the customer profile I can see the difference (see the screenshots), but it is not possible to go through all the customers manually. Not to mention that the customers actually are doubled or tripled or even more times accounted for due to the Prestashop illogic.

Thank you for the answer! I now ran a SQL query to get the id_default_group from the ps_customer table and with this I understood to which group I must assign the discount to. It was Group 3 (whatever the original name was, I now changed it to Loyal Customer).

I would like to activate an automatic 5% discount for all logged in customers. The shop itself is 10+ years old, has been updated/migrated from 1.3->1.6->1.7.8 and therefore has the Customer Groups Default/Guest/Visitor. I know that now it is Visitor/Guest/Customer, but I have not figured out how the old classification corresponds to that. As I'm not sure to which of these groups should I add the 5% discount (I tried the default one, but it gives a discount to a guest user as well), the easiest way would probably be to create a new group and assign the discount there? But for that, I need to get info about which customers actually have an account, so I can add only them to this group. If the info is relevant, then one-page check-out is not possible due to the theme.

Thank you, it worked!

Hello! Shop runs on PS 1.7.8.8., purchased theme. Today morning, when I was trying to access the login page for BO, I got error 500: This page isn’t working domain.com is currently unable to handle this request. HTTP ERROR 500 I opened config/defines.inc.php file, looked up: define('_PS_MODE_DEV_', false); and replaced it with: define('_PS_MODE_DEV_', true); and got this info: Whoops, looks like something went wrong. (1/1) IOException A temporary file could not be created. in Filesystem.php line 637 at Filesystem->tempnam('/shop/var/cache/dev', 'appDevDebugProjectContainer.xml')in Filesystem.php line 685 at Filesystem->dumpFile('/shop/var/cache/dev/appDevDebugProjectContainer.xml', '<?xml version="1.0" encoding="utf-8"?><container xmlns="http://symfony.com/schema/dic/services" x ...................... gazillion lines............................................. ="tactician.command.debug" public="true"/> </services></container>')in ResourceCheckerConfigCache.php line 124 at ResourceCheckerConfigCache->write('<?xml version="1.0" encoding="utf-8"?><container xmlns="http://symfony.com/schema/dic/services" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://symfony.com/schema/dic/services https://symfony.com/schema/dic/services/services- ...................... gazillion lines............................................. object(ReflectionClassResource)))in ContainerBuilderDebugDumpPass.php line 32 at ContainerBuilderDebugDumpPass->process(object(ContainerBuilder))in Compiler.php line 140 at Compiler->compile(object(ContainerBuilder))in ContainerBuilder.php line 789 at ContainerBuilder->compile()in Kernel.php line 643 at Kernel->initializeContainer()in Kernel.php line 135 at Kernel->boot()in Kernel.php line 195 at Kernel->handle(object(Request), 1, false)in index.php line 82 Front end is working apparently. What should I do, so I could access BO again?

Anyone had experience with this?

Help needed - my e-shop has been running on single language until now. No problems, all works just fine. As I want to enable a second language, a problem has occurred. Once enabled, the language selector comes visible in the shop, but the index page (now with language extension) has been replaced with 'page not found' message. I have tried to solve this by changing disable Apache's MultiViews option to yes, disabling and enabling friendly url's, clearing cache - so the htaccess will be rewritten, but no avail. The only time the new index page seems to work is when friendly url's are disabled, but I would very much prefer to have those. Any recommendations on how to solve this issue?

Having the same problem with the vp_beststore theme. I tried to use the solution on the linked topic, but for some reason I even cannot find a line with body#category #subcategories li { margin-right:10px; } to start editing it. Tried also to look in other .css files, but still now luck. Any ideas? Thanks in advance!