Posts

Showing posts from May, 2018

OpenCart 3.0.2.0 cache issue Resolve

https://github.com/vqmod/vqmod/issues/128 https://github.com/vqmod/vqmod/issues/135 usmanalimaan Fiverr Seller Experienced Developer with a demonstrated history of working in the computer software industry. I have two year plus working experience in web development using php frameworks like Cakephp, Laravel and codeigniter and using php versions 5 and 7 , mysql , sqllite . Do have hand on practice with Restful apis. Strong engineering professional with a Bachelor’s Degree focused in Bscs from GC University Lahore.

how to update entire Category price in OpenCart

Image
We will do this by directly updating into databases Here are Steps to do this 1>Search Category by Name here is script SELECT * FROM `oc_category_description` WHERE name in ("Clothing" , "Kids dresses") 2> No get Products Prices and Special price by just provide category id SELECT   pc .product_id , category_id , p .product_id , ps .product_id , p .price , ps .price   FROM   oc_product   as   p   join   `oc_product_to_category`   as   pc   on   pc .product_id = p .product_id   JOIN `oc_product_special`   as   ps   on   p .product_id = ps .product_id   WHERE   pc .category_id = 415 3> Now its time to update prices of all Products once by updating price and special price UPDATE  oc_product as p join `oc_product_to_category` as pc on pc.product_id=p.product_id JOIN `oc_product_special` as ps on p.product_id=ps.product_id SET ps.price=0 WHERE pc.category_id=656 U...