I don't understand Step 1 of the mod for MSRP. What exactly do we put in the SQL query under admin? I put in what is indicated in step one and I get errors.
This is what I get -
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 'tableprefix_products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products' at line 1
in:
[ALTER TABLE zen_ tableprefix_products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products_price ;]
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.
What is the correct verbiage that I am supposed to use to get this part to work?
I am using version 3.8
Please advise. I would appreciate it. Thanks