WooCommerce

Estimated reading time: 8 min

In this article, you’ll find the answers to the following questions:

Creating an Integration

From your Slemma account, head over to the Library page and click the plus button at the bottom right. Select Integration from the submenu.

In the following page, you can find WooCommerce with one of the following ways:

  1. Scroll down and select WooCommerce from the list of Integrations.
  2. Use search to find WooCommerce from the list of Integrations.
  3. Choose WooCommerce using All dropdown list > E-Commerce.

You’ll see the Integration settings dialog window. You can select the frequency for the automatic updates on the DATA REFRESH tab, or set weeks settings on the ADVANCED tab.

Leave this page open for now – we’ll need it to complete the setup.

Here you need to enter your Consumer Key, Consumer Secret, and your store URL. Follow this WooCommerce instruction to get your Consumer Key and Secret.

Enter them to the Integration settings window. Click OK.

After authorization, you’ll be able to share the integration with either individuals or the entire Team, rename or remove the integration. To view the options available for the integration, right click it in the list.

Creating a Dataset

To create a dataset, click your WooCommerce integration in the list and select Browse datasets. From the following page, select which data you want to add to use in your charts.

The Products data source contains information about all of your products.

Dimensions

  1. Type – Product type. Options: simple, grouped, external, variable
  2. Name – Product name
  3. Category – Categories of the product
  4. SKU – Unique identifier
  5. Visible – Catalog visibility. Default is visible. Options: visible (Catalog and search), catalog (Only in catalog), search (Only in search) and hidden (Hidden from all)
  6. Status – Product status. Options: draft, pending, private and publish
  7. Featured – Featured product. Default is false
  8. Created – The date the product was created, as GMT
  9. Backorders – If managing stock, this controls if backorders are allowed. If enabled, stock quantity can go below 0. Default is no. Options are: no (Do not allow), notify (Allow, but notify customer), and yes (Allow)
  10. Backordered – Shows if a product is on backorder (if the product have the stock_quantity negative)
  11. Backorders Allowed – Shows if backorders are allowed
  12. Updated – The date the product was last modified, as GMT
  13. Virtual – If the product is virtual. Virtual products are intangible and aren’t shipped. Default is false
  14. Tax Class – Tax class
  15. Sold Individually – Allow one item to be bought in a single order. Default is false
  16. Manage Stock – Stock management at product level. Default is false
  17. In Stock – Controls whether or not the product is listed as “in stock” or “out of stock” on the frontend. Default is true
  18. Sale – Shows if the product is on sale
  19. Shipping Class – Shipping class slug. Shipping classes are used by certain shipping methods to group similar products
  20. Shipping Taxable – Shows whether or not the product shipping is taxable
  21. Shipping Required – Shows if the product need to be shipped
  22. Download Type – Download type. Options: ‘standard’ (Standard Product), application (Application/Software) and music (Music)
  23. Purchasable – Shows if the product can be bought
  24. Downloadable – If the product is downloadable. Downloadable products give access to a file upon purchase. Default is false
  25. Tax Status – Tax status. Default is taxable. Options: taxable, shipping (Shipping only) and none
  26. Reviews Allowed – Allow reviews. Default is true

Measures

  1. Price – Current product price. This is setted from regular_price and sale_price
  2. Total Sales – Amount of sales
  3. Total Amount – The total amount in orders
  4. Regular Price – Product regular price
  5. Sale Price – Product sale price
  6. Variations Count – Number of variations
  7. Average Rating – Reviews average rating
  8. Ratings Count – Amount of reviews that the product have
  9. Stock Quantity – Stock quantity. If is a variable product this value will be used to control stock for all variations, unless you define stock at variation level
  10. Products Count – Products Count

Templates

  • Average Rating by Products (last 30 days)
  • Sales by Product Category
  • Top 10 Products by Total Sales

The Orders data source contains information about all of your orders.

Dimensions

  1. Number – Order number
  2. Status – Order status. Options: pending, processing, on-hold, completed, cancelled, refunded and failed
  3. Customer – User First Name, Last Name and Email  who owns the order
  4. Currency – Currency the order was created with, in ISO format, e.g USD. Default is the current store currency
  5. Created – The date the order was created, as GMT
  6. Updated – The date the order was last modified, as GMT
  7. Completed – The date the order was completed, as GMT
  8. Payment Methods – Payment method
  9. Shipping Country – Name of the shipping country
  10. Billing Country – Name of the billing country
  11. Paid – The date the order has been paid, as GMT
  12. Version – Version of WooCommerce when the order was made
  13. Prices Include Tax – Shows if the prices included tax during checkout

Measures

  1. Amount – Grand total
  2. Shipping Amount – Total shipping amount for the order
  3. Tax Amount – Sum of all taxes
  4. Shipping Tax – Total shipping tax amount for the order
  5. Cart Tax – Sum of line item taxes only
  6. Subtotal – Line subtotal (before discounts)
  7. Subtotal Tax – Line subtotal tax (before discounts)
  8. Discount Amount – Total discount amount for the order
  9. Discount Tax – Total discount tax amount for the order
  10. Quantity – Quantity ordered
  11. Coupons Count – Number of coupons applied to the order
  12. Refunds Count – Number of returns
  13. Refund Items Count – Number of products returned
  14. Refund Amount – Total amount refunded for the order
  15. Orders Count – Orders Count

Templates

  • Cumulative Gross Revenue over the last 30 days
  • Number of Orders by Customer (last 30 days)
  • Total Order Value by Status (last 30 days)

The Customers data source contains information about all of your customers.

Dimensions

  1. Name – User First Name, Last Name and Email
  2. Created – The date the customer was created, as GMT
  3. Shipping Country – Name of the shipping country
  4. Billing Country – Name of the billing country

Measures

  1. Orders Count – Quantity of orders made by the customer
  2. Total Spent – Total amount spent
  3. Customers Count – Customers Count

Templates

  • Number of Customers Created over the last 30 days
  • Number of Orders by Country (last 30 days)
  • Top 10 Customers by Total Amount Spent
  • Total Sales by Country (last 30 days)

The Coupons data source contains information about all of your coupons.

Dimensions

  1. Code – Coupon code
  2. Type – Determines the type of discount that will be applied. Options: fixed_cart, percent, fixed_product and percent_product. Default: fixed_cart
  3. Created – The date the coupon was created, as GMT
  4. Updated – The date the coupon was last modified, as GMT
  5. Individual Use – Whether coupon can only be used individually
  6. Usage Limit – How many times the coupon can be used
  7. Expired – UTC DateTime when the coupon expires
  8. Free Shipping – Define if can be applied for free shipping
  9. Exclude Sale Items – Define if should not apply when have sale items

Measures

  1. Amount – The amount of discount
  2. Products Count – Number of products the coupon can be used on
  3. Exclude Products Count – Number of products the coupon cannot be used on
  4. Limit Usage To Items – Max number of items in the cart the coupon can be applied to
  5. Usage Count – Number of times the coupon has been used already
  6. Coupons Count – Coupons Count

The Sales data source contains information about all of your orders and their composition.

Dimensions

  1. Order Number – Order number
  2. Order Status – Order status. Options: pending, processing, on-hold, completed, cancelled, refunded and failed
  3. Customer – User First Name, Last Name and Email who owns the order
  4. Shipping City – Name of the shipping city
  5. Billing City – Name of the billing city
  6. Billing State – Name of the billing state
  7. Shipping State – Name of the shipping state
  8. Billing Company – Name of the billing company
  9. Shipping Company – Name of the shipping company
  10. Customer Username – The user name of the customer
  11. Customer Created At – The date the customer was created, as GMT
  12. Customer Updated At – The date the customer was last modified, as GMT
  13. Paying Customer – Is the customer a paying customer
  14. Currency – Currency the order was created with, in ISO format, e.g USD. Default is the current store currency
  15. Order Created At – The date the order was created, as GMT
  16. Order Updated At – The date the order was last modified, as GMT
  17. Order Completed – The date the order was completed, as GMT
  18. Payment Methods – Payment method
  19. Shipping Country – Name of the shipping country
  20. Billing Country – Name of the billing country
  21. Order Paid At – The date the order has been paid, as GMT
  22. Order Paid – Define if the order is paid. Default is false
  23. Order Version – Version of WooCommerce when the order was made
  24. Prices Include Tax – Shows if the prices included tax during checkout
  25. Product Type – Product type. Options: simple, grouped, external, variable
  26. Product Name – Product name
  27. Product Category – Categories of the product
  28. Product SKU – Unique identifier
  29. Product Visible – Catalog visibility. Default is visible. Options: visible (Catalog and search), catalog (Only in catalog), search (Only in search) and hidden (Hidden from all)
  30. Product Status – Product status. Options: draft, pending, private and publish
  31. Product Featured – Featured product. Default is false
  32. Product Created At – The date the product was created, as GMT
  33. Product Updated At – The date the product was last modified, as GMT
  34. Product Backorders – If managing stock, this controls if backorders are allowed. If enabled, stock quantity can go below 0. Default is no. Options are: no (Do not allow), notify (Allow, but notify customer), and yes (Allow)
  35. Product Backordered – Shows if a product is on backorder (if the product have the stock_quantity negative)
  36. Product Backorders Allowed – Shows if backorders are allowed
  37. Product Updated At – The date the product was last modified, as GMT
  38. Product Virtual – If the product is virtual. Virtual products are intangible and aren’t shipped. Default is false
  39. Product Tax Class – Tax class
  40. Product Sold Individually – Allow one item to be bought in a single order. Default is false
  41. Product Manage Stock – Stock management at product level. Default is false
  42. Product In Stock – Controls whether or not the product is listed as “in stock” or “out of stock” on the frontend. Default is true
  43. Product On Sale – Shows if the product is on sale
  44. Product Shipping Class – Shipping class slug. Shipping classes are used by certain shipping methods to group similar products
  45. Product Shipping Taxable – Shows whether or not the product shipping is taxable
  46. Product Shipping Required – Shows if the product need to be shipped
  47. Product Download Type – Download type. Options: ‘standard’ (Standard Product), application (Application/Software) and music (Music)
  48. Product Purchasable – Shows if the product can be bought
  49. Product Downloadable – If the product is downloadable. Downloadable products give access to a file upon purchase. Default is false
  50. Product Tax Status – Tax status. Default is taxable. Options: taxable, shipping (Shipping only) and none
  51. Product Reviews Allowed – Allow reviews. Default is true
  52. Product Tags – The list of tags associated with this product

Measures

  1. Quantity – Quantity ordered
  2. Subtotal – Line subtotal (before discounts)
  3. Subtotal Tax – Line subtotal tax (before discounts)
  4. Total – Line total (after discounts)
  5. Price – Product price
  6. Variations Count – Number of variations
  7. Average Rating – Reviews average rating
  8. Ratings Count – Amount of reviews that the product have
  9. Stock Quantity – Stock quantity. If is a variable product this value will be used to control stock for all variations, unless you define stock at variation level
  10. Average Rating – Reviews average rating
  11. Ratings Count – Amount of reviews that the product have
  12. Regular Price – Product regular price
  13. Sale Price – Product sale price
  14. Product Count – Product Count

 

NOTE: Cloud Service Integrations have prebuilt data sets that are not editable.

Creating a Chart

Click a dataset or integration and select Create dashboard/Create chart/Create presentation to start building a chart (please note that presentations are available starting from the Standard Plan).

From the next page, you can choose to create your own chart from scratch, or you can apply one of the templates we created.

  • If you choose to build a new chart from scratch (“Blank” option), the Chart designer will open. Go here to learn how to create a chart in the Chart editor.
  • If you choose a template, a new chart will be added to a dashboard/saved chart/presentation (depending on the way you start the chart creation).
Was this article helpful?
Dislike 0
Views: 150