How To Import And Export On Big Commerce

How To Import And Export On Big Commerce

Kevin Richards
4 years ago

Importing and exporting files on Big Commerce can seem like a daunting task at first but with the steps and video listed below you should be able to import and export with ease. 

 

Before Getting Started

To import and export on Big Commerce you will need access to a program like Excel, Numbers, or Google Sheets that supports CSV and XML files. CSV is recommended due to the fact that it is needed if you plan to import exported data back into Big Commerce.

The CSV requires certain fields for import. 

Creating new products requires:

  • Product name
  • Price fields. 

Importing product images must have:

  • Only allowed characters 
  • Case-sensitive text 
  • Image files that are either JPEG/JPG, GIF or PNG. 

When importing SKUs they must have the:

  • Product SKU
  • Stock level fields

For other common issues visit the Big Commerce troubleshooting page.

 

Choosing An Export Template

Big Commerce provides two export templates.

Bulk edit (recommended) – This template allows you to skip steps in the import process since it prefilled headers that are the same as the ones Big Commerce uses. 

Default – this template only has basic fields like name, weight, description, and price.

You can make your own custom template and decide which export fields to include.

 

Export Your Products

  1. Click on Bulk Edit
  2. Choose Export to ____ (CSV)
  3. Optional- Check Save export to the server for later download (this will save progress in case any interruptions happen while exporting
  4. Click Continue button in the bottom right corner
  5. Click the Download link in the pop-up window

 

Importing Products

  1. Go to Products
  2. Click Import

Steps to take if you used the Bulk Edit 

  1. Check the box next to Bulk Edit Re-Import
  2. The fields will auto-populate
  3. Upload your edited CSV file
  4. Click Next
  5. Edit the Link Import Fields to match the headers in your CSV spreadsheet (if you used the Bulk Edit option this isn’t necessary)
  6. Click Next
  7. Click Start Import
  8. Options will come up click More Information to check for any warnings found during the import process
  9. Click View Imported Products

 

Creating New Products Via Import

When adding a new product there are some things that are required.

Required fields for a new product:

  • Product Name
  • Category
  • Price
  • Weight (physical products only)
  • Track Inventory Value

Leave this field blank otherwise the product will not upload correctly

  • Product ID

To ensure import runs smoothly do not import more than a couple hundred items and use the Bulk Edit CSV if possible.

 

Importing Product Options

To create product variants tied to product options, you will need to add sub-product SKUs or Rules with those attributes. The easiest process is to create the base product first, export it, then add the SKUs or Rules. 

 

Importing Product Images

As mentioned above images have requirements they are:

  • Image file names are restricted to a-z, 0-9, – and _.
  • Image file names cannot contain any spaces or special characters.
  • Image file types must be JPEG/JPG, GIF or PNG. They cannot be TIFF, BMP, or PDF file formats.
  • The optimal size for your product images is 1280 x 1280 pixels. Other product images (like thumbnails) will be created from the original image you upload.

There are two ways to import an image:

  • If the image is already on the Internet you can use the URL to import them using the image path in the CSV file
  • If you’re uploading photos from your computer it’s recommended to upload them using WebDAV

 

How to import using the image path:

  1. Find the column in your CSV for product images. If you’re using the Bulk Edit template, this column will be called Product Image File
    • If you are importing new products, be sure to leave the Product Image ID column blank.
  2. Enter the full path (URL) http must be included
  3. To upload multiple images for a single product, create a new column with a heading of Product Image File – # (increasing the number each time you make a new column)
  4. To include any of the other information for that image (such as descriptions), make a new column with the appropriate heading and the same number as the corresponding image.

 

Ex: 

    • Product Image ID – 2
    • Product Image File – 2
    • Product Image Description – 2
  1. Once these steps have been completed import your items. If you are using a template other than Bulk Edit, match the Product Image field to the correct column on the Link Import Fields step of the import.

 

Uploading through WebDAV:

  1. Connect to your store through WebDAV 
  2. Open the product_images folder followed by the import folder. Then drag and drop the images from your computer into the import folder.
  3. In your product CSV, locate the column for product images. If you are using the Bulk Edit template, this column is called Product Image File – (#). Enter the file name (such as image.png) of the image file.
  4. To upload multiple images for a single product, create a new column with a heading of Product Image File – # (increasing the number each time you make a new column)
  5. To include any of the other information for that image (such as descriptions), make a new column with the appropriate heading and the same number as the corresponding image.
  6. If you are using a template other than Bulk Edit, match the Product Image field to the correct column on the Link Import Fields step of the import.

 

Exporting Specific Products

There are three ways to export specific products. They are selecting individual products, export products based on search or view, export products belonging to a certain category.

Here are the steps to export select individual products:

  1. Go to Products
  2. Click on View
  3. Click the checkbox to the left of the product or products you want to export

 

Testimonials

What Our Customers Are Saying

“I wanted to share the awesomeness of Kevin and Ventura. I just had an amazing meeting. He was so helpful in explaining IT lingo, software vs hosting, visibility, etc. He went to my customer’s website and diagnosed the issues we are facing with fraud and enlightened me on WooCommerce and the differences in some of these platforms. Kevin also gave me recommendations of ways to address those issues, as he put it…”I have a quick answer to your problem”, or “I have a really great answer to your problem!” He will also provide a strategy on how to pitch to the customer based on the culture of the business.”

Happy client
Jen
Account Manager

“I have had the opportunity to work with Ventura on a few projects and the team always provides great insights and direction. I would have no issue in recommending Kevin with any of my customers or prospects.”

Happy client
Kurt Eady
Marketing Manager

“Kevin is the consummate professional. Many web store owners that I have come to speak with highly recommend Ventura Web Design and continue to work with his team to grow their ecommerce business. We recently collaborated on a speaking panel and we worked thru the topic and logistics without missing a beat.”

Happy client
Shirley Tan
Senior Commerce Partner Manager, Oracle

“You are making an impact already! We look forward to great growth with you and your team.”

Happy client
Jamie L
Sales Manager

“I will definitely continue to position Ventura Web Design to my customers.”

Happy client
Jose H
Account Executive

“Ventura did awesome work for Memphis Grindhouse Coffee. Ventura provided step by step guidance on how to create a better customer experience through the website redesign. I recommend Ventura to any ecommerce business due to their extensive knowledge and experience with increasing traffic for ecommerce businesses.”

Happy client
Tre
Account Executive

“Kevin and the team at Ventura are so easy to work with. Thank you Ventura!”

Happy client
Mark C
Account Executive

Ready to get started?

We can't wait to help you grow your business. Our team is ready to help you achieve your goals. Contact us today to get started.