This author's response time can be up to 2 business days.
Congrats. Added to my collection named “This is fu… Awesome”
Played around with the demo and I really like it.
But I have a suggestions and maybe you can add this too:
Can you make Custom Post Types, Custom Taxonomies and Custom fields of Post Types editable in this way too?
oh and just a quick addition:
It would be very helpful to decide if some (for products for example the article number and name) columns can be fixed while scrolling the sheet
Thank you for your kind words.
1- You already can edit custom post types. In the settings page, which is disabled in the demo, you can enable the spreadsheet editor on any custom post type.
2- You can already edit custom taxonomies. For example, if you have woocommerce, in the settings page you can enable the edition of products attributes.
If you have a custom taxonomy in “posts”, you can enable the edition as well besides the default tags and categories.
3- Right now the spreadsheet allows you to edit only fixed columns (fields), which are core fields (title, content, date, author, excerpt, featured image, etc.) and a few plugins fields (yoast SEO and woocommerce).
But yesterday I developed an extension that allows you to add custom columns to the spreadsheet.
This way you can add a new column to edit any custom field. It can be a custom field from a metabox added by a different plugin, or a completely new custom field that you want to add for your own purposes.
You can also select the type of cell, for example, a tinymce editor that opens by clicking on a button (like the post content cell), an single or multiple image upload, simple text, html, taxonomy terms dropdown, or calendar.
I´m doing the final tweaks to the extension, I will release it as an standalone product possibly.
4- I guess you mean to fix the column at the left side while scrolling horizontally, like it is now with the row ID. That´s a good suggestion, I added it to the wishlist.
5- I´m also planning to create a “custom spreadsheets” extension, which would be very cool. It would allow you to create custom spreadsheets which could be private (only visible in the spreadsheet editor) or public (visible in the spreadsheet editor and all the rows visible as public posts).
This would be very helpful.
Imagine, you could create a custom private spreadsheet for adding “quotes”. Only you can see it on wp-admin. And you install a plugin for posting on twitter random items of the custom post type (the custom spreadsheet would be a custom post type).
You could do so many things with this if you connect it with other plugins.
I will have a look at the first extrension but believe me, I am pretty sure I will buy it.
And additional: If you need somebode to test or to add languages (I am german), I am your man. Will not charge you, no worry
Oh, why this Idea: Cause you can build really everything with it. Think of just directory listings, where users can add their favorite places.
Or more business variants… allow others businesses to add themselfes.
Making a recipe book: allow users to add their own recipes.
Book, movie, game reviews, marketplaces for users, sky is the limit
There is just one thing that could be problem.
Not every wordpress admin has php knowledge, so there should be something that can output all the fields in a post. Something like an drag and drop shortcode creator with all the post fields, taxonomies, custom fields, tags… with rows and columns… I think it´s a lot of work… but the result could be awesome
1- ” I am not sure If I understand this second extension idea.”
Yes. Internally the custom spreadsheets are custom post types. So each row is a normal post.
2- “making the plugin compatible with the most used custom field plugin (Advanced Custom Fields // ACF)”
This is a great idea. I will definitely add it.
3- “What If you allow to insert that spreadsheet on the frontend via shortcode”.
You have read my mind. I´ve had this new feature in my todo list for over 2 months
But I was waiting to release the core plugin first and then release it as extension.
I will definitely do this. It would be great because users will be able to edit entries in the spreadsheet from the front-end.
4- I dont think a user dashboard is needed. For example, you will place the spreadsheet shortcode in a page and add the page in the front-end menu.
So when the user wants to edit his own entries, he just opens the spreadsheet. In this case the spreadsheet is the dashboard.
5- The permissions feature is already in place. Right now the users with “author” role can edit and see only their own posts, “editors” and “admins” can edit all users posts.
6- Your idea of the shortcode to display cells information on the front-end is great. I love it and I will add it.
It won´t be a drag and drop generator, it will be a simple form to generate the shortcode though.
I have a lot of ideas for this plugin and when I develop them the plugin will be amazing.
But it all depends on the number of sales. If I make enough sales I will devote more time to this plugin.
So if you really want to see these features, you should buy the plugin as a sign of support.
good work. very nice
Hello Vegacorp, very good plugin! We are currently using “WooCommerce Quick Edit Products Pro” which lacks the ability to use the same quick editing for posts as well. We are interested in switching to your plugin but it may be missing the following. Please clarify if you have these features and if not how soon could you implement them.
1. in POSTS and PRODUCTS the ability to select multiple categories via multi select is not there.
2. Ability to move column order. For posting its important to have category selection closer to the left that way far to the right. Is there ability to just hide columns as well?
3. You have featured image column but not additional images.
Great start for this plugin. Can do very well with some additions. We will buy if it can do the listed that Quick Edit Product Pro can do. thanks
1- You already can select multiple categories and tags, just enter the names separated by commas.
For example, category 1, category 2.
Right now the auto complete functionality only allows you to select one item in the list, but you can type directly the names separated by commas in the cell and it works.
PD. In the next release I will add the option to select multiple items in the auto complete dropdown.
2- Right now you can´t change the columns order. But you can hide columns in the settings page.
So you can hide the columns in between the categories to make the categories move to the left.
PD. I plan to release an extension that will allow you to change the columns order.
3- You already can assign the product gallery. When you are editing woocommerce products there is a column where you can set / edit the product gallery.
It is appearing on the demo.
PD. Keep in mind you can´t edit woocommerce variable products at the moment. You can edit all types of products except variable products. I plan to add this feature in the next releases.
1. Your plugin is suppose to save time and less typing. Requiring us to have to type in the category name makes no sense. They should appear with a checkbox and you just check off which ones the post applies to. Category as well as subcategories under it.
2. Ability to hide categories should be on the chart page and not the setting page. Again we need faster options without having to leave a page from a product that we already searched and went to the page number that its on.
3. Please take a look at the plugin we mentioned which a lot of people use. That is the fastest way to manage woocommerce products and additional images.
The advantage of your product is that it does both posts and products but on the product end which we already use another plugin it will have to rival it with the features mentioned if we are going to switch. It will be of course super cool if the features you upgrade on the products sheet be also on the posts sheet.
About how long will your updates be releasing(ex. days, weeks, or months away)?
You are right. All your suggestions are in my todo list and I will work on them as soon as possible.
The release of new features depends on the number of sales. If I get enough sales I will be able to devote more time to the development.
I´m planning a release for next week that will contain these new features:
- Advanced custom fields compatibility = edit advanced custom fields in the spreadsheet.
- Columns sorting = so you can move the categories column to the left.
- Select multiple categories on autocomplete dropdown
The “hide columns” feature might be included in that release if it doesn´t turn out to be too complex technically. If it causes bugs or takes too much time, it might be pushed to the 3rd release.
Does this work on Multisite installs?
Right now the plugin works with multisite installs, but it works independently on each site. This means each site has its own settings, therefore each site asks for a license.
However, I am working on a new version of the plugin that will be released next week, which will add more compatibiity with multisite installations, adding a global options page where you can set up the plugin once and all the settings will inherit to all the sites in the network. In this case a single license will be needed to use it in the entire network.
PD. In the meantime you can use the plugin on each site, and ignore the license verification.
Thanks. I’ll try it again in the meantime.
3 Problems with the plugin:
Please add a feature that the plugin can recognize, if redux is already in use by the theme. I don´t want to install redux twice.
After entering my licence (via copy and paste), i get the following:
The license couldn´t be activated. Maybe the validation server is not available , your license has expired , or you entered an invalid license. Please try again later, if the issue persists contact us.
And: I can not set the post types again. The option is away
Ok I found the settings. But problem 1 and 2 are still alive
Hi, thank you for reporting the issues. The 3 issues were fixed yesterday and I will submit the update to codecanyon today.
1- Now the plugin recognizes reduxframework included in themes
2- The license activation is working now
3- I added a settings button to the “quick usage” screen.
The update will be available in a couple of days, after codecanyon´s approval.
HELLO THE ID COL SEEM BLOCKED CAN I EDIT IT ?
Hi, the ID column is read-only. It is used for displaying the post ID. Why?
1- If you have 2 posts with the same title, you can differentiate them by the ID.
2- The system uses the ID to save the changes to the right post. If you have 2 posts with the same title, how would the system know what changes belong to each post.
I liked your plugin and going to buy it to try it on my site. I think this will save a lot of time posting products and posts one by one.
Thanks & Regards
Useful Plugin. How do I enable Custom Meta Boxes to show up in the spreadsheet columns?
Hi, I answered your question via email.
Well done, looks great!
Hello VegaCorp. I wish happy new year to you and your family. GLWS.
I found your plugin very useful and good.
Please inform me after you added woocommerce variable products edit feature.
I have another suggestion : Export to excel,csv and/or import from excel,csv.
Thank you for the suggestions. I will notify you when I add those features.
Thanks for your quick reply. GLWS.
Really nice plugin! Is there any column based Find/Replace function as spreadsheets offer?
Yes. There is a find/replace function per column. Look this video: https://www.youtube.com/watch?v=OfZqqdL0Hls
I couldn’t activate the plugin. I get this message:
Plugin could not be activated because it triggered a fatal error.
Fatal error: Cannot redeclare vgse_autofill_cells_init() (previously declared in /nas/content/live/ideagrove1/wp-content/plugins/vg-sheet-editor-autofill-cells/autofill-cells.php:84) in /nas/content/live/ideagrove1/wp-content/plugins/vg-sheet-editor-pro/modules/autofill-cells/autofill-cells.php on line 60
What should I do?
Hi, if you have installed the free version of the plugin and the premium version, you have to deactivate the free version. The 2 can´t be active at the same time.
PD. Support messages should be sent through the “support” tab on this page. This comments section is for pre-sale questions.
Hello – I reviewed your plugin as a possibility, but cannot use for one reasons. I would need it to handle variable products and show the variations under the main product. I take time to write this comment as I hope that you integrate that capability in the future. I really like what you are doing with the plugin. Please keep up the great work.
Thanks. I´m working on the woocommerce variable products feature. It´s a big update so it will take a while, but it´s coming
I’d love this if it supported variable products!
Just want to let you know that i will also be buying when you support variable products. Please inform me.
Can you answer my message (profile) please My problem is a little urgent
So… now you now my licence, but stil no answer for my problem
Actually, I don´t want to rate this plugin cause there are a lot of bugs and I will give you the chance to fix them.
Big potential plugin, but a little slow backend
Hi. Thank you for reporting the issues.
1- How many posts are you loading per page? if you see a red warning is because the server wasn´t able to respond. So maybe your server requires less posts per page, which you can adjust in the settings. Also make sure you install the “heartbeat control” plugin that disables the heartbeat API, that api makes your server slow because it pings the server every X minutes.
2- The image cells can be edited in bulk but only using formulas. The images cells can not be dragged down or auto filled, the auto fill doens´t work in file uploads cells or editor cells. It´s by design. When you update images in bulk using formulas you have to use the image ID.
3- If the processing crashes is because your server can not handle the number of posts at once. So you have to reduce the number of posts to save per page in the settings.
4- Same as previous point.
In the next version I will see how the processing speed can be improved, but keep in mind that servers have limitations and you must adjust the settings to work in your server.
for 1) 20 per page. I get a script debug windows with “stop”, “continue” I try heart bet.
for 2) Of course I can fill them (content changes). Only saving does not work.
for 3) i am using another plugin that can save around 200 posts in under a minute without any issue. (WP Bulk Edit).
for 4) the setting is 4 posts, 30 seconds. Crashes.
My server does not have any limits (only phisical). Believe me, I tried and successfully edited and saved 200 posts with other plugins in less that a minute without any problems.
I think, the problem is that ajax load more.
I would really prefer a simple pagination.
Why don´t you allow to set images by url to image in mediathek?
Hi. I´ve been working on a new version of the plugin and I want to let you know that I already fixed the speed problems in the new version.
Now we can load over 200 posts in the spreadsheet in about 2 seconds (depends on the server though). And it saves the changes in 1/4 of the time as before.
I will release the new version at the end of this week.
Looks great. How about an update for WP 4.7.x?
Hi, I will release an update at the end of this week. This update will have a lot of speed improvements and some other improvements.
Use, by you or one client, in a single end product which end users are not charged for. The total price includes the item price and a buyer fee.
Use, by you or one client, in a single end product which end users can be charged for. The total price includes the item price and a buyer fee.
View license details
Get it now and save up to $3.50