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
- Sun Sep 15, 2019 5:01 pm
- Replies 1
- Views 56
Re: Extension seller Payout Date
That's about right, yes
Jump to post- Sun Sep 15, 2019 4:09 pm
- Replies 1
- Views 91
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
- 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
- Wed Jul 31, 2019 3:23 pm
- Replies 4
- Views 260
Re: Transferring OC from main domain to a sub domain
+ 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.
- 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
- 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.
- 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
