Categories
View Replies (1)

Resolved split export for Google Merchant center

  1. New
  1. baroen
    baroen
  2. RO CSVI
  3. Monday, 11 August 2025
  4.  Subscribe via email
I have around 3400 products in my Virtuemart database that needs to be processed in order to create a Google Merchant file.
It takes CSVI around 0,36 seconds per record. So for the whole products table it would approx. take 1200 seconds (20 minutes).
Not a real problem as I run the CRON at night, but I doubt this (setting the max execution time to 1200) is the best approach on this. Wouldn't it be better to somehow split up the export in multiple pieces, but still resulting in one file? (I understand that Google like to receive the main feed in one big file)
0
Responses (1)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
3400 products is not a big number to take 20 minutes to export. In Google merchant export template the field which can take time in export is product_url field and that is when SEF URLs are generated. To avoid this we have an option in RO CSVI Maintenance page to generate SEF URLs before hand and then use them in export. To do that in CSVI Maintenance page, select VirtueMart in first option, Refresh SEF URL's in second option. Select the export template and set Empty SEF cache to Yes. Click continue. This will generate SEF URLs for products and save them to database and when export runs these URLs are read and used from database. Run this maintenance option and then run the export. See if that makes any difference.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 1 day ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!