Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 11834
Latest: Volker S
New This Month: 1
New This Week: 1
New Today: 0
Stats
Total Posts: 42319
Total Topics: 7381
Most Online Today: 219
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 40
Total: 41

Author Topic: Email Note - Included in order purchase  (Read 520 times)

0 Members and 1 Guest are viewing this topic.

Offline Shades

  • Community Suite Customer
  • Full Member
  • ******
  • Posts: 185
  • Community Suite Customer
    • View Profile
    • Bikerhound.com
Email Note - Included in order purchase
« 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!

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16045
    • View Profile
Re: Email Note - Included in order purchase
« Reply #1 on: August 30, 2021, 06:33:27 pm »
Yes
UPDATE smf_store_item SET emailnote = "note goes here";
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Shades

  • Community Suite Customer
  • Full Member
  • ******
  • Posts: 185
  • Community Suite Customer
    • View Profile
    • Bikerhound.com
Re: Email Note - Included in order purchase
« Reply #2 on: August 30, 2021, 06:46:10 pm »
Thank you Thank you Thank you!
That just saved me hours of editing! 8)

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Offline Shades

  • Community Suite Customer
  • Full Member
  • ******
  • Posts: 185
  • Community Suite Customer
    • View Profile
    • Bikerhound.com
Re: Email Note - Included in order purchase
« Reply #3 on: August 30, 2021, 06:48:10 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"; ?
« Last Edit: August 30, 2021, 06:50:05 pm by Shades »

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16045
    • View Profile
Re: Email Note - Included in order purchase
« Reply #4 on: August 30, 2021, 07:13:08 pm »
Yes you can.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Shades

  • Community Suite Customer
  • Full Member
  • ******
  • Posts: 185
  • Community Suite Customer
    • View Profile
    • Bikerhound.com
Re: Email Note - Included in order purchase
« Reply #5 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?

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16045
    • View Profile
Re: Email Note - Included in order purchase
« Reply #6 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")
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/
Like Like x 1 View List

Offline Shades

  • Community Suite Customer
  • Full Member
  • ******
  • Posts: 185
  • Community Suite Customer
    • View Profile
    • Bikerhound.com
Re: Email Note - Included in order purchase
« Reply #7 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

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
5950 Views
Last post October 05, 2006, 01:12:17 am
by Nite
0 Replies
2859 Views
Last post January 22, 2014, 11:26:51 am
by dan4ever
20 Replies
7166 Views
Last post October 02, 2017, 03:00:50 pm
by Michael Vail
5 Replies
2252 Views
Last post November 15, 2017, 05:29:15 pm
by SMFHacks
8 Replies
2159 Views
Last post December 08, 2017, 12:39:47 am
by KKOG

+- Recent Topics

Profile Gallery Link by Hatshepsut
July 04, 2022, 11:00:01 pm

Trying to access array offset on value of type null by SMFHacks
July 04, 2022, 08:14:20 pm

Pictures appearing in post by SMFHacks
July 04, 2022, 12:56:40 pm

Error When Uploading Gifs To Subcategories by SMFHacks
July 03, 2022, 05:50:19 pm

SMF forum by davejo
June 27, 2022, 01:16:25 am

Quick-moderation checkboxes by davejo
June 22, 2022, 09:27:24 am

Add option to Main Menu bar by Shades
June 21, 2022, 12:23:00 am

Logo and Category? by SMFHacks
June 12, 2022, 03:43:31 pm

prettyurls - TroubleShooting.wiki by GhostHunting
June 12, 2022, 02:52:57 pm

[Mod]Modification Update Version Checker by SMFHacks
June 06, 2022, 09:25:39 pm

Powered by EzPortal