30knees

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?

I found out today that when a customer visits "Home> My account>My vouchers", the customer can see ALL cart rules ever created that match the customer group. This does not seem right to me because it prevents any selective distribution of vouchers. For example, if I want a voucher to be valid for all customer groups, but I want to distribute it only to people on Facebook, this feature/bug prevents that. Not only will the intended recipients on Facebook see the voucher when I post it there on my Facebook page, any customer who visits their account and clicks on "My vouchers" will see it, regardless of whether they use Facebook or not. Is this a bug or a feature? If it is a feature, is there any way to prevent all vouchers from being shown in this way?

@alwayspaws But please note that it doesn't properly delete the orders (and I think also not the stock - did you check whether it replenishes the stock?). See this post: https://forum.thirtybees.com/topic/793/suggestion-delete-orders-directly-in-the-backend

I am revisiting this question. I got some spam orders from people who apparently just wanted to test the order process and entered nonsense names and addresses. What is the best way to delete such orders AND restock the products? This is such a basic functionality. I do not understand how it is not in the system.

This is an interesting discussion. I think it's difficult for the people behind thirty bees to please everyone. I know I've been annoyed a couple of times in discussions about the project and features / changes I think are important, but I'm not the driver behind the project and I try not to get dissuaded from contributing. I think the most important thing to keep the community and contribution spirit alive is to explain carefully why one rejects a contribution, a suggestion, etc. No serious effort to improve the project should be rejected without an explanation. Also, I don't think it is good when people like @eleazar leave the project because of some dispute and where, at least to an outsider, it doesn't seem like there's much of an effort to keep him or try to rectify a misunderstanding. Finally, while I think Patreon is a brilliant idea, I would rather spend my money on developing modules I think are useful, or even core changes, and have them become an open source part of the project. I hope that thirty bees is open to this approach.

That would be a great module. Good find!

Yes - I am a strong believer in adapting data protection law so that usability does not suffer. It's definitely possible. Great post, @Traumflug.