Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Location
    California
    Posts
    663
    Plugin Contributions
    0

    help question Is this is the correct SQL statement for setting products to 'call for price'?

    I really don't know SQL so I would appreciate it if someone can confirm whether the following is the correct SQL statement (not sure if that's what you call it) to set a product to 'call for price'

    UPDATE products SET product_is_call = 1 WHERE products_model = 'XXXXX' LIMIT 1;

    I have run a test and it seems to work, but I would like someone to confirm that I'm not doing anything wrong.

    I have a couple hundred products that I need to set to 'call for price' and it would be a lot easier to run the statements rather than updating each product manually one by one.

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Is this is the correct SQL statement for setting products to 'call for price'?

    That should do it for you ...

    Be sure to backup your database first ... and periodically during your updating make additional backups in case you moof up ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: Is this is the correct SQL statement for setting products to 'call for price'?

    if your doing ALL of your products then you could just use

    UPDATE products SET product_is_call = 1
    Zen cart PCI compliant Hosting

 

 

Similar Threads

  1. What's the correct setting for these 2 lines?
    By joejoejoe in forum Basic Configuration
    Replies: 5
    Last Post: 29 Oct 2011, 06:46 PM
  2. Disable Call for price url below Call for price image?
    By IllusionGuy in forum General Questions
    Replies: 0
    Last Post: 6 Jan 2009, 10:36 PM
  3. changing link for Call for Price products
    By earmsby in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 31 Jul 2008, 07:05 PM
  4. Is this the correct for for entering product weight?
    By shamis in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 24 Apr 2008, 04:55 PM
  5. This is the main define statement for the page for english when no template defined f
    By ginginca in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 10 Nov 2006, 08:15 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR