Search found 69 matches

Search found 69 matches

Re: Remove duplicate product with lower price using mysql qu

This works in-case someone needs it: :joker: delete p1 from product p1 join product_description d1 on d1.product_id = p1.product_id join product_description d2 on d2.product_id <> d1.product_id and d2.language_id = d1.language_id and d2.name = d1.name join product p2 on p2.product_id = d2.product_id...

Jump to post
  • Wed Feb 17, 2016 8:25 pm
  • Replies 4
  • Views 751
Remove duplicate product with lower price using mysql query

I have many duplicate products that I need to delete. Is there a query to delete these "Duplicates" with the "lower price" and/or "Same Price" an just keep 1 of each product?

The duplicates have duplicate "Product Name" Iam using Opencart Version 2.1.0.1

???

Jump to post
  • Sun Feb 07, 2016 4:48 am
  • Replies 4
  • Views 751
Product Category autocomplete and subcategories

When using autocomplete in the: Product > Links > Categories If you have a Category with a sub category like: Bearings > Inch sizes Bearings > Inch sizes will not show up, you need to type Inch and "then" It will display Bearings > Inch sizes Is there a way to fix this as customers think that Bearin...

Jump to post
  • Mon Jan 25, 2016 4:37 am
  • Replies 0
  • Views 140
Re: Image Manager Is Crashing

Paul What I do is go to an item -> edit Image -> Image-manager opens: When I click on the last or second to last navigational links the "Pagination" on the bottom the Image-manager closes. Now I tested it on a fresh install and It works fine it just seems to be when there are a large number of image...

Jump to post
  • Sun Aug 23, 2015 8:03 pm
  • Replies 8
  • Views 885
Re: Image Manager Is Crashing

The version of OC that I'm using is 2.0.3.1

Jump to post
  • Sun Aug 23, 2015 6:45 pm
  • Replies 8
  • Views 885
Image Manager Is Crashing

Hi all my Image Manager is crashing on OC 2.0.X, when I click on the last or second to last navigational links "Pagination" on the bottom of the browser < 1 2 3 4 5 6 > This is happening on two different sites and different PCs tested it on top browser's and get the same thing so It cant be a browse...

Jump to post
  • Fri Jul 24, 2015 9:14 pm
  • Replies 8
  • Views 885
Add left hand category navigation to the home page

How do I

Add left hand category navigation to the home page?

Jump to post
  • Mon May 11, 2015 9:58 pm
  • Replies 1
  • Views 194
PHP5.3+ Required error

I'm only getting "PHP5.3+ Required" error on installer and manual install ant ideas? and server has PHP5.3

Jump to post
  • Thu Oct 16, 2014 4:34 am
  • Replies 3
  • Views 6950
Warning: The file you uploaded was empty!

I am getting this error when I try to restore the database. I get: "Warning: The file you uploaded was empty!" This site has worked with no issues for a year no out of the blue I'm getting errors. ??? GD Linux dedicated server I am using OC 1.5.3.1. PHP.INI: magic_quotes_gpc = Off; register_globals ...

Jump to post
  • Mon Jan 06, 2014 11:46 pm
  • Replies 1
  • Views 868
Re: 301 redirect without using .htaccess

Remove your add-on for SEO and leave the URL's as they are set in opencart's "default package: they will work out fine for SEO the way they are.

Jump to post
  • Sun Sep 22, 2013 3:22 am
  • Replies 9
  • Views 1319
Re: Password for purchase

Try in admin: sales ->coupons

Jump to post
  • Sun Sep 22, 2013 3:16 am
  • Replies 4
  • Views 638
Re: Pop Up On Checkout

OK here what I have. I edited catalog/view/theme/default/template/checkout/checkout.tpl ADDING: <script type='text/javascript'>//<![CDATA[ $(function(){ $("#confirm").fancybox({ content : "<p>HTML content will go here</p>" }); });//]]> </script> The widow pops up but, closes automatically and then a...

Jump to post
  • Sun Sep 22, 2013 2:57 am
  • Replies 1
  • Views 444
Re: Return Reason in version 1.5.6

It's in your .sql file ;D

Jump to post
  • Fri Sep 20, 2013 7:13 pm
  • Replies 3
  • Views 454
Pop Up On Checkout

Hi all

How can I call fancybox to display a image with a OK button when the user clicks on the "Confirm Order" button before being re-directed to Credit Card processors site. I can seem to figure it out ???

Jump to post
  • Fri Sep 20, 2013 5:53 am
  • Replies 1
  • Views 444
Cannot remove Company, Company ID, Tax ID on the checkout

Hi All I cannot remove Company, Company ID, Tax ID on the checkout form, even though I have it set to off in the -> admin sales -> customer HERE IS THE SQL: TRUNCATE TABLE `customer_group`; INSERT INTO `customer_group` (`customer_group_id`, `approval`, `company_id_display`, `company_id_required`, `t...

Jump to post
  • Tue Sep 25, 2012 3:06 am
  • Replies 3
  • Views 462
OPENBAY PRO EXTENSION ERROR ON THE "PRODUCTS PAGE"

I installed OpenBay Pro extension and I get this error on the "Products Page" Notice: Undefined variable: ebay_linked in /var/www/vhosts/mydomain.com/httpdocs/vqmod/vqcache/vq2-admin_view_template_catalog_product_form.tpl on line 19 AND: On the OpenBay Pro page I get this error: You are running the ...

Jump to post
  • Sat Sep 22, 2012 5:25 am
  • Replies 1
  • Views 664
Upgrade error to 1.5.4.1

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/preppyplayer.com/httpdocs/install/model/upgrade.php on line 50
Could not Execute: ALTER TABLE product_tag ADD INDEX product_id (product_id);
Table 'PPCO5.product_tag' doesn't exist

Jump to post
  • Fri Sep 21, 2012 4:53 am
  • Replies 2
  • Views 676

Search found 69 matches