Search found 7449 matches

Search found 7449 matches

Re: Deleting inactive customers

You don't need to request customers and then use array_diff(). One single query should be enough: $query = $db->query("SELECT c.customer_id FROM `" . DB_PREFIX . "customer` AS c LEFT JOIN `" . DB_PREFIX . "order` AS o ON (c.customer_id = o.order_id AND o.date_added <= DATE_SUB(NOW(),INTERVAL 5 YEAR...

Jump to post
  • Thu Sep 19, 2019 2:04 pm
  • Replies 5
  • Views 234
Re: Deleting inactive customers

You could do it with a script. IMPORTANT - Backup your database before using this script create a file in your favourite text editor with the following code and save it as whatever.php - Upload it to your store root and run it in a web browser <?php set_time_limit(0); require_once('config.php'); req...

Jump to post
  • Sun Sep 15, 2019 5:47 pm
  • Replies 5
  • Views 234
Re: How would I get all the categories of a product with a sql?

SELECT category_id FROM oc_product_to_category WHERE product_id = 'XXX';

Insert product ID where I have put XXX

Jump to post
  • Sun Sep 15, 2019 5:01 pm
  • Replies 1
  • Views 56
Re: Pointing my domain to the new website doesn't load site

Check your config.php and admin/config.php files to make sure URLs are correct

Jump to post
  • Fri Sep 13, 2019 1:59 pm
  • Replies 4
  • Views 150
Re: Recommended and best robots.txt file for opencart 3.x

robots.txt should list only links that are accessible via a robot that follows links in your site. Therefore no admin folder or other OC folders should be listed really. Plus listing them gives script kiddies something to attempt to play with. robots.txt is not always adhered to (depending on the ro...

Jump to post
  • Sun Sep 08, 2019 3:46 pm
  • Replies 11
  • Views 3530
Re: Install Facebook Business

First port of call would be to contact the extension developer for support.

Jump to post
  • Sun Sep 01, 2019 3:05 pm
  • Replies 1
  • Views 125
Re: migrating from local host to live server

Have you checked the path given in the error for the file the error says is missing ?

Jump to post
  • Sun Sep 01, 2019 3:01 pm
  • Replies 2
  • Views 172
Re: Is it worth switching from opencart 2 to opencart 3

IF the version you are using is working fine and there is no new feature that you really need and no unpatched security issues, then stick with what is working for you

Jump to post
  • Mon Aug 26, 2019 12:19 am
  • Replies 4
  • Views 217
Re: Making site live

You will need to edit config.php and admin/config.php to change the URLs and server paths.

You may lso find that some banners will need to be re-inserted and any images you have added to any any descriptions as they may use the old long urls

Jump to post
  • Thu Aug 01, 2019 3:27 pm
  • Replies 2
  • Views 150
Re: Google Search Headings - how do you change them?

They are page titles or category/product titles

Change those and in time Google will update, but it may take some time as mentioned above

Jump to post
  • Wed Jul 31, 2019 3:23 pm
  • Replies 4
  • Views 260
Re: Transferring OC from main domain to a sub domain

lovenatural wrote:
Tue Jul 30, 2019 11:38 pm
thekrotek wrote:
Tue Jul 30, 2019 6:47 pm
Just copy your site to subfolder, edit .htaccess. Assign different SSl certificate and copy database as well, if necessary.
+ edit urls in both config files.
+ edit any Banners you have added or images in descriptions as their path URLs will be wrong once you move to subdomain.

Jump to post
  • Wed Jul 31, 2019 3:22 pm
  • Replies 5
  • Views 198
Re: Transfer Online

FTP the files

Edit config.php and admin/config.php to match your domain name, server file paths and database details

Import database backup via phpmyadmin

Finally fix any banners as their URL paths may be incorrect.

Jump to post
  • Wed Jul 31, 2019 3:18 pm
  • Replies 2
  • Views 110
Re: Few questions re: OpenCart customization

You would be better off with something like Craft CMS which can be used headless

Jump to post
  • Mon Jul 29, 2019 2:02 pm
  • Replies 2
  • Views 139
Re: Show Product MPN on Invoice

You could just create a new model function in the admin/model/sale/order.php file, then call that function in your controller.

Jump to post
  • Fri Jul 19, 2019 2:54 pm
  • Replies 5
  • Views 910
Re: Show Product MPN on Invoice

Unfortunately, MPN is not stored in the oc_order_product table

Therefore you would have to capture mpn at the point of the order being added to the database

Quite a bit of work involved and would most likely require a commercial support request via our commercial support forum

Jump to post
  • Thu Jul 18, 2019 7:18 pm
  • Replies 5
  • Views 910
Re: Secured site does not show the https green padlock

Well you need to correct all errors reported by whynopadlock

For example, if you were previously just on http before installing SSL you may have added banners, slideshows etc via OC modules. These banners would have used a http URL for the images. You should update any/all banners to fix this.

Jump to post
  • Thu Jul 18, 2019 3:31 pm
  • Replies 4
  • Views 997
Re: Locked myself out of Admin

If you have access to your database, for example by using PHPMyAdmin, you can edit the oc_user table and set the user_group_id column for your username to '1'

Jump to post
  • Thu Jul 18, 2019 3:23 pm
  • Replies 1
  • Views 778
Re: Cloudfare problem

I guess you should maybe ask them about it ?

Jump to post
  • Sun Jul 14, 2019 3:53 pm
  • Replies 3
  • Views 408
Re: Cloudfare problem

Most likely it is something you have got set-up in the Firewall Rules in Cloudflare that is forcing a Challenge intervention.

Jump to post
  • Sat Jul 13, 2019 2:15 pm
  • Replies 3
  • Views 408

Search found 7449 matches