Import products

If you have several products you’d like to add, you can import them with a CSV file in this format. Depending on the way your computer is set-up, the CSV template might open in either Excel, Open Office Calc, Numbers or even Google Sheets. It doesn't matter too much as any spreadsheet editing application will handle it just fine.

Pro tips for a successful import

  • Leave the header row intact.
  • Do not remove any mandatory columns.
  • If copying from another system, make sure you use the same column headings, or change them to match.
  • If you use a spreadsheet application such as Excel or Google Sheets to create your CSV file, ensure that the application is not auto-configuring some fields into dates in strange formats or they will not be read correctly.
Column Mandatory (Y/N) Description
SKU Y Product reference
name Y Product name
type Y Product type: good or service
tax_class N Product tax class: eservice, ebook or standard. By default, eservice.
unit_price Y Product price
currency N Product currency. By default, the account currency.
display_price N Taxes in display price: Included or excluded. By default, excluded.
purchase_type N One_off or subscription. By default, one_off.
stripe_plan_id N For Stripe subscriptions only. (Where can I find my Stripe plan ID?)
paypal_subscription_interval_unit N For Paypal subscriptions only. Interval unit: monthly, yearly.
paypal_subscription_interval_frequency N For Paypal subscriptions only. Frequency of the units when the charge should recur.
paypal_subscription_interval_duration N For Paypal subscriptions only. Number of times the charge should recur (Maximum: 52). Optional.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us