Post by IT-Me-Up.co.uk » Fri Jan 31, 2025 10:34 pm

Hi,
Long story short, upgrade to 4.1.0.0 failed, so I restored my site and database files via my hosting sites backup manager (Hostinger).

Now when I import new products into my site, they do not show up on the home page under the 'Latest Product' section.
I have tried the following steps:
* Deleted and recreated the latest product extension
* Removed and re-added the Latest Product section in the Layout manager
* Checked SQL for product info, status = 1, date added = today, store Id = 0, quanity=1+ etc. etc.
* Re-run my XML import add-on to pull latest products from supplier

Nothing in the error logs about this, so asking on here for some support please.

SQL shows 15 new products since the start of the week:
SELECT p.product_id, pd.name, p.status, p.date_added, p.quantity, ps.store_id
FROM oc_product p
JOIN oc_product_description pd ON p.product_id = pd.product_id
LEFT JOIN oc_product_to_store ps ON p.product_id = ps.product_id
WHERE p.date_added >= '2025-01-27' and p.status = 1 and p.quantity > 0;

However the last newest product on my site is from the date of my backup (13th Jan)

Also removed any VQMod XMLs as a test, but no luck.

Any other ideas please?

Please Check Out My Site:
https://www.IT-Me-Up.co.uk/


New member

Posts

Joined
Thu Sep 21, 2017 4:27 pm

Post by ADD Creative » Sat Feb 01, 2025 1:38 am

What version did you restore to? Have you cleaned the cache files from the storage/cache directory?

www.add-creative.co.uk


Guru Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by IT-Me-Up.co.uk » Sat Feb 01, 2025 2:17 am

I restored back to 4.0.2.3
Cache has been cleared from Admin dashboard as well as from the Hostinger portal / CDN
Deleted the VQMod cache as well.

Please Check Out My Site:
https://www.IT-Me-Up.co.uk/


New member

Posts

Joined
Thu Sep 21, 2017 4:27 pm

Post by ADD Creative » Sat Feb 01, 2025 8:28 pm

But have you cleaned the cache files from the storage/cache directory?

www.add-creative.co.uk


Guru Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by IT-Me-Up.co.uk » Mon Feb 03, 2025 8:02 pm

Hi,
Yes I have cleared the Storage/Cache and tried to re-import products but the home page does not change.

Please Check Out My Site:
https://www.IT-Me-Up.co.uk/


New member

Posts

Joined
Thu Sep 21, 2017 4:27 pm

User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by JNeuhoff » Mon Feb 03, 2025 8:50 pm

IT-Me-Up.co.uk wrote:
Mon Feb 03, 2025 8:02 pm
Hi,
Yes I have cleared the Storage/Cache and tried to re-import products but the home page does not change.
Re-importing products won't restore the home page. The Home Page contents is usually made up of HTML modules, see the design > layouts for the home page for more details which ones it uses, and then restore them from a backup database.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by IT-Me-Up.co.uk » Mon Feb 03, 2025 9:31 pm

I've tried to delete all the componets of the home page layout and add them back but the lastest product section still shows old items.

Please Check Out My Site:
https://www.IT-Me-Up.co.uk/


New member

Posts

Joined
Thu Sep 21, 2017 4:27 pm

Post by by mona » Mon Feb 03, 2025 10:54 pm

Often this is a caching issue.
Have you cleared ALL your cache, including any caching you have on your server?
Also => viewtopic.php?f=201&t=207498#p737358

Double check the dates in the database

DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by IT-Me-Up.co.uk » Mon Feb 03, 2025 11:57 pm

Hi,
I'm fairly certain I have cleared down all caches.
In v4.0.2.3 this line already exists in system/framework.php

Code: Select all

$response->addHeader('Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0');
$response->addHeader('Pragma: no-cache');

Please Check Out My Site:
https://www.IT-Me-Up.co.uk/


New member

Posts

Joined
Thu Sep 21, 2017 4:27 pm

Post by by mona » Tue Feb 04, 2025 12:39 am

Apologies, I thought you returned back to OC3.0.4.0 - I see it is still OC4 -
That could be anything ..

DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by JNeuhoff » Tue Feb 04, 2025 12:40 am

IT-Me-Up.co.uk wrote:
Mon Feb 03, 2025 9:31 pm
I've tried to delete all the componets of the home page layout and add them back but the lastest product section still shows old items.
In PHPMyAdmin run this query:

Code: Select all

SELECT * FROM `oc_product`  
ORDER BY `oc_product`.`date_added`  DESC
Do the results match up with the expected ones?

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by JNeuhoff » Wed Feb 05, 2025 9:05 pm

@ikonicdev: Please don't use generic AI posts, the OP needs genuine support.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by paulfeakins » Thu Feb 06, 2025 7:48 pm

JNeuhoff wrote:
Wed Feb 05, 2025 9:05 pm
@ikonicdev: Please don't use generic AI posts, the OP needs genuine support.
Deleting their post and issuing a warning as their services list Shopify and WooCommerce but not OpenCart.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom
Who is online

Users browsing this forum: Balramsaini@123 and 5 guests