Import products to ShopBase by CSV file
With ShopBase, you can use CSV file to import and export product information, customer information, orders, discount information, and so on. Please refer to this article if you need to learn more about CSV files and how to create one. In this article, we will show you how to import products to ShopBase through a CSV file.
A. Import products to ShopBase by CSV file
B. Import products while retain Variant ID information
From your ShopBase admin, go to Products > All Products.
Click Import.
Click Choose file in the import products by CSV file window. Tick the option Overwrite existing products that have the same handle if you want to override any data that exists on ShopBase.
Please refer to this example CSV file to create a CSV file according to ShopBase requirements. Fields in CSV file include:
Handle (required): Part of the product link. For example, if the link to the product is https://demostore.onshopbase.com/products/womens-snowboard, then womens-snowboard is the product handle.
Title (required): Product title.
Body (HTML): Product description written in HTML format.
Vendor.
Type: Product type.
Tags: Product tag.
Published (optional): You can enter the value TRUE or keep it blank if you want to publish the product on your store, enter FALSE if you don't.
Custom Option: Product personalization feature.
Variant SKU: SKU code of product/product variant.
Variant Grams (required): Weight of product/product variants in grams.
Variant Inventory Tracker: Authorized party to track the inventory of product/product variant. You can enter shopbase if you allow ShopBase to track product/product variant inventory. If you leave this field blank, the product/product variant inventory is not tracked.
Variant Inventory Qty: Quantity of product inventory/product variant.
Variant Inventory Policy (required): Enter continue if you allow ShopBase to track the number of product variant inventory, or deny if you don't.
Variant Fulfillment Service (required): The order processing service you use. You can enter manual in this field if you manually process your orders.
Variant Price (required): The selling price of the product/product variant.
Variant Compare At Price: Original price of the product/product variant before discount.
Variant Requires Shipping: Whether the product/product variant needs to be shipped to the customer. Valid values in this field are TRUE (yes), FALSE (no), or if you leave it blank the value will be labelled as FALSE.
Variant Taxable: Whether this product/product variant is taxable or not. Valid values in this field are TRUE (yes), FALSE (no), or if you leave it blank the value will be labelled as FALSE.
Variant Barcode: Barcode of product/product variant.
Image Src: Product image link address.
To make sure images are imported correctly, please avoid using commas , in each image link.
Image Alt Text: Alt text you want to insert for product image.
Image Position: Position in product image stacking order.
Gift Card: Whether this product/product variant is applicable for gift card promotion or not.
SEO Title: Product title appears on search engines (It is recommended to have a maximum of 70 characters).
SEO Description: Product description appears on search engines (It is recommended to have a maximum of 320 characters).
Variant Image: Variant image link address. In case the product variant has more than one image, put each link on a new line, or separate each image link using a comma ,.
To make sure images are imported correctly, please avoid using commas , in each image link.
Variant Weight Unit: Unit of weight, acceptable values are g, kg, lb and oz.
Variant Tax Code: Tax code of product/product variant.
Cost per item: The costs associated with the production of the product.
Collection: The collection to which you want to add your product. Before you add a product to a collection, you must create it beforehand on your ShopBase admin. If you add the value of this collection field but do not have a corresponding collection on your ShopBase admin, the data will be ignored and the product will not be added to any collections. Please refer to this article on how to create product collections.
Available On Listing Pages (required): This shows whether the product/product variant is available on the store or not. Valid values in this field are TRUE (yes), FALSE (no). Please refer to this article to understand how to set up product availability.
Available On Sitemap Files (required): This shows whether the product/product variant appears on search engines or not. Valid values in this field are TRUE (yes), FALSE (no). Please refer to this article to learn more about product availability settings.
The number of products you can create per day is limited by your current subscription plan.
The first line contains the names of the fields in the CSV file that should be sorted in the same order as in the sample CSV file.
Browsers like Chrome only allow uploading files within 30 seconds. Heavy CSV files can lead to unsuccessful uploads with the accompanying message "The connection has timed out. Please try again later.". To fix this, you should split the file into a smaller size or connect to a faster network. The file cannot be more than 10 MB.
Click Upload file.
After that, you can preview your file. Click Upload file to finish.
Once the CSV file has been uploaded, a confirmation email will be sent to your email address registered with ShopBase.
To optimize importing speed, your product information with default images will be imported first. Other product images will be imported later. After receiving the confirmation email, if your product images haven't fully loaded, please wait 5-10 minutes.
If you want to update product data while keeping the variant ID:
Export the product information into a CSV file. Modify only the necessary details as per your requirements, do NOT change the variant ID in the file.
Re-import this file into ShopBase, ensuring to select the Overwrite existing products that have the same handle option.
Overview of Products
Add a new product
Import products via Migrate to ShopBase
Export products from ShopBase
In this article
A. Import products to ShopBase by CSV file
B. Import products while retain Variant ID information
A. Import products to ShopBase by CSV file
From your ShopBase admin, go to Products > All Products.
Click Import.
Click Choose file in the import products by CSV file window. Tick the option Overwrite existing products that have the same handle if you want to override any data that exists on ShopBase.
Please refer to this example CSV file to create a CSV file according to ShopBase requirements. Fields in CSV file include:
Handle (required): Part of the product link. For example, if the link to the product is https://demostore.onshopbase.com/products/womens-snowboard, then womens-snowboard is the product handle.
Title (required): Product title.
Body (HTML): Product description written in HTML format.
Vendor.
Type: Product type.
Tags: Product tag.
Published (optional): You can enter the value TRUE or keep it blank if you want to publish the product on your store, enter FALSE if you don't.
Custom Option: Product personalization feature.
Variant SKU: SKU code of product/product variant.
Variant Grams (required): Weight of product/product variants in grams.
Variant Inventory Tracker: Authorized party to track the inventory of product/product variant. You can enter shopbase if you allow ShopBase to track product/product variant inventory. If you leave this field blank, the product/product variant inventory is not tracked.
Variant Inventory Qty: Quantity of product inventory/product variant.
Variant Inventory Policy (required): Enter continue if you allow ShopBase to track the number of product variant inventory, or deny if you don't.
Variant Fulfillment Service (required): The order processing service you use. You can enter manual in this field if you manually process your orders.
Variant Price (required): The selling price of the product/product variant.
Variant Compare At Price: Original price of the product/product variant before discount.
Variant Requires Shipping: Whether the product/product variant needs to be shipped to the customer. Valid values in this field are TRUE (yes), FALSE (no), or if you leave it blank the value will be labelled as FALSE.
Variant Taxable: Whether this product/product variant is taxable or not. Valid values in this field are TRUE (yes), FALSE (no), or if you leave it blank the value will be labelled as FALSE.
Variant Barcode: Barcode of product/product variant.
Image Src: Product image link address.
To make sure images are imported correctly, please avoid using commas , in each image link.
Image Alt Text: Alt text you want to insert for product image.
Image Position: Position in product image stacking order.
Gift Card: Whether this product/product variant is applicable for gift card promotion or not.
SEO Title: Product title appears on search engines (It is recommended to have a maximum of 70 characters).
SEO Description: Product description appears on search engines (It is recommended to have a maximum of 320 characters).
Variant Image: Variant image link address. In case the product variant has more than one image, put each link on a new line, or separate each image link using a comma ,.
To make sure images are imported correctly, please avoid using commas , in each image link.
Variant Weight Unit: Unit of weight, acceptable values are g, kg, lb and oz.
Variant Tax Code: Tax code of product/product variant.
Cost per item: The costs associated with the production of the product.
Collection: The collection to which you want to add your product. Before you add a product to a collection, you must create it beforehand on your ShopBase admin. If you add the value of this collection field but do not have a corresponding collection on your ShopBase admin, the data will be ignored and the product will not be added to any collections. Please refer to this article on how to create product collections.
Available On Listing Pages (required): This shows whether the product/product variant is available on the store or not. Valid values in this field are TRUE (yes), FALSE (no). Please refer to this article to understand how to set up product availability.
Available On Sitemap Files (required): This shows whether the product/product variant appears on search engines or not. Valid values in this field are TRUE (yes), FALSE (no). Please refer to this article to learn more about product availability settings.
The number of products you can create per day is limited by your current subscription plan.
The first line contains the names of the fields in the CSV file that should be sorted in the same order as in the sample CSV file.
Browsers like Chrome only allow uploading files within 30 seconds. Heavy CSV files can lead to unsuccessful uploads with the accompanying message "The connection has timed out. Please try again later.". To fix this, you should split the file into a smaller size or connect to a faster network. The file cannot be more than 10 MB.
Click Upload file.
After that, you can preview your file. Click Upload file to finish.
Once the CSV file has been uploaded, a confirmation email will be sent to your email address registered with ShopBase.
To optimize importing speed, your product information with default images will be imported first. Other product images will be imported later. After receiving the confirmation email, if your product images haven't fully loaded, please wait 5-10 minutes.
B. Import products while retaining Variant ID information
If you want to update product data while keeping the variant ID:
Export the product information into a CSV file. Modify only the necessary details as per your requirements, do NOT change the variant ID in the file.
Re-import this file into ShopBase, ensuring to select the Overwrite existing products that have the same handle option.
Related articles
Overview of Products
Add a new product
Import products via Migrate to ShopBase
Export products from ShopBase
Updated on: 30/05/2024
Thank you!