Search found 14 matches

Page 1 of 1

Search found 14 matches

Re: jewelry site price update methods

how can i do that? By posting a request in Commercial Support section. Thanks for the answer. I can code in php enough, but not experienced enough in opencart logic. I can make this modification by editing core files, but it s not true way. Can you give me a suggestion, like; writing a plugin oc mo...

Jump to post
  • Sat Feb 20, 2021 6:13 pm
  • Replies 4
  • Views 279
jewelry site price update methods

Hello, i m coding a jewelry online store. There are 3 kinds of metals (22k gold, 14k gold and silver) and we are selling them with different rates. Because of the prices are changing so many times in a day, i need to update prices but its not possible to change one by one. i need something like this...

Jump to post
  • Sat Feb 20, 2021 6:42 am
  • Replies 4
  • Views 279
opencart 3 designing new layout

Hello, i ve duplicated the default theme and now making changes on my new theme. I want to change some pages design. For example, homepage is 3 cols. but i want full width slider, after that 3 cols design how can i create a custom layout? you can see a simpler one in the link https://docs.journal-th...

Jump to post
  • Tue Dec 08, 2020 8:47 pm
  • Replies 4
  • Views 356
Re: speeding up search

I analyzed the sql query In what way? "like"s and % are making the query slow many things make a query slow Can this be a good solution: creating a new table with product id and keywords (product name, product sku is can be enough ) and indexing keywords column than search in this table, something ...

Jump to post
  • Tue Jun 02, 2020 1:45 pm
  • Replies 4
  • Views 289
speeding up search

Hello, I am using oc 3.0.3.2 I have more than 300k products in my store. I have problem with search page, it takes ~10 sec.s I checked and found the problem, in catalog/model/catalog/product a getProducts function takes more that 6 secs. I analyzed the sql query, at the end; pd.name LIKE '%_SEARCH_%...

Jump to post
  • Tue Jun 02, 2020 5:06 am
  • Replies 4
  • Views 289
Re: opencart 3 sef url without mysql

which cache method do you suggest?

Jump to post
  • Wed Jan 29, 2020 3:30 am
  • Replies 8
  • Views 648
Re: opencart 3 sef url without mysql

You have slow search not because of additional query, but because your database is not indexed. I ve indexed some columns, which are being used by search. i checked with mysql slow log, gettotalproducts and getproducts functions takes time. i found a thread here that suggesting the indexes, i ve do...

Jump to post
  • Tue Jan 28, 2020 4:56 pm
  • Replies 8
  • Views 648
Re: opencart 3 sef url without mysql

I have 200k status = 1 products and 115k status=0 products.
search takes more than 5 seconds, it was more than 45 seconds and i changed queries and indexes of database.

@letxobnav @thekrotek

Jump to post
  • Mon Jan 27, 2020 5:52 pm
  • Replies 8
  • Views 648
opencart 3 sef url without mysql

hello, i ve got too many products, so having database speed issues. i want to use sef urls, but i dont want it to make a new mysql query. so i want to learn your opinions about doing this without mysql for example, in httaccess RewriteRule ^([a-zA-Z-]+)-([0-9])$ index.php?route=$1&product_id=$2 [NC,...

Jump to post
  • Sun Jan 26, 2020 7:05 pm
  • Replies 8
  • Views 648
Re: modifying the contollers and models

First of all, there's no developer mode. Second, if you don't see the changes - refresh modification cache. And the last, but not the least - don't change core files, use OCMod/VQmod. Thanks for your answer. Developer mode, i mean, in the dashboard, there is a setting for disabling theme and css ca...

Jump to post
  • Mon Dec 30, 2019 10:15 pm
  • Replies 3
  • Views 214
modifying the contollers and models

hello, i am using opencart 3.0.3.2 i want to make some changes in some modules, for example, modules/special when i change catalog/view/theme/default/template/extensions/module/special.twig no problem, i can see the changes in the front. but when i try to change to controller (catalog/controller/ext...

Jump to post
  • Mon Dec 30, 2019 8:52 pm
  • Replies 3
  • Views 214
Re: opencart book store, authors and publishers

Recently I made a site for a publishing house. In my case there are no publishers. Categories for genre, manufacturers for authors, a good live search(comes with the theme in my case). A lot of attributes(cover, year,pages....). Additional filter on category page. The main problem to solve was that...

Jump to post
  • Sun Dec 01, 2019 5:38 pm
  • Replies 11
  • Views 880
Re: opencart book store, authors and publishers

Thanks for all answers. I planned to use genres as categories. Looks like a good solution is using manufacturers as authors. So i can use tags for authors. In this case, i have to list books by publishers and also i have to list books by authors, is it possible? And also i am making discounts by pub...

Jump to post
  • Sat Nov 30, 2019 9:13 pm
  • Replies 11
  • Views 880
opencart book store, authors and publishers

Hello, I have an active online book store and I am planning to move my site to opencart. I m a web developer but new on opencart, and now testing my site on local host with opencart 3.0.2.0 with smart book theme https://themeforest.net/item/smartbook-opencart-theme-included-color-swatches/23201048 I...

Jump to post
  • Sat Nov 30, 2019 6:39 am
  • Replies 11
  • Views 880

Page 1 of 1

Search found 14 matches