Go Back   Webmaster Forums UK SEO SEM Webmaster Community Forum - UKWW > Webmaster Marketplace > Marketplace (all other buy/sell/wanted)
Register FAQ Members List Downloads Calendar Today's Posts Webmaster Resources Webmaster Blogs
 
 

Marketplace (all other buy/sell/wanted) Buy or Sell webmaster goods and services such as websites, links. You can also advertise or find SEO, content writing and Internet based jobs.
Sub Forums :: Jobs:: Links Market :: Other items for sale :: Freebies :: Content

Closed Thread
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-02-2008, 10:34 PM
OldWelshGuy's Avatar
Super Moderator
992 posts this year. Platinum VIP!
Trusted Member - This user is a Master!
Last months UKWW Tokens: 8
 
Join Date: Oct 2004
Posts: 2,272
Thanks: 2
Thanked 10 Times in 10 Posts
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
Default MYSQL help URGENT

I have a problem. We have built a zen cart store, we have uploaded the products 1300 of them. BUT the prices we were given have all changed!

So we are left with 1300 products all with the wrong prices.

The change is a % change and i am hoping that we can pull the database out, apply the % change, then put the database back, and all will be fine.

I am absolutely desperate for this as the deadline is friday, and while I can manage everything else, this is a big problem.

the most annoying part is that I only took it on as the guy was recommended to me by a really good client.

Any help here appreciated, I don't expect a freebie (unless someone feels like helping me LOL)
__________________
Umbrella Consultancy SEO WALES - Web Design Wales- Internet Marketing Consultancy - Google expert
Digg this Post!Add Post to del.icio.usStumble this Post!Wong this Post!
  #2 (permalink)  
Old 07-02-2008, 11:43 PM
DanielEZPZ's Avatar
Member
104 posts this year. Executive spud!
We have not managed to scare them away..
 
Join Date: Feb 2008
Posts: 92
Thanks: 0
Thanked 0 Times in 0 Posts
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
Default

Hey,

If you do an SQL dump of your products table, email it over to daniel -AT- ezpzhosting.co.uk with the percentage that the prices need changing by and i'll sort it out and email you back the SQL.
__________________
EZPZ Hosting.co.uk - Affordable and Reliable UK Web Hosting
Free Domain for Life - Hourly Backups - Fast UK Servers
Digg this Post!Add Post to del.icio.usStumble this Post!Wong this Post!
  #3 (permalink)  
Old 07-03-2008, 08:30 AM
bochgoch's Avatar
Senior Member
198 posts this year. Executive spud!
We have not managed to scare them away..
 
Join Date: May 2007
Posts: 366
Thanks: 0
Thanked 0 Times in 0 Posts
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
Default

I'll happily take a look if Daniel isn't able to sort you out ... PM me or post here & I'll check back tonight
__________________
Small but perfectly formed ~ Welsh Directory
Barn Conversion Advice
ahhhhh .... born shouting ... were you?
Digg this Post!Add Post to del.icio.usStumble this Post!Wong this Post!
  #4 (permalink)  
Old 07-03-2008, 08:46 PM
Senior Member
178 posts this year. Executive spud!
We have not managed to scare them away..
Last months UKWW Tokens: 3
 
Join Date: Feb 2007
Posts: 713
Thanks: 1
Thanked 2 Times in 1 Post
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
Default

Zen Carts Admin area is pretty powerfull, its a while since I used it, but cannot this task be done there?
Digg this Post!Add Post to del.icio.usStumble this Post!Wong this Post!
  #5 (permalink)  
Old 07-03-2008, 10:39 PM
bochgoch's Avatar
Senior Member
198 posts this year. Executive spud!
We have not managed to scare them away..
 
Join Date: May 2007
Posts: 366
Thanks: 0
Thanked 0 Times in 0 Posts
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
Default

All quiet - guess you sorted it out?
__________________
Small but perfectly formed ~ Welsh Directory
Barn Conversion Advice
ahhhhh .... born shouting ... were you?
Digg this Post!Add Post to del.icio.usStumble this Post!Wong this Post!
  #6 (permalink)  
Old 07-03-2008, 11:46 PM
DanielEZPZ's Avatar
Member
104 posts this year. Executive spud!
We have not managed to scare them away..
 
Join Date: Feb 2008
Posts: 92
Thanks: 0
Thanked 0 Times in 0 Posts
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
Default

Must have done, i've not had an email.
__________________
EZPZ Hosting.co.uk - Affordable and Reliable UK Web Hosting
Free Domain for Life - Hourly Backups - Fast UK Servers
Digg this Post!Add Post to del.icio.usStumble this Post!Wong this Post!
  #7 (permalink)  
Old 07-04-2008, 12:55 AM
OldWelshGuy's Avatar
Super Moderator
992 posts this year. Platinum VIP!
Trusted Member - This user is a Master!
Last months UKWW Tokens: 8
 
Join Date: Oct 2004
Posts: 2,272
Thanks: 2
Thanked 10 Times in 10 Posts
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
Default

Sorry guys, Thanks for the offers, but I don't know how to do an SQL dump, so i paid someone to do it for me

Appreciate the offers though.
__________________
Umbrella Consultancy SEO WALES - Web Design Wales- Internet Marketing Consultancy - Google expert
Digg this Post!Add Post to del.icio.usStumble this Post!Wong this Post!
  #8 (permalink)  
Old 07-04-2008, 04:15 AM
Junior Member
27 posts this year. i see smoke!
It looks like they have moved their luggage in.
Last months UKWW Tokens: 5
 
Join Date: Jun 2007
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
Default

Sorry to hear that you had to pay for that. it will be just an sql query like.
update column_name set (column_name*0.(your percentage)+colums_name) where rowid=:rowid
and that's it.
Digg this Post!Add Post to del.icio.usStumble this Post!Wong this Post!
  #9 (permalink)  
Old 07-30-2008, 07:18 PM
OldWelshGuy's Avatar
Super Moderator
992 posts this year. Platinum VIP!
Trusted Member - This user is a Master!
Last months UKWW Tokens: 8
 
Join Date: Oct 2004
Posts: 2,272
Thanks: 2
Thanked 10 Times in 10 Posts
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
Default

cost me $50
__________________
Umbrella Consultancy SEO WALES - Web Design Wales- Internet Marketing Consultancy - Google expert
Digg this Post!Add Post to del.icio.usStumble this Post!Wong this Post!
  #10 (permalink)  
Old 08-03-2008, 09:10 PM
Senior Member
178 posts this year. Executive spud!
We have not managed to scare them away..
Last months UKWW Tokens: 3
 
Join Date: Feb 2007
Posts: 713
Thanks: 1
Thanked 2 Times in 1 Post
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
Default

Quote:
Originally Posted by OldWelshGuy View Post
cost me $50
LOL...loose change for you I guess
Digg this Post!Add Post to del.icio.usStumble this Post!Wong this Post!
Closed Thread

Bookmarks



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Webmaster Resources
UK WW SEO Tools
Find UK Hosts
 
The Forum Rules
Forum Rules - MUST READ
 
Site Of the Month
BizzFace
Nominate site of the month
 
Tag Cloud
ad exchange audio ads bid bidding directory bid directory list bid for position business clothes dedicated servers delisted designer directory links wanted discount executive suites finance google handbags internet and marketing internet marketing iphone jewelry link exchange nokia n95 paid blogging phones electronics replica samsung sem seo seo company sunglasses teac cd recorder uk property writer wallets web web design web development website development website promotion wholesale yahoo backlink

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:22 PM.

UK Webmaster World Forums - Internet marketing, web development, domain names, SEO contest and discussuons.
Subscribe to our feeds   Subscribe to our feeds

Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0