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/
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/
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/
https://www.antropy.co.uk/blog/how-to-c ... t-3-0-2-0/
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
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.IT-Me-Up.co.uk wrote: ↑Mon Feb 03, 2025 8:02 pmHi,
Yes I have cleared the Storage/Cache and tried to re-import products but the home page does not change.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Please Check Out My Site:
https://www.IT-Me-Up.co.uk/
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
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/
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
In PHPMyAdmin run this query:IT-Me-Up.co.uk wrote: ↑Mon Feb 03, 2025 9:31 pmI'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.
Code: Select all
SELECT * FROM `oc_product`
ORDER BY `oc_product`.`date_added` DESC
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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
Users browsing this forum: Balramsaini@123 and 5 guests