1. ptrouw
  2. RO CSVI
  3. Wednesday, 28 October 2015
  4.  Subscribe via email
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
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Found it :)
With advanced I only saw the "limit" tab on and off!
Thx for your fast response.
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Here is the log and part of import file
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


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