Jump to content

nttcar

Members
  • Content count

    35
  • Joined

  • Last visited

  1. nttcar

    need help on SQL update statement

    Finall I got it, update need to be in UPPER case
  2. nttcar

    need help on SQL update statement

    udpate products SET `products_price` = `products_price` +10 MySQL said: #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 'udpate products set `products_price` = `products_price` + 10' at line 1
  3. I need to quick update the products_price when I run the sql from phpadmin, I got below error SQL query: udpate product SET products_price = products_price +10 MySQL said: #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 'udpate product set products_price = products_price + 10' at line 1
  4. nttcar

    Financial reporting contribution

    Installed it works fine but when I go to category and try to duplicate an item (Copy To) then give me 1136 - Column count doesn't match value count at row 1 insert into products (products_quantity, products_model,products_image, products_price, products_cost, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('1000', '', 'emergen-cimmunedefense.jpg', '430.0000', now(), null, '0.00', '0', '0', '0') Any one know how to fix it ?
  5. I have seen one Cont module will show original price we get from manufacture (admi only) so we know exactly what is our invoice price, so we can set the sale price in the admin panel. Does anyone know what is the name of the contribution Thanks !
  6. I want my handing fee to be caculate base on number of item being purchased plus the shipping cost also base on number of item being purchased. Thanks
  7. Does any one know is there contributions provide table rate shipping plus talbe rate handling fee thanks
×