1. simonhodgkiss
  2. RO CSVI
  3. Friday, 11 September 2020
  4.  Subscribe via email
Product URL export.

Is there any way to export the full product URL out for Virtuemart Products?

I appear to be having mixed results with the product_url & slug exports.

I am moving my website and the products have a new URL so I was looking to export this data so I can create a list of 404 redirects?

Many thanks
Accepted Answer Pending Moderation
Hello Simon,

There is so much work involved it's really possible to wipe and start again.
I think you wanted to say that it isn't really possible ;)

Since this is a dev site, why is it so important to have the export spot on? There is clearly some data inconsistency going on. Since you know which products have issues, can you compare a couple with the live site? Perhaps that may shed some light without doing a full database dump and restore.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,
There is so much work involved it's really possible to wipe and start again.

Not really, you can export to get db dump of live site using PHPMyAdmin and import it on dev site using PHPMyAdmin. That would make the data same on live and dev site.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
The export would work if the data in the live site is same as the dev site. Is the data on the dev site been a test data for years? If yes then i would recommend cleaning the VirtueMart data and do a fresh import on your dev site.


The data has been imported over the last few months since January 2020.

I exported data out the live site to import into the dev website as part of the new website build.

There is so much work involved it's really possible to wipe and start again.
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
Yes, I've used CSVI since the days of Joomla 2.5 maybe even 1.5 I can't remember if the old name CSVI Improved was supported on Joomla 1.5.

Ok, older versions of CSV Improved has supported Joomla 1.5 version.

Is there any way you can take a look / get the export to work for?

The export would work if the data in the live site is same as the dev site. Is the data on the dev site been a test data for years? If yes then i would recommend cleaning the VirtueMart data and do a fresh import on your dev site.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Did you use RO CSVI to import the data from CSV sheets?


Yes, I've used CSVI since the days of Joomla 2.5 maybe even 1.5 I can't remember if the old name CSVI Improved was supported on Joomla 1.5.


Is there any way you can take a look / get the export to work for?
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
Product ID 360 plain URL is actually currently linked to the SEF version of the product ID 2915?

This is what makes me think that data is messed up. I have not seen your data or i don't know how it was imported to say how it got messed up.

I believe that I've been reading the database entries correct?

VirtueMart product id is the ID number shown in the backend product list right?

Yes correct. virtuemart_product_id is the ID value shown in the list.

In general terms, they are the same products just updated by CSV sheets and re-imported. What do you think could be messing up the data?

Did you use RO CSVI to import the data from CSV sheets?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,

Is the VirtueMart data on live and dev site the same? I am still thinking there is something wrong with data which is generating this wrong URLs.


The data has been downloaded and improved and re-imported into our new dev website.

In general terms, they are the same products just updated by CSV sheets and re-imported.


What do you think could be messing up the data?

Thanks for your help.
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
So I don't know why it doesn't work for my (Dev) website.

Is the VirtueMart data on live and dev site the same? I am still thinking there is something wrong with data which is generating this wrong URLs.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
I just imported the template above to my other (Live) website and tried it.

It worked spot on the URLs are correct.


So I don't know why it doesn't work for my (Dev) website.
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello,

1. In my reply earlier I had told about the Maintenance option to generate SEF URLs for products. Did you try that? Please check if you can see SEF URLs generate in #__csvi_sefurls table.


I did complete this and this shows the URLs but it appears to be completely incorrect.

- Missing the category name from the URL
- Some missing the category name & Product Slug part (I can accept some products in the database do not currently have a category so this will account for some of the gaps but not all of them.


2. Can you tell me one example product where you see the wrong URL? What is the expected URL for the product?


I've checked over the database table and the plain URL doesn't = sef url.

They don't match up at all.

I've checked a number of random entries.

Product ID 360 plain URL is actually currently linked to the SEF version of the product ID 2915?

- I believe that I've been reading the database entries correct?

VirtueMart product id is the ID number shown in the backend product list right?


3. Post your template XML file to check. To get your template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select your template and download the XML file. Post the XML file.


I have added it to here.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,
Any other ideas?

1. In my reply earlier i had told about Maintenance option to generate SEF URLs for products. Did you try that? Please check if you can see SEF URLs generate in #__csvi_sefurls table.
2. Can you tell me one example product where you see wrong URL? What is the expected URL for the product?
3. Post your template XML file to check. To get your template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select your template and download the XML file. Post the XML file.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello

The URL box is empty like shown above.

Any other ideas?

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,
There is nothing wrong i could see from debug log. With product_url, RO CSVI checks if there is a URL set in VirtueMart for a product in product edit page, uses it in export if available else product_url is generated based on the category set. Can you check if there is a URL set for products? See attached screenshot to know where you can find URL field in VirtueMart Products page. See if the URL is set correct and that is used in export.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello,

The URL's are missing the full path to the product?

Even if they are already listing in a category it appears to be missing?

Added the debug as well.

P.S I am aware that some products are not current assigned to categories but there are items which are assigned to categories which still don't show the correct URL.

Thanks
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello,
Is there any reason why the export would have gaps and not show the URL at all?

If the export does not show URL then it is possible that there is no category assigned to that product. May i know what you mean by export would have gaps?

Also, the URL's are not correct?

Can you post the debug log and also export file to check? To get the debug log check How to collect debug information? document.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello Tharuna,

Is there any reason why the export would have gaps and not show the URL at all?

Also, the URL's are not correct?

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello,
Yes, you can use product_url field in your VirtueMart Product export template to get the full product URL. In Export template on Options tab set Export SEF URLs to Yes and save the template. Export SEF URLs option in template gets the product_url as SEF version of URL, if this option is set to No, export will get plain URL for products.

RO CSVI does not generate SEF URLs by itself but Joomla does it for RO CSVI. So for each product on export, Joomla sends the request to Joomla and generates the SEF URL. This will take a lot of time when the number of products is more. To reduce this export time, RO CSVI has a Maintenance option to generate SEF URLs for products beforehand and use these generated SEF URLs on export. To index the SEF URLs, go to RO CSVI and select Maintenance from the left menu, select VirtueMart in the first dropdown, Refresh SEF URLs in the second dropdown, select the export template that you will use to export the products and click the Continue button in the toolbar. This will start the indexing of the SEF URLs. You can then run the export.
Kind regards,

Tharuna

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


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