- Product Types
- Adding Products
- One Time Pricing
- Subscription Pricing
- Subscription Trials Setup
- Installment Pricing
- Donation / Pay What You Want
- Inventory Management
- Product Variants
- Variant Images
- Digital Downloads
- Change Product Availability
- Hide Product from Shop Page
- Template Customization
- Product Collections
- First-Time Payment Discounts
- Manage Product Access
- Payment Types
- Free Trials & Setup Fees
- Create Product With Free Trials
- Charge Set Up Fee on Trials
- Product List
- Product Pages
- Create Product Page in Elementor
- Custom Buy Links
- Product SEO
- Change Permalinks
- Custom Fields
- Adding Products
- Test Mode
- Make Test Payments
- Edit & Customize Form
- Change Form Template
- Delete SureCart Forms
- Custom Checkout Form
- Add New Checkout Form
- Checkout Form With Gutenberg
- Checkout Form in Elementor
- Custom Thank You Page
- Create Donation Form
- Customize Confirmation Popup
- Include Coupons in URLs
- Pre-Fill Checkout Fields
- Change Checkout Texts
- Password Field in Checkout
- Default Country Code
- Add Terms to Checkout
- Conditional Block Checkouts
- Remove Coupon Field
- Hide Quantity Option
- Disable Quantity Editing
- Disable Item Removal
- Country Specific Purchases
- Fix View Order Button
- Fix Express Payment Buttons
- Fix PayPal Test Connection
- Fix PayPal Test Connection
- Fix Sign-In Loop
- Fix Order Confirmation Redirect
- Fix Divi Bullet Point Issue
- Fix Customer Dashboard
- Fix JSON Response Error
- Failed Payment Behavior
- Fix Stripe Zip Code Error
- Fix "Product Can’t Be Blank"
- Troubleshooting Guide
- PayPal IPN Warning Emails
- Caching Configuration for SureCart
- Why iDEAL Might Not Appear in Your CheckoutÂ
How to Import Products in Bulk With SureCart
In this article, we’ll guide you through the process of importing products in bulk into SureCart.
By following the steps outlined in this documentation, you can import products in bulk into your SureCart store using a CSV file.
Let’s get started.
Important Note
Migrating your eCommerce platform is a complex process and may require technical expertise, especially when dealing with custom setups or unique configurations. While we aim to provide comprehensive documentation to guide you through the migration process, we strongly recommend consulting a qualified developer to ensure a smooth transition.
Here are some key points to keep in mind:
1. Effort and Expertise Required: Migration involves critical steps to ensure your data is transferred accurately and that your store remains operational. For this reason, we encourage users who are not familiar with technical processes to seek professional assistance.
2. Support During Migration: Our team is here to assist with any questions or issues you encounter during the migration. However, our standard support is limited to specific queries regarding the documentation and functionality of SureCart. For more in-depth or immediate assistance, consider upgrading to any paid plan.
3. Realistic Expectations: While SureCart is designed to simplify your eCommerce operations, the migration process requires careful planning and execution. We’re here to provide guidance, but ultimately, the responsibility for the migration lies with the store owner or their developer.
If you encounter any difficulties, please don’t hesitate to contact our support team. We are constantly updating our resources and improving our processes to serve you better.
Preparing Your CSV File
To import your products through a CSV file, you need to prepare a CSV file with the information required to create a product in SureCart.
Here’s a template CSV file that you can refer to and create your file with product information.
In the template file, you will find all the fields you need to have to import the product data.
You have two options to start with your product data.
Option one: You can use your own file that has all the product information. Just make sure to change the headers in your file to match the headers of our template.
Option two: If it’s easier for you, just copy the information from your file and paste it into our template. The most important thing is to make sure the first row with the column headers matches correctly. For example, put the slug data in the column labeled “slug,” and do the same for other information in their respective columns.
Please note: The required fields are the ones that contain an asterisk (*) next to the header. In the above example, the required fields are Slug, Name, Currency, and Amount. If you don’t fill the required fields, importing will not be successful.
List of all fields
Below is a list of all the fields and a simple explanation of what it means.
| Field | Description | Use |
|---|---|---|
| Slug | A short, unique identifier used in URLs or references for the product. Must be unique and use only lowercase letters, numbers, hyphens (-), or underscores (_). Uppercase letters (eg. ProductName) and special characters (eg. product$name) are not allowed. | product-name, special_product_123 |
| Name | The name or title of the product. | |
| Currency | The currency in which the product’s price is denominated. | |
| Amount | The price or cost of the product. | |
| Description | A brief text describing the product and its features. | |
| Status | The current state of the product. | published, draft |
| Recurring Interval | The time period between recurring charges for a subscription-based product. | day, week, month, year |
| Recurring Interval Count | The number of recurring intervals for a subscription | |
| Recurring Period Count | The total number of recurring periods a subscription will last. | |
| Recurring End Behavior | Specifies what happens after the subscription ends. | complete |
| Scratch Amount | The original price of the product before any discounts or promotions. | |
| Ad Hoc | Indicates if the product allows ad-hoc (one-time) purchases without a subscription. | boolean |
| Ad Hoc Max Amount | The maximum amount allowed for an ad-hoc purchase. | |
| Ad Hoc Min Amount | The minimum amount required for an ad-hoc purchase. | |
| Trial Duration Days | The duration of any trial period offered for the product, specified in days. | 1 to 365 |
| Setup Fee Enabled | Indicates whether a setup fee is charged for subscription-based products. | boolean |
| Setup Fee Name | The name or description of the setup fee. | |
| Setup Fee Amount | The amount charged for the setup fee. | |
| Setup Fee Trial Enabled | Indicates if the setup fee is included in the trial period. | boolean |
| Purchase Limit | The maximum number of times the product can be purchased. | 1 to 999999999 |
| Shipping Enabled | Indicates whether shipping is available for physical products. | boolean |
| Tax Enabled | Specifies if taxes are applied to the product. | boolean |
| Tax Category | The category or type of tax applied to the product | tangible |
| Tax Behavior | How tax is calculated or applied to the product | exclusive |
| Weight | The weight of the product. | infinite |
| Weight Unit | The unit of measurement for the product’s weight | lb, kg, oz, g |
How to Import Products?
Once you have your CSV file ready, you can follow the instructions below to import the products into SureCart. Visit the SureCart platform.
Before proceeding, double-check that you are in the right store.
- Click on the Imports menu.
- Click on the New Import button.
- Choose Products from the dropdown menu. You’ll see a pop-up screen appear.
- Click on the template CSV file button to download our sample CSV file.
- Once your CSV file is ready, you have two ways to import it. The first option is to drag and drop the file directly into the specified area. You can also click on that area to browse your computer and choose the file you want to import.
- Click on the Import button.
- You’ll find a green notice at the top of your screen, and the status of the import will be displayed as Pending. This indicates that the importing process has been initiated and is in progress.
The importing process can vary, but for small data sets with less than 1000 rows, it usually takes less than a minute.
- You can click on the status to check if the import is ready. Additionally, you’ll receive an email notification once the process is complete.
After the import process is done, you’ll see the status change to Completed, as you can see in the screenshot below.
- You’ll see rows that display the status of each item. If you want to get more detailed information about any specific item, just click on its row. This way, you can access the information you need.
- You can see all the information about your products in this section. You can review and verify the details of each product to ensure everything looks the way you want it.
- Once you’ve imported your products, you’ll find them in the Products menu of your SureCart dashboard. To see and manage these newly added products, simply click on any of them.
That’s it!
Your product data has been successfully imported into SureCart. Now, let’s take it to the next level! You can add some stunning product images, tweak the product status, and make any other changes you want to make your store look fantastic.
By following the steps outlined in this documentation, you can import products in bulk into your SureCart store using a CSV file.
Check out these docs to import additional components to your SureCart store:
With this process, you can effectively set up and manage your product inventory, contributing to the success of your online store.
We don't respond to the article feedback, we use it to improve our support content.