Le tabelle di WooCommerce in Sheets
Sheets legge il tuo negozio WooCommerce come 9 tabelle. Aggiungine una a un foglio di calcolo come origine dati e le sue colonne diventano nomi che le tue formule usano.
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…