Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
It's me again
Sorry to bother you but what are you trying to achieve using customer search table??
There is nothing there to connect it with orders.
Moreover you getting date from customer_search MIN(`cs`.`date_added`) AS `date_start` and then in GROUP BY YEAR(`o`.`date_added`) ?
Sorry for stupid questions but I'm trying do understand...
Pottery Glaze shop
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
- Added cache with $product_data as per the original query
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
- Edited catalog controller file to fit the model's requirements accordingly
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
This approach is very interesting. If I understand the concept well, does this approach AI? Or also a type of internal remarketing?straightlight wrote: ↑Sun Mar 17, 2019 5:47 amIn OC v3.x releases (and perhaps prior), the bestsellers extension is based on the highest prices being sold which provides the vision on noticing the ordered products that have been purchased with limited results. However, since Opencart v3.0.2.0 and above has a customer search method built-in, I thought of the idea on migrating the customer search with the ordered product results - including the updates of product options within the customer search table whenever an order has been created.
These changes now involves Demand Management with the Service Strategy as it should be. Based on the customer's service request, in this case the customer search results, store owners can now filter by total or by the most recent search queries which makes much more sense. Demands will keep increasing by customers and, in this case, for a good cause. Each products involving changes with the product options will automatically be updated in the customer search based on the last time the identical product was purchased which will only require a low amount of resource. This methodology will allow store owners to keep track of the demands vs. the sales all in the same place as for customers having an account will be able to notice the change (if not, then later on with an extension).
Edit: From now on, see from my GitHub namespace all files called: bestseller.php, catalog/model/account/search.php and catalog/model/catalog/product.php files: https://github.com/straightlight/openca ... ter/upload
Lastly, FAQ: viewtopic.php?f=176&p=739789#p718325
It would be a great feature to have among the core.
Could it be extended to the other modules (latest, featured, etc)?
It focuses on the best practices of Service Strategy with Service Management; not remarketing. Since there's a lot of people using OC for Marketing in general, better to set a higher level.This approach is very interesting. If I understand the concept well, does this approach AI? Or also a type of internal remarketing?
Latest and featured are based on products that just arrived or about to arrived on stock based on the store's or its service provider's perspective. It does not bring much value other than what it's worth upon its arrival since new arrivals are at their bottom levels to meet the demands while the best seller products extension module is what grows the demands being gathered from the customer search feature based on what the customers are specifically looking for but also buying officially.Could it be extended to the other modules (latest, featured, etc)?
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
About my suggestion, what I envisioned was related to an attempt to buy / buy and customer search. For example: if the client is logged and search iphone term, posteriorly during in store navigation, the modules automatically displays iphone related products.
If the customer buys, would be listed products related to the purchase. Not necessarily latest or featured modules, I used these just as an example...
Suggestion now added on catalog/model/catalog/product.php in my GitHub namespace. Good idea.diegospm wrote: ↑Sat May 11, 2019 9:03 amSorry, I made a little confusion, I think I got it now.
About my suggestion, what I envisioned was related to an attempt to buy / buy and customer search. For example: if the client is logged and search iphone term, posteriorly during in store navigation, the modules automatically displays iphone related products.
If the customer buys, would be listed products related to the purchase. Not necessarily latest or featured modules, I used these just as an example...
However, I also added more ideas with your suggestions since the model's method still needs to focus specifically on service providers where products are NOT free.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
I know it's not related to the topic, but how about we add an api library?
It would facilitate the development of extensions to connect to external apps.
For example:
$api new Api ('base_url', $options);
$api->auth($params);
$api->post('endpoint', $ data);
I would use guzzle to make the request. I would use guzzle to make the request. I can upload library scope....
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
maybe you did not understand to my suggestion or I did not understand the proposal of the topic you mentioned.straightlight wrote: ↑Sat May 11, 2019 9:28 pmThere's no need to re-invent the wheel by using an API. Simply use this example: viewtopic.php?f=202&t=203512&p=720446#p720446 . Then, once the token gathered at the bottom, use the custom codes as you see fits to return the results to your jQuery response.
The purpose of the api would be to connect the OC in external sites / apps (erps, marketplaces, payments provider, shippings provider, etc) and not the other way around.
In some countries (such as mine), the OC is not yet extensively exploited by external providers and api could simplify to developers create extensions.
It would not be necessary to create a curl function to connect to each app and I thought about the guzzle to be able to use requests async/promise (when necessary).
Yes, I understood very well. If you want to do this the other way around, it can also be done via the Ajax URL. If you don't know how to build an API, this could be done as a custom paid job. If you'd like, you could submit a service request in the Commercial Support section of the forum to get it done.diegospm wrote: ↑Sun May 12, 2019 7:41 ammaybe you did not understand to my suggestion or I did not understand the proposal of the topic you mentioned.straightlight wrote: ↑Sat May 11, 2019 9:28 pmThere's no need to re-invent the wheel by using an API. Simply use this example: viewtopic.php?f=202&t=203512&p=720446#p720446 . Then, once the token gathered at the bottom, use the custom codes as you see fits to return the results to your jQuery response.
The purpose of the api would be to connect the OC in external sites / apps (erps, marketplaces, payments provider, shippings provider, etc) and not the other way around.
In some countries (such as mine), the OC is not yet extensively exploited by external providers and api could simplify to developers create extensions.
It would not be necessary to create a curl function to connect to each app and I thought about the guzzle to be able to use requests async/promise (when necessary).
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Users browsing this forum: No registered users and 10 guests