Support is online

Existing Virtuemart Slug is not updated #7771

Open ptrouw opened this topic Wednesday, 28 October 2015 · 8 replies
Author

HI Roland,

I am trying to update virtuemart products; just 3 fields, SKU, name and slug.
It seems not to update alias/slug how can i force this?
I couldn't find an option for this?

Cheers Paul

Support

Hello Paul,

Post the information requested at the top of the page under Looking for a useful answer so I can check what is going on. Just make sure you have not set the Recreate alias to Yes in your template.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Hi Roland,

Sorry I don't understand you remark post in "Looking for a useful answer"!
Concerning the alias/slug, you mention "Recreate alias to Yes in your template". I am using 6.3.0 and Vm 3.0.10 and I can't find this option you mention. Not within the template and not with the template fields.

Support

Hello Paul,

Sorry I don't understand you remark post in "Looking for a useful answer"!

If you scroll to the top of this page you will find some text that starts with "Looking for a useful answer". This explains the information that you need to post in order for me to be able to help you. The bare minimum I need the debug log and a sample of your import file.

I can't find this option you mention.

In that case I don't think you changed it ;) It is on the Options tab when you click on the Advanced button.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Found it :)
With advanced I only saw the "limit" tab on and off!
Thx for your fast response.

Author

The automatic recreate of alias works fine.
But with 3 fields, SKU, name and slug, selected in my template I expected to able to use my own alias.
But not to worry.

Support

You should be able to use your own slug, that is why I am asking for the debug log and sample of the import file to see what happens in your case.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Here is the log and part of import file

Support

Hello,

Thanks for that, it has helped. So I see that your slug is indeed being used as set in the CSV file except for the last 2 products because they have the same slug and that is impossible. It would be the same as saying this 1 URL goes to 2 different products, simply impossible :)

The slugs needs to be unique, if you keep them unique your slugs will be used. This is the first product from the debug log:

UPDATE `xxxx_virtuemart_products_nl_nl` SET `product_s_desc`='',`product_desc`='<h1><span style=\"font-size: 16px;\"><strong>Alfa Romeo 146 \'94-\'01 stootlijst set</strong></span></h1>\r\n<p> </p>\r\n<p>Een stootlijst set van Car Parts Expert beschermt uw Alfa Romeo 146 effectief tegen deukjes en krasjes. Bovendien geven ze uw Alfa Romeo 146 een stoer uiterlijk. Al onze stootlijsten zijn kwalitatief hoogwaardige producten, vervaardigd uit PU of PP tenzij anders aangegeven. Klik <a href=\"index.php?option=com_content&view=article&id=94:assembly-clips-Car Parts Expert&catid=1:general&Itemid=152\" target=\"_blank\">hier</a> om te zien hoe u gemakkelijk en snel zelf een stootlijst set monteert.</p>\r\n<p> </p>\r\n<p>Elke stootlijst set wordt geleverd met complete montageset en duidelijke montagehandleiding. Montage is uiterst eenvoudig, doordat het product standaard is voorzien van stevig hechtende dubbelzijdige tape. Standaard worden onze stootlijst sets geleverd in matzwart, maar voor een extra luxe uitstraling kunnen we ze ook in elke gewenste carrosseriekleur leveren. Car Parts Expert biedt daarvoor een eigen spuitservice met unieke klanttevredenheidsgarantie.</p>',`product_name`='Alfa Romeo 146 1994-2001 5d stootlijst set zijportieren',`metadesc`='',`metakey`='',`customtitle`='',`slug`='alfa-romeo-146-1994-2001-5d-stootlijst-set-zijportieren' WHERE `virtuemart_product_id`='796'

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Log in to reply to this topic.