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.
Bookmarks