2-Way Sync Order’s Configuration : Sheet to WooCommerce #
We’re excited to introduce the Google Sheet to WooCommerce Sync feature. This feature will be available in the beta version : 2.0.27-beta2 and stable version will be released in 2.0.27
Now, you can seamlessly add single or bulk orders within your connected sheet. Simply follow the provided instructions, click to sync, and watch as your orders are seamlessly integrated into your WooCommerce store.
In this article, I will show you step by step configuration, while explaining how it will work,
Connected WooCommerce Google Sheet: Within the Connected WooCommerce Google Sheet, you’ll see the linked sheet. Please note that sheet settings cannot be updated from this interface.
Sync Settings for Two-Way Sync: 2-Way Sync Settings #
These sync settings facilitate the seamless transfer of records to WooCommerce within the selected Google Sheet!
Considerations for Two-Way Sync : #
- Ensure the header names remain unchanged from the default settings during synchronization.
- Leave the Order ID and Product ID field blank; it will be automatically updated once the sync is processed. If a either one is present, the sync will fail and display an error.
- To add multiple Product Categories and tags, separate them with commas (,).
- Mandatory fields include Product name, with a dash (-) added in the last column.
- Specify the rows for synchronization. For a single row, input the same number in both text boxes.
- Example of Single Row: If the product is in row 5, enter ‘5’ in both boxes and click to sync.
- Example of Multiple Rows: If orders are listed in rows 5-10, input ‘5’ and ’10’ in the respective boxes and initiate the sync.
- In the Image column, upload the image from media, copy the uploaded image path, and paste it in the corresponding column for each product.
- For the Product Downloadable Files column, upload a single file from media, copy the uploaded file path, and paste it in the relevant column for each product.
Supported Fields for Synchronization : #
Please note that only the following list of fields will sync. If you’re using any other custom fields or columns based on third-party plugins, they will not sync :
- Order Id
- Created Date
- Product ID
- Product Image
- Product Name
- Product Meta
- Product Variation
- SKU
- Product Quantity
- Product Base Price
- Product Total
- Product Categories
- Partial Refund Amount
- Order URL
- Status Updated Date
- Transaction ID
- Customer ID
- Order Completion Date
- Order Paid Date
- Order Notes
- Order Status
- Currency
- Tax Total
- Order Total
- Payment Method
- Billing First name
- Billing Last Name
- Billing Address 1
- Billing Address 2
- Billing City
- Billing State
- Billing Postcode
- Billing Country
- Billing Company Name
- Shipping F Name
- Shipping L Name
- Shipping Add 1
- Shipping Add 2
- Shipping City
- Shipping State
- Shipping Postcode
- Shipping Country
- Shipping Method
- Shipping Company
- Discount Total
- Discount Tax
- Shipping Total
- Shipping Tax
- Cart Tax
- Coupons Codes
- Phone
- Customer Note
- Product Type
- Product Tax
- Customer Total orders
- Customer Total revenue
- Customer Average order value
- Order Total (Excl. Shipp. Charges and Other Fees)
In Google Sheet #
Go to Connected Google Sheet Add Order info as you Prefer.
insert a dash (-) in the final column.
Insert and Update Orders #
Start by carefully reviewing the considerations provided. Once you have a clear understanding, proceed to indicate the range of rows where you wish to insert new data. For example, you can specify the range as starting from the second(2) row and ending at the second(2) row.
Following this, click on “Click to Sync Insert,” and your order will be generated based on the provided order’s information.
Now, if you have update something in Google Sheet and want to update in WooCommerce Store also then you can do it.
Update Orders with Order Status #
Start by updating the Google Sheet accordingly. Next, navigate to the WordPress Dashboard and locate the WooCommerce Google Sheet Connector – 2 Way Sync plugin. Then, enter the desired Rows Range, for example, from 2 to 200, as per your preference.
Following these steps, click on “Click to Sync update,” and your order will be updated according to the provided order’s information.
NOTE: If you are getting an quota limit error while click to sync from sheet to woocommerce, then please consider authentication with manual method, as this limit is from Google API.
