If I import a large amount of users, will they get a welcome email?
We have an option on our spreadsheet to send a welcome email to every newly imported user. You will be asked if you want to do this when…
Why are my users getting emails when I import users information?
By default, WordPress sends a notification email each time you update the user password or user email or create users. The notification is sent by WordPress and it's…
I’m exporting my images and I see the image ID on the URL, why?
By default, when you export the featured image column or gallery columns, we add the file ID to each image url so we can import them later faster.…
Why can’t I import embedded images on my Excel file?
WP Sheet Editor only supports CSV files to import, and CSV files are text-only and can't contain an embedded image; also, our plugin doesn't recognize any "actual" image…
When I import my CSV file, I can’t start the import process on the final step, the button is grayed out
This happens because the CSV file you're trying to upload is either corrupt or doesn't have the right encoding. The fastest solution for this issue is to: 1-…
I don’t want my attribute to be “used for variations”
We have a quick setting that lets you mark which attributes you don't want to be used for variations. Go to our Spreadsheet > Settings > Advanced settings…
When I import, I get all the posts I want but also more rows with “…” titles, why?
This happens because your CSV file has some blank rows that the plugin detects as blank products. You need to scroll down to the bottom of your CSV…
How to count WooCommerce product variations?
WP Sheet Editor only counts the parent products as rows, so even if you click on "display variations" the rows count will be the same. If you need…
Does WP Sheet Editor support Jet Engine’s Relationship Fields?
Yes, WP Sheet Editor has an extension for JetEngine that supports all the Jet Engine's fields, you will be asked to install this extension when you open our…
You do not have enough permissions to do this action
You might see the error "You do not have enough permissions to do this action" in a pop-up message when trying to edit or run any operation. This…
Rows not aligning properly / not matching
Sometimes the rows on Column A don't follow the same alignment that rows on Column B, like if they were distorted or misaligned. This happens when there is…
I have a list of orders/products ID’s that I want to search for and then modify/delete, how can I do that?
Yes, in our spreadsheets, we have an option to look for a list of ID's. The number of ID's you have on your list is irrelevant, our plugin…
Can WP Sheet Editor create URL slugs from the post title?
Yes, the post slug is automatically created by WordPress when the product/page/post is published. It will appear empty when it's not published.
The header columns on my spreadsheet have scrambled or weird characters on them
If you open the spreadsheet and the column headers show like in the screenshot below, it's very likely you have activated the Enable the utf8 encoding fix option.…
How to see taxonomies like categories and tags with a drop down menu
By default, our spreadsheet lets you edit taxonomies like categories and tags in the format of a regular cell, where you enter the term names separated with commas.…
I don’t want some user roles to use the spreadsheet
By default, the spreadsheet editor will be available for all the users who have access to the regular editor. For example, the users spreadsheet is available for all…
When I delete a product, the featured image is still on the Media Library
When you delete the rows from the spreadsheet, the Product Images will remain in the media library by default because they might be used by other products. However,…
How to separate Featured Image from Gallery Images on the export?
By default, WooCommerce exports the Product Featured Images and the Product Gallery images together on the same column: Images (the images are separated with commas, the first image…
A custom attribute is not showing up on the spreadsheet
If a custom attribute is not showing as a column on the sheet, the solution is to go to the Settings > Advanced Settings > WooCommerce Products >…
Can I use a TXT file instead of a CSV file for importing?
No, our export and import tools only use CSV files, any other format will be rejected by our plugin. If you have a TXT file containing delimited data,…
If I hide or eliminate a column, will it delete the values from the database too?
If you hide a column following the methods described in this other tutorial, the values will not disappear from the database, they will just not show on the…
My spreadsheet is loading slow
The performance depends on your server capability and how you configured WP Sheet Editor. All the processes in our plugin can be configured to use few server resources…
How to blacklist columns I don’t want to see
What does "blacklisting" mean? Is blacklisting columns dangerous? This is very safe, blacklisting means that our spreadsheet editor will ignore those fields. But they will continue to exist…
Can I revert the changes I’ve made with the spreadsheet?
When you edit using WP Sheet Editor and save any change, they are saved in your database directly. For example, when you edit 10 cells and click on…
Will the plugins work on a local site from my computer?
Yes, WP Sheet Editor will work the same on a live site and on a local site.
If I have the bundle, can I use some spreadsheets in one site and other spreadsheets on another site with the same license?
Yes, when you purchased the All Plugins plan, you received one license key that you can use with all our plugins. Each plugin shares the same license, but…
How do I know which spreadsheet do I need?
In this quick guide, we'll show you what spreadsheet you need for each scenario. If you still have doubts after going through this guide, contact us on our…