Search found 101 matches

Search found 101 matches

Re: GetProducts() where p.model is not equal to string

wrong place insert before if (!empty($data['filter_manufacturer_id'])) { this code if (isset($data['filter_shop']) && $data['filter_shop'] == 'shop') { $sql .= " AND p.model <> '" .$data['filter_shop'] . "' "; } insert this twice, in getProducts and in getTotalProducts for correct pagination Works ...

Jump to post
  • Sun Oct 25, 2020 7:54 pm
  • Replies 3
  • Views 150
[SOLVED] GetProducts() where p.model is not equal to string

I am trying to add a custom filter to differentiate between products. In the controller I am not filtering categories so the getProducts function will go through all products and I am passing in a custom filter "filter_shop": $filter_featured = array( 'filter_shop' => 'shop', 'sort' => '$sort', 'sta...

Jump to post
  • Sun Oct 25, 2020 6:37 pm
  • Replies 3
  • Views 150
Re: Can't save with iframe?

If I simply put <iframe> without the video link, etc it takes me to a 404 page when saving. if your html is solid then your host does not allow iframes in the html body, ask them. Would my host not block me completely then? I can add the iframe to the description within the database and it works fi...

Jump to post
  • Thu Oct 15, 2020 3:03 pm
  • Replies 9
  • Views 1379
Re: Can't save with iframe?

I know the classic editor has video and you can paste in a youtube link and it will display the video and if you view code view it shows the iframe. I have removed summernote so that it is just a textarea field. This allows me to just work in code view and has been better for me so far - I have more...

Jump to post
  • Thu Oct 15, 2020 2:41 pm
  • Replies 9
  • Views 1379
Can't save with iframe?

What would be stopping me from saving information or product with an iframe in description? It is taking me to a 404 if I try to save. I've tried removing the javascript files from the information_form.twig, doesn't affect it. Also looked at information.php in the controller, validate form function ...

Jump to post
  • Sat Oct 10, 2020 1:29 am
  • Replies 9
  • Views 1379
Re: Hourly or Daily Product Views

Thank you letxobnav for all the help and for explaining each bit - I have learnt a lot!

Scott

Jump to post
  • Sat Aug 22, 2020 5:07 pm
  • Replies 10
  • Views 495
Re: Hourly or Daily Product Views

I've passed in session_id value too. Is there a way of counting total WHERE product_id = '". $product_id WHERE session_id is unique? view_id 1 expires 2020-08-21 19:00:54 product_id 2199 session_id e88605e39e79b6d4ea9a5b3f76 view_id 2 expires 2020-08-21 19:00:54 product_id 2199 session_id e88605e39e...

Jump to post
  • Sat Aug 22, 2020 5:19 am
  • Replies 10
  • Views 495
Re: Hourly or Daily Product Views

Thanks for such a detailed response! That has really helped me. You don't think it will be greedy on resources counting the records of how many rows with product_id = x to get the viewed total over a period? Also would I not need a cron job to check if records date expired to delete them from the ta...

Jump to post
  • Fri Aug 21, 2020 2:13 am
  • Replies 10
  • Views 495
Hourly or Daily Product Views

I've seen on a few e-commerce websites that when I go onto a product it says "2 other people viewing this product" or "30 product views in the past hour". I'm trying to think of a way to do this with my Opencart website. Currently Opencart has product views, my idea would be to store the total and t...

Jump to post
  • Thu Aug 20, 2020 12:10 am
  • Replies 10
  • Views 495
Re: Where does the checkout get the product data from?

Johnathan wrote:
Wed Aug 19, 2020 2:45 am
This file is the one that builds the order and calls that addOrder() function:

/catalog/controller/checkout/confirm.php
This is what I was looking for! ;D

Thank you

Jump to post
  • Wed Aug 19, 2020 4:52 am
  • Replies 3
  • Views 175
Where does the checkout get the product data from?

What sends the carts product data to the checkout?

Seems to be class Model Checkout Order function addOrder(). But I don't see any code that uses addOrder in cart.php, etc.

Is it from the session?

Jump to post
  • Wed Aug 19, 2020 12:25 am
  • Replies 3
  • Views 175
getOrder() - product quantity?

in ModelCheckoutOrder getOrder($order_id) function doesn't have a value for quantity. I am basically trying to do the following in the getOrder function: return array( 'order_id' => $order_query->row['order_id'], .... 'total' => $order_query->row['total'], .... change to: 'total' => 100 * product qu...

Jump to post
  • Tue Aug 18, 2020 4:44 am
  • Replies 1
  • Views 228
Javascript not updating page

Just wondering if anyone knows what might be blocking page from reloading.

For example if I click add to cart, it goes to shopping cart which is empty unless refreshed.

Or if I remove product, it does nothing but on refresh its removed.

Any ideas? :-)

Jump to post
  • Tue Aug 18, 2020 2:33 am
  • Replies 1
  • Views 129
Zones for guest payment address not showing in select

Is there any reason for zones (counties, regions, states) for guest payment address not to showing options (empty) in the select on a clean opencart? Any idea what could cause it?

Cheers!

Jump to post
  • Sat Aug 01, 2020 7:36 pm
  • Replies 2
  • Views 206
Import products from affiliate & cron job

Looking for a clean opencart install with option for products to be imported from csv files (I've seen extensions for this) but the csv files will come from an affiliate website. I would then need a cron job to check for new products / changes in products. Not sure if the best way would be to delete...

Jump to post
  • Wed May 06, 2020 3:19 am
  • Replies 7
  • Views 482
Re: Account - Add an Affiliate (SMTP ERROR)

yep, looks like it. you could try replacing the smtp class with the one from version 3.1.0.0. It is basically the same but it has a function (handleReply) which promises to handle the replies better from slow mail server responses. you can set the attempts counter in the class. Not sure this is you...

Jump to post
  • Sat Apr 04, 2020 11:24 pm
  • Replies 21
  • Views 2072
Re: Account - Add an Affiliate (SMTP ERROR)

are you sure you have the right DATA not accepted from server line? there are two in there. I think so? Uncaught exception 'Exception' with message 'Error: DATA nnot accepted from server!' in /system/library/mail/smtp.php:328 Line 328 in SMTP: if (substr($reply, 0, 3) != 250) { throw new \Exception...

Jump to post
  • Sat Apr 04, 2020 10:54 pm
  • Replies 21
  • Views 2072
Re: Account - Add an Affiliate (SMTP ERROR)

mail parameter is only used for php mail, not smtp. you could try throw new \Exception('Error: '.$reply.' DATA not accepted from server!'); to show the entire reply to the period. could just be a timeout issue. Getting nothing for '.$reply.' too. Is timeout something that I will be able to fix? Or ...

Jump to post
  • Sat Apr 04, 2020 10:40 pm
  • Replies 21
  • Views 2072
Re: Account - Add an Affiliate (SMTP ERROR)

PM sent, thanks for helping me! I have just done some extra tests. If I create an account through affiliate/register it makes a new customer and adds affiliate details to `oc_customer_affiliate`. If I delete its entry in `oc_customer_affiliate`and go to account/affiliate/add I am able to add it back...

Jump to post
  • Sat Apr 04, 2020 10:31 pm
  • Replies 21
  • Views 2072
Re: Account - Add an Affiliate (SMTP ERROR)

must be null as it's not changing the error message. Why would it return null? Could this be the issue? Your mail parameter is also empty in the form. Some servers still may require you enter your outgoing mail. address in the Mail Parameter of your OC Mail form. Same error :( throw new \Exception(...

Jump to post
  • Sat Apr 04, 2020 10:13 pm
  • Replies 21
  • Views 2072

Search found 101 matches