Export product descriptions in other languages

[gaiuspahk]

Hi there!

 

Since Cloud is getting shut down by February, I already started migrating to the download version. Everything else I'm pretty much willing to do from scratch, but I have over a hundred products and I do not wish to reenter them one by one once again. Not really familiar with SQL, but managed to create a .CSV file of my products with a query found on the web. Problem - this query is looking for product descriptions etc in English. Mine are in Estonian. How exactly do I have to change the code for it save Estonian (ET) descriptions?

 

Also, the CSV file included product images, but only a name for the image. But how is it possible to move the actual image files from one store to another?

 

Keep in mind - I'm migrating from the Cloud version - so the free modules for export are not an option.

 

 

Thanks in advance

SELECT p.id_product, p.active, pl.name, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") as categories, p.price, p.id_tax_rules_group, p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier, p.id_manufacturer, p.upc, p.ecotax, p.weight, p.quantity, pl.description_short, pl.description, pl.meta_title, pl.meta_keywords, pl.meta_description, pl.link_rewrite, pl.available_now, pl.available_later, p.available_for_order, p.date_add, p.show_price, p.online_only, p.condition, p.id_shop_default
FROM ps_product p
LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)
LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product)
LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category)
LEFT JOIN ps_category c ON (cp.id_category = c.id_category)
LEFT JOIN ps_product_tag pt ON (p.id_product = pt.id_product)
WHERE pl.id_lang = 1
AND cl.id_lang = 1
AND p.id_shop_default = 1
AND c.id_shop_default = 1
GROUP BY p.id_product

 

[Iryna]

Hello! 

 

You can consider using Store Manager for PrestaShop. It is compatible with PrestaShop Cloud (works via Bridge Connector) and has export facility that allows to transfer multilingual product details to .csv.

 

Export  allows also to write full image path (URL to image) in the result file, so you can further import images from URLs to new store using this it. For that you  need to enable "Export image filename with full HTTP path" in the export wizard (see the screenshot attached). Here is the tutorial, you can look through - https://www.prestashopmanager.com/useful-articles/prestashop-product-management/prestashop-export-products/

 

 

Store Manager is paid application, but also there is free 30-day trial, you can use to transfer data to new store - https://www.prestashopmanager.com/free-download/

[gaiuspahk]

Thank you for the reply.

 

Downloaded the store manager and it looks very promising. Exported file seemed to have everything I need. With product images, I used the download option and it saved all of the product images to a single folder. I didn't use the URL method, because the old store won't be up for long and my guess would be that the links to images would stop working along with the old store.

 

Now, this leads me to another question - How to upload these images to the new store so that Prestashop would recognize them? Aren't product images stored in separate folders for each product? Store manager downloaded them as on folder.

 

Also, I have a lot of images and videos in product descriptions.

 

Example: https://autocare.ee/pesemisvahendid/126-chemical-guys-honeydew-snow-foam-auto-wash-cleanser-3780-ml.html

 

Videos are not an issue, these are all embed videos from youtube. But how to import the images? These are all uploaded to the current store.

 

These should all be in a single folder (https://autocare.ee/img/cms/), so my quess would be to download and upload the folder through FTP and done. But since I'm using cloud, I can only access a handful of folders through FTP and this is not one of them. Any thoughts? Adding these images to product descriptions was the most time consuming part when I entered the products for the first time, so I really really wouldn't wan't to do that again.

[Iryna]

Hi

 

If your new store is running now, you can import images from URL, that you have exported from Cloud store. 

 

Although you can download all images in the process of export to local folder. For that you need to enable "Download product images to the following directory" option in the wizard and select local folder these images will be stored in after export (see the screenshot attached). Further you will be able to import these images to new PrestaShop store, having their names in the file and images themselves stored locally. In the import wizard you will have to specify local folder name. 

As to images in descriptions, when you export descriptions with Store Manager, you will get URL to images, as you have indicated. You may ask for permissions to img/cms folder and copy images, you use in descriptions. Further you can transfer images to new FTP. When importing data to new store, you can use expression to substitute part of image URLs  with new store address. Since images will be already on FTP, you will get them in descriptions on new store.  

Edited December 1, 2016 by Iryna (see edit history)