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 1997
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 778
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 4488
Re: Language
http://opencartadmin.com/en/files/seo-muktilang-cat/
Jump to post- Sun Aug 07, 2016 3:53 pm
- Replies 3
- Views 550
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 2299
Re: Currency Button
Add currency
from Admin ->System ->Localisation ->Currencies
- Mon Nov 23, 2015 9:47 pm
- Replies 1
- Views 1499
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 1521
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 4488
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 4488
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 651
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 860
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 703
Re: Unable to login after Migration
check
/config.php
/admin/config.php
- Fri Aug 14, 2015 8:09 pm
- Replies 3
- Views 1850
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 2134
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 1307
Re: site crashed, need help
reinstall nitrocache
or remove new xml
- Fri Aug 14, 2015 8:00 pm
- Replies 1
- Views 324
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 651
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 1281
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 365
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 766