Can someone help me with this problem.
I am using Stock By Attributes MultiAdd but I'm running into a simple problem. I read the entire forum and can't find anything on it...
I need to set my stock quantity to Zero. I can do it by manually manipulating the database, but can't seem to get it to work from the Admin panel. Everytime I try I get a MySQL error that looks like this...
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' attribute_sku=0 where stock_id=68 limit 1' at line 1
in:
[update `products_with_attributes_stock` set quantity=, attribute_sku=0 where stock_id=68 limit 1]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I added the Attribute_sku. I've tried everything and can't get it to work. It just keeps the Quanit=, and places no value there. If I put in -0 it works though...I don't get it.... Please HELP!
Bookmarks