Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2013
    Posts
    8
    Plugin Contributions
    0

    Default Updating product price by MySQL gives copy of product

    Hi all,

    I am using Zen Cart 1.5.1, I installed myself via SFTP upload and then configuration. My host uses PHPMyAdmin to access the database, which is how I am checking if my stuff is working.

    I've looked through the forums and can't find anything relevant.

    I am using a program (irobotsoft.com MySQL version) that scrapes data and uploads to my MySQL database by SSH tunnel.

    It sort of works when I have it updating the prices on my products, except all I had it updating was the products_price and products_price_sorter fields. What is does is create a new product field with only the products_price field and products_price_sorter values filled, everything else NULL or blank.

    So I thought, ok, I will just tell it to update the product I want, so I have it updating products_id with the id I want to update as well as the price fields, and nothing changes when I run it then.

    Is the problem with the program I am using or with MySQL or zen cart? Is there a feature I can tick to allow it to "hot update" the products prices?

    Thanks.

  2. #2
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,167
    Plugin Contributions
    7

    Default Re: Updating product price by MySQL gives copy of product

    Sounds to me like that the program you are using is performing INSERTS rather than UPDATES.

    Should be quite easy to fix/modify. The main problem (which won't be a problem with your usage) is that UPDATE commands can only work with *existing* records. If you try to UPDATE a non existent record mySQL outputs a server error message.

    Cheers
    Rod

  3. #3
    Join Date
    Apr 2013
    Posts
    8
    Plugin Contributions
    0

    Default Re: Updating product price by MySQL gives copy of product

    Thanks Rod! I think you are right, I will look into it!

 

 

Similar Threads

  1. v138a Updating product properties and price via spreadsheets or modules
    By websitecurious in forum General Questions
    Replies: 2
    Last Post: 14 Feb 2013, 03:01 AM
  2. copy linked-product multiple category info to another product
    By torvista in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 10 Nov 2010, 06:31 PM
  3. Copy Product Price Manager Discounts
    By JeffTew in forum Setting Up Categories, Products, Attributes
    Replies: 5
    Last Post: 6 Sep 2010, 02:53 PM
  4. Updating Product Price based on Market Price
    By rpersonal2 in forum General Questions
    Replies: 1
    Last Post: 2 Sep 2009, 08:34 AM
  5. Product Price not updating
    By dreamstudio in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 12 Jun 2009, 12:42 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