Las tablas de WooCommerce en Sheets
Sheets lee tu tienda WooCommerce como 9 tablas. Añade una a una hoja de cálculo como fuente de datos y sus columnas se convierten en nombres que tus fórmulas usan.
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…