The Ultimate BigCommerce Export Guide

Import and export operations can help you handle your store’s products, stocks, clients, and other entities. To assist with these duties, BigCommerce offers instruments for moving data to and from your e-commerce store. As a result, various BigCommerce import processes empower you to update product catalogs and customer data, while BigCommerce export operations let you apply bulk adjustments to various entities. In the following article, we focus on the export side of data transfers associated with the platform. 

Although BigCommerce works only with CSV and XML files, it does support a few extra export entities. Thus, BigCommerce order export and BigCommerce product export are at your service. Also, you can transfer such product-related entities as product options or variations and images. Note that the system lets you apply filters to narrow down the selection of items you transfer from your website. Below, we explain how to export products in a certain category in BigCommerce, as well as shed light on how to export customers with addresses. We explore the many data types that can be exported by default along with those not supported by the platforms, including BigCommerce customer export, BigCommerce customer review export, or the entire BigCommerce database export. With the help of this guide, you will learn how to export orders, products, product options, product images, customers, 301 redirects, categories, and customer reviews from your e-commerce website. Also, we teach how to add an export template in BigCommerce and customize it. For additional information on the import side of the topic, go to the corresponding BigCommerce Import Guide.

Firebear Import & Export Tool for BigCommerce

BigCommerce Export General Overview

You can examine your product, order, or customer data in spreadsheet form by exporting it out of BigCommerce. After that, it is possible to apply modifications (such as changing product prices or descriptions) and re-import the data back into your store or transfer it to third-party software.

In terms of supported file formats, the default BigCommerce export lets you create output as CSV or XML files. If you intend to re-import the data, it is highly recommended to export it as CSV.

As for the supported entities, the BigCommerce export covers orders, products with product options and SKUs, customers, 301 redirects, and even Ecommerce Analytics Reports. The default capabilities usually result in the following use-cases:

• Updating your store data. You can export orders, products, or customers to update the corresponding tables and re-import them back, updating your database in BigCommerce with no additional and time-consuming movements in the control panel.
• Creating product options. A more specific subject for the previous use case is associated with adding product variants to the existing items. Although you may export product variations from BigCommerce by default, in some cases, it is necessary to transfer simple items, add variants to them manually, and then re-import them to create product options. 
• Exporting data for third-party systems. You can use the BigCommerce export functionality to transfer data to various ERP, CRM, and accounting systems. Create output and match it to the requirements of the accepting platform.
• Making backups. And, of course, you can export a CSV file from BigCommerce to create a backup of products, orders, customers, etc. 

Note that it is highly recommended to export your file to the server and then download it from there rather than using the control panel and straight file downloads if you are exporting a lot of data. This will enhance the export process’ stability. While exporting your products, clients, or other items, save an export for later download from the server by choosing the corresponding option.

After that, you can download your export file from the export folder at your WebDAV.

Export Templates

To simplify your data transfer endeavors (both import and export), BigCommerce introduces export templates. You will be prompted to choose an export template when exporting items, orders, customers, or product SKUs. The selected template determines which fields are available in a CSV file you transfer. Utilizing the Bulk Edit template for exporting Products and Customers and the Default template when exporting Orders.

However, you might discover that using a unique export template is preferable. With a custom template, you may alter the formatting settings, rename the headers, and choose which fields are exported. How to add an export template in BigCommerce, you will ask? You will find the answer below. We explain how to create an export template in BigCommerce following your specific business requirements.

How To Add An Export Template In BigCommerce?

The easiest method to guarantee that your export contains exactly what you want is to customize your templates. A copy of an existing export template can be modified to meet your needs, or you can create one from the start. These are perfect for updating quickly, running reports, or moving goods to another store.

Go to Settings -> Export templates to create an export template in BigCommerce. The ready-to-use templates are already there.

So, how to add an export template in BigCommerce as fast as possible? Even though you can make an export template from scratch, we advise making a duplicate of the Bulk Edit template and customizing it for your requirements. It is the most user-friendly approach. When you later re-import with a BigCommerce custom export template like this, you can do so without going through the settings and field mapping. 

You can add an export template in BigCommerce as follows:

1. As we’ve just mentioned, there are two ways to create an export template in BigCommerce: you can either click Create an Export Template to create a new one or click Choose an Action and specify Create a Copy next to the Bulk Edit template.
   
   
2. You may provide a template name under the Template Details tab. Give your template a unique name that reminds you of its functions, such as Quantity Update or Price Change.
   
   
3. Proceed to Export Options, and check the data type you are creating the template for. Observe how your choices alter the tabs listed at the top.
   
   
4. The data type tab can be found at the top of the screen. Let’s click the Products tab to illustrate how to add an export template in BigCommerce.
   
   
5. Check or uncheck each field as necessary by going through the list of fields. Do not forget that some fields are necessary for re-import.
6. Click Save & Exit after you have finished editing. Your new BigCommerce export template lets you transfer your data following your unique requirements. By selecting Export [data type] from the Choose an Action dropdown menu, you can launch the export process. In our case, it is Export Customers:
   
   

Field Formatting

The Field Formatting Options section is included in the template details underneath the Export Options section. With the use of the available choices, you can manage how the template’s fields are formatted during export.

The following options are at your service:

• Several formatting options for dates are available in the Date Format dropdown menu for the export;
• Price Format is a dropdown menu where users can choose their preferred price display format;
• In Boolean Format, you can configure the BigCommerce export boolean format via a dropdown menu with a selection of how to present Boolean outputs;;
• Blank for False? is here to help you verify that blank fields in Boolean options also represent the negative value;
• Remove HTML? makes sure that the product descriptions are free of HTML. Use it to make your product descriptions style- and formatting-free. We advise creating a backup of your products before turning on this feature.

Product Export

This section consists of just one item – Include Product Options? Check it to include product options in your export CSV.

Advanced CSV Export Settings

If you are utilizing the Bulk Edit template, you can usually leave these options untouched. However, it is possible to change them to suit the particular export requirements. For instance, setting Sub Items to display each item on a separate line simplifies viewing products in an order.

So, creating an export template in BigCommerce is associated with the following Advanced CSV Export Settings:

• Field Separator – a character that separates each field in the export (comma by default);.
• Field Enclosure – a character that encloses the contents of each field (double quote by default);
• First Line as Field Names? – select this option to have the names of fields that are being exported appear in the first row of the export, such as Product Name and SKU;
• Blank Line Between Records – check this box to add a blank line between each content row in the export;
• Sub Items – a dropdown menu that shows options to display the sub-items in the export;
• Sub-Item Separator – a character to serve as a sub-item separator upon export (vertical bar by default). The character designated as the Field Separator must be different from this;
• New Line Character – a dropdown menu to choose the format of new lines in the export.

The BigCommerce custom template creation process looks as follows:

How To Edit And Delete Export Templates in Bigcommerce

While custom templates can be edited or removed, the built-in templates stay unchanged. You will need to use the methods described above to copy and customize a built-in template if you want to change it.

Editing An Existing BigCommerce Export Template

Select Edit from the Choose an Action dropdown next to the template you want to change. You will be directed to the template’s edit page. Save your changes by clicking Save & Exit.

Deleting An Existing BigCommerce Export Template

Select Delete from the Choose an Action dropdown next to the template you want to change. The system will display a pop-up asking you to confirm your action. Click OK to delete your customer export template.

BigCommerce Export: Orders

Now, when you are familiar with BigCommerce export templates, let’s see how to export orders to a CSV file in BigCommerce. Although it is possible to use XMl files to create the output, we will focus on the CSV side of the process. You will learn what default template to choose and how to create a BigCommerce custom order export template. After that we describe the general order export procedure and proceed to more specific use cases. The table of supported fields is also available in this chapter, so you can discover order attributes available in an exported CSV file as well as columns that can be added manually. You can use this chapter to learn how to export orders from BigCommerce to Shopify and other e-commerce platforms or ERP systems. At the same time, keep in mind that there is a better way to achieve this goal associated with third-party instruments. Contact us to export BigCommerce orders to Magento. We have huge experience in the area of data transfers.

How To Choose A BigCommerce Export Template For Order Fulfilment

It is extremely important to choose a proper template for order export since it is responsible for transferring particular order data out of your e-commerce website. Note that all BigCommerce order export templates a similar from the perspective of such details as the order ID and customer name. Nonetheless, you may still get more granular regarding other aspects of your exported order CSV.

BigCommerce order export offers the following templates by default:

• Default – this template contains basic order information, such as order total, customer information, and shipping information. A full list of what’s included in the default template is available in the table below.
• MYOB – BigCommerce offers a template configured for exporting to the MYOB accounting software.
• Peachtree – it also provides a template configured for exporting to the Peachtree accounting software.

If the standard templates listed above are insufficient to fulfill your business demands, you can always create custom order export templates in BigCommerce.

How To Create An Export Template For BigCommerce Order Export

You need to create a custom template to export and filter web orders to a spreadsheet in BigCommerce. The easiest method to make sure your export table has everything you want is to customize the default template. A copy of an existing template can be modified to meet your unique business needs, or you can create an export template from start, following all the very nuances.

We advise making a duplicate of the Default template and then editing it to implement the first approach since it is associated with bypassing the settings and field mapping upon import via a custom template.

Follow these steps to create a custom order export template in BigCommerce: 

1. Go to Settings/Export templates to get started. Create a copy of the Default template there using the Action menu.
   
2. Give your template a name in the Template Details box, and because it will be used to export orders, make sure the only choice selected under Export Options is Enable Orders Exporting. The tabs listed along the top are updated according to your selections.
   
3. Change the remaining template settings to suit your requirements. When you’re ready, select the Orders tab at the top to see the export fields that are accessible.
   
4. Check or uncheck each field as necessary in your case. Once you’ve finished making your changes, click Save & Exit. Use your new template to export your order data.
   

How To Export Orders To CSV File In BigCommerce

You can export and filter orders to a CSV file in BigCommerce as follows:

1. Proceed to the Orders -> Export Orders page. Here, you can configure order export settings.
   Where
   – Template is your custom export template that we created above. Select it to export and filter web orders to a spreadsheet in BigCommerce. For a default order export procedure, it is recommended to use the Default template.
   – File Format lets you choose either a CSV or XML format for your order export file.
   – Save export to the server for later download? This option introduces a more stable BigCommerce order export by saving the file to your exports folder in WebDAV. If you are going to export more than 1k orders, activate this feature.
2. Click Continue to proceed. A pop-up displays where you can initiate the export process by clicking Export my orders to a CSV file.
   
   
3. Click Download my Orders file when prompted.
   
   

That’s it! You need to make just three steps to export orders to CSV file in BigCommerce. However, there are several more specific use cases that we explain below. You can use the following step-by-step guides to export selected orders in BigCommerce instead of transferring all the records. Learn about the opposite process here: How to import orders to BigCommerce (order tracking numbers).

How To Export Specific Orders From BigCommerce

Let’s take a look at how to narrow down the selection of orders to export only specific orders from your BigCommerce website.

How to Export Orders By Keywords

In BigCommerce, keywords associated with particular orders can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export orders for specific keywords. To achieve this goal, you need to search your orders by a particular keyword and then run through the standard BigCommerce order export. 

Follow the steps below to export orders by keywords in BigCommerce:

1. Visit your order search page under Orders -> Search. Here, you need to scroll down to the Advanced Search section.
2. Specify a keyword in the Search Keywords field. Note that keywords only relate to order IDs and shipping/billing details.
   
   
3. Select orders you want to export (probably, all of the orders for the specified keyword or just specific ones) and click Export All.
4. Follow the standard procedure described above to export orders by a keyword in BigCommerce.

That’s how to export orders to CSV file in BigCommerce via keywords.

How to Export Orders By Order Status

In BigCommerce, an order status associated with particular orders can be used as a filter to narrow down the selection of records that you want to transfer. You can export orders by order status in BigCommerce. To achieve this goal, you need to search your orders by particular order status and then run through the standard BigCommerce order export. 

Follow the steps below to export orders by order status in BigCommerce:

1. Visit your order search page under Orders -> Search. Here, you need to scroll down to the Advanced Search section.
2. Select an order status in the Order Status field.
   
   
3. Select orders you want to export (probably, all of the orders for the specified order status or just specific ones) and click Export All.
4. Follow the standard procedure described above to export orders by a keyword in BigCommerce.

That’s how to export orders to CSV file in BigCommerce via order status.

How to Export Orders By Payment Method

In BigCommerce, a payment method associated with particular orders can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export orders by payment method. To achieve this goal, you need to search your orders by a particular payment method and then run through the standard BigCommerce order export. 

Follow the steps below to export orders by payment method in BigCommerce:

1. Visit your order search page under Orders -> Search. Here, you need to scroll down to the Advanced Search section.
2. Select a payment method in the Payment Method field.
   
   
3. Select orders you want to export (probably, all of the orders for the specified payment method or just specific ones) and click Export All.
4. Follow the standard procedure described above to export orders by a keyword in BigCommerce.

That’s how to export orders to CSV file in BigCommerce via payment method.

How to Export Orders By Sales Channel

In BigCommerce, a sales channel associated with particular orders can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export orders by sales channels. To achieve this goal, you need to search your orders by a particular sales channel and then run through the standard BigCommerce order export. 

Follow the steps below to export orders by sales channel in BigCommerce:

1. Visit your order search page under Orders -> Search. Here, you need to scroll down to the Advanced Search section.
2. Select a sales channel in the Channel field.
   
   
3. Select orders you want to export (probably, all of the orders for the specified sales channel or just specific ones) and click Export All.
4. Follow the standard procedure described above to export orders by a keyword in BigCommerce.

That’s how to export orders to CSV file in BigCommerce via sales channel.

How to Export Orders By Shipping Method

In BigCommerce, a shipping method associated with particular orders can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export orders by shipping method. To achieve this goal, you need to search your orders by a particular shipping method and then run through the standard BigCommerce order export. 

Follow the steps below to export orders by shipping method in BigCommerce:

1. Visit your order search page under Orders -> Search. Here, you need to scroll down to the Advanced Search section.
2. Select a shipping method in the Shipping Method field.
   
   
3. Select orders you want to export (probably, all of the orders for the specified shipping method or just specific ones) and click Export All.
4. Follow the standard procedure described above to export orders by a keyword in BigCommerce.

That’s how to export orders to CSV file in BigCommerce via shipping method.

How to Export Orders By Fulfillment Source

In BigCommerce, a fulfillment source associated with particular orders can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export orders by fulfillment sources. To achieve this goal, you need to search your orders by a particular fulfillment source and then run through the standard BigCommerce order export. 

Follow the steps below to export orders by fulfillment source in BigCommerce:

1. Visit your order search page under Orders -> Search. Here, you need to scroll down to the Advanced Search section.
2. Select a fulfillment source in the Fulfillment Source field.
   
   
3. Select orders you want to export (probably, all of the orders for the specified fulfillment source or just specific ones) and click Export All.
4. Follow the standard procedure described above to export orders by a keyword in BigCommerce.

That’s how to export orders to CSV file in BigCommerce via fulfillment source.

How to Export Orders By Coupon Code

In BigCommerce, a coupon code associated with particular orders can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export orders by coupon codes. To achieve this goal, you need to search your orders by a particular coupon code and then run through the standard BigCommerce order export. 

Follow the steps below to export orders by coupon code in BigCommerce:

1. Visit your order search page under Orders -> Search. Here, you need to scroll down to the Advanced Search section.
2. Specify a coupon code in the Coupon Code field.
   
   
3. Select orders you want to export (probably, all of the orders for the specified coupon code or just specific ones) and click Export All.
4. Follow the standard procedure described above to export orders by a keyword in BigCommerce.

That’s how to export orders to CSV file in BigCommerce via coupon code.

How to Export Orders By ID

In BigCommerce, order ID can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export orders for specific order IDs. To achieve this goal, you need to search your orders for a particular ID range and then run through the standard BigCommerce order export. 

Follow the steps below to export orders by ID in BigCommerce:

1. Visit your order search page under Orders -> Search. Here, you need to scroll down to the Search by Range section.
2. Specify an order ID range.
   
   
3. Select orders you want to export (probably, all of the orders for the specified range or just specific IDs) and click Export All.
4. Follow the standard procedure described above to export orders by IDs in BigCommerce.

That’s how to export orders to CSV file in BigCommerce via order ID.

How to Export Orders By Order Total

In BigCommerce, order total can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export orders for a specific range of order totals. To achieve this goal, you need to search your orders for a particular order total range and then run through the standard BigCommerce order export. 

Follow the steps below to export orders by order total in BigCommerce:

1. Visit your order search page under Orders -> Search. Here, you need to scroll down to the Search by Range section.
2. Specify an order total range.
   
   
3. Select orders you want to export (probably, all of the orders for the specified range or just orders with specific order totals) and click Export All.
4. Follow the standard procedure described above to export orders by order total in BigCommerce.

That’s how to export orders to CSV file in BigCommerce via order total.

How to Export Orders By Date Range

In BigCommerce, export orders date format can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export orders from within a certain date range. To achieve this goal, you only need to search your orders for a particular date range and then run through the standard BigCommerce order export. 

Follow the steps below to export orders by date range in BigCommerce:

1. Visit your order search page under Orders -> Search. Here, you need to scroll down to the Search by Date section.
2. Select your date range from the drop-down (Today, Yesterday, Last 24 Hours, Last 7 Days, Last 30 Days, This Month, or This Year) or choose Custom Period.
3. Sat Date Type to Order Date and click Search.
   
   
4. Select orders you want to export (probably, all of the orders for the specified date range) and click Export All.
5. Follow the standard procedure described above to export orders by date range in BigCommerce.

That’s how to export orders to CSV file in BigCommerce for a particular date range.

BigCommerce Order Export CSV: Exportable Fields

The data that can be exported during the default order export procedure ir organized by the following fields. When utilizing the Default export template, most of them are present.

Custom Export Template Fields

The following fields are not available in the Default export template. However, you can add them manually to your custom order export template in BigCommerce.

BigCommerce Export: Products

Below, we explain how to export products from BigCommerce. You will learn what default template to choose and how to create a BigCommerce custom export template. After that, we describe the general product export procedure and proceed to more specific use cases. The table of supported fields is also available in this chapter, so you can discover product attributes available in an exported CSV file as well as columns that can be added manually. You can use this chapter to learn how to export products from BigCommerce to Shopify and other e-commerce platforms or ERP systems. At the same time, remember that there is a better way to achieve this goal associated with third-party instruments. Contact us to export BigCommerce products to Magento. We have huge experience in this area. 

How To Choose A Product Export Template in BigCommerce

You need to select a template to export products out of BigCommerce. The type of product information you are exporting is determined by an export template you choose. The product name will be included in all export templates, but you can also include other information like the price and dimensions.

Several product export templates are pre-built inside BigCommerce:

• Bulk Edit (recommended) – this template is designed to assist you with updating your product information. It contains the majority of exportable fields along with specifically named columns. As a result, you can skip most steps while importing products to BigCommerce with the help of this template.
• Default – this template, in its turn, includes only such basic product details as name, weight, description, and price.

How To Add An Export Template in BigCommerce For Product Export

Instead of these two options, you can also create a custom product export template, selecting only the product fields that should be exported.

The easiest method to ensure your product export has all you want is to customize your BigCommerce product export template. A copy of an existing export template can be modified to meet your needs, or you can create one from the start.

Let’s explore the case when the Bulk Edit template is copied and customized for your needs. When you later re-import it, you can avoid custom settings and field mapping. Follow these steps to create a custom product export template in BigCommerce:

1. Visit Settings -› Export templates and select Create a Copy from the Action dropdown to duplicate the Bulk Edit template.
   
2. Name your template.
3. Check Enable Products Exporting – it should be the only option selected under Export Options.
   
4. Work with other settings to customize the template according to your needs. 
5. Click the Products tab at the top to examine the available product export fields and check the necessary ones.
   
6. Click Save & Exit when finished.

How To Export Products in BigCommerce

Follow these steps to export products from a BigCommerce store:

1. You can start exporting products under Products -> Export.
2. Select your export template and file format (CSV or XML). At this stage, you can also choose between a direct download and saving your exported product CSV on your server.
   
3. Hit the Continue button and click Export my Products to a CSV file.
   
4. When your product export is complete, hit Download my Products file to get your product CSV on a computer.
   

Now, you can edit and update your products. Apply changes in a spreadsheet editor and import product CSV back to BigCommerce. Also, save a copy of the exported file separately to ensure you have a backup.

How To Export Variations From BigCommerce

If you want to export variations from BigCommerce, Follow these steps:

• Go to Settings -> Export templates;
• Hit Create an Export Template;
• Name your template;
• Choose products as your export entity – check Enable Products Exporting?;
• Configure Field Formating Options if necessary;
• Enable Include Product Options? in your export template under Product Export Options;
  
  
• Configure Advanced CSV Export Settings if necessary;
• Save your template and use it to export options from BigCommerce.

However, BigCommerce variation export seems even simpler since the Include Product Options? feature in your Bulk Export template is enabled by default. It means that you can use it to export product options from BigCommerce. Learn more about BigCommerce product option import.

How to Export Specific Products From BigCommerce

Below, we explore several specific use cases for the BigCommerce product export that let you move items out of your e-commerce website more precisely.

 How to Export Products By Keywords

In BigCommerce, keywords associated with particular products can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export products for specific keywords. To achieve this goal, you need to search your products by a particular keyword and then run through the standard BigCommerce product export. 

Follow the steps below to export products by keywords in BigCommerce:

1. Visit your product search page under Products -> Search. Here, you need to scroll down to the Advanced Search section.
2. Specify a keyword in the Search Keywords field.
   
   
3. Select products you want to export and click Export All.
4. Follow the standard procedure described above to export products by a keyword in BigCommerce.

How to Export Products Starting From A Specific Letter

In BigCommerce, the first letter in a product name can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export products with names that spart from a particular letter. To achieve this goal, you need to search your products by this letter and then run through the standard BigCommerce product export. 

Follow the steps below to export products by specific letter in BigCommerce:

1. Visit your product search page under Products -> Search. Here, you need to scroll down to the Advanced Search section.
2. Choose a letter or a number range in the Starts With the Letter field.
   
   
3. Select products you want to export and click Export All.
4. Follow the standard procedure described above to export products that start from a specific letter in BigCommerce.

How to Export Products By Brand

In BigCommerce, brands associated with particular products can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export products for specific brands. To achieve this goal, you need to search your products by brand and then run through the standard BigCommerce product export. 

Follow the steps below to export products by brands in BigCommerce:

1. Visit your product search page under Products -> Search. Here, you need to scroll down to the Advanced Search section.
2. Specify a brand in the Brand Name field.
   
   
3. Select products you want to export and click Export All.
4. Follow the standard procedure described above to export products by a brand in BigCommerce.

How to Export Products By Category

In BigCommerce, brands associated with particular products can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export products for specific categories only. To achieve this goal, you need to search your products by category and then run through the standard BigCommerce product export. 

Follow the steps below to see how to export products in a certain category in BigCommerce:

1. Visit your product search page under Products -> Search. Here, you need to scroll down to the Advanced Search section.
2. Specify a category in the Categories field. Note that you can select multiple categories as well as choose sub-categories as a filter parameter.
   
   
3. Select products you want to export and click Export All.
4. Follow the standard procedure described above to export products in a certain category in BigCommerce.

How to Export Products By Price Range

In BigCommerce, a price range can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export products for a specific price range. To achieve this goal, you need to search your products for a particular price range and then run through the standard BigCommerce product export. 

Follow the steps below to export products for price range in BigCommerce:

1. Visit your product search page under Products -> Search. Here, you need to scroll down to the Search by Range section.
2. Specify a product price range in the Price Range field.
   
   
3. Select products you want to export and click Export All.
4. Follow the standard procedure described above to export products by price range in BigCommerce.

How to Export Products By Quantity Sold

In BigCommerce, a product sold quantity can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export products associated with a specific sold quantity. To achieve this goal, you need to search your products for a particular quantity sold range and then run through the standard BigCommerce product export. 

Follow the steps below to export products for the quantity sold range in BigCommerce:

1. Visit your product search page under Products -> Search. Here, you need to scroll down to the Search by Range section.
2. Specify a quantity sold range in the Quantity Sold field.
   
   
3. Select products you want to export and click Export All.
4. Follow the standard procedure described above to export products by quantity sold range in BigCommerce.

How to Export Products By Inventory Level

In BigCommerce, an inventory level can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export products for a specific inventory level. To achieve this goal, you need to search your products for a particular inventory level and then run through the standard BigCommerce product export. 

Follow the steps below to export products for inventory level in BigCommerce:

1. Visit your product search page under Products -> Search. Here, you need to scroll down to the Search by Range section.
2. Specify a product inventory level in the Inventory Level field.
   
   
3. Select products you want to export and click Export All.
4. Follow the standard procedure described above to export products by inventory level in BigCommerce.

How to Export Products By Product Visibility

In BigCommerce, product visibility can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export only visible or only invisible products. To achieve this goal, you need to search your products for a particular visibility setting and then run through the standard BigCommerce product export. 

Follow the steps below to export product by product visibility in BigCommerce:

1. Visit your product search page under Products -> Search. Here, you need to scroll down to the Search by Setting section.
2. Specify a product visibility setting (visible or invisible) in the Product Visibility field.
   
   
3. Select products you want to export and click Export All.
4. Follow the standard procedure described above to export products by product visibility in BigCommerce.

How to Export Featured And Non-Featured Products

In BigCommerce, a featured product setting can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export only featured or only non-featured products. To achieve this goal, you need to search your products for a particular featured product setting and then run through the standard BigCommerce product export. 

Follow the steps below to export featured or non-featured products in BigCommerce:

1. Visit your product search page under Products -> Search. Here, you need to scroll down to the Search by Setting section.
2. Specify whether you want to export featured or non-featured products in the Featured Product field.
   
   
3. Select products you want to export and click Export All.
4. Follow the standard procedure described above to export featured or non-featured products in BigCommerce.

How to Export Products With Free Shipping

In BigCommerce, free or paid shipping can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export products with free shipping only. To achieve this goal, you need to search your products using a free shipping parameter and then run through the standard BigCommerce product export. 

Follow the steps below to export products with free shipping  in BigCommerce:

1. Visit your product search page under Products -> Search. Here, you need to scroll down to the Search by Setting section.
2. Specify whether it is a product with free shipping or paid one in the Free Shipping field.
   
   
3. Select products you want to export and click Export All.
4. Follow the standard procedure described above to export products with free shipping in BigCommerce.

How to Export Products By Status

In BigCommerce, a product status can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to separately export products that can be purchased, pre-ordered, or cannot be purchased. To achieve this goal, you need to search your products using their status and then run through the standard BigCommerce product export. 

Follow the steps below to export products by status in BigCommerce:

1. Visit your product search page under Products -> Search. Here, you need to scroll down to the Search by Setting section.
2. Specify whether it is a product that can be purchased, pre-ordered, or cannot be purchased in the Status field.
   
   
3. Select products you want to export and click Export All.
4. Follow the standard procedure described above to export products by status in BigCommerce.

How to Export Product SKUs

You can export product SKUs in BigCommerce as follows:

1. Go to Products -> Export Product SKUs;
2. Select the SKU Inventory Management template;
3. Choose a file format: CSV or XML;
4. Select your export destination: server or direct download;
5. Click Continue and follow the standard BigCommerce export routine.
   
   

You will get a file with the following columns: Product SKU, Product UPC/EAN, Stock Level, Product Width, Product Height, Product Depth, Free Shipping, and Fixed Shipping Cost.

BigCommerce Product Export CSV: Exportable Fields

The table below lists every field that may be exported and imported using the Bulk Edit Template through a CSV file. If a field is not listed here, it cannot be manually imported, exported, or generated (for example, bulk pricing).

See Custom Export Template Fields for a list of fields that can be manually added and re-imported but are not included in the Bulk Edit template.

Custom Export Template Fields

Although they are not by default present in the Bulk Edit template, the following fields can be manually added and reimported using Bulk Edit Re-Import. In the Match Fields area, they will also be automatically matched.

BigCommerce Export: Customers

Below, we explain how to export customers from BigCommerce. You will learn what default template to choose and how to create a BigCommerce custom export template. After that, we describe the general customer export procedure that lets you export customers with address data and proceed to more specific use cases. The table of supported fields is also available in this chapter, so you can discover customer attributes available in an exported CSV file as well as columns that can be added manually. You can use this chapter to learn how to export customers from BigCommerce to Mailchimp or various e-commerce platforms and sales channels, including Shopify, Shopware, and other platforms. At the same time, keep in mind that there is a better way to achieve this goal associated with third-party instruments. Contact us to export BigCommerce customers to Magento. We have huge experience in this area.

How To Choose A Customer Export Template in BigCommerce

With the help of a customer export template, you may specify exactly what customer data you’re exporting. All templates contain such information as the client’s name and email address, but you can use specific templates to obtain more specific customer data. See the table of Supported Fields in this chapter below for a complete list of data that can be exported.

Various customer export templates available in BigCommerce include:

• Bulk Edit – use this template to update your customer data. It contains almost all exportable fields along with specifically named columns that let you skip some steps in the BisgCommerce customer import.
• Default – this one includes the following basic details: first name, last name, email address, phone number, and address data.
• MYOB – use it for the BigCommerce MYOB accounting software integration.
• Peachtree Accounting – use this template for the BigCommerce Peachtree accounting software integration.

As we’ve already stated several times, you can create custom customer export templates in addition to the above pre-made solutions.

How To Create An Export Template For BigCommerce Customer Export

The easiest method to make sure your customer export contains all the information your particular business case requires is to customize it. A copy of an existing export template can be modified to follow your standards. Alternatively, you can create a customer export template from scratch.

We explain a situation when the Bulk Edit template is copied and customized for your needs below. When you later re-import customer data with its help, you can do so without having to go through some settings and field mapping.

1. Go to Settings -> Export templates to get started. Create a copy of the Bulk Edit template using the Action menu.
   
2. Specify your customer export template name in the Template Details section. Select Enable Customers Exporting? under Export Options.
   
3. Apply changes to the rest of the template settings according to your requirements. Click the Customers tab at the top to specify what fields are available for the BigCommerce customer export.
4.  Apply changes and click Save & Exit. Now, you can export your customer data using the new custom template.

How to Export Customers with Addresses In BigCommerce

Follow these steps to export customers from BigCommerce:

1. Proceed to Customers -> Export. 
2. Select your template, file format, and destination (server or direct download).
   
3. After that, you can click the Continue button and then – Export my customers to a CSV file.
   
4. You need to wait for a while until the system prepares your customer CSV for download. Click the download link when it is ready.
   

If you need to move client data back to your website, follow this link: How to import customers in BigCommerce.

How to Export Specific Customers From BigCommerce

Below, we explore several specific use cases for the BigCommerce customer export that let you move client data out of your e-commerce website more precisely.

How to Export Customers By Keywords

In BigCommerce, keywords associated with particular customers can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export customers that match specific keywords. To achieve this goal, you need to search your customers by a particular keyword and then run through the standard BigCommerce customer export. 

Follow the steps below to export customers by keywords in BigCommerce:

1. Visit your customer search page under Customers -> Search. Here, you need to scroll down to the Advanced Search section.
2. Specify a keyword in the Search Keywords field.
   
   
3. Select customers you want to export and click Export All.
4. Follow the standard procedure described above to export customers who match a keyword in BigCommerce.

How to Export Customers by A Specific Letter

In BigCommerce, the first letter in a customer name can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export customers with names that start from a particular character. To achieve this goal, you need to search your customers by this letter and then run through the standard BigCommerce customer export. 

Follow the steps below to export customers by specific letter in BigCommerce:

1. Visit your product search page under Customers -> Search. Here, you need to scroll down to the Advanced Search section.
2. Type a letter in the Starts With the Letter field.
   
   
3. Select customers you want to export and click Export All.
4. Follow the standard procedure described above to export customers that start from a specific letter in BigCommerce.

How to Export Customers By Phone Numbers

In BigCommerce, a phone number associated with a particular customer can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export customers that match specific phone numbers. To achieve this goal, you need to search your customers by a particular number and then run through the standard BigCommerce customer export. 

Follow the steps below to export customers by phone numbers in BigCommerce:

1. Visit your customer search page under Customers -> Search. Here, you need to scroll down to the Advanced Search section.
2. Specify a number in the Phone field.
   
3. Select customers you want to export and click Export All.
4. Follow the standard procedure described above to export customers who match a keyword in BigCommerce.

How to Export Customers By Country

In BigCommerce, a country associated with particular customers can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export customers by country. To achieve this goal, you need to search customers by their country and then run through the standard BigCommerce customer export. Alternatively, it is possible to export customers for a particular state or province.

Follow the steps below to export customers by country in BigCommerce:

1. Visit your customer search page under Customers -> Search. Here, you need to scroll down to the Advanced Search section.
2. Specify a country (state or province) in the Country (State/Province) field.
   
   
3. Select customers you want to export and click Export All.
4. Follow the standard procedure described above to export customers by country in BigCommerce.

How to Export Customers By Customer ID

In BigCommerce, a customer ID can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export customers for a range of customer IDs. To achieve this goal, you need to search your customers by a particular customer ID range and then initiate the standard BigCommerce customer export. 

Follow the steps below to export customers by customer IDs in BigCommerce:

1. Visit your product search page under Customers -> Search. Here, you need to scroll down to the Search by Range section.
2. Specify a range of customer IDs in the Customer ID field.
   
   
3. Select customers you want to export and click Export All.
4. Follow the standard procedure described above to export customers by IDs in BigCommerce.

How to Export Customers By Number of Orders

In BigCommerce, the number of orders associated with each customer can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export customers for a range of orders placed on your website. To achieve this goal, you need to search your customers by a particular range of orders and then initiate the standard BigCommerce customer export. 

Follow the steps below to export customers by the number of orders in BigCommerce:

1. Visit your product search page under Customers -> Search. Here, you need to scroll down to the Search by Range section.
2. Specify a range of orders in the Number of Orders field.
   
   
3. Select customers you want to export and click Export All.
4. Follow the standard procedure described above to export customers by the number of orders in BigCommerce.

How to Export Customers By Store Credit

In BigCommerce, a store credit associated with each customer can be used as a filter to narrow down the selection of records that you want to transfer. The platform empowers you to export customers for a range of store credits they have. To achieve this goal, you need to search your customers by a particular range and then initiate the standard BigCommerce customer export. 

Follow the steps below to export customers by store credit in BigCommerce:

1. Visit your product search page under Customers -> Search. Here, you need to scroll down to the Search by Range section.
2. Specify a range of store credits in the Store Credit field.
   
   
3. Select customers you want to export and click Export All.
4. Follow the standard procedure described above to export customers by store credit in BigCommerce.

How to Export Customers By Date

In BigCommerce, a specific date range can be used as a filter to narrow down the selection of records that you want to transfer. Thus, you can export a list of customers who registered in past year or month in BigCommerce. To achieve this goal, you need to search your shoppers by particular time frames and then initiate the standard BigCommerce customer export. 

Follow the steps below to export customers by store credit in BigCommerce:

1. Visit your product search page under Customers -> Search. Here, you need to scroll down to the Search by Date section.
2. Specify a date range in the Date Joined field.
   
   
3. Select customers you want to export and click Export All.
4. Follow the standard procedure described above to export customers by date in BigCommerce.

How to Export Customers By Customer Group

In BigCommerce, a customer group can be used as a filter to narrow down the selection of records that you want to transfer. Thus, you can export a list of customers who belong to a particular customer group only. To achieve this goal, you need to search your shoppers by particular time frames and then initiate the standard BigCommerce customer export. 

Follow the steps below to export customers by customer group in BigCommerce:

1. Visit your product search page under Customers -> Search. Here, you need to scroll down to the Search by Group section.
2. Specify a customer group in the Customer Group field.
   
   
3. Select customers you want to export and click Export All.
4. Follow the standard procedure described above to export customers by date in BigCommerce.

BigCommerce Customer Export CSV: Exportable Fields

The table below includes all customer attributes that can be exported as CSV. The majority of these fields are available when using the Bulk Edit export template. See Custom Export Template Fields for a list of fields that can be manually added to a custom export template but are not present in the Bulk Edit template.

Custom Export Template Fields

Athough you cannot export these fields in the Bulk Edit export template, it is possible to add them to a custom export template.

BigCommerce Export: 301 Redirects

You can export 301 redirects via CSV in BigCommerce as follows:

1. Go to Settings -> 301 redirects;
2. Hit the Export these Redirects button;
3. Choose a built-in export template or create a custom one to specify which fields you want to include;
4. Select a file format (CSV or XML);
5. Choose between server or direct download;
6. Click Continue; 
7. Click Export my redirects to a CSV file in the Redirects pop-up;
8.  Click Download my Redirects file when it is generated.

That’s it! Now, you know how to export page URLs in BigCommerce. Also, check our guide to BigCommerce 301 URL redirects import. 

Firebear Improved Import & Export App for BigCommerce

On your BigCommerce website, all import processes can be significantly improved using the Firebear Improved Import & Export App. Our application works with all of the aforementioned entities and also enables you to transfer data blocks between your online storefront and any external systems.

Unlike the typical import solution, our program provides thorough support for items, inventories, orders, customers, and categories. Additionally, it offers the following features:

• All entities’ import and export mapping. With this feature, you can explain how to modify external data input to comply with the specifications of the BigCommerce platform and the application will do all the editing for you.
• Support for Google Sheets, Excel, and CSV. In addition to CSV and XML files, our addon also data import and export in BigCommerce via Excel tables. Furthermore, you may directly import data from Google Sheets or export it there.
• Adaptable launch. You can use scheduling or events in addition to manually carrying out import and export processes, as is the case with native BigCommerce import tools. You might start updating your inventory, for instance, each day or as soon as a new order is placed automatically.
• Sources for custom exports and imports. With the help of the Improved Import & Export BigCommerce app, you can quickly upload data files to the system, import them from a URL, or transfer them through FTP/SFTP.
• Diff only import, update only. Use product IDs and SKUs to edit stock information and other fields.
• Alter data instantly. You are free to make as many changes to your CSV file as necessary before importing or exporting them. It introduces the most natural method to combine and divide values, use RegExp, search and replace attributes, and change capitalization.
• Advanced filters. Due to sophisticated filtering, the Improved Import & Export BigCommerce app empowers you to export list of customers who ordered in past year or transfer orders associated with particular client.
• Database export. Wondering how to export BigCommerce database? Our extension is here to assist you. It provides the ability to move data straight between two databases.

For further information on the enhanced BigCommerce import and export capabilities, contact us. We can also help you with data transfers between BigCommerce and any external system.

Other BigCommerce Import & Export Apps

Let’s see what other BigCommerce import and export applications are available, extending the default data transfer capabilities. Below, we highlight a few interesting solutions from the app store:

• Product Review Importer & Exporter. With this application, you will know how to export product reviews in BigCommerce. It also lets you import Product Reviews into your BigCommerce store via CSV. As for the export capabilities, you can transfer the corresponding information from your website straight to Yotpo and other similar systems. 
• Price List Importer/Exporter. With the help of this program, you can easily maintain and modify your price lists, thanks to its straightforward design. They can be edited, exported as CSV files, and then imported again. The supported currencies range widely.
• Spreadr Amazon Importer. Your BigCommerce website is equipped to import products from Amazon thanks to this solution. Simply paste the URL of the Amazon product into the dashboard and select Add. Product information is pulled from the official Amazon API and added to your BigCommerce website. With the exception of the “View on Amazon” button, which is shown instead of the “Add to cart” button on your e-commerce website, Amazon products will be presented in the same style and layout. You can also change the product name, description, and other information.
  Every imported product in your shop has its own URL that may be crawled and indexed. There, all of the product images from your BigCommerce website are preserved, making it simple for you to resize, optimize, and display them. You may also pin them on Pinterest, where they are indexed by Google. With this app, BigCommerce stores all product information in its database.
• MultiChannel Importer by CedCommerce. The quickest way to import products from Etsy, Amazon, Wish, and eBay to BigCommerce is with the MultiChannel Importer software. Every element of a product, including its photos, inventory, price, and description, is imported with the assistance of this app. Add various product images to your BigCommerce store, enable inventory and price syncing for all items from the selected marketplace, and use the Profiling tool to upload products into various BigCommerce categories.
• AmaZone DropShipper Product Importer. Purchase items for your BigCommerce store from US Walmart and Amazon. Such product information as pictures, variations, and prices is transferred in full via this app. As a result, you may easily launch your dropshipping company or sign up for the Amazon Affiliates Program. Also, keep in mind that this application allows you to input each primary image and pricing for up to 25 product variants.
• Bulk Category Import and Edit. This app’s name speaks for itself. It enables you to export BigCommerce categories, apply changes to them, and then mass import categories to your Big-Commerce website.

Conclusion

As you can see, the default BigCommerce export is quite straightforward and intuitive. Following this guide, you can easily transfer orders, clients, items, and 301 redirects from your store. As for more advanced processes, they are available via third-party apps, such as Firebear Import & Export Tool for BigCommerce. This extension not only provides more advanced and flexible BigCommerce export of orders, products, customers, and redirects but also lets you update categories, reviews, coupon codes, etc. Also, contact us regarding data transfers to and from your website. We can assist you with any data synchronization and integration related to your e-commerce business.

BigCommerce Export FAQ

Now, it’s time to provide a few more answers to popular BigCommerce export inquiries:

Sources

The following article is inspired by the official BigCommerce documentation that describes import and export processes. Our material combines several BigCommerce export guides, expanding and enhancing them to cover the BigCommerce export in a more eloquent manner with a bunch of details unavailable in the official materials.

Firebear Import & Export Tool for BigCommerce