Import and export products on ShopBase

Modified on: Mon, 12 Aug, 2019 at 11:34 AM


Use this migrate app to move data to ShopBase easier while keeping their product & variant IDs so ads performance won’t be impacted. 

If you want to use CSV file instead, check this article for details.


In this article: 

A. How to import products with a CSV file?  

B. How to export products?  

C. How to migrate from Shopify to ShopBase? 

D. How to access your product image files? 

E. What is product CSV file format?


A. How to import products with a CSV file?  

Walkthrough:
1. Head to your ShopBase Admin and click Products

2. Click Import. 

3. Click Choose file in the Import products by CSV file window. 

4. Locate your CSV file, then click to open. 

5. Click the Overwrite existing products that have the same handle checkbox. This will override any data that is on ShopBase. 

6. Click Upload file. 

After this, you will see a preview of your product:  

Preview

After your CSV file is uploaded, a confirmation email will be sent to the email address that you used to set up your ShopBase store.  


B. How to export products? 

You can export your products to a CSV file to help with several tasks:
- Backup of your product listings.
- Moving your existing products to a new ShopBase store.
- Adjusting your products in bulk using a spreadsheet.

Walkthrough:
1. Head to your ShopBase Admin and click Products

2. Click Export.

3. From the dialog box, choose the products you want to export:

  • The current page of products
  • All products
  • Products you have selected (link)

4. Select which type of CSV file you want to export:

  • CSV file for Excel, Numbers, or another spreadsheet program. Use this format if you plan to use a spreadsheet program to edit your product CSV file.
  • Plain CSV file. Use this format if you plan to use a plain-text editor with your product CSV file.

5. Click Export products.


C. How to migrate from Shopify to ShopBase?

Since ShopBase can automatically changes Variant Inventory Tracker and Variant Fulfillment Service to "shopbase" for invalid value in imported files, merchants can upload CSV files downloaded from Shopify right away without having to edit anything.

Shopify CSV files will be automatically edited like this:

  • Variant Fulfilment Service only accepts "manual" or existed fulfillment service. If not, set value of Variant Fulfillment Service as "manual" for all matched products.
  • If Variant Inventory Tracker is not blank and not "shopbase", set value of Variant Inventory Tracker as "shopbase" for all matched products.

If you want to manually edit your CSV files, you can follow these steps: 

Step 1: Export products from your Shopify store. 

Step 2: Updates these fields: 

  • Variant Fulfillment Service: please set it as "manual" or "dropship-connector". 
  • Variant Inventory Tracker: change from "shopify" to "shopbase" or leave it blank (ShopBase has not supported other trackers).

Step 3: Add a column titled Collection and fill in the collections for your products. 

Step 4: Add a column titled Variant Inventory Qty and fill in the product inventory if needed. Merchants can look up with SKU. 

Note for Step 3 & Step 4: It's not required to fill in Collection and Qty sections. If these are filled in, note that you can only fill in rows with titles other than Blank. 

Step 5: Check two columns: SEO title và SEO Description. If these two columns are empty, merchants can fill these in by themselves or copy SEO title as Product Title and SEO Description as Product description. 

Step 6: Import your file to ShopBase. 


D. How to access your product image files?

If you move your products from Shopify to ShopBase, then you need to upload your product CSV file to your new store while your old store and its product listings remain viewable.
When you export your products, the images associated with each product are not included in the CSV file. If you import the products to a new store, then the product images are generated only if they remain viewable on a publicly accessible website.

To ensure that your product images remain accessible to you, leave your original store and its products intact until you finish the import process. This allows your ShopBase store to assign the correct product image to each listing.


E. What is product CSV file format? 

This section will provide the basic information of product CSV file format.  

Please note that the first line of your product CSV needs to include the field headers described in the table, in the same order, each separated by a comma. Subsequent lines in the file should contain data for your product using the same fields in that exact same order. 

Handle 

Handles are unique names for each product. They can contain letters, dashes, and numbers, but no spaces. A handle is used in the URL for each product. For example, the handle for a "Women's Snowboard" should be womens-snowboard, and the product's URL would be http://yourshop.onshopbase.com/products/womens-snowboard .  

Every line in the CSV that starts with a different handle is treated as a new product. To add multiple images to a product, you should add multiple lines with the same handle. 

Title 
The title of your product. Example: Women's Snowboard 
Body (HTML) 
The description of the product in HTML format. This can be plain text without any formatting. 
Vendor (min. 2 characters)  
The name of the vendor for your product. For example, John's Apparel. 
Type  The product type. For example, Snowboard.
 
Tags (can be left blank)  A comma-separated list of tags for the product. Most spreadsheet applications automatically add quotes around the tags for you. If you are using a plain text editor, you will need to manually add the quotes. For example, "tag1, tag2, tag3" 
Published  States whether a product is published on your online store. Valid values are TRUE if the product is published on your online store, or FALSE if the product is hidden from your online store. Leaving the field blank will publish the product.
 
Option1 Name  If a product has an option, then enter its name. For example, Color. 

For products with only one option, this should be set to Title. 

Option1 Value  

If a product has an option, then enter its value. For example, Black. 

For products with only one option, this should be set to Default Title. 

Option2 Name (can be left blank) 
If a product has a second option, then enter its name. For example, Size. 
Option2 Value (can be left blank)     
If a product has a second option, then enter its value. For example, Large. 
Option3 Name (can be left blank) 
If a product has a third option, then enter its name. 
Option3 Value (can be left blank)
 
If a product has a third option, then enter its value.
 
Variant SKU (can be left blank) 
 

The SKU of the product or variant. This is used to track inventory with inventory tracking services. 

This field can't be left blank if you're using a custom fulfillment service.  

Variant Grams 

The weight of the product or variant in grams. Do not specify a unit of measurement or use decimals. For example, for a weight of 5.125 kg, enter 5125.

Shopbase always imports and exports the weight in grams, even if you specify a different unit. You must use accurate weights if you intend to offer carrier-calculated shipping.

Variant Inventory Tracker (can be left blank)
Include your inventory tracking for this variant or product. Valid value is shopbase or blank if inventory is not tracked.
Variant Inventory Qty 

The number of items you have in stock of this product or variant. This column is used only for stores that have a single location.

If your store manages inventory at multiple locations, then this column isn't included. If you want to import or export inventory quantities, use the inventory CSV file.  

Variant Inventory Policy How to handle orders when inventory level for this product or variant has reached zero. Valid values are deny, or continue.deny will stop selling when inventory reaches 0, and continue will allow sales to continue into negative inventory levels.
Variant Fulfillment Service 

The product or variant fulfillment service used. Valid values are: manual and dropship-connector. 

 

Variant Price The price of the product or variant. Don't include any currency symbols. For example, 9.99.
Variant Compare at PriceThe "Compare at Price" of the product or variant. Don't include any currency symbols. For example, 9.99.
Variant Requires Shipping (blank = TRUE)The option to require shipping. Valid values are TRUE, FALSE, or blank.
Variant Taxable (blank = TRUE) Apply taxes to this variant. Valid values are TRUE, FALSE, or blank. 
Variant Barcode (can be left blank) The barcode, ISBN, or UPC of the product. 
Image Src 

Enter the URL for the product image. Shopbase downloads the images during the import and re-uploads them into your store. These images are not variant-specific. The variant image column is where you specify variant images.   

You can't change the image filename after that image has been uploaded to your store. Don't upload images that have _thumb, _small, or _medium suffixes in their names.

Image PositionEnter the number that represents the order in which you want the image to appear on the product's page. The images will appear in order from smallest to largest starting from an image position value of 1. For example, enter 1 if you want the image to appear first for that product.
Image Alt Text (can be left blank) Alt (alternate) text describes an image and is an important part of a product description. If an image can't load for any reason, then alt text is shown instead. It's also used to describe an image to a customer who's visually impaired. Including alt text will boost your website's SEO. Keep your alt text brief and descriptive. The maximum length is 512 characters, but 125 or less is recommended.
SEO TitleThe SEO Title is found on a product's details page under the Search engine listing preview header in the Page title field. The SEO Title has a character (letters and numbers) limit of 70. If you leave this field blank when importing a product, the field is automatically populated with the product title.
SEO Description The SEO Description is also found on a product's details page under the Search engine listing preview header in the Meta description field. The SEO Description has a character (letters and numbers) limit of 320. If you leave this field blank when importing a product, the field is automatically populated with the product description.
Variant Image The URL for images of variants.
Variant Weight UnitValid values are lb, kg, and oz.
Cost per itemHow much it costs you for the product or variant. Don't include any currency symbols. For example, 9.99.

If you need our assistance with the steps, don't hesitate to shoot an email. We are here to help!

ShopBase team.


Did you find it helpful? Yes No

Can you please tell us how we can improve this article?