wp-sheet-editor-logo-15px
  • AI
  • Google Sheets Sync
  • Plugins
    • Automations
    • WooCommerce Products Spreadsheet
    • Posts, Pages, and Custom Post Types Spreadsheet
    • Courses Spreadsheet
    • Media Library Spreadsheet
    • WordPress Users Spreadsheet
    • WooCommerce Coupons Spreadsheet
    • Comments and Reviews Spreadsheet
    • Categories, Tags, Product Attributes, Taxonomies Spreadsheet
    • WooCommerce Orders Spreadsheet
    • Universal Frontend Editor
    • Easy Digital Downloads Spreadsheet
    • GiveWP Spreadsheet
    • Events Spreadsheet
    • WooCommerce Customers Spreadsheet
    • Custom Database Tables Spreadsheet
    • All Plugins
  • Help
    • Guides and Tutorials
    • FAQ
    • Contact
    • Developers
  • Account
  • Toggle website search
Menu Close
  • AI
  • Google Sheets Sync
  • Plugins
    • Automations
    • WooCommerce Products Spreadsheet
    • Posts, Pages, and Custom Post Types Spreadsheet
    • Courses Spreadsheet
    • Media Library Spreadsheet
    • WordPress Users Spreadsheet
    • WooCommerce Coupons Spreadsheet
    • Comments and Reviews Spreadsheet
    • Categories, Tags, Product Attributes, Taxonomies Spreadsheet
    • WooCommerce Orders Spreadsheet
    • Universal Frontend Editor
    • Easy Digital Downloads Spreadsheet
    • GiveWP Spreadsheet
    • Events Spreadsheet
    • WooCommerce Customers Spreadsheet
    • Custom Database Tables Spreadsheet
    • All Plugins
  • Help
    • Guides and Tutorials
    • FAQ
    • Contact
    • Developers
  • Account
  • Toggle website search

Help articles

  1. Home>
  2. Help articles>
  3. Page 12

The spreadsheet is showing a column/field that I’m not using

  • Post author:Jonathan Gomez
  • Post published:October 5, 2022
  • Post category:Common errors/FAQ

The spreadsheet creates columns for all the fields found in the database.So it’s normal that it found the old fields and displayed columns.If you don’t want to use…

Continue ReadingThe spreadsheet is showing a column/field that I’m not using

I have multiple columns with same title and I don’t know which one to edit

  • Post author:Jonathan Gomez
  • Post published:October 5, 2022
  • Post category:Common errors/FAQ

We detect all the fields in the database and generate the column names from the key. If you have 2 fields from 2 plugins: _price and __price. We…

Continue ReadingI have multiple columns with same title and I don’t know which one to edit

I imported a file and the accents and some characters are missing or look weird

  • Post author:Jonathan Gomez
  • Post published:October 5, 2022
  • Post category:Common errors/FAQ

It’s an encoding issue on Excel’s end. We export the file in UTF-8 which works with all the characters across all languages. You need to edit the file…

Continue ReadingI imported a file and the accents and some characters are missing or look weird

I’m trying to import a CSV file but it reads everything as one column

  • Post author:Jonathan Gomez
  • Post published:October 5, 2022
  • Post category:Common errors/FAQ

CSV files are like spreadsheets, they are made of columns and rows. Our plugin detects the columns separator automatically when the file uses any of these separators: ,…

Continue ReadingI’m trying to import a CSV file but it reads everything as one column

I’m experiencing a bug or error and I can’t find the solution

  • Post author:Jonathan Gomez
  • Post published:October 5, 2022
  • Post category:Common errors/FAQ

There are multiple ways we can help: a) You can try installing the dev version of the plugin, which contains the latest fixes. Go to the spreadsheet page…

Continue ReadingI’m experiencing a bug or error and I can’t find the solution

WooCommerce is duplicating my variations after every import

  • Post author:Jonathan Gomez
  • Post published:October 5, 2022
  • Post category:Common errors/FAQ

Variations must have unique SKU, otherwise WooCommerce can’t find the existing variation to update, and it duplicates them on future imports.

Continue ReadingWooCommerce is duplicating my variations after every import

I imported product variations but the variation attribute is empty or appears as “any”

  • Post author:Jonathan Gomez
  • Post published:October 5, 2022
  • Post category:Common errors/FAQ

If the attributes of a variation are not imported (i.e. one attribute appears as “any”), maybe they were global attributes and the names from your CSV don’t match…

Continue ReadingI imported product variations but the variation attribute is empty or appears as “any”

I get “server not available” errors while saving

  • Post author:Jonathan Gomez
  • Post published:October 5, 2022
  • Post category:Common errors/FAQ

If you are getting network errors (messages like “server not available”) when you are saving changes or executing bulk edits, it means your server is overloaded. Possible solutions:…

Continue ReadingI get “server not available” errors while saving

WooCommerce – Bulk Edit YaySwatches using a Spreadsheet

  • Post author:Diego Portillo
  • Post published:October 5, 2022
  • Post category:Guides

In this guide, you'll learn how to bulk edit variation swatches from the YaySwatches – Variation Swatches for WooCommerce plugin. We'll use the WP Sheet Editor - Products Spreadsheet…

Continue ReadingWooCommerce – Bulk Edit YaySwatches using a Spreadsheet

How can I install the plugin?

  • Post author:Jose Vega
  • Post published:October 4, 2022
  • Post category:FAQ/Getting started

When you purchased the plugin, you received an email with the download link and license key If you were using the free version of the plugin before, you…

Continue ReadingHow can I install the plugin?

WordPress – Bulk Rename Blog Categories and Blog Tags

  • Post author:Diego Portillo
  • Post published:September 24, 2022
  • Post category:Guides

https://youtu.be/QlpHEkq5RrA Let’s put it like this. We have uploaded hundreds of posts during some years, and the time comes then we’ll need to completely change our sites appearance…

Continue ReadingWordPress – Bulk Rename Blog Categories and Blog Tags

How to Bulk Edit Discount Amounts – WooCommerce Coupons

  • Post author:Diego Portillo
  • Post published:September 24, 2022
  • Post category:Guides

Let's learn how to bulk edit discount amounts for WooCommerce coupons. https://youtu.be/6n5qlEGfVQM Coupons are a good way to get lots of new customers and turn those occasional customers…

Continue ReadingHow to Bulk Edit Discount Amounts – WooCommerce Coupons

WooCommerce Coupons – How to Bulk Edit Expiration Dates

  • Post author:Diego Portillo
  • Post published:September 24, 2022
  • Post category:Guides

Learn how to edit your WooCommerce coupon expiration dates by extending or restricting their duration. https://youtu.be/Pvq8mdEjHWE   Imagine you're running a Christmas campaign using WooCommerce coupons. Your customers…

Continue ReadingWooCommerce Coupons – How to Bulk Edit Expiration Dates

WooCommerce Orders – Bulk Edit Status using a Spreadsheet

  • Post author:Diego Portillo
  • Post published:September 24, 2022
  • Post category:Guides

In this tutorial, you'll learn how to bulk edit status in WooCommerce Orders. You can change the status for hundreds of orders in bulk and with a few…

Continue ReadingWooCommerce Orders – Bulk Edit Status using a Spreadsheet

WooCommerce – Export Orders to CSV (Excel, Google Sheets, etc.)

  • Post author:Diego Portillo
  • Post published:September 24, 2022
  • Post category:Guides

Imagine you want to review the progress of your online store, and you need a detailed report of the orders you have received. The best way to achieve…

Continue ReadingWooCommerce – Export Orders to CSV (Excel, Google Sheets, etc.)

WP Review – How to Export and Import Reviews

  • Post author:Diego Portillo
  • Post published:September 24, 2022
  • Post category:Integrations

If you want to hire somebody to edit reviews created with WP Review, you may look for somebody who knows WordPress. But what if we told you the person…

Continue ReadingWP Review – How to Export and Import Reviews

BuddyPress – Bulk Edit Profile Fields in Spreadsheet

  • Post author:Diego Portillo
  • Post published:September 23, 2022
  • Post category:Guides

Let's see how to bulk edit BuddyPress profile fields in a spreadsheet. https://youtu.be/DXTJjxKqyAs You've just downloaded BuddyPress and then want to make some changes to a certain number…

Continue ReadingBuddyPress – Bulk Edit Profile Fields in Spreadsheet

WooCommerce – How to Import Product Reviews from a CSV File

  • Post author:Diego Portillo
  • Post published:September 23, 2022
  • Post category:Guides

In a previous tutorial, we showed you how to export WooCommerce product reviews to a CSV file. Here, we'll show you how to import product reviews into your…

Continue ReadingWooCommerce – How to Import Product Reviews from a CSV File

WordPress – How to Bulk Delete Comments Pending Moderation

  • Post author:Diego Portillo
  • Post published:September 22, 2022
  • Post category:Guides

In this tutorial, we will show you how to bulk delete comments pending moderation on WordPress. We'll be able to search for all comments with "pending moderation" status…

Continue ReadingWordPress – How to Bulk Delete Comments Pending Moderation

WP Ultimate Recipe – How to Bulk Delete Recipes by Keyword, Category, Ingredient, Etc.

  • Post author:Diego Portillo
  • Post published:September 22, 2022
  • Post category:Integrations

In this tutorial, we will show you how to bulk delete your recipes created with the WP Ultimate Recipe plugin. But you won't just delete them one by…

Continue ReadingWP Ultimate Recipe – How to Bulk Delete Recipes by Keyword, Category, Ingredient, Etc.

WooCommerce – How to Bulk Delete all Pending Reviews Quickly

  • Post author:Diego Portillo
  • Post published:September 22, 2022
  • Post category:Guides

This is a quick guide on how to bulk delete pending reviews on WooCommerce products. https://youtu.be/tvcxD60xFrY We know that it can be really tedious to delete 50k pending…

Continue ReadingWooCommerce – How to Bulk Delete all Pending Reviews Quickly

WooCommerce – Export Orders by City, State, or Country

  • Post author:Diego Portillo
  • Post published:September 22, 2022
  • Post category:Guides

In this entry, we’ll show you how to search and export all your WooCommerce orders by city, state, or country. No matter if it’s billing or shipping, you’ll…

Continue ReadingWooCommerce – Export Orders by City, State, or Country

WooCommerce – Search Active Subscriptions by City, State, Country

  • Post author:Diego Portillo
  • Post published:September 22, 2022
  • Post category:Integrations

In this tutorial, we'll show you how to search for all the WooCommerce active subscriptions by country, state or city. Normally in WooCommerce Subscriptions, you'd do this by…

Continue ReadingWooCommerce – Search Active Subscriptions by City, State, Country

WooCommerce Orders – Copy Billing Address to Shipping Address

  • Post author:Diego Portillo
  • Post published:September 21, 2022
  • Post category:Guides

Let's see how to copy billing address to shipping address in WooCommerce orders. https://youtu.be/CYWtLqyepgM Most of the time, the billing address provided by our WooCommerce customers is the…

Continue ReadingWooCommerce Orders – Copy Billing Address to Shipping Address

WooCommerce – Export Customer Reviews to a CSV File

  • Post author:Diego Portillo
  • Post published:September 21, 2022
  • Post category:Guides

Let's learn how to export WooCommerce customer reviews to Excel or Google Sheets. https://youtu.be/UvR_vAIoiqk If you're migrating from WooCommerce to Shopify or BigCommerce and want to also migrate…

Continue ReadingWooCommerce – Export Customer Reviews to a CSV File

WooCommerce – Exclude Sale Items from All Coupons in 5 Minutes

  • Post author:Diego Portillo
  • Post published:September 21, 2022
  • Post category:Guides

In this article, we'll show you how to exclude sale items from all your Woocommerce coupons in about five minutes. https://youtu.be/aXJPb2uzgbA Sometimes customers take advantage and buy sale…

Continue ReadingWooCommerce – Exclude Sale Items from All Coupons in 5 Minutes

WooCommerce – How to Search for Orders by Currency

  • Post author:Diego Portillo
  • Post published:September 19, 2022
  • Post category:Guides

In this tutorial, we will show you how to search for WooCommerce orders by currency. https://youtu.be/vKGjeZPJIC8   If you have a WooCommerce store that accepts multiple currencies, you…

Continue ReadingWooCommerce – How to Search for Orders by Currency
  • Go to the previous page
  • 1
  • …
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • …
  • 32
  • Go to the next page

Help

  • Guides and Tutorials
  • FAQ
  • Technical support
  • Request refund
  • My account

Product

  • AI
  • Google Sheets Sync
  • All Spreadsheets
  • Features
  • Testimonials and reviews
  • Changelog
  • Suggest new features

Company

  • Company
  • Contact Us
  • Development services
  • Affiliate Program
  • Sitemap
  • Privacy Policy of our Google Sheets Sync service
  • Privacy Policy of the Bulk AI API

Guides

  • How to Export WooCommerce Cancelled Orders to CSV
  • WooCommerce: How to Export Orders with Pending Payment Status
  • WooCommerce: How to Export Refunded Orders to CSV or Excel
  • How to Export Small WooCommerce Orders to CSV or Excel
  • How to Export WooCommerce Orders for Monthly Tax Reports
  • License
  • Privacy Policy
  • Cookies
  • Terms and Conditions
Copyright © 2016 - 2025 VegaCorp S.A. de C.V. All Rights Reserved. Sheet Editor® is a registered trademark.
Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
  • Manage options
  • Manage services
  • Manage {vendor_count} vendors
  • Read more about these purposes
View preferences
  • {title}
  • {title}
  • {title}