Liste de clients par produit pour WooCommerce

Description

Une extension qui affiche simplement une liste de clients qui ont acheté un produit spécifique au bas de la page d’édition du produit de WooCommerce. Vous pouvez également envoyer un e-mail à votre liste de clients, l’imprimer ou l’exporter en format CSV, PDF ou Excel. Requiert l’installation et l’activation de WooCommerce 2.2+

Great for sending out e-mails or getting a list of customers for courses, for shows or for product recalls.

Fonctionnalités :

  • Support pour les produits variables
  • Page d’options pour sélectionner les colonnes d’information à afficher
  • Displays customer name, email, phone number, address, order number, order date, shipping method, order total and quantity for each product
  • Shortcode to display orders in the front-end. You can select which information to display using attributes
  • Button to e-mail all customers for a specific product using your favorite e-mail client (b.c.c.)
  • Email selected customers
  • Exportation de la liste de clients en format CSV (parfait pour importer dans Mailchimp !)
  • Exportez la liste de clients vers Excel
  • Exporter la liste de clients au format PDF (choix de l’orientation et des dimensions de la page dans les paramètres)
  • Copiez la liste de clients au presse-papier
  • Imprimez la liste des clients
  • Recherche par une colonne dans la liste
  • Filtrer par une colonne dans la liste
  • Faire un glisser-déposer pour les réorganiser.
  • Internationalisé et compatible avec WPML et Polylang (fichier .pot inclus)
  • Traductions incluses: Français, Français (France), Français (Canada), Espagnol, Néerlandais, Néerlandais (Pays-Bas), Néerlandais (Belgique)
  • Toutes les fonctions sont extensibles
  • Orienté performance
  • Responsive
  • Multisite compatible
  • Support for custom statuses

Premium version:

  • Support for Custom Fields
  • Support for User meta
  • Support for WooCommerce Custom Fields (RightPress)
  • Support for WooTours
  • Support for WooEvents
  • Support for YITH WooCommerce Product Add-ons
  • Shortcode by variation ID
  • Datatables functionalities for the shortcode (export PDF, export CSV, print, email customers, search, paging, etc…).
  • Change default sorting column
  • Much more coming soon!

To upgrade the plugin to the premium version, simply click on « upgrade » under the plugin title in the plugin list page, or purchase it here.

Contributeurs :

Captures d’écran

  • La liste de clients dans la page d’édition de produit.
  • La page des paramètres

Installation

  1. Télécharger les fichiers de l’extension dans le dossier /wp-content/plugins/wc-product-customer-list, ou installez directement l’extension par via la page des extensions WordPress.
  2. Activez l’extension sur la page « Extensions » dans WordPress
  3. Modifiez n’importe quel produit WooCommerce pour voir la liste des clients qui ont acheté ce dernier.
  4. Veuillez vous assurer que la boîte « Product Customer List for WooCommerce » est cochée dans les options d’écran.
  5. Access the settings page in WooCommerce / Settings / Products / Product Customer List

FAQ

How do I use the shortcode?

WARNING: The shortcode can display very private information about your customers (if you decide to). Please use with caution.

To display the list in the front end, simply use the following shortcode: [customer_list] along with the following attributes and their « true » or « false » value:

  • product : The ID of the product for which you wish to display the customer list. If you do not put an ID number, it will use the ID of the current product (if used on a product page)
  • table_title : Add a title that will be added at the top of the list. Uses h3 tags that can be styled via css.
  • order_status : The order status for which the shortcode will display your customers. If you have more than one, seperate them with commas. Options are: wc-completed, wc-processing, wc-on-hold, wc-pending, wc-cancelled, wc-refunded, wc-failed. Default is « wc-completed ».
  • show_titles : Display the titles of each column in the head of the table. Titles cannot be modified at this time.
  • order_number : The ID of the order. Can be a variation ID in the premium version of the plugin.
  • order_date : The date of the order.
  • billing_first_name : Billing first name.
  • billing_last_name : Billing last name.
  • billing_company : Billing company.
  • billing_email : Billing e-mail.
  • billing_phone : Billing phone.
  • billing_address_1 : Billing address 1.
  • billing_address_2 : Billing address 2.
  • billing_city : Billing city.
  • billing_state : Billing state.
  • billing_postalcode : Billing postal / Zip code.
  • billing_country : Billing country.
  • shipping_first_name : Shipping first name.
  • shipping_last_name : Shipping last name.
  • shipping_company : Shipping company.
  • shipping_address_1 : Shipping address 1.
  • shipping_address_2 : Shipping address 2.
  • shipping_city : Shipping city.
  • shipping_state : Shipping state.
  • shipping_postalcode : Shipping postal / Zip code.
  • shipping_country : Shipping country.
  • customer_message : Message from the customer.
  • customer_id : The ID of the customer (if registered).
  • customer_username : The user name of the Customer (if registered).
  • customer_username_link : Add a link to the customer’s profile page (requires customer_username).
  • customer_display_name : The display name of the Customer (if registered).
  • order_status_column : The order status.
  • order_payment : The order payment method.
  • order_shipping : The order shipping method.
  • order_coupon : The coupon(s) used at checkout.
  • order_variations : The variations column. Default: true.
  • order_total : The order total.
  • order_qty : The quantity of products purchased.
  • order_qty_total : The total of products purchased for all customers. This field is added at the bottom of the table.
  • order_qty_total_column : The total of products purchased for all customers. This field is added as a column.
  • limit : The amount of orders you want to display.

Premium version

  • custom_fields : A comma separated list of your custom field keys. You can copy the keys that are available in the list in the admin settings.
  • sortable : Activates datatables script and enables sorting by column and is required for all other premium shortcode parameters to work. Default: false.
  • index : Adds an index column to the left of the list. Default: false.
  • export_pdf : Adds button to export the list as PDF. Default: false.
  • export_csv : Adds button to export the list as CSV. Default: false.
  • email_all : Adds button to e-mail all customers with your e-mail client (b.c.c.). Default: false.
  • copy : Adds button to copy table data to clipboard. Default: false.
  • print : Adds button to print the table. Default: false.
  • search : Adds option to search the list. Default: false.
  • paging : Adds paging to list. Default: false.
  • info : Displays additional information such as posts per page. Default: false.
  • scrollx : Enables horizontal scrolling. Default: false.
  • pdf_pagesize : Sets the paper format for the PDF export. Options are LETTER|LEGAL|A3|A4|A5. Default: LETTER.
  • pdf_orientation : Sets the paper orientation for the PDF export. Options are portrait|landscape. Default: portrait.

If you do not use any attributes for the product ID, it will display the customers of the current product (on a product page).

Here is an example containing every attribute of the shortcode, with the default values. Please note that it is not needed to include each attribute, you can simply use the attributes that you wish to modify (replace 999 with your product id):

[customer_list product="999" show_titles="true" order_status="wc-completed" order_number="false" order_date="false" billing_first_name="true" billing_last_name="true" billing_company="false" billing_email="false" billing_phone="false" billing_address_1="false" billing_address_2="false" billing_city="false" billing_state="false" billing_postalcode="false" billing_country="false" shipping_first_name="false" shipping_last_name="false" shipping_company="false" shipping_address_1="false" shipping_address_2="false" shipping_city="false" shipping_state="false" shipping_postalcode="false" shipping_country="false" customer_message="false" customer_id="false" customer_username="false"  order_payment="false" order_shipping="false" order_coupon="false" order_variations="true" order_total="false" order_qty="false" order_qty_total="false" order_qty_total_column="false" limit="9999"]

Pourquoi la liste de clients n’apparait pas lorsque je modifie un produit ?

Veuillez vous assurer que la boîte « Product Customer List for WooCommerce » est cochée dans les options d’écran.

Where can I select which columns to display

You can access the settings page in WooCommerce / Settings / Products / Product Customer List

Comment peut-on changer l’ordre des colonnes?

You can reorder the columns by dragging them and dropping them in the order you want. The browser will remember your selection. You can press the « Reset column order » button at any time to reset the order to it’s initial state.

Available hooks and filters

Many hooks and filters. Documentation coming soon.

Avis

13 juillet 2020
We had installed this plugin awhile ago just to see who had purchased a book. Just realized how much more I can do with it when we realized we could use it to export a csv to print label sheets PLUS see which customers used a coupon on the product. This is like a swiss army knife of usefulness! Thanks so much for creating this plugin.
8 juillet 2020
WooCommerce's reporting features are embarrassingly bad. I always end up having to install some kind of third party plugin in order to get anything useful out of it. Why this stuff isn't part of the core plugin I have no idea, it's so frustrating. But anyway, this little plugin does exactly what it says. You just scroll to the bottom of whatever product and it will spit out a wonderful list of people who've bought it along with buttons to export that info in a variety of formats. I took the time to track down the plugin page and log in to write a review because this plugin is PERFECT and will save you some headaches.
30 avril 2020
Works great. It's a simple plugin but is capable of many advanced use cases. For example, you can pull all emails for people that bought a certain product and then import that as a segment in your mailing list client. Anyways, great plugin.
24 avril 2020
This plugin is so good that I am leaving my first ever review. I'm normally too busy to write reviews, but this plugin deserves it. It is simple, clean, and does exactly what I needed. It is great for marketing when you need to quickly know who has purchased a particular product. The free version is extremely generous, and there are no pushy nags to upgrade. All in all, excellent work!
30 janvier 2020
Wow, I am really impressed with what this plugin offers right out of the box. Easy to use with plenty of intuitive features. Highly recommended.
28 janvier 2020
Very useful for a company that sells small events - we can easily check the list of who bought a ticket.
Lire les 59 avis

Contributeurs & développeurs

« Liste de clients par produit pour WooCommerce » est un logiciel libre. Les personnes suivantes ont contribué à cette extension.

Contributeurs

“Liste de clients par produit pour WooCommerce” a été traduit dans 9 locales. Remerciez l’équipe de traduction pour ses contributions.

Traduisez « Liste de clients par produit pour WooCommerce » dans votre langue.

Le développement vous intéresse ?

Parcourir le code, consulter le SVN dépôt, ou s’inscrire au journal de développement par RSS.

Journal

2.9.2

  • Fix BCC for emails

2.9.1

  • Fix for email all customers

2.9.0

  • Switched from REST to ajax
  • Fixed partial refunds option
  • Pro: Added User meta columns

2.8.9

  • Fixed broken PDF button
  • Added the IntersectionObserver API and a few extra class and method safety checks in PHP.

2.8.8

  • Updated the Freemius SDK to remove an error that was introduced in WordPress 5.2
  • Added missing PDFmake map file

2.8.7

  • Fix WPML issues

2.8.6

  • Fix quantity count
  • Variation cleanup

2.8.5

  • Fix missing e-mail button and total line
  • Visual fixes

2.8.4

  • Performance improvement: Orders on the backend now load using ajax
  • Fixed issue with multiple products in shortcode

2.8.3

  • Assets reupload

2.8.2

  • Updated Freemius SDK to fix PHP notice.
  • Removed CDN for chinese users
  • Premium: fixed checkout field display issue

2.8.1

  • Feature: Added option to add SKU to PDF titles

2.8.0

  • Fixed issue with Wootours/Wooevents (premium)
  • Fixed issue emailing all customers
  • Security fix

2.7.9

  • Fixed « Undefined variable: split_rows » PHP notice
  • Premium: Added an index column for shortcode (coming soon for admin page)

2.7.8

  • Fix for shortcode on WPML
  • Add support for RightPress
  • Add « split by row » option for RightPress

2.7.7

  • Updated datatables to latest version
  • Simplified the customer email selection
  • Updated .pot file
  • Updated freemius to the latest version
  • Added setting to select the default column to order by (Pro)
  • Added setting to enable/disable state save (Pro).

2.7.6

  • Fixed unicode character related errors.

2.7.5

  • Added customer_display_name in shortcode
  • Added table_title in shortcode
  • Added Customer display name column in admin
  • Updated .pot file
  • Premium: Added support for WooEvents
  • Premium: Fixed issue with custom fields in shortcode
  • Premium: Fixed issue with email_all in shortcode

2.7.4

  • Updated .pot file and re-uploaded french files
  • Freemius GDPR compliance
  • Compatibility with YITH WooCommerce Product Add-ons

2.7.3

  • Premium: Added function wpcl_product_sales($product, $status) to return actual sales.
  • Free: Fixed variable column

2.7.2

  • Fixed other bug with Freemius

2.7.1

  • Fixed bug with Freemius
  • Updated .pot file

2.7.0

  • Fixed issue with billing email in shortcode
  • Premium version: Added support for shortcode by variation ID.

2.6.9

  • Fixed issue with settings page (again)

2.6.8

  • Fixed issue with settings page

2.6.7

  • Added support for Preemius / licensing system

2.6.6

  • Added support for Pro version
  • Added multiple hooks and filters (documentation to come)
  • Added style for shortcode
  • Added variations settings for admin
  • Added variations settings for shortcode
  • Updated shortcode documentation

2.6.5

  • Fixed shameful PHP notice.

2.6.4

  • Fixed duplicate order_status option in shortcode (please use order_status_column to display the order status column.
  • Added a few more shortcode options (please see FAQ on how to use the shortcode).

2.6.3

  • Returning shortcode output instead of echo (thanks to aerobass)

2.6.2

  • Fixed rogue  » at the end of the shortcode (thanks to aerobass)

2.6.1

  • Added shortcode attributes for all columns

2.6.0

  • Fixed compatibility bug in PHP 7.1 (Thanks to mmagnani)

2.5.9

  • Added username column

2.5.8

  • Fixed partially refunded orders

2.5.7

  • Added billing company column
  • Added shipping company column
  • Added coupons used

2.5.6

  • Added compatibility with Avada theme and The events calendar plugin
  • Changed payment output to title instead of slug
  • Option ajoutée pour cacher les commandes partiellement remboursées

2.5.5

  • Fixed datatables related javascript errors
  • Added missing translation in settings page

2.5.4

  • Fixed bug where some variations wouldn’t display (again!)

2.5.3

  • Fixed bug where some variations wouldn’t display
  • Added row selection for emails
  • Added shipping method column
  • Updated screenshots

2.5.2

  • Ajout de la liste déroulante pour sélectionner la longueur de la liste

2.5.1

  • Added hook “wpcl_after_email_button” to display content after the email button.
  • Affichage de variation fixe.

2.5.0

  • Fixed issue where the email list would be incomplete.

2.4.9

  • Added support for custom statuses

2.4.8

  • Fixed deprecation notices and bugs in variable products

2.4.7

  • Script optimizations

2.4.6

  • Fixed settings text mismatch

2.4.5

  • Fixed bug where current date would be show instead of the order date
  • Added plugin action links
  • Added order total column
  • Added translations for order statuses

2.4.4

  • WooCommerce 3.0+ compatibility
  • Script optimizations (thanks to Alexandre Simard)
  • Code optimization
  • Improved multisite compatibility
  • Updated .pot file

2.4.3

  • Added Customer ID column
  • Fixed wpdb notice (thanks to Michal Bluma)

2.4.2

  • Fixed multisite compatibility

2.4.1

  • Fixed compatibility issue with plugin “WooCommerce Amazon S3 storage”

2.4.0

  • Added multisite compatibility

2.3.9

  • Ajouter de l’option de l’activation de la ville dans les paramètres

2.3.8

  • Fixed bug where quantity would not show up in shortcode

2.3.7

  • Ajouté compatibilité avec WPML

2.3.6

  • Réparé dimensions et orientation des fichiers PDF
  • Ajout de la colonne et du paramètre de méthode de paiement

2.3.5

  • Ajout des paramètres pour l’orientation et les dimensions du format PDF

2.3.4

  • Fixed bug where refunds would appear in the list.
  • Retrait de vieux code inutilisé

2.3.3

  • Fixed trailing slash in scripts and stylesheet urls which could prevent them to load on certain servers.

2.3.2

  • Fixed bug where featured image uploader wouldn’t work when activated.
  • Mise à jour du scripte PDFMake à la dernière version (locale)

2.3.1

  • Added column reordering and state save
  • Fixed javascript localization handling (wp_localize_script)

2.3.0

  • Changed print and export system to reflect filters and order
  • Ajouté l’exportation en format excel
  • Ajouté l’exportation en format PDF
  • Ajouté la copie au presse-papier

2.2.9

  • Added all missing order statuses in settings

2.2.8

  • Fixed bug where shipping postal code wouldn’t be displayed in CSV export

2.2.7

  • Fixed bug where two extra columns would appear while printing
  • Fixed bug where there would be an error if you delete a variation after it is purchased

2.2.6

  • Ajout de la traduction Portugaise (Brésil) (merci à Marcello Ruoppolo)
  • Fixed alignment shortcode bug and added default product as current product

2.2.5

  • Ajout du support aux produits variables (merci à Alexandre Simard)
  • Bug fixes & optimisation

2.2.4

  • Fixed Urls for wordpress subdirectory installs

2.2.3

  • Fixed issue where columns would shift when printing

2.2.2

  • Added front-end shortcode
  • Correction du type de commande par défaut dans les paramètres.

2.2.1

  • Ajout de la colonne date
  • Ajout de la compatibilité avec WordPress 4.5
  • Fixed some bugs

2.2.0

  • Added settings tab section
  • Added support for horizontal scrolling
  • Loaded datatables CSS and JS via CDN

2.1.2

  • Fixed undefined object error when there are no customers
  • Fixed text domain to match plugin slug
  • Ajout de la traduction Néerlandaise (Belgique)

2.1.1

  • Fixed issue where the plugin would prevent WooCommerce from displaying or saving product attributes (price & stock)

2.1.0

  • Ajout de la pagination
  • Ajout de la recherche
  • Added sortable columns
  • Ajout de la traduction Néerlandaise (Pays-Bas) (merci à pieterclaesen)
  • Ajout de « row actions »
  • Fixed empty table notice
  • Nettoyé le code

2.0.4

  • Fixed other “cannot send session cache limiter” warning

2.0.3

  • Fixed bug where variations wouldn’t be added to the quantity column sum

2.0.2

  • Correction de l’avertissement “session_start(): Cannot send session cookie”
  • Correction de l’avertissement “session_start(): Cannot send session cache limiter”

2.0.1

  • Correction du bug de quantité

2.0.0

  • Ajout du bouton d’export au format CSV
  • Ajout du bouton d’impression

1.11

  • Amélioration du style de la table
  • Ajout de la traduction espagnole
  • Optimisation du code: les fichiers sont maintenant plus légers!

1.1

  • Ajout de la colonne de quantité
  • Correction et optimisation de la vérification de l’extension WooCommerce
  • Amélioration de la lisibilité du code
  • Mise à jour des traductions

1.02

  • Correction du bouton courriel

1.01

  • Mise à jour des statuts de commande WooCommerce dépréciés
  • Ajout des fonctions extensibles
  • Optimisation du code

1.0

  • Première version stable