30knees

I've been talking to Cloudways support and they say they only support one set of MySQL access credentials. So, unlike for SFTP, I can't give each developer unique access credentials. Is this the same with other hosting providers? If so, how do you deal with the security implications? Do you change the MySQL credentials manually regularly?

OK, I'll keep an eye on it and report if it happens again.

@basix101 Yes, the module works. I didn't fully set it up yet, but my tests were positive.

Haha, but two different customers, two distinct orders :) So it can't be that.

Hi @Daresh, I'm not sure whether this is your module, which I am using, or something with the shop, but I got two orders that have the same reference number. The order IDs are 377 and 378 and the reference numbers are each XX377. Any ideas hows to troubleshoot?

Same problem: New messages and Pending messages.

I'd just like to re-state how fantastic @datakick's customer support is. The tool is also incredibly powerful. You can use it as a bulk editing, too, too. It's highly recommended. One of the few exceptionally well-done modules out there.

@mockob There are some things that need to be addressed by the software, but nothing major. Of more hassle are the organisational measures needed, such as Data Processing Agreements with all parties who can touch your customer data, etc.

@mockob "Which law you think we have to comply with, keeping financial history or delete user data? I believe the greedy lawyers in Germany are eager to launch lawsuits against merchants because they perfectly know we don’t have the answer to that question." It is crystal clear for anyone who has a basic understanding of data protection law and law in general that there is absolutely no conflict here that needs to be resolved. It’s about deleting data that is a) no longer subject to a legal obligation to be kept or b) no longer required for the purposes for which it was originally collected. Any data required for tax purposes falls outside the scope of the right to be forgotten ... until the legal retention period has expired.

I'd like to piggy back on this thread, as I'd have the same thread title. I would like to change the subject of an order status email. I get the same "No Subject was found for bankwire in the database" error when I click the order status to translate. I have it in my themes/theme/mails/language folder. Where can I change the order status? I am assuming I can change the name of the order status in Orders>Statuses, but I'd like to keep that one shorter/different (for usability purposes in the backend) than in the email subject.

I think there is a misunderstanding. The "All groups" bit allows only one customer group to be selected. But you might want to exclude one customer group, so multiple groups are included in the specific price. This is currently not possible and requires that you create specific prices for each group separately except for the one group that shouldn't receive a specific price.

Specific prices can be restricted to certain customer groups, but it's either that all customer groups are included or only one customer group that is included. One cannot select multiple customer groups that are not all customer groups. That means that if one wants to use a specific price for 3 out of 4 customer groups, one needs to create 3 separate specific prices for each of the 3 customer groups. A more efficient solution would be to be able to select multiple customer groups at once, either positively (to include) or negatively (to exclude).

Ich verwende dafür: https://addons.prestashop.com/en/sizes-units/5756-basicprice-unit-price.html

Brilliant! Tested and it works!

Awesome, tested and it works!

Brilliant! Thank you so much for sharing.

This is the error thrown by the first issue: Unknown column 'cp.idproductattrbute' in 'on clause' SELECT cp.`quantity`, cp.`id_product`, pac.`id_attribute`, cp.`id_product_attribute` FROM `tb_cart_product` cp LEFT JOIN `tb_product_attribute_combination` `pac` ON cp.`id_product_attrbute` = pac.`id_product_attribute` WHERE (cp.`id_cart` = 481) AND (cp.`id_product` IN (70,57,41)) AND (cp.`id_product_attribute` > 0)

When I use a customer group restriction the voucher fails. A friend took a look at the error and he thinks the problem is: SELECT crg.id_cart_rule FROM tb_cart_rule_group crg WHERE (crg.id_cart_rule = 7) AND (crg.id_group = = 1) LIMIT 1 –> the = 7 should probably be = = 7 I couldn't find where this code would be to test, though.

OK, so it looks like there are two separate issues here: There is the originally reported issue of the first post. Then there is an error that vouchers weren't working because of conditions a customer group selection. A friend took a look at the customer group error and he thinks the problem is: SELECT crg.id_cart_rule FROM tb_cart_rule_group crg WHERE (crg.id_cart_rule = 7) AND (crg.id_group = = 1) LIMIT 1 --> the = 7 should probably be = = 7 See https://forum.thirtybees.com/topic/1161/cart-rules-vouchers-customer-group-restrictions-throw-an-error

[Edited due to different issues popping up and confusing the tread]

@baarssen Aha! So Mailchimp can also take different order statuses and user types and email according to that? I didn't know. That is indeed interesting.

OK, but that's a problem for people who don't have a github repo/don't know how to use it. What about having a sub-section of the modules forum "Free modules for download" or letting people upload directly to the main modules forum (with some guidelines on how to name posts to keep a good overview of what's available)?

@lesley Thank you for explaining. By the way, have you thought about a streamlined process to get modules users like me would like to contribute into the repository?

[Title and content edited after seeing different issues pop up and trying to separate them] I created a cart rule with a product needing to match these conditions: A certain attribute A certain product All customer groups It has the action of applying the discount to the product of the attribute. It gives me this error: Unknown column ‘cp.idproductattrbute’ in ‘on clause’ SELECT cp.`quantity`, cp.`id_product`, pac.`id_attribute`, cp.`id_product_attribute` FROM `tb_cart_product` cp LEFT JOIN `tb_product_attribute_combination` `pac` ON cp.`id_product_attrbute` = pac.`id_product_attribute` WHERE (cp.`id_cart` = 481) AND (cp.`id_product` IN (70,57,41)) AND (cp.`id_product_attribute` > 0)

@wakabayashi Ah, so canceling the order restocks the product. Super! But the module you linked to does not clean the database properly, does it?