Importing products
You can import multiple products at once by uploading a specially-formatted CSV file.
Quaderno uses CSV (Comma-Separated Value) files for this kind of bulk import. Here's an example: products.csv
To import products, follow these steps:
- Go to the products page.
- Click
Import products, under the…menu. - Drag & drop or select your CSV file in the modal window.
- Customise the column mapping in the pop-up window.
- Review the final preview and click
Send.
Only the creation of new products is supported. If a product with the same sku already exists in the system, it 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 complete them, leave them empty, or remove them.
| 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 (only for subscriptions). |
| paypal_subscription_interval_unit | For PayPal subscriptions only. Interval unit: monthly, yearly. |
| paypal_subscription_interval_frequency | For PayPal subscriptions only. Frequency of the unit at which the charge should recur. |
| paypal_subscription_interval_duration | For PayPal subscriptions only. Number of times the charge should recur. Maximum: 52. |