Importing products
To transfer a large amount of product information between Quaderno and another system, you can use a specially-formatted spreadsheet, CSV.
Quaderno uses CSV (Comma-Separated Value) files to perform this kind of bulk task, like in this example: products.csv
To import products, follow these steps:
- Go to the products page and click
Import products, under the…menu. - Drag & drop or select your CSV file in the modal window.
- A pop-up will appear, allowing you to customize the mapping of columns and providing field clarifications.
- A final preview of what's going to be imported will be shown. When you're done reviewing, click the
Submitbutton!
Note that only the creation of products is supported. When products with the same SKU are found on the system, they won’t be updated and an error screen will appear.
Columns breakdown
The fields sku, name, type, and unit_price are required. All other fields are optional, you can either complete them, leave them empty, or remove them as you wish.
| Name | Description |
|---|---|
| sku | Product reference. Required. |
| name | Product name. Required. |
| type | Product type: good or service. Default is service. Required. |
| tax_class | Product tax class: eservice, ebook or standard. Default is eservice. |
| unit_price | Product price. Required. |
| currency | Product currency. By default, the account currency. |
| display_price | Taxes in display price: included or excluded. Default is excluded. |
| purchase_type | one_off or subscription. Default is one_off. |
| stripe_plan_id | The Stripe plan ID. |
| paypal_subscription_interval_unit | For Paypal subscriptions only. Interval unit: monthly, yearly. |
| paypal_subscription_interval_frequency | For Paypal subscriptions only. Frequency of the units when the charge should recur. |
| paypal_subscription_interval_duration | For Paypal subscriptions only. Number of times the charge should recur. Maximum: 52. |