How to load rows from a specific row number
When you have 1000 posts, you might want to open the spreadsheet and start editing from post 200. For that, go to settings > advanced settings > Misc…
When you have 1000 posts, you might want to open the spreadsheet and start editing from post 200. For that, go to settings > advanced settings > Misc…
To disable or enable the fixing of the first 2 columns at the left side of the spreadsheet, go to Settings > Advanced settings > Increase productivity >…
To prepend or append something to columns or rows, open the “Bulk Edit” tool. Select the fields you’ll edit and select the type of edit you’ll apply: prepend…
To set new values on columns, go to the “Bulk Edit” tool. Select the column you’ll edit >Choose “Set value” as the type of edit you’ll apply >…
To replace words or phrases in an entire column, go to “Bulk Edit” on the toolbar. Select the column you’ll edit in the “Field you want to edit”…
To delete everything in one column, you have two options: manual and bulk. Manually, select the column by clicking the above part of it and then hit “Delete”…
To edit a product/post URL, go to the “Slug” column, and hit “Enable”. Then, paste the URL in the “Slug” cell. Note: If the products are not…
To copy from excel, go to the spreadsheet in Excell and copy what you need from a specific cell, row, column, and then go to Sheet Editor and…
To copy/paste images from one cell to another, just copy from one cell and then paste into another cell using CTRL + C and CTRL + V
To edit images as plain text/URLs, you need to go to the cell you want to edit and double click it; it converts into a plain text field…
For most cases, our spreadsheet will recognize all the columns in the spreadsheet immediately if you go to Settings > Scan DB. This action will show all the…
Sheet Editor saves products in batches, so if you want to increase the number of products to save in each batch go to the spreadsheet and click on…
To show date columns as simple texts, you need to go to settings > Show cells as simple text.
To hide columns from the spreadsheet, you need to right-click on the column you want to hide and click “Hide column”. You can also use the Columns Manager…
To display hidden columns in the spreadsheet, go to settings > Hide / Display / Sort columns. Drag the disabled columns to the enabled columns.
Yes, multiple users can make use of the spreadsheet at the same time, but they have to coordinate with each other to not edit the same items and…
The plugin can be translated to your language. You need to translate 2 .pot files with poedit (or any translation software). /lang/**.pot /modules/wp-sheet-editor/lang/**.pot = this file is shared…
There are 2 main ways to create products or posts 1 - Create them through the live editor To create new rows, write the number of rows you…
To open the “Search” tool, click “Search” on the toolbar. It contains fields to look for products by keyword, status, category, attribute, tag, date, product variations, and filters…
To open this tool, click “Bulk Edit” on the toolbar. It contains fields for you to search for the products to edit. It also contains the fields you’ll…
To locate specific cells in the spreadsheet, just write the word of the cell you want to locate in the “Locate cell” field and hit enter.
https://youtu.be/9b3Ng4KT9CY In this tutorial, we'll show you how to sort WooCommerce attributes quickly and in one go by following a few steps. Normally, you need to open the…
In a previous post, we showed you how to bulk edit attribute fees for the Iconic Attribute Swatches plugin in WooCommerce. In this tutorial, we show you how…
Hi there. In this tutorial, we’ll show you how to bulk edit attribute fees in WooCommerce. As most Iconic Attribute Swatches users may know, the plugin allows you…
https://youtu.be/OB-bm-F8H7E In a previous tutorial, we showed you how to add decimals to WooCommerce prices in bulk. Here, we show you how to remove decimals from product prices,…
https://youtu.be/Vcx15VeLugQ In this post, we show you how to add the 99 cents decimal to all your WooCommerce product prices. It is a generally accepted idea that the…
In this post, we show you how to bulk edit wholesale prices in WooCommerce. You'll be able to bulk update wholesale prices for these plugins: WooCommerce Wholesale Prices…