-Ryan
If possible, yo fix whit don,t show the inactive products in admin?
That will be good for me, because I have a lot products inactive
One odd thing I've noticed (before and after your mod), is that the sales report by days is screwy.... See screenshot. Cannot figure out how it figures out these are "by days"

Only thing I can think of is changing to US dates is fouling with it somehow????
If I manually put in the same date for start/end, it reports the sales correctly (minus the statuses I don't want to include which was actually why I got your mod


Attachments
sales report by days.png (14.76 KiB) Viewed 4623 times
Running Opencart v3.0.3.9 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.
Running Opencart v3.0.3.9 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.
-Ryan
Running Opencart v3.0.3.9 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.
Good idea and very true!labeshops wrote:One more thing - how about adding a product sort by date in the options? So I can put the most recently added products at the top (which are usually the ones I need to edit lol).
artisantool.co
Don't forget to add [SOLVED] to your Thread Title (first post), if your issue is solved.
It isn't applied there because there's already status filtering in reports.labeshops wrote:Well, I figured out if I put in starting and ending dates, then group by days, the dates are correct. BUT your filter doesn't work properly
-Ryan
Running Opencart v3.0.3.9 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.
Code: Select all
<file name="admin/model/report/sale.php">
<operation error="log">
<search position="replace" regex="true"><![CDATA[~" ((WHERE)|(AND)) (o\.)*order_status_id > '0'"~]]></search>
<add><![CDATA[" $1 $4order_status_id NOT IN (0," . $this->db->escape(implode(',', $this->config->get('aes_sales_status_exclude'))) . ")"]]></add>
</operation>
</file>
-Ryan
- Order List - Order Total ranges filtering, e.g. "75-150" for order totals between $75 and $150
- Order List - Company sorting/filtering
- Order List - Email sorting/filtering
- Product List - Category filtering (optional)
- Product List - Date Added sorting/filtering (optional)
- Product List - Date Modified sorting/filtering (optional)
- Product List - Price ranges filtering; separate values with a dash, e.g. "10-50" for regular prices between $10 and $50
- Product List - Quantity ranges filtering; separate values with a dash, e.g. "100-200" for products with quantities between 100 and 200
- Latest Orders - Number of orders customer placed
- Latest Orders - Company name
- SEO Keyword duplication checking can now be optionally disabled for compatibility with third-party SEO mods
- Two new sizes for Image Manager optimized for widescreen monitors
- Model search in product autocomplete (optional)
- Verbose errors in category, information, and product forms
- Order status exclusions extended to reports
- Improved language fallback
- Ported to vQmod 2.3.0 (required)
Once AES v1.3.0 leaves beta I'll be increasing the price. The current price is a great bargain for a mod that touches every corner of Administration and dramatically increases its productivity.
-Ryan
Could you please tell me where I might get an answer for this:
I have installed vqmod, vqmod Manager in my OpenCart program with no problems, all seems to be working OK. BUT (as there always is) when I add "Admin Enhancement Suite" I get the error "
---------- Date: 2013-05-26 15:27:57 ~ IP : 122.148.224.250 ----------
REQUEST URI : /upload/admin/index.php?route=common/home/chart&token=fd0d706cf4d39d72bb245584eb1b3b20&range=day
MOD DETAILS:
modFile : /smhhome/a-web/a1/1d/flowbenchoz.com/public/vividlaser/upload/vqmod/xml/admin_enhancement_suite.xml
id : Admin Enhancement Suite
version : 1.2.2
vqmver : 2.1.5
author : Ryan (rph) - OpenCartHelp.com
SEARCH NOT FOUND (ABORTING MOD): order_status_id > '0'
I have unloaded it and reloaded but I still get the same error. I don't mean to bother you and I suppose the fix is probably quite simple (like me).
Kind Regards
Warren Eames


Users browsing this forum: No registered users and 22 guests