*Reduced by 1% after each order
Rating 5 stars - 1 votes

Import Orders to WooCommerce from Google Sheets

The most common reason to import orders to WooCommerce is probably migration from one WooCommerce store to another. Importing orders from other shopping carts or marketplaces is also a possible scenario. You’ll find both of these cases described below.

In this article, we’ll be importing orders from Google Sheets using Store Manager for WooCommerce. We want to reassure you at once that Store Manager is not yet another plugin to install but a desktop application. You download the app to your computer, connect to your WooCommerce store database and migrate orders. Moreover, with a 14 days free trial you can import orders from Google Sheets to WooCommerce for absolutely free.

Steps to import orders to WooCommerce from Google Sheets

  1. Download Store Manager for WooCommerce and connect to your store database.

  2. Prepare a document with the orders to import.
  3. If you’re importing a document that you’ve previously exported from another WooCommerce store, all the columns will have correct headers and the upload will go smoothly.

    If you're uploading order data from another shopping cart, ensure all the headers are correct and all required columns are included. Here are the required fields for the orders to be created correctly:

    Order data:
    • Order date
    • Order Status
    • Order Currency
    • Customer (Customer Last Name)
    • Order total = Shipping cost + Product total
    • Order Key
    Product data:
    • Product ID
    • Variation ID (for a simple product, variation ID will equal 0)
    • Product title
    • Product QTY
    • Product Tax
    • Product cost
    • Product total = Product cost * QTY(quantity)
    • Product Subtotal = (Product total)
    • Product Subtotal Tax = 0
    Customer data:
    • Customer Email
    • Customer First Name
    • Customer Last Name
    • Payment Method Title (Cash on Delivery, Direct Bank Transfer)
    Billing data:
    • Billing Address 1
    • Billing Address 2
    • Billing City
    • Billing Company
    • Billing Country
    • Billing Email
    • Billing First Name
    • Billing Last Name
    • Billing Phone
    • Billing Postcode
    • Billing State
    Shipping data:
    • Shipping Address 1
    • Shipping Address 2
    • Shipping City
    • Shipping Company
    • Shipping Country
    • Shipping First Name
    • Shipping Last Name
    • Shipping Postcode
    • Shipping State
    • Shipping Cost
    • Shipping Method Title(Flat Rate, Local Pickup)
    • Shipping Tax
    Tip: If you don’t have any of that data in your source document, you can fill the missing field values with some default data.

    If you have difficulties with your source import document, contact our support team and we’ll help you configure it properly.

    How will data associated with orders be imported to WooCommerce

    Customers. If your source document contains customer details, customers will automatically be created along with orders.

    Products. Products from an order will also be imported though they won’t be created and won’t be tied to any existing products. It means that the order will be imported even if the products in this order don’t exist in the target store.

  4. Run Order Import Wizard and upload the data.
  5. When you have your document ready for import, launch Store Manager and switch to the Orders section. Here press Import Orders.

    WooCommerce Google Sheets Order Launch Import

    In step 1, you should select Google spreadsheets as an import source. Then you connect to your Google Drive and locate the document with orders:

    WooCommerce Google Sheets Order Import Select Document

    If there are several sheets in the document, you can pick a sheet in the next step:

    WooCommerce Google Sheets Order Import Select Sheet

    The linking step shows a list of fields from the import sheet and a list of database fields. If you’re importing orders previously exported from WooCommerce, the fields will be mapped automatically. To ensure all fields are linked, click the icon Autolink All.

    For a correct import of a non-native WooCommerce file, you will need to assign fields manually. For that, select a database field on the left and then pick a matching column from your source file.

    If you’re are updating order details via import, select how you want to identify them (Identification Fields):

    • By Order ID
    • Order key

    WooCommerce Google Sheets Order Import Map Fields

    At the next step, you’ll be prompted to select an import method:

    • Only add new orders and not modify existing ones.
    • Add orders from the file without checking for existing orders (this method is a good option when you’re importing orders to a clean database or when you’re sure that there can be no duplicates. In this case, Store Manager will not check for the existing products and the import will go faster).

    WooCommerce Google Sheets Order Import Select Method

    Tip: If you don’t want to upload all orders but only import one or several (for instance, for testing purposes), expand Advanced Options and specify the rows to import. Thus you’ll be able to upload specific orders without modifying the source file.

    This is the final step of the import setup. To proceed with importing orders to WooCommerce from Google Sheets, press Import.

    WooCommerce Google Sheets Order Import Advanced Options

    After the upload has completed, you will see a report informing you how many orders have been created or modified and if any issues occurred.

    WooCommerce Google Sheets Order Import Complete

    Let’s now check the order imported to our test WooCommerce store from the Google Sheet. The order is here and below are its details:

    WooCommerce Google Sheets Order Imported

    If we switch to the Customers section, we’ll see that a customer has also been created:

    WooCommerce Google Sheets Order Imported with Customer

    Use Store Manager to import orders from Google Sheets to WooCommerce to migrate data or upload it from a marketplace or any other source. Write in the comments below in case you have any questions regarding your source Google document, import configuration, or any other!

    Import orders to WooCommerce from Google Sheets with Store Manager!

    Try now FREE

    Be the first to comment.