Results 1 to 5 of 5

Thread: Best way to Mass Edit Listings?

  1. #1
    Join Date
    Jan 2008
    Posts
    160

    Default Best way to Mass Edit Listings?

    Hello all ORer's :-)

    I am undergoing upgrades to our OR site; part of it is going to involve editing approx. 1,000 listings to fit the upgraded site criteria.

    Basically, is there any way other than 1 by 1 where I can (or better yet multiple people can) edit listings? Mass edit?

    Any recommendations let me know please thanks!
    Discount Land For Sale.com - List Your Land For Free

    This is my open-realty site, input is always greatly appreciated!

  2. #2
    Join Date
    Jul 2003
    Location
    California
    Age
    43
    Posts
    4,229

    Default Re: Best way to Mass Edit Listings?

    What can/needs to be done will really depend on what changes you have to make. Any agent with permissions to edit other people's users can edit all the listings to help make shorter time of the work. Ultimately, a custom SQL statement ran against your database to update all of your listing data with new criteria would be the fastest way but would require knowledge of mySQL and OR's database structure in order to do it.

    Something simple like changing all the state fields from California to CA would be a really simple SQL statement and would save a ton of time. If it is really involved then SQL statement may not be the best bet depending on your knowledge level.
    Open-Realty 2 Documentation

    ~The Difference Between an ORDEAL and an ADVENTURE is ATTITUDE~

  3. #3
    Join Date
    Jan 2008
    Posts
    160

    Default Re: Best way to Mass Edit Listings?

    Quote Originally Posted by Mick View Post
    What can/needs to be done will really depend on what changes you have to make. Any agent with permissions to edit other people's users can edit all the listings to help make shorter time of the work. Ultimately, a custom SQL statement ran against your database to update all of your listing data with new criteria would be the fastest way but would require knowledge of mySQL and OR's database structure in order to do it.

    Something simple like changing all the state fields from California to CA would be a really simple SQL statement and would save a ton of time. If it is really involved then SQL statement may not be the best bet depending on your knowledge level.
    Can you help out with just an example of updating all state fields from CA to California?

    Maybe I can get hang of it for other fields, hopefully (eh its always worth a try on the test site lol)
    Discount Land For Sale.com - List Your Land For Free

    This is my open-realty site, input is always greatly appreciated!

  4. #4
    Join Date
    Feb 2004
    Posts
    1,085

    Default Re: Best way to Mass Edit Listings?

    greg it really depends on what your field name is and also the table name but here is an example
    using phpmyadmin this may help, do a search for at least 1 listing then make the update to that listing, the php my admin may provide you something like:

    UPDATE default_en_listingsdbelements SET listingsdbelements_field VALUE 'California' WHERE listingsdbelements_field_name = 'state' AND listingsdbelements_field_value = 'CA';

  5. #5
    Join Date
    Jul 2003
    Location
    California
    Age
    43
    Posts
    4,229

    Default Re: Best way to Mass Edit Listings?

    Sorry, went to work after my post but Al is spot on. You can adjust that statement to suit just about any listing field you need it to. However, this will be limited to existing fields. If you are looking to add fields to every listing then this statement won't work and things will get a bit more complicated.
    Open-Realty 2 Documentation

    ~The Difference Between an ORDEAL and an ADVENTURE is ATTITUDE~

Similar Threads

  1. Mass Mailer addon
    By nycbrokerfreedotcom in forum Addon help, ideas and discussion (CLOSED)
    Replies: 8
    Last Post: 02-20-2011, 10:08 AM
  2. Date, MK Time and mass adding by One Year
    By igoouk in forum General Help (CLOSED)
    Replies: 0
    Last Post: 01-08-2009, 11:44 AM
  3. Mass Mail to Agents
    By raebaca in forum Addon help, ideas and discussion (CLOSED)
    Replies: 2
    Last Post: 09-20-2005, 12:49 AM
  4. Mass field update
    By bluma in forum HELP (CLOSED)
    Replies: 0
    Last Post: 07-03-2004, 01:43 AM
  5. Mass loading of images ?
    By Denver Dave in forum Feature Request (CLOSED)
    Replies: 4
    Last Post: 07-12-2003, 06:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •