Met deze module kunt u producten en hun combinaties eenvoudig exporteren naar een CSV-bestand. De module kan de hele catalogus exporteren en het geëxporteerde bestand is klaar voor gebruik met de Import CSV-tool in PrestaShop. De module heeft verschillende functies waarmee u kunt bepalen welk type producten geëxporteerd wordt.
Deze module die werkt met nieuwe PrestaShop 1.7 en 8.0 maakt het mogelijk om eenvoudig en snel duizenden producten te exporteren naar .csv-bestand dat kan worden geïmporteerd in andere prestashop instantie - bestand is klaar om te importeren naar prestashop. Veel functies beschikbaar in de module kunt exporteren producten precies en in elke beschikbare taal in uw winkel. Details over de module vind je hieronder.
Twee bestandsformaten | |
CSV bestand | XML bestand |
geëxporteerd bestand zal in csv formaat zijn, dit formaat wordt standaard geaccepteerd door prestashops IMPORT CSV tool | geëxporteerd bestand zal in xml formaat zijn, dit formaat wordt algemeen geaccepteerd door prijsvergelijkingswebsites |
Deze module genereert een feed voor prestashop's import CSV tool. Deze tool vereist een zeer specifiek bestandsformaat en een zeer specifieke volgorde van datasets in dit bestand. Het gegenereerde CSV-bestand moet worden gecodeerd met UTF-8 standaard - alleen dan zullen beschrijvingen en namen speciale tekens bevatten.
Twee exportmogelijkheden | |
CSV / XML Downloadbaar bestand | CSV / XML bestand online beschikbaar |
Als winkeleigenaar kun je een feed van producten maken en deze vanuit de backoffice van de winkel downloaden als een .csv-bestand. Je kunt alle beschikbare filters gebruiken om de producten te filteren die beschikbaar zullen zijn in de feed | .CSV bestand dat beschikbaar zal zijn op de gedefinieerde URL. Bestand bevat altijd een bijgewerkte lijst van producten die automatisch wordt gegenereerd - ook in .CSV-formaat (ondersteunt ook alle beschikbare filters) |
Deze module exporteert bestanden voor prestashop "IMPORT CSV" tool doeleinden (standaard import tool in prestashop)
Diverse CSV / XML-bestanden Formaat | |||
PrestaShop 1.5 - 1.6 |
PrestaShop 1.7.0.0 - 1.7.2.x |
PrestaShop 1.7.3.0 - 1.7.6.9 |
PrestaShop 1.7.7+ en 8.0 |
Elke versie van PrestaShop heeft een functie met de naam "CSV IMPORT" waarmee u .csv-bestanden kunt importeren die door deze module zijn gegenereerd. Elke versie van PrestaShop accepteert een beetje verschillende structuur o CSV-bestand. Vanwege dit tijdens het exportproces kunt u de structuur van het bestand - module zal genereren bestand voor geselecteerde versie van PrestaShop |
Belangrijkste functies beschikbaar in de module
Zoals je al weet is de belangrijkste functie van deze module de mogelijkheid om producten te exporteren naar een csv-bestand. Module heeft extra functies waarmee je geëxporteerde producten kunt aanpassen. Met de module kunnen ook productcombinaties (attributen) worden geëxporteerd. Op de configuratiepagina van de module kun je opties definiëren zoals:
U kunt natuurlijk meerdere opties tegelijk selecteren en combineren, zodat u gemakkelijk exacte producten kunt exporteren en CSV-bestanden kunt maken met alleen de geselecteerde producten.
Lijst met velden die module exporteert
Module exporteert volledige informatie over product. Het CSV-bestand bevat veel informatie - een lijst vindt u hieronder
Veldnaam | Omschrijving |
Product ID | Uniek identificatienummer van het product |
Actief (0/1) | Informatie of product actief is of niet, 0 - product is niet actief 1 - product is actief |
Naam | Productnaam (in geselecteerde taal) |
Categorieën (x,y,z...) | Lijst van alle categorieën, product is toegewezen aan deze categorieën |
Prijs inclusief belasting | Prijs van het product (inclusief btw) |
Tax regels ID | ID van gebruikte belastingregels |
groothandelsprijs | Waarde van de prijs van het groothandelsproduct |
In de uitverkoop (0/1) | Informatie als product is gemarkeerd als product "in de uitverkoop". 1 - als product in de uitverkoop is, 0 - als product niet is gemarkeerd als product "in de uitverkoop" |
Kortingsbedrag | Kortingswaarde (bedrag) |
Kortingspercentage | Kortingswaarde (procent) |
Korting vanaf (jjjj-mm-dd) | Informatie over beschikbaarheid korting - in dit geval - over ingangsdatum korting |
Korting tot (jjjj-mm-dd) | Informatie over beschikbaarheid korting - in dit geval - over vervaldatum korting |
Referentie # | Referentienummer uniek product |
Referentienummer leverancier | Unieke productreferentie gekoppeld aan geselecteerde leverancier |
Leverancier | Leverancier ID |
Fabrikant | Fabrikant ID |
EAN13 | EAN13 code van het product |
UPC | Product's UPC code |
Ecotax | informatie over de Ecotax van het product |
breedte | Informatie over breedte product |
Hoogte | Informatie over de hoogte van het product |
Diepte | Informatie over de diepte van het product |
Gewicht | Informatie over gewicht product |
Hoeveelheid | Informatie over de hoeveelheid van het product |
Minimale hoeveelheid | Informatie over minimale hoeveelheid product |
Zichtbaarheid | Informatie over zichtbaarheid van product |
Bijkomende verzendkosten | Informatie over extra verzendkosten |
Eenheid voor de eenheidsprijs | Informatie over de eenheidsprijs van het product |
Eenheidsprijs | Eenheidsprijs product |
Korte beschrijving | Korte beschrijving product (in geselecteerde taal) |
Beschrijving | Productbeschrijving (in geselecteerde taal) |
Tags (x,y,z...) | Lijst van alle tags geassocieerd met dit product |
Meta titel | SEO meta titel van product |
Meta trefwoorden | SEO meta trefwoord van product |
Meta beschrijving | SEO meta beschrijving van product |
URL herschreven | SEO herschreven url van product |
Tekst indien op voorraad | Tekst die verschijnt als product op voorraad is |
Tekst wanneer nabestelling toegestaan | Tekst wanneer product beschikbaar is voor "nabestelling" |
Beschikbaar voor bestelling (0 = Nee, 1 = Ja) | Informatie of product beschikbaar is voor bestelling |
Beschikbaarheidsdatum product | Beschikbaarheidsdatum product |
Product aanmaakdatum | Informatie over aanmaakdatum product |
Toon prijs (0 = Nee, 1 = Ja) | Informatie of productpagina prijs weergeeft of niet |
Afbeelding URLs (x,y,z...) | Lijst van alle afbeeldingen die zijn geüpload naar dit product (url's naar afbeeldingen) |
Bestaande afbeeldingen verwijderen (0 = Nee, 1 = Ja) | Informatie over verwijderde bestaande afbeeldingen |
Feature (Naam:Waarde:Positie:Aangepast) | Informatie over kenmerken geassocieerd met dit product (lijst van hen) |
Alleen online beschikbaar (0 = Nee, 1 = Ja) | Informatie als product alleen online beschikbaar is |
Voorwaarde | Informatie over de conditie van het product (nieuw, gebruikt, gereviseerd etc.) |
Aanpasbaar (0 = Nee, 1 = Ja) | Informatie, als product is aangepast of niet (maatwerk optie) |
Uploadbare bestanden (0 = Nee, 1 = Ja) | Informatie, of product geüploade bestanden heeft, of niet (aanpassingsoptie) |
Tekstvelden (0 = Nee, 1 = Ja) | Informatie, indien product "tekst" velden heeft (maatwerk optie) |
Actie indien niet op voorraad | Wat te doen als product niet op voorraad is |
ID / Naam winkel | ID van winkel |
Optionele url naar productpagina | Optie, indien ingeschakeld, om link naar productpagina op te nemen in csv bestand |
Exporteer productcategorieën
Module is klaar om ook categorieën te exporteren. Geëxporteerde categorieën naar CSV-bestand bevatten alle vereiste velden om ze te importeren naar prestashop met "importeer csv" tool die standaard beschikbaar is in shop.
2.0.9
- added improvements to export of id_product_attribute in prestashop 8.x
2.0.8
- added improvements to export features to avoid sql problems in prestashop 81.4
2.0.7
- added improvements to module usage in environments based on php 8.1.x to avoid sql query problems
2.0.6
- fixed problem with missing feature values in feed
2.0.5
- updated translations system in the module to support new translations feature in prestashop 8.x
2.0.4
- added new feature to save export to file located in module directory
2.0.3
- added improvements to module workflow in prestashop 8.x
2.0.2
- added improvements to export process of description and short description fields
- from now you can also remove all html code from these fields (you can enable option or disable it)
2.0.1
- added new feature to export categories option. From now you can export only selected categories
2.0.0
- added improvement to export process of attribute values with name that contain special character : to avoid problems with import process in prestashop's default "import" tool
1.9.9
- added possibility to export products from many various categories
1.9.8
- added support of MPN field (for products and combinations) that was added in PrestaShop 1.7.7.x
1.9.7
- added feature to save form only without export products to file
- from now you have two buttons "save" and "save & export"
1.9.6
- added link to main configuration page of the module that redirects to configuration form of export process
1.9.5
- added new feature to define multiple values separator
- usually its a comma symbol "," - but you can personalize it now
1.9.4
- added feature to export products by date
- you can filter products by date from, date to or date from + date to
1.9.3
- added improvements to export process of attribute names (name + public name)
- added improvements to export process of attribute values
1.9.2
- added improvements to export process dedicated for prestashop 1.7.3+
1.9.1
- added improvements to usage of variable export_increase_price. Module does not spawn information about Undefined index: export_increase_price
1.9.0
- added improvements to include_url feature (include link to product / combination to feed). Now include_url field is excluded properly + prestashop does not spawn information about Undefined index: include_url
1.8.9
- added fixes to recently added upgrade to avoid var_dump command added acidentally to export combinations code
1.8.8
- from now you can decide about category field format during export configuration
- added new feature to export category id instead category name
- added improvements to module's updates checker feature
- updated the copyright notices in all files
1.8.7
- added improvements to export products by supplier when splitting feed to small parts is active
1.8.6
- added improvements to export products by manufacturer when splitting feed to small parts is active
1.8.5
- added new feature to save settings of form (you can decide if you want to save form settings or not)
- added improvements to feed splitting process, it shows suggestions now
1.8.4
- added new feature to increase prices of products in feed by defined percentage value (add profit margin)
1.8.3
- added improvements related to export process of tax excluded prices, from now csv / xml files are not distorted anymore
1.8.2
- improved export process of products and combinations
- from now when you will select option to export feed in defined language - the url to product will be also an url for selected language
1.8.1
- added feature to partially download feed
- feature useful for shops with large number of products and hosting account with limited resouces
1.8.0
- added improvements to export process of categories, now categories are in correct order so default category is defines properly after import process
1.7.9
- added improvements to features export format. Now it creates an exact mirror of features (features are no longer exported as customized value)
- added xml format, so now you can select CSV file, or XML file
1.7.8
- added fixes to export process of tax included / tax exluded prices
1.7.7
- added improvements to export process of tax included / tax excluded product prices
1.7.7
- added filter by suppliers
1.7.6
- added improvements to export process of virtual products in PrestaShop 1.5.x
1.7.5
- added improvements to export products to avoid problems with category / manufacturer / supplier with id 99999
1.7.4
- added feature that checks for module updates automatically
- added improvement to notification about unidentified index export_type
1.7.3
- added new feature to select file structure type
- module can generate csv file with structure accepted in: PrestaShop 1.6, PrestaShop 1.7.0 - 1.7.2, PrestaShop 1.7.3
- added missing fields to PrestaShop 1.7 export: alert when product is out of stock, quantity threshold to send email, downloadable files (url, name, expiration date, number of available downloads)
1.7.2
- added feature to generate export feed that will be available online and always up to dated (feature allows to use the same filters as module has)
1.7.1
- added improvements to specific prices export process
1.7.0
- added imprvement to save process of "active" variable
- when product is disabled module will save information about it as "0" (not empty as previously
1.6.9
- added improvements to export products of combinations, it does not include products without combinations to exported .csv file anymore
1.6.8
- added improvements to export process of categories tree
1.6.7
- added feature to export categories to .csv file
1.6.6
- added fixes to export products module to eliminate problem with specific prices date, now it does not spawn Fatal error: Call to undefined method Tools::date_format() in /modules/exportproducts/controllers/admin/AdminExportProducts.php
1.6.5
- added feature to better support "date add" column
1.6.4
- added full polish translation
1.6.3
- improved export process of product url, url can be included to combination export too.
1.6.2
- changed the default delimiter from comma to semicolon (default separator in csv files)
1.6.1
- added feature to include to csv file link to product page
1.5.1
- proper identification of combination's images
- optimized code
1.4.5
- added proper format of combination group, combination value (attributes)
1.4.4
- improved export of image positions
1.4.3
- improved export of combinations
- now if you defined impact on weight or availability date - module exports these values for each combination properly
- improved export of products
1.4.2
- added proper formatting of csv file heading
1.4.1
- added feature to export product combinations
- updated module core to eliminate notificaiton about unidentified index 'id_product' and 'id_image' inside .csv file
1.3.1
- module fully supports PrestaShop 1.7.x now
1.2.1
- added feature to export products by selected manufacturers
- added feature to export all / active products only
- added feature to export products by selected suppliers
1.1.1
- added fixes to export process in PrestaShop 1.6.0.9
1.1.0
- added feature to define price type that will be exported (vat included / vat excluded)
- added feature to export products from selected categories
1.0.0
- started project on mypresta.eu addons marketplace
2.0.0
- added improvement to export process of attribute values with name that contain special character : to avoid problems with import process in prestashop's default "import" tool
1.9.9
- added possibility to export products from many various categories
1.9.8
- added support of MPN field (for products and combinations) that was added in PrestaShop 1.7.7.x
1.9.7
- added feature to save form only without export products to file
- from now you have two buttons "save" and "save & export"
1.9.6
- added link to main configuration page of the module that redirects to configuration form of export process
1.9.5
- added new feature to define multiple values separator
- usually its a comma symbol "," - but you can personalize it now
1.9.4
- added feature to export products by date
- you can filter products by date from, date to or date from + date to
1.9.3
- added improvements to export process of attribute names (name + public name)
- added improvements to export process of attribute values
1.9.2
- added improvements to export process dedicated for prestashop 1.7.3+
1.9.1
- added improvements to usage of variable export_increase_price. Module does not spawn information about Undefined index: export_increase_price
1.9.0
- added improvements to include_url feature (include link to product / combination to feed). Now include_url field is excluded properly + prestashop does not spawn information about Undefined index: include_url
1.8.9
- added fixes to recently added upgrade to avoid var_dump command added acidentally to export combinations code
1.8.8
- from now you can decide about category field format during export configuration
- added new feature to export category id instead category name
- added improvements to module's updates checker feature
- updated the copyright notices in all files
1.8.7
- added improvements to export products by supplier when splitting feed to small parts is active
1.8.6
- added improvements to export products by manufacturer when splitting feed to small parts is active
1.8.5
- added new feature to save settings of form (you can decide if you want to save form settings or not)
- added improvements to feed splitting process, it shows suggestions now
1.8.4
- added new feature to increase prices of products in feed by defined percentage value (add profit margin)
1.8.3
- added improvements related to export process of tax excluded prices, from now csv / xml files are not distorted anymore
1.8.2
- improved export process of products and combinations
- from now when you will select option to export feed in defined language - the url to product will be also an url for selected language
1.8.1
- added feature to partially download feed
- feature useful for shops with large number of products and hosting account with limited resouces
1.8.0
- added improvements to export process of categories, now categories are in correct order so default category is defines properly after import process
1.7.9
- added improvements to features export format. Now it creates an exact mirror of features (features are no longer exported as customized value)
- added xml format, so now you can select CSV file, or XML file
1.7.8
- added fixes to export process of tax included / tax exluded prices
1.7.7
- added improvements to export process of tax included / tax excluded product prices
1.7.7
- added filter by suppliers
1.7.6
- added improvements to export process of virtual products in PrestaShop 1.5.x
1.7.5
- added improvements to export products to avoid problems with category / manufacturer / supplier with id 99999
1.7.4
- added feature that checks for module updates automatically
- added improvement to notification about unidentified index export_type
1.7.3
- added new feature to select file structure type
- module can generate csv file with structure accepted in: PrestaShop 1.6, PrestaShop 1.7.0 - 1.7.2, PrestaShop 1.7.3
- added missing fields to PrestaShop 1.7 export: alert when product is out of stock, quantity threshold to send email, downloadable files (url, name, expiration date, number of available downloads)
1.7.2
- added feature to generate export feed that will be available online and always up to dated (feature allows to use the same filters as module has)
1.7.1
- added improvements to specific prices export process
1.7.0
- added imprvement to save process of "active" variable
- when product is disabled module will save information about it as "0" (not empty as previously
1.6.9
- added improvements to export products of combinations, it does not include products without combinations to exported .csv file anymore
1.6.8
- added improvements to export process of categories tree
1.6.7
- added feature to export categories to .csv file
1.6.6
- added fixes to export products module to eliminate problem with specific prices date, now it does not spawn Fatal error: Call to undefined method Tools::date_format() in /modules/exportproducts/controllers/admin/AdminExportProducts.php
1.6.5
- added feature to better support "date add" column
1.6.4
- added full polish translation
1.6.3
- improved export process of product url, url can be included to combination export too.
1.6.2
- changed the default delimiter from comma to semicolon (default separator in csv files)
1.6.1
- added feature to include to csv file link to product page
1.5.1
- proper identification of combination's images
- optimized code
1.4.5
- added proper format of combination group, combination value (attributes)
1.4.4
- improved export of image positions
1.4.3
- improved export of combinations
- now if you defined impact on weight or availability date - module exports these values for each combination properly
- improved export of products
1.4.2
- added proper formatting of csv file heading
1.4.1
- added feature to export product combinations
- updated module core to eliminate notificaiton about unidentified index 'id_product' and 'id_image' inside .csv file
1.3.1
- module fully supports PrestaShop 1.7.x now
1.2.1
- added feature to export products by selected manufacturers
- added feature to export all / active products only
- added feature to export products by selected suppliers
1.1.1
- added fixes to export process in PrestaShop 1.6.0.9
1.1.0
- added feature to define price type that will be exported (vat included / vat excluded)
- added feature to export products from selected categories
1.0.0
- started project on mypresta.eu addons marketplace