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);
- Tue Jan 17, 2017 7:16 pm
- Replies 7
- Views 1203
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 458
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 3041
Re: Language
http://opencartadmin.com/en/files/seo-muktilang-cat/
Jump to post- Sun Aug 07, 2016 3:53 pm
- Replies 3
- Views 414
Re: How to set meta tag "noindex, nofollow" for certain lang
If you need to do this, please PM
Jump to post- Sun May 01, 2016 2:14 am
- Replies 7
- Views 1744
Re: Currency Button
Add currency
from Admin ->System ->Localisation ->Currencies
- Mon Nov 23, 2015 9:47 pm
- Replies 1
- Views 1372
Re: 2.0.3.1 Maintenance Mode keeps turning on
try it
http://www.opencart.com/index.php?route ... n_id=23316
- Thu Oct 08, 2015 10:18 pm
- Replies 6
- Views 1194
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 3041
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 3041
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?
- Mon Aug 17, 2015 5:51 pm
- Replies 3
- Views 467
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 727
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 599
Re: Unable to login after Migration
check
/config.php
/admin/config.php
- Fri Aug 14, 2015 8:09 pm
- Replies 3
- Views 1169
Re: Undefined index: order_status_id
check vqmod log
skip error
or
not found string
- Fri Aug 14, 2015 8:07 pm
- Replies 5
- Views 1822
Re: Allow products with future available date to be pre-orde
What is this expansion intended?
Link show, pls.
- Fri Aug 14, 2015 8:06 pm
- Replies 3
- Views 1172
Re: site crashed, need help
reinstall nitrocache
or remove new xml
- Fri Aug 14, 2015 8:00 pm
- Replies 1
- Views 245
Re: Opencart Calculation
width_white = 3
height_white = 4
width_red = 2
square_red = (width_red*width_white)*2 + (width_red*height_white)*2
- Fri Aug 14, 2015 6:15 pm
- Replies 3
- Views 467
Re: check if user login or not in cart checkout
How can I help?
PM?
- Fri Aug 07, 2015 2:18 am
- Replies 3
- Views 899
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));
- Thu Aug 06, 2015 3:11 am
- Replies 2
- Views 235
Re: database opencart issue
All right.
I changed the sql driver from mysqli to mysql
- Tue Aug 04, 2015 7:32 pm
- Replies 7
- Views 611