Skip to content
Advertisement

Tag: opencart

Subtract tax from a price with tax in OpenCart?

How do I subtract all taxes from a price with tax in OpenCart? In the example below I use the default “Taxable goods” tax setting from OpenCart, which is 20% VAT + $2,00 Eco-Tax. This returns an incorrect value of $14,64 because it calculates the tax on $number (20,80), which already is a price with tax. The correct price for

Filter qry to get data according to Another Table

This is query to get all categories available in database. to get this output So, i am trying to get only that categories listed in rma_mapping_category(this has category_id column) so i tried this, but syntax got wrong by adding this(AND rma_mapping_category rma)… ///////////////////// Also tried this… ////////////////////// by this i am getting all categories rather than just rma_mapping_category Same result

Errors on font change to site

On the site, which is made on the Opencart theme, which allows you to change the font in the theme control panel. But, when I have a standard font on “Ralewey” (it is in the theme directory) I get Opencart such an error and does not change the font. Can you please tell me how to fix it and still

opencart error Fatal error: Uncaught Exception: Error: Unknown column

So first of I apologize for my rocky explanation. My PHP skills need serious refinement. I did get this error Fatal error: Uncaught Exception: Error: Unknown column ‘is_unlimited’ in ‘field list’Error No: 1054INSERT INTO oc_seller_group SET product_id = ‘1202’ ,gquantity = ‘0’,gprice = ’59’,group_commission = ‘0’,expiry = ’30’,membership_type = ‘stm’,trial_status = ‘0’,group_image = ‘catalog/Image.jpg’, defaultCategoryProduct = ‘0’,defaultCategoryQuantity = ‘0’, defaultCategoryPrice

How to add reward point to all products at once in opencart

How to add reward point to all products at once instead of adding manually to each product? This is time consuming to add point to each product manually instead I want to add 2% of product price to reward point. How can i do this? Answer You can easily perform sql querys in phpmyadmin to update points. Assuming your table

Advertisement