SMFHacks.com

SMF Store => Support => Topic started by: Shades on August 30, 2021, 06:30:20 pm

Title: Email Note - Included in order purchase
Post by: Shades on August 30, 2021, 06:30:20 pm

The Email Note - Included in order purchase...is there a way to edit that globally like in phpadmin? I need them all to say the same thing for all products but I don't want to have to go into each item to edit cause that will take forever!

Title: Re: Email Note - Included in order purchase
Post by: SMFHacks on August 30, 2021, 06:33:27 pm

Yes
UPDATE smf_store_item SET emailnote = "note goes here";

Title: Re: Email Note - Included in order purchase
Post by: Shades on August 30, 2021, 06:46:10 pm

Thank you Thank you Thank you!
That just saved me hours of editing! 8)

Title: Re: Email Note - Included in order purchase
Post by: Shades on August 30, 2021, 06:48:10 pm

Quote from: SMFHacks on August 30, 2021, 06:33:27 pm

Yes
UPDATE smf_store_item SET emailnote = "note goes here";

So I could ultimately do that for any one of the fields in phpadmin? Like if I wanted to change the price of all to the same?

UPDATE smf_store_item SET price = "30.00"; ?

Title: Re: Email Note - Included in order purchase
Post by: SMFHacks on August 30, 2021, 07:13:08 pm

Yes you can.

Title: Re: Email Note - Included in order purchase
Post by: Shades on May 18, 2022, 02:17:19 pm

Is there a way to globally change certain phrases or words in the description without changing the whole description in phpadmin?

Title: Re: Email Note - Included in order purchase
Post by: SMFHacks on May 18, 2022, 02:33:21 pm

yes https://www.w3resource.com/mysql/string-functions/mysql-replace-function.php

update tablename set columnname = REPLACE(columnname, "find_string", "replace_with")

Title: Re: Email Note - Included in order purchase
Post by: Shades on May 18, 2022, 02:54:54 pm

Thanks, I will give that a go on my test site because I'm sure I'll screw something up! :o  ;D