Search found 48 matches

Search found 48 matches

Add delivery address city to admin view of orders

Hi there, After we've sent our product i have to send our customers the track & tracecode. It would save me a lot of time if i would be able to add the city of the delivery address to the admin overview of all the orders so i can match my shipping receipts to the orders fast. Anyone know how to do t...

Jump to post
  • Thu Jan 10, 2019 5:14 pm
  • Replies 1
  • Views 107
Re: Opencart 2 mobile view layout order

Hi there, great stuff but what do i put in the code when i want the following on my MOBILE product page. I think it is better to have the add to cart button directly in view in stead of below the fold. >>>title<<< image product code/reward points/availability price quantity add to cart description r...

Jump to post
  • Thu Sep 20, 2018 4:33 pm
  • Replies 2
  • Views 887
Re: Change currency decimal point for structured data problem

I found that this code changes the comma to a point but then on my product page is it also changed, so close but no cigar..... <meta property="product:price:amount" content="'.preg_replace( '/[^.,0-9]/', '',($data['special'] ? $data['special'] : $data['price'] = str_replace(",", ".", $data['price'])...

Jump to post
  • Thu Aug 30, 2018 10:18 pm
  • Replies 5
  • Views 364
Re: Change currency decimal point for structured data problem

I have purchased SEO pro pack wich amongst other things has a structured data option. Off-course i want to use this but google don't validate the price because of the comma in stead of a point. Contact the extension developer to resolved this issue, since your request is about editing a licensed di...

Jump to post
  • Thu Aug 30, 2018 9:49 pm
  • Replies 5
  • Views 364
Change currency decimal point for structured data problem

Hi there, I am on opencart 2.3.0.2 with default theme. I have a problem. In Europe we use a comma in stead of a point as decimal point in our prices. So we use € 19,95 in stead of € 19.95 I have purchased SEO pro pack wich amongst other things has a structured data option. Off-course i want to use t...

Jump to post
  • Thu Aug 30, 2018 7:54 pm
  • Replies 5
  • Views 364
Re: PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row

Solved!

restored the url_alias part with phpmyadmin from a backup and everything seems to work ok now.

Just lost my homepage layout wich is strange but i can restore that pretty quick

Jump to post
  • Wed Aug 15, 2018 4:32 pm
  • Replies 18
  • Views 1306
Re: PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row

As an addition to the above i found this: http://trueliarx.blogspot.com/2017/03/check-for-duplicate-entries-in-url.html When i run this query i get a whole list of products and categories apperently having something larger then 1. (they all have 2, guess it should be 1) SELECT `query`, COUNT(*) FROM...

Jump to post
  • Tue Aug 14, 2018 5:24 pm
  • Replies 18
  • Views 1306
Re: PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row

Was able to find this error in my server log when editing product: [Tue Aug 14 09:17:42.990556 2018] [fcgid:warn] [pid 88885:tid 140543510062848] [client 83.82.250.9:62881] mod_fcgid: stderr: PHP Fatal error: Uncaught Exception: Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT...

Jump to post
  • Tue Aug 14, 2018 4:18 pm
  • Replies 18
  • Views 1306
Re: PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row

Allright, Anybody able to commercially help me solve this issue? Please contact me

Jump to post
  • Tue Aug 14, 2018 3:15 pm
  • Replies 18
  • Views 1306
Re: PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row

Hi again, I was able to track the querys that were send to the database and i see that there are double querys sent when i try and get the packing slip opened. Any suggestions? Am i on the right track? Here is what i found: SELECT * FROM oc_setting WHERE store_id = '0' SELECT * FROM `oc_language` WH...

Jump to post
  • Thu Aug 09, 2018 11:17 pm
  • Replies 18
  • Views 1306
Re: PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row

straightlight wrote:
Thu Aug 09, 2018 8:06 pm
I've searched the forum and found something about maybe double entries in the database
Source unprovided. Forum rules.
Original post edited, thanks for the heads up

Jump to post
  • Thu Aug 09, 2018 8:20 pm
  • Replies 18
  • Views 1306
PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row

Hi all, I am running opencart 2.3.0.2 with the default theme on a hosted linux server and am having the following problem which wasn't there before: When i try to edit a product or when i click on the button to make a packing slip i get a blank screen. Chrome browser gives http error 500 The error l...

Jump to post
  • Thu Aug 09, 2018 7:05 pm
  • Replies 18
  • Views 1306
Import email addresses for newsletter in 2.3.0.2

Hi there, i have recently migrated from zen cart to opencart and did not migrate my customers. (tried to but failed..........) Now i was wondering if there is a way to import the email adresses of my newsletter subscribers using phpmyadmin or something else.

Thanks for your help!

Jump to post
  • Wed Aug 08, 2018 11:26 pm
  • Replies 1
  • Views 154
Re: Looking for adding attachment to customer mail when i set order on shipped

I know it is not automated but it gives me the possibility to send attachments when i update the order.

Jump to post
  • Tue Jul 10, 2018 3:22 pm
  • Replies 5
  • Views 422
Looking for adding attachment to customer mail when i set order on shipped

Hi all,

I am on opencart 2.3.0.2 and i would like to send my customers a ebook in pdf format when i set the order on shipped. That way they can read about my product in anticipation of the package to arrive.

Anyone able to point me in the right direction to do this?

Thanks

Jump to post
  • Sat Jul 07, 2018 6:41 pm
  • Replies 5
  • Views 422

Search found 48 matches