Custom PHP development on Prestashop webshop

Requests 1/ Write a small PHP script that exports products in a csv file on the server. Format: EAN code;SKU Code;Name;Deeplink;Price;Delivery Time;Transportation costs Example: 4960999975269;8331B006;Canon PIXMA MG3550;[login to view URL] [login to view URL];81,36;Levering verwacht binnen 3 dagen;0,00 EAN Code: Field ean13 from ps_product SKU Code: Field reference from ps_product Name: Field name from ps_product_lang Deeplink: “http:/[login to view URL]” + id_product from ps_product + “-” + field link_rewrite from ps_product_lang Price: field price from ps_product + 21% Delivery Time: Fixed value “Levering verwacht binnen 3 dagen” Trasportation costs: Fixed value: “0,00” Only Dutch and active products to select: WHERE [login to view URL] = 1 AND b.id_lang = 4 Select statement should look more or less like this: SELECT [login to view URL],[login to view URL],[login to view URL],b.link_rewrite,[login to view URL],"Levering verwacht binnen 3 dagen","0,00" from a.ps_product, b.ps_product_lang WHERE a.id_product = b.id_product AND [login to view URL] = 1 AND b.id_lang = 4 2/ Icecat import for Prestashop language ID 5,6 and 7 Currently updates name, short_description, long_description, meta_data, link_rewrite etc for Prestashop languages with ID 1 to 4: 1 => EN 2 => FR 3 => NL 4 => DE I have 7 countries in Prestashop so languages 5, 6 and 7 should be updated as well, the same way as the other languages. 5 => FR 6 => FR 7 => NL 3/ Multi-lingual manuals Currently only English manuals are imported (language ID 1). Prestashop does not support multilingual lanuals, however, multiple manuals can be linked to a product. So following languages should be added: FR, NL and DE (If manual is available in this language) For $id_lang = 1 this currently is: switch ($key) { case 'NL': $name_pdf = "Brochure (Engels)"; break; case 'FR': $name_pdf = "Brochure (Anglais)"; break; case 'EN': $name_pdf = "Data Sheet (UK English)"; break; case 'DE': $name_pdf = "Handbuch (Englisch)"; break; default: $name_pdf = "Data Sheet"; break; For $id_lang = 2 this should become: switch ($key) { case 'NL': $name_pdf = "Brochure (Frans)"; break; case 'FR': $name_pdf = "Brochure (Français)"; break; case 'EN': $name_pdf = "Data Sheet (French)"; break; case 'DE': $name_pdf = "Handbuch (Französisch)"; break; default: $name_pdf = "Data Sheet"; break; For $id_lang = 3 this should become: switch ($key) { case 'NL': $name_pdf = "Brochure (Duits)"; break; case 'FR': $name_pdf = "Brochure (Allemand)"; break; case 'EN': $name_pdf = "Data Sheet (German)"; break; case 'DE': $name_pdf = "Handbuch (Deutsch)"; break; default: $name_pdf = "Data Sheet"; break; For $id_lang = 4 this should become: switch ($key) { case 'NL': $name_pdf = "Brochure (Nederlands)"; break; case 'FR': $name_pdf = "Brochure (Néerlandais)"; break; case 'EN': $name_pdf = "Data Sheet (Dutch)"; break; case 'DE': $name_pdf = "Handbuch (Höllandisch)"; break; For full specs see PDF file