export product url from front end

Hello,
Is it possible to export the product url's of the products?

Hello Boudewijn,

I don't really understand your question but you can for example have the link of every product through the "Add to cart HTML link" button in your product page.

Hello Mohamed,
There are product sites like google products where I can upload my products.
But these site need a productlist in csv with different product information. And also the url to the product on my website.
Does this give you more information?

Hi Boudewijn,

Actually there is no export for the url of the product.
But you can do it manually by creating a custom field, for example "url", with the type "product" and for each products add the url of the product, you can find it through the "Add to cart HTML link" button, in the url custom field of the product.

Then when you export a product, the url is in the .csv file.

Hello Mohamed,
The first step I understand.
I created in custom field a field called product_url
But then? could you describe a bit more specific?

Hi Boudewijn,

You can set a default value in your custom field "product_url", like: " yousite.com/index.php?option=com_hikasho...oduct&task=show&cid= "
And in the product edition page, just add the cid at the end of the url. You can find this url in your browser address bar.

									<?php
										if(!isset($this->element->$fieldName))
											$this->element->$fieldName = $oneExtraField->field_default;
									?>

									<?php $onWhat='onchange'; if($oneExtraField->field_type=='radio') $onWhat='onclick'; ?>
									<?php echo $this->fieldsClass->display($oneExtraField,$this->element->$fieldName,'data[product]['.$fieldName.']',false,' '.$onWhat.'="hikashopToggleFields(this.value,\''.$fieldName.'\',\'product\',0);"'); ?>

Hello Xavier,
Thanks for your information. But my knowlegde is to low and I have to many products to maintain this.

I have taken a look at the google products file. And as I see it has all the information in it.
But I need it as a straight table.
There is another topic on this as well
www.hikashop.com/en/forum/4-how-to/65563...t-my-export-csv.html
Is there some way to get the google products file set as a table?
Then I think a lot is solved.

For a backlink from a price comparison page, you can directly link to a product id via the Joomla / HikaShop controller, e. g. for product ID 1717:

shop.smartgart.com/en/?option=com_hikash...roduct&task=show&cid []=1717

PHP wise, this is:

$table1 = "joomla_hikashop_price";
$table2 = "joomla_hikashop_product";
$table3 = "joomla_hikashop_category";
$join1 = "price_product_id = product_id";
$join2 = "product_manufacturer_id = category_id";
$order1 = "category_name";
$order2 = "product_name";
$exportfile = '/xxx/export-prices-geizhals.csv';

$rows = $mysqli->query("SELECT * FROM $table1, $table2, $table3 where $join1 and $join2 ORDER BY $order1, $order2");
// table does not exist
if($mysqli->errno == 1146) {
printf("%d: %s<br>/n", $mysqli->errno, $mysqli->error);
} else {
$myfile = fopen($exportfile, "w");
fwrite($myfile, "Produktbezeichnung;Herstellername;Preis;Deeplink;Herstellernummer;Verfügbarkeit;Versand Vorkasse;Versand Nachnahme\n");
while($obj = $rows->fetch_object()) {
$deeplink = ' shop.smartgart.com/en/?option=com_hikash...roduct&task=show&cid []=' . $obj->product_id;
fwrite($myfile, "$obj->product_name;$obj->category_name;" . round($obj->price_value * 1.19, 2) . ";$deeplink;$obj->product_manufacturer_id;auf Bestellung;6;12\n");
} // while
fclose($myfile);
$rows->close();

best regards

Klaus