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.



It's possible that the default value doesn't appear on your product configuration page.
If it doesn't appear you will have to edit the view "product / form" in HikaShop > Display > Views (backend template)

And add the lines: Before:

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.

Maybe a copy/paste of Xmap could help you ?
www.hikashop.com/en/support/documentatio...ation-with-xmap.html
Xmap will be able to produce a list of all the products in your shop and that link is clickable to go to the product page. So with a copy of HTML copy/paste and search&replace you should be able to get a listing of the product URLs with it.

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

Hi,

Thank you for your feedback.
Note that this thread is almost 3 years old.
Since then, there is an easy solution to do that in HikaShop.
Simply configure the "Force canonical URLs on listings" setting of the HikaShop configuration to generate them if missing and the system will automatically fill in the canonical URLs of the products when the listings are displayed on the frontend.
Then, when you run a normal export of the products in HikaShop, you'll be able to get the links in the product_canonical column of the CSV.
One thing though will be that the generated links will be relative and thus won't contain your domain name.
It it would be really easy to either have it done automatically with a batch replacement of the CSV, or even a small modification of the export view file generating the CSV in HikaShop.