Search found 51 matches

Search found 51 matches

Will adding FULLTEXT to a few opencart database columns potentially break my site?

Hi, Will adding fulltext index to opencart database break anything? I'd like to do this: ALTER TABLE oc_product_description ADD FULLTEXT(name, description) Will this potentially break anything on opencart? It's a big opencart 2.3 site (30k items) with a bunch of plugins, etc. I'm going to add a cust...

Jump to post
  • Tue Jan 11, 2022 8:37 am
  • Replies 2
  • Views 541
2 separate customers order same quantity=1 item, both orders are processed. results in negative quantity

Hi everyone, My client has a very busy opencart site. If we have, for example, a qty=8 item and three different customers put 5 each in their carts and checkout at around the same time, then suddenly we have a -7 quantity and the site owner has to email one of the customers and apologize, cancel the...

Jump to post
  • Wed Nov 25, 2020 10:35 am
  • Replies 1
  • Views 536
Re: OC2.3, main page won't use the cookie currency value

Thanks for the reply. One step closer to a solution. Where are the session values stored for Opencart?

Code: Select all

print_r($_SESSION);
does not return any values.

Thanks,

Takayuki

Jump to post
  • Fri Sep 04, 2020 9:17 am
  • Replies 3
  • Views 527
OC2.3, main page won't use the cookie currency value

Hi, If I change the cookie currency value from USD to JPY, for example, from an external myOCsite.com/currencyswitch.php page like this: $ccode='JPY'; setcookie('currency', $ccode, time() + 60 * 60 * 24 * 30, '/', ".myOCsite.com"); I can verify the currency value is set to JPY in the cooki...

Jump to post
  • Thu Sep 03, 2020 11:56 am
  • Replies 3
  • Views 527
Re: [SOLVED] - how to grab product id, UPC, SKU, etc. data for product.tpl page??

I can't get the upc value doing what I described below. Is there anything else I need to do in the product.php page?

I'm trying to access the upc value in the product.tpl page via $upc.

Any thoughts here as to what is wrong?

thanks

Jump to post
  • Thu May 21, 2020 11:44 am
  • Replies 4
  • Views 772
Re: how to grab product id, UPC, SKU, etc. data for product.tpl page??

thanks for the reply, but can you be more specific? :choke: do you mean add an entry to the array here in the controller/product/product.php page? line 440: $data['products'][] = array( 'product_id' => $result['product_id'], 'thumb' => $image, 'name' => $result['name'], 'upc' => $upc and then grab t...

Jump to post
  • Mon May 18, 2020 5:37 pm
  • Replies 4
  • Views 772
[SOLVED] - how to grab product id, UPC, SKU, etc. data for product.tpl page??

Hi,
I'd like to add the UPC, SKU and some other product data (also the product id) to each product page.

I'm editing the product.tpl page here: /catalog/view/theme/journal2/template/product

Any help here appreciated.

Dave

Jump to post
  • Mon May 18, 2020 12:55 pm
  • Replies 4
  • Views 772
Re: OC 2.3, can't get htaccess 301 redirects to work

thanks for your help, UKsitebuilder. unfortunately, i still get the wonky URL with the route=blahblah tacked on which 404s it.

I think you are right, there has to be another variable affecting things. it *should* work.

Jump to post
  • Sun Mar 22, 2020 8:54 am
  • Replies 4
  • Views 736
Re: OC 2.3, can't get htaccess 301 redirects to work

Thanks for the reply. Here's the full file # SEO URL Settings RewriteEngine On RewriteBase / RewriteRule ^sitemap.xml$ index.php?route=extension/feed/google_sitemap [L] RewriteRule ^googlebase.xml$ index.php?route=extension/feed/google_base [L] RewriteRule ^system/download/(.*) index.php?route=error...

Jump to post
  • Sat Mar 21, 2020 9:11 pm
  • Replies 4
  • Views 736
OC 2.3, can't get htaccess 301 redirects to work

Hi, I'm trying to do a simple 301 redirect via htaccess with my Opencart 2.3 site. old url: http://domain.com/PokPlushToy/PlushToys/ChikoPlush the url I want to redirect to: https://domain.com/PokPlushToy Here's my rewrite rule: RewriteRule ^PokPlushToy/PlushToys/ChikoPlush$ index.php?route=category...

Jump to post
  • Sat Mar 21, 2020 12:13 pm
  • Replies 4
  • Views 736
Re: Sending Gift Certificate recipient email automatically

I've got the same issue with 2.3.0.2, too. Anyone got a fix?

Jump to post
  • Thu Dec 27, 2018 11:30 am
  • Replies 12
  • Views 2962
2.3.0.2: gift voucher works but doesn't send the recipient an email

Hi,

Customers can order a gift voucher and the order gets processed, but the recipient never gets an email.

Does anyone have a fix for this?

thanks,

Takayuki

Jump to post
  • Tue Dec 18, 2018 12:15 pm
  • Replies 0
  • Views 689
[bugfix] orders to "missing", items not subtracting: bug in /catalog/model/checkout/order.php

on a fresh 2.3.0.2 install orders were going straight to missing status and item qty was not subtracting. PHP Fatal error: Call to a member function check() on a non-object in /catalog/model/checkout/order.php on line 267 the fix: $fraud_status_id = $this->{'model_fraud_' . $extension['code']}->chec...

Jump to post
  • Thu Oct 11, 2018 7:44 am
  • Replies 3
  • Views 2847
Re: OC 2.3 Paypal Standard IPN URL??

Thanks so much for all of your help trying to find the problem. I went as far as I could go with it and then got some help from Zuma Design. He found a bug in order.php. PHP Fatal error: Call to a member function check() on a non-object in /usr/www/users/chickasaw/octwo.pokevault.com/catalog/model/c...

Jump to post
  • Thu Oct 11, 2018 7:36 am
  • Replies 8
  • Views 4757
Re: OC 2.3 Paypal Standard IPN URL??

Thanks again for your tips. I checked the logs and I've gotten 12 PP_STANDARD :: IPN REQUEST: (data here) which all look fine. And it also shows 12 PP_STANDARD :: IPN RESPONSE: VERIFIED messages. So it looks like the PP standard module is doing it's thing just fine, but all orders still go to missin...

Jump to post
  • Tue Oct 09, 2018 8:59 am
  • Replies 8
  • Views 4757
Re: OC 2.3 Paypal Standard IPN URL??

Great idea. I checked the IPN history and ran a test order and got a 200 response code and everything else looked fine. Orders show up in the dashboard, but in the Orders section they go in as missing. Paypal processes everything fine. But item quantity is not subtracted, even though I've got each p...

Jump to post
  • Mon Oct 08, 2018 7:39 pm
  • Replies 8
  • Views 4757
Re: OC 2.3 Paypal Standard IPN URL??

Thanks for the reply. Paypal standard works great on my main site, but on the site I'm about to move to, currently sitting on a subdomain (newsite.mydomain.com), paypal tests fail. Orders get processed at paypal but then all orders go to missing status and item qty does not get subtracted. I've doub...

Jump to post
  • Sat Oct 06, 2018 5:51 am
  • Replies 8
  • Views 4757
OC 2.3 Paypal Standard IPN URL??

Hi,

What URL should I use for the paypal IPN in my paypal acct settings?


thanks

Jump to post
  • Thu Oct 04, 2018 1:56 pm
  • Replies 8
  • Views 4757
Re: 2.2 and 2.3 database exactly the same?

good way to do it, Ernie. thanks. ;D

Jump to post
  • Tue Feb 13, 2018 9:53 am
  • Replies 2
  • Views 316
2.2 and 2.3 database exactly the same?

Are the 2.2 and 2.3 databases exactly the same? thanks.

Jump to post
  • Sun Feb 11, 2018 12:36 pm
  • Replies 2
  • Views 316

Search found 51 matches