Special Offers issue

Open to all! Ask other shopowners for help.
Omar_one
Senior Contributor
Posts: 679
Joined: Fri Oct 25, 2019 5:06 pm
Phoenix Version: v1.0.8.16
Has thanked: 100 times
Been thanked: 56 times

Special Offers issue

Post by Omar_one »

Hello.
We have weird issue some customers contact us about products has offers as it's shown to them ... but when I visit the link it's shows without Special Offers,, and the customer send me a screenshot
415051764_1354152745276427_4943467083427445784_n.png
and same link its shows for me without Special Offers
offers.JPG
the product's has been of offers..
offers 2.JPG
and there is something weird,, there was not edit these products and it show on next screenshot Status Change data today 22.01.2024 .. and there has not one edit anything
offers 3.JPG
Btw this not first time we got email or messages from customers about this ,, but today I checked mere deeper .
any idea what's wrong ?

Omar
You do not have the required permissions to view the files attached to this post.


Join The Code Co-op to get access to your library in the Code Co-op Forum
User avatar
burt
Core Team
Posts: 4551
Joined: Tue Oct 29, 2019 9:37 am
Phoenix Version: v1.1.0.8
Has thanked: 252 times
Been thanked: 412 times

Re: Special Offers issue

Post by burt »

What's the URL of your specials page.
What version of Phoenix.
What addons.

--

Something changed the status.
Maybe an addon is interfering.

What addons do you have installed that might interfere with specials?

--

I do note that the specials end date is showing as 31 January 2023
So your special should turn off before it shows in the specials page.
User avatar
burt
Core Team
Posts: 4551
Joined: Tue Oct 29, 2019 9:37 am
Phoenix Version: v1.1.0.8
Has thanked: 252 times
Been thanked: 412 times

Re: Special Offers issue

Post by burt »

I know your URL, but many don't.

On your specials page right now there are 13 specials offers.

Hat You Neuleturbaani 0780
does not show as a special offer.
heatherbell
Senior Contributor
Posts: 2540
Joined: Mon Oct 07, 2019 4:39 am
Phoenix Version:
Has thanked: 35 times
Been thanked: 243 times

Re: Special Offers issue

Post by heatherbell »

I see that screenshot is a Search Result so cannot guess the URL but this - https://www.hattu.fi/turbaanit-c-1_21.html - shows no Specials for me.
Omar_one
Senior Contributor
Posts: 679
Joined: Fri Oct 25, 2019 5:06 pm
Phoenix Version: v1.0.8.16
Has thanked: 100 times
Been thanked: 56 times

Re: Special Offers issue

Post by Omar_one »

heatherbell wrote: Mon Jan 22, 2024 11:56 am I see that screenshot is a Search Result so cannot guess the URL but this - https://www.hattu.fi/turbaanit-c-1_21.html - shows no Specials for me.
here is the link

Code: Select all

https://www.hattu.fi/advanced_search_result.php?search_in_description=1&keywords=Neuleturbaani+
heatherbell
Senior Contributor
Posts: 2540
Joined: Mon Oct 07, 2019 4:39 am
Phoenix Version:
Has thanked: 35 times
Been thanked: 243 times

Re: Special Offers issue

Post by heatherbell »

Omar_one wrote: Mon Jan 22, 2024 12:06 pm here is the link
No Specials showing for me
Omar_one
Senior Contributor
Posts: 679
Joined: Fri Oct 25, 2019 5:06 pm
Phoenix Version: v1.0.8.16
Has thanked: 100 times
Been thanked: 56 times

Re: Special Offers issue

Post by Omar_one »

burt wrote: Mon Jan 22, 2024 11:42 am What's the URL of your specials page.
What version of Phoenix.
What addons.

--

Something changed the status.
Maybe an addon is interfering.

What addons do you have installed that might interfere with specials?

--

I do note that the specials end date is showing as 31 January 2023
So your special should turn off before it shows in the specials page.

Code: Select all

https://www.hattu.fi/specials.php?sort=2a&language=en
version 1.0.8.16

I find class file for that..

Code: Select all

  class adv_specials specials {
public function __construct() {
  	}
////
// Auto start products on special
    public static function start() {
      return tep_db_query("UPDATE specials SET status = 1, date_status_change = NOW() WHERE status = 0 AND NOW() >= start_date AND start_date > 0");
    }

  }
when the we refresh most of the time the products show normal price, the issue go after we refresh for a few time
Last edited by Omar_one on Mon Jan 22, 2024 12:15 pm, edited 2 times in total.
Omar_one
Senior Contributor
Posts: 679
Joined: Fri Oct 25, 2019 5:06 pm
Phoenix Version: v1.0.8.16
Has thanked: 100 times
Been thanked: 56 times

Re: Special Offers issue

Post by Omar_one »

heatherbell wrote: Mon Jan 22, 2024 12:08 pm
Omar_one wrote: Mon Jan 22, 2024 12:06 pm here is the link
No Specials showing for me
and for us but for some customers its shows there is Specials there
heatherbell
Senior Contributor
Posts: 2540
Joined: Mon Oct 07, 2019 4:39 am
Phoenix Version:
Has thanked: 35 times
Been thanked: 243 times

Re: Special Offers issue

Post by heatherbell »

Omar_one wrote: Mon Jan 22, 2024 12:12 pm and for us but for some customers its shows there is Specials there
If it was me, until the underlying issue is discovered, I'd delete those historical Specials. If they are not active, delete them.
User avatar
burt
Core Team
Posts: 4551
Joined: Tue Oct 29, 2019 9:37 am
Phoenix Version: v1.1.0.8
Has thanked: 252 times
Been thanked: 412 times

Re: Special Offers issue

Post by burt »

I don't know what adv_specials is.
I'd probably remove that as a first step and do some testing.

Put simple:
something is turning on/off specials.

That something is either a person (you) or an addon


Join The Code Co-op to get access to your library in the Code Co-op Forum
Post Reply