WooCommerce-tabellerna i Sheets
Sheets läser din WooCommerce-butik som 9 tabeller. Lägg till en i ett kalkylark som datakälla så blir dess kolumner namn som dina formler använder.
Sales
OrdersDate, Month, Order number, Status, Counts as sale…Order linesDate, Month, Order number, Status, Counts as sale…RefundsDate, Month, Amount, Reason, Refunded through the payment method…
Catalog
ProductsName, Type, Status, SKU, Categories…Product variationsProduct, Variation, SKU, Category, Price…Product categoriesName, Slug, Parent, Products, ID…
Customers
CustomersName, E-mail, Username, Role, Company…Buyers (from orders)E-mail, Name, Country, Registered, Customer ID…