In this article, we’ll explore the main data tables that you can import from Stripe into Magento BI. After setup is completed, the following tables will be created in your data warehouse. Click the links in the Table Name column to learn more about the attributes in each table.
|Customers||Customer objects allow you to perform recurring charges and track multiple charges that are associated with the same customer.|
|Charges||This table contains information about charges to credit and debit cards, including the amount, currency, status, customer ID, and more.|
|Coupons||This table contains information about a percent- or amount-off discount you may want to apply to a customer. Note that coupons only apply to invoices; they do not apply to one-off charges.|
|Invoices||This table contains information about invoices including the amount owed, subscriptions, invoice items, any automatic proration adjustments, and more.|
|Plans||This table contains the pricing information for different products and feature levels on your site. For example, you may have a $10/month plan for basic features and a $20/month plan for premium features.|
|Subscriptions||This table contains the details of subscription plans your customers belong to. Attributes include customer ID, status, canceled/ended at dates, tax percent, trial information, and more.|
|Events||Events let you know about something interesting that has just happened in an account. When an interesting event occurs, a new event object is created. For example, when a charge succeeds charge.succeeded event is created; or, when an invoice can't be paid an invoice.payment_failed event is created.
Note that many API requests may cause multiple events to be created. For example, if you create a new subscription for a customer, you will receive both a customer.subscription.created event and a charge.succeeded event.