Vendor Prices menu

User Tag List

Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Stryder302's Avatar Member
    Reputation
    1
    Join Date
    Dec 2007
    Posts
    20
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Vendor Prices

    I see a ton of threads about vendor prices, but I still haven't seen a direct answer. Does anyone know a way to edit all items on a vendor, instead of doing each item individually? This would take hours on end to edit every single item in our mall. If anyone knows how to do this it would be greatly appreciated.

    Vendor Prices
  2. #2
    Ukrajinc's Avatar Member
    Reputation
    8
    Join Date
    Aug 2007
    Posts
    200
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    well the easyest way i could find is ADE - Ascent database editor.That way you can lookup an item and change the price manually.Its faster than doing them in navicat

  3. #3
    *TraPStaR*'s Avatar Contributor
    Reputation
    164
    Join Date
    Aug 2007
    Posts
    275
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i know how

  4. #4
    Stryder302's Avatar Member
    Reputation
    1
    Join Date
    Dec 2007
    Posts
    20
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well Kard do you care to share? We figured we would have to look up every item manually, that is what we were trying to avoid. Are there any other ways to say redo every item on the vendor to be a set price by only doing one thing to the vendor?

  5. #5
    Illidan1's Avatar Banned
    Reputation
    244
    Join Date
    Jul 2007
    Posts
    2,251
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There is an SQL Format that would add a Price to every item in game, that would eb the Fast way
    But if you Wont Tier 1 to be 100g and Tier 6 to be a 1000g you would have to do it
    Manuel

  6. #6
    Spartansp's Avatar Member
    Reputation
    644
    Join Date
    Sep 2007
    Posts
    1,803
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yes it has to do manually just go to your items table and search for the items you want to change their selling price go to the columns that says buying price and selling price and change those with the value you want just remember that the value is in copper so 10000 copper is 1 gold so just add 0's to do it easier like 1000000---> 100gold etc hope it helped you

  7. #7
    Illidan1's Avatar Banned
    Reputation
    244
    Join Date
    Jul 2007
    Posts
    2,251
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    He will have to do that for over 15'000 Items, because that is how much
    Items there are in the Vendors

  8. #8
    toxic11b's Avatar Active Member
    Reputation
    21
    Join Date
    Nov 2007
    Posts
    27
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Run this in query and it should help you . This will set the buy price , sell price and item extended cost to 0 . Hope this is what your looking for and helps.

    Code:
    update items set buyprice = 0 , sellprice = 0, itemextendedcost = 0;
    Last edited by toxic11b; 12-18-2007 at 11:32 AM.

  9. #9
    Illidan1's Avatar Banned
    Reputation
    244
    Join Date
    Jul 2007
    Posts
    2,251
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    He wonts it so it Cost money to buy the Items

    So try this SQL, it will make the Items sell for 10g each, and Sells for 10g To

    update items set buyprice = 100000 , sellprice = 100000, itemextendedcost = 0;
    Last edited by Illidan1; 12-18-2007 at 12:40 PM.

  10. #10
    toxic11b's Avatar Active Member
    Reputation
    21
    Join Date
    Nov 2007
    Posts
    27
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    OO im sorry , I thought he was trying to delete them =*(

  11. #11
    Spartansp's Avatar Member
    Reputation
    644
    Join Date
    Sep 2007
    Posts
    1,803
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    let me make a little correction for the items to cost 10 gold its not 10000 as illidan says the correct number for ten is 100000 that number is equal to 10 gold

  12. #12
    Illidan1's Avatar Banned
    Reputation
    244
    Join Date
    Jul 2007
    Posts
    2,251
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Spartansp, I'm a little Tired, haven't had a slepp in 17 hours, but i had a 2 day sleep before that lol

  13. #13
    Spartansp's Avatar Member
    Reputation
    644
    Join Date
    Sep 2007
    Posts
    1,803
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    lol dont worry we are here to help

  14. #14
    Stryder302's Avatar Member
    Reputation
    1
    Join Date
    Dec 2007
    Posts
    20
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    So I guess there is just no way to edit the venors entire shop full of items. That is a shame though because like he said there is probably 10k items. Thats a hell of a lot of editing. I dont want everything to be one prices. I want some stuff to be 5 some 10 some 100 and so on...

  15. #15
    Steph's Avatar Member
    Reputation
    166
    Join Date
    Dec 2007
    Posts
    695
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by toxic11b View Post
    Run this in query and it should help you . This will set the buy price , sell price and item extended cost to 0 . Hope this is what your looking for and helps.

    Code:
    update items set buyprice = 0 , sellprice = 0, itemextendedcost = 0;
    Oh my god! I was just playing a server where everything was pretty much, free, I wondered how they did it!

    +rep!
    Last edited by Steph; 12-18-2007 at 05:40 PM.

Page 1 of 2 12 LastLast

Similar Threads

  1. [Buying] Buy Eu/US wow gold ! TOP Market Price ! Great Vendor ! Instant + on-demand payment !
    By ignariss in forum World of Warcraft Buy Sell Trade
    Replies: 23
    Last Post: 01-23-2015, 04:44 AM
  2. [Buying] Buy Eu/US wow gold ! TOP Market Price ! Great Vendor ! Instant + on-demand payment !
    By ignariss in forum World of Warcraft Buy Sell Trade
    Replies: 3
    Last Post: 01-17-2015, 09:18 AM
  3. Help Reducing Vendor Prices in Hero Editor
    By lex666 in forum Diablo 2
    Replies: 0
    Last Post: 02-06-2014, 11:47 PM
  4. Addon to buy auctions that are posted lower than vendor sell price
    By Vitani in forum World of Warcraft General
    Replies: 3
    Last Post: 10-01-2012, 06:55 PM
  5. [ArcEmu] How To Change/Remove Price from Vendor Items?
    By Astonix in forum WoW EMU Questions & Requests
    Replies: 2
    Last Post: 06-27-2010, 08:40 AM
All times are GMT -5. The time now is 08:41 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search