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 2528
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_e...
Jump to post- Tue Jan 17, 2017 6:48 pm
- Replies 1
- Views 873
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 5228
Re: Language
http://opencartadmin.com/en/files/seo-muktilang-cat/
Jump to post- Sun Aug 07, 2016 3:53 pm
- Replies 3
- Views 701
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 2630
Re: Currency Button
Add currency
from Admin ->System ->Localisation ->Currencies
- Mon Nov 23, 2015 9:47 pm
- Replies 1
- Views 1564
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 1749
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 5228
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 5228
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 787
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 960
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 791
Re: Unable to login after Migration
check
/config.php
/admin/config.php
- Fri Aug 14, 2015 8:09 pm
- Replies 3
- Views 4847
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 2346
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 1403
Re: site crashed, need help
reinstall nitrocache
or remove new xml
- Fri Aug 14, 2015 8:00 pm
- Replies 1
- Views 386
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 787
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 1602
Re: Replacement for "while" loop
try it $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 464
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 953
