Search found 201 matches

Search found 201 matches

Re: How to link products to all categories easly ?

1 backup
2 backup

3.

Code: Select all

DELETE FROM oc_product_to_category WHERE product_id= 'YOUR uneversal_product_id';
INSERT INTO oc_product_to_category VALUES(prosuct_id,category_id) (SELECT 'YOUR uneversal_product_id', category_id FROM oc_category);

Jump to post
  • Tue Jan 17, 2017 7:16 pm
  • Replies 7
  • Views 308
2.3 Events. Where events registered?

2.1 index.php $query = $db->query("SELECT * FROM " . DB_PREFIX . "event"); foreach ($query->rows as $result) { $event->register($result['trigger'], $result['action']); } 2.3 system/framework.php // Event Register if ($config->has('action_event')) { foreach ($config->get('action_event') as $key => $v...

Jump to post
  • Tue Jan 17, 2017 6:48 pm
  • Replies 1
  • Views 198
Re: [SOLVED]Remove duplicate products using mysql query

INSERT tmptable (id) select product_id from oc_product p where exists ( select * from oc_product p1 where p1.model = p.model and p1.sku = p.sku and p1.product_id > p.product_id ); delete from oc_product where product_id in (select id from tmptable); DELETE FROM oc_product WHERE product_id in (selec...

Jump to post
  • Sat Oct 01, 2016 6:03 am
  • Replies 12
  • Views 1601
Re: Currency Button

Add currency
from Admin ->System ->Localisation ->Currencies

Jump to post
  • Mon Nov 23, 2015 9:47 pm
  • Replies 3
  • Views 1086
Re: [SOLVED]Remove duplicate products using mysql query

All queries you must do in a SQL window together

Jump to post
  • Wed Aug 26, 2015 3:48 pm
  • Replies 12
  • Views 1601
Re: [SOLVED]Remove duplicate products using mysql query

INSERT tmptable (id) select product_id from oc_product p where exists ( select * from oc_product p1 where p1.model = p.model and p1.sku = p.sku and p1.product_id > p.product_id ); delete from oc_product where product_id in (select id from tmptable); DELETE FROM oc_product WHERE product_id in (selec...

Jump to post
  • Wed Aug 26, 2015 1:58 am
  • Replies 12
  • Views 1601
Re: Opencart Calculation

Describe in more detail.
The width and height of the white block are optional, or option is the area of the square.
The width and height of the red stripes are optional or option is the summary square.

These values can be integer or decimal as well?
These values can be fixed size?

PM?

Jump to post
  • Mon Aug 17, 2015 5:51 pm
  • Replies 3
  • Views 334
Re: Can't create/write to file '/var/tmp

Contact your hosting provider

Jump to post
  • Fri Aug 14, 2015 8:24 pm
  • Replies 1
  • Views 539
Re: All of sudden im getting this error

Contact your hosting provider

Jump to post
  • Fri Aug 14, 2015 8:15 pm
  • Replies 1
  • Views 511
Re: Undefined index: order_status_id

check vqmod log

skip error
or
not found string

Jump to post
  • Fri Aug 14, 2015 8:07 pm
  • Replies 5
  • Views 1342
Re: site crashed, need help

reinstall nitrocache
or remove new xml

Jump to post
  • Fri Aug 14, 2015 8:00 pm
  • Replies 1
  • Views 166
Re: Opencart Calculation

width_white = 3
height_white = 4

width_red = 2

square_red = (width_red*width_white)*2 + (width_red*height_white)*2

???

Jump to post
  • Fri Aug 14, 2015 6:15 pm
  • Replies 3
  • Views 334
Re: Replacement for "while" loop

try it

Code: Select all

$findCustomers = $this->db->query("SELECT * FROM customer WHERE substr(birth_date,6) = '" . $todayDate . "'");
foreach ($findCustomers->rows as $row) {
   $birthDate = $row['birth_date'];
   $birthEmail = $row['bday_email'];
   $age = $thisYear - (substr($birthDate,0,4));

Jump to post
  • Thu Aug 06, 2015 3:11 am
  • Replies 2
  • Views 141
Re: database opencart issue

All right.

I changed the sql driver from mysqli to mysql

Jump to post
  • Tue Aug 04, 2015 7:32 pm
  • Replies 7
  • Views 346

Search found 201 matches