OpenCart Community

Search found 7 matches

Page 1 of 1

Search found 7 matches

MySQL: Left Join product attributes

I have this SQL, but does't work as spected to be a Left Join (doesn't show NULL on right table), any help? thanks!

SELECT
  ad.name,
  pa.text
FROM
  oc_attribute_description ad
  LEFT JOIN oc_product_attribute pa ON ad.attribute_id = pa.attribute_id
WHERE
  pa.product_id = :product_id

Jump to post

Wed Feb 28, 2018 3:43 am
Replies 1
Views 643

eft0

Re: How to notify the order confirmation with a request to another server

I do that in /catalog/controller/mail/order.php after the "// Send to additional alert emails" line 465

if ($data['order_status'] == 'Complete') // then do you stuff

Jump to post

Fri Feb 23, 2018 5:43 am
Replies 2
Views 375

eft0

Multistore, help duplicating "default" template and assign

OC version: 3.0.2.0 I need to use the multi-store feature, the 1st store it's working fine, now I need to create a new one. I want to duplicate the "default" template, and assign it to a new store in the same OC, what I do so far: - Upload the "default" version of the theme into ...

Jump to post

Fri Feb 23, 2018 3:31 am
Replies 12
Views 13501

eft0

UPDATE: Product quantity (total) variable, to custom shipping method

Hey there, any ideas how to do this ? I need the product quantity (total) variable, in a custom shipping method. Thanks in advanced. [UPDATE] This code snipped Works fine: $total_productos = 0; foreach ($this->cart->getProducts() as $product) { $total_productos += $product['quantity']; }

Jump to post

Fri Jan 19, 2018 4:36 am
Replies 1
Views 250

eft0

Set all e-mails to html format

Where I do this ? currently all mails, register, order, etc, are sending in plain text format.

Thanks!

Jump to post

Sat Jan 06, 2018 4:47 am
Replies 1
Views 236

eft0

Chile: Modulo Webpay OpenCart 3.0.2.0

Hola, en Transbank Developers esta un modulo listo, pero es para la version 2 de OC, ¿alguien tiene una actualización para la 3.0.2.0? Gracias!

Dejo el link (hay que estar registrado): http://www.transbankdevelopers.cl/?m=plugin

Jump to post