Useful database queries

In Opencart 3 find all products without a seo url value

SELECT * FROM oc_product WHERE NOT EXISTS(SELECT 1 FROM oc_seo_url WHERE query LIKE CONCAT('product_id=', product_id))

Featured

Professional Email Template - Advanced

Professional Email Template - Advanced

Responsive HTML Email template - not only will your emails look professional on all desktop computer

£22.50

Modifications Manager

Modifications Manager

Edit modifications (ocmod code) easily from the admin using a xml code editor. The xml ocmod is stor

FREE

PDF Order Invoice

PDF Order Invoice

Attach PDF invoice to order update email or customer download from their account. Works well with Ad

£10.00

Admin Order Status Updater

Admin Order Status Updater

Quickly and easily update orders with the same order status and auto populated message.Works very we

FREE