Customer / Product Table

  • rikidev

    (@rikidev)


    5 years, 11 months ago

    I’m trying to get a simple WooCommerce report that shows the following;

    1) Customers/Customer Name in the first (left) column.
    2) Product Names as headers in the other columns.
    3) Product Totals in one row against the customer.
    4) Each customer should only have one row.
    5) Total Products in the final column.

    Is there a simple way to do this, it’s like any totals table I’ve ever worked with, yet I can’t see to replicate it in WooCommerce.

    Thanks in advance for your help.

    R

    • This topic was modified 5 years, 11 months ago by Jan Dembowski.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator bcworkz

    (@bcworkz)

    5 years, 11 months ago

    I don’t think such a display is available by default. Most stores have so many products it would be a very cumbersome table. You may wish to ask in the dedicated WooCommerce support forum to be sure.

    It’d be possible to custom build such a table. Products are a special post type and customers are WP users. You could query for products ordered and grouped by customer and build the table based on the returned data.

    Thread Starter rikidev

    (@rikidev)

    5 years, 11 months ago

    Thanks @bcworkz,

    I guess that’s a good point about the number of products, we do only have a few at this stage though.

    I’ve reposted in the WooCommerce forum to check, alternatively I can manipulate manually in a spreadsheet but wanted to avoid the manual intervention :/

    Thanks Again,
    R

    Moderator bcworkz

    (@bcworkz)

    5 years, 11 months ago

    Sure, a manual spreadsheet is not at all desirable. I recognize the utility in what you are after. When I said “custom build such a table”, a manual spreadsheet is not what I had in mind. I was thinking a custom coded page that dynamically generates the table for you on request 🙂 It’s a bit of a coding project, so not something anyone can accomplish. If you don’t have the requisite coding skills yourself, you might consider hiring an expert to do it for you. A couple possible resources are https://jobs.wordpress.net/ or https://jetpack.pro/.

    I saw in your WC topic that they confirmed my suspicion. Though they did offer some other suggestions to pursue. To keep any further suggestions in one place, I’m closing this topic. Anyone with further suggestions should continue at https://wordpress.org/support/topic/customer-product-table-2/

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Customer / Product Table’ is closed to new replies.