As tabelas do WooCommerce no Sheets
O Sheets lê sua loja WooCommerce em 9 tabelas. Adicione uma delas a uma planilha como fonte de dados e suas colunas viram nomes que suas fórmulas usam.
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…