Re: Count number of a product sold in x days
Thanks for your reply. I feel like I'm close, but I'm still getting "Undefined variable: sold30 in /home/blades/public_html/vqmod/vqcache/vq2-dashboard_view_template_catalog_product_list.tpl".
Jump to post- Thu Mar 03, 2016 10:20 pm
- Replies 6
- Views 2029
Re: Count number of a product sold in x days
I am trying to display on the admin > catalogue > products page how many of each item has sold in the past 30 days. I have tried the following but I'm a bit unsure what I'm doing so wondering if anyone could help where I'm going wrong. In admin/model/catalog/product.php I have added public function ...
Jump to post- Thu Mar 03, 2016 7:16 pm
- Replies 6
- Views 2029
Re: Upgrade from OC 1.5.4 to OC 2.1.0.2 instructions please
You can try it the 'hard' way and follow that 'simple' instructions - I am sure we will hear from you again. Or you can follow the instructions Randem posted - the chance to read from you here about upgrading is very small. At the end, it is your decision .. That's what I thought. Thanks for confir...
Jump to post- Tue Mar 01, 2016 5:31 pm
- Replies 7
- Views 1513
Re: Upgrade from OC 1.5.4 to OC 2.1.0.2 instructions please
Hi sat tv guy, This may be helpful - http://www.randemsystems.com/support/opencart/migrating-your-data-from-opencart-version-1-5-6-4-to-version-2-1-0-1/ Hi, Thanks for sharing that link, looks useful, however when I look at http://docs.opencart.com/upgrading/ it seems to suggest that there's not mu...
Jump to post- Thu Feb 25, 2016 11:50 pm
- Replies 7
- Views 1513
Product bundle
I am looking for a simple module but having no luck. We sell products on our website, and also sell some kits which will be a bag that includes a selection of our products, depending on which kit is purchased. Whenever a kit is purchased I need the items that are in the kit to all be deducted from t...
Jump to post- Thu Sep 03, 2015 7:19 pm
- Replies 1
- Views 555
Re: Count number of a product sold in x days
I've come up with the following which kind of works, but always seems to be a few out compared to other reports: SELECT sum(op.quantity) AS total FROM order_product op LEFT JOIN `order` o ON (op.order_id = o.order_id) WHERE product_id=257 AND DATE(date_added) >= CURDATE()-INTERVAL 1 MONTH; Any sugge...
Jump to post- Mon Jul 27, 2015 9:13 pm
- Replies 6
- Views 2029
Count number of a product sold in x days
Trying to run a query to do as the title suggests. I need to know how many of a product has sold in the last 30 days. Not quite sure how to do it though as the data is in both tables 'order' and 'order_product'. Looking at some other code looks like I might need to use 'LEFT JOIN' perhaps? Any help ...
Jump to post- Mon Jul 27, 2015 7:45 pm
- Replies 6
- Views 2029
Automatically add to new customer basket / cart
I would like to automatically add our product catalogue to the basket when a new customer registers. Is there a module to do this or would it be easy to to? Opencart Version 1.5.6
Thanks,
- Thu Nov 13, 2014 6:28 pm
- Replies 0
- Views 341
Re: Hide product price
Just tried that and it seems to be working the same as if I use if (!$logged) { It's just saying TRADE ONLY whether they are logged in or not.
Jump to post- Wed Aug 06, 2014 4:32 pm
- Replies 2
- Views 875
Hide product price
I need the price on just a few products to be hidden, only if the customer is not logged in. Been trying to modify this mod: http://forum.opencart.com/viewtopic.php?f=112&t=4952 So far I have come up with if (!$logged) { $product_id = (int)$this->request->get['product_id']; if ($product_id == 44...
Jump to post- Tue Aug 05, 2014 11:14 pm
- Replies 2
- Views 875
Add product to basket on registration
Looking for a module or a point in the right direction to do what the subject says - I'd like to be able to automatically add a product (our printed catalogue which is free) to the basket when a new customer registers.
Could anyone help?
Thanks,
- Mon Aug 04, 2014 9:43 pm
- Replies 0
- Views 405
Re: How to create/duplicate a module?
Please don't just post that! What was the issue so that anyone in the future can be helped too please
Jump to post- Fri Oct 11, 2013 4:48 pm
- Replies 173
- Views 482586
Re: Product search in admin by part of the name
You didn't put the code to replace and I know that some of my admin files have been modified by my theme so didn't try this method. Used this mod instead (thought I'd share as I found this thread first so others might too) http://www.opencart.com/index.php?route=extension/extension/info&extensio...
Jump to post- Tue Sep 24, 2013 6:59 pm
- Replies 8
- Views 9016
Re: How to create/duplicate a module?
What does line 51 say on that file? What module are you duplicating?
Jump to post- Thu Sep 05, 2013 10:29 pm
- Replies 173
- Views 482586
Re: How to create/duplicate a module?
hi buyers, i created a offline payment, but when i tested, i met the problem as below, Notice: Undefined index: code in E:\xampp\htdocs\testcartv1512\catalog\view\theme\default\template\checkout\payment.tpl on line 9 Notice: Undefined index: code in E:\xampp\htdocs\testcartv1512\catalog\view\theme\...
Jump to post- Mon Aug 19, 2013 10:57 pm
- Replies 173
- Views 482586
Re: order comments also displayed in invoice
Anyone know how to get ths working with 1.5.x?
Jump to post- Tue Jul 23, 2013 8:31 pm
- Replies 17
- Views 6202
Re: web.config rewrite rules
I understand this is an old post but I figured I'd response in case somebody else is searching... This is web.config I use and it seems to work for v1.4.9.4 <?xml version="1.0" encoding="UTF-8"?> <configuration> <system.webServer> <rewrite> <rules> <rule name="Imported Rule...
Jump to post- Tue Jul 16, 2013 5:11 pm
- Replies 12
- Views 15110
Re: SEO Friendly URL's on information pages
Looks like the above fix for the original error works for this problem too :) On line 93 change: } elseif (isset($data['route']) && $data['route'] == 'account/order') { to } elseif (isset($data['route']) && $data['route'] == 'account/order' && $key != 'remove') { EDIT: Actual...
Jump to post- Wed Jun 19, 2013 7:28 pm
- Replies 31
- Views 36522
Re: SEO Friendly URL's on information pages
Yes, hadn't noticed it before but like you say I'm having the same problem - the re-order button (from previous order history when logged in) takes you to /order-history/order-history?order_id=1 and comes back as page not found
Jump to post- Wed Jun 19, 2013 6:47 pm
- Replies 31
- Views 36522
Re: SEO Friendly URL's on information pages
Perfect, thanks for posting fix!
Jump to post- Fri May 03, 2013 8:03 pm
- Replies 31
- Views 36522