VirtueMart Forum

VirtueMart 2 + 3 + 4 => Plugins: Payment, Shipment and others => Topic started by: creatifpresence on February 16, 2017, 19:01:52 PM

Title: Best Multi Variant Bulk Editor Suggestions
Post by: creatifpresence on February 16, 2017, 19:01:52 PM
Hello,

I was looking for advice on what the best multi-variant bulk editor others use is?

I'm relatively new to this aspect of virtuemart so create multi-variant, add fields, click create child and off we go.
The problem is I need to change weight, product sizes quickly rather than going into each child product and changing it which takes forever...

I found http://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm not sure if this is the best or maybe there's a better way?

Many thanks for any advice or suggestions your time and effort is appreciated.

Phil

Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: Studio 42 on February 17, 2017, 00:24:27 AM
Hi Phil,
I'm the developer.
i think the only limit is multi-variant and some customfield plugin, but 95% can be  managed with Vm Be Pro.
For eg. You can quickly add a category for promoted product, compare image meta tag and know in how much products it's used.
I'm on writing front-end quick edit to directly add ,change text and unpublish a product or category and get included for free with Vm Be Pro.
For child, you can directly change parent ID and you can display the products as a tree(or not) to check product dependencies.
Regards,
Patrick
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: creatifpresence on February 22, 2017, 15:41:37 PM
Thank you for your reply and time. It's for a client, so I will suggest this to them.

Kind regards

Phil
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: aftertaf on April 02, 2017, 13:19:54 PM
Hi Patrick,
Can you check and confirm if a bug exists in VM BE Pro for VM3.2.1 ?
I dont have any categories showing up in the treeview on the top left side of the screen, since i went to 3.2.x
david
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: Studio 42 on April 02, 2017, 13:32:52 PM
Hi aftertaf,
I don't checked for now VM 3.2.1. If i found a bug i try to update it tomorrow.
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: bortolani on April 02, 2017, 21:12:19 PM
Hi Creatif, I've been using VM BE PRO for a while and I can guarantee you that it makes editing variants much easier and faster than standard VM tools. Highy reccomended!
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: aftertaf on April 02, 2017, 22:49:48 PM
second that ! ;)
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: Studio 42 on April 03, 2017, 15:51:26 PM
I have no problem with categories on left. Do you updated vmbepro to 3.4?
Have you refresh your browser view ?
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: aftertaf on April 04, 2017, 22:12:16 PM
Version : 3.4.0.0
OK, found it.
Content language change to VM affects this too.
I have to admin in french to see the categories...

Side question...
Is it possible to import also this field -> [product_params]  ?
would allow setting of 'min_order_level="20"|max_order_level=""|step_order_level="5"|product_box=""|' for certain types of my products for example...
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: aftertaf on April 04, 2017, 22:48:18 PM
Issue: Error: -200, Message: HTTP Error., File: import_20170404.xlsx and with your .ods file
Are there any logs to see why?
Or can i send u my file to see why ?
But still, i get this when i download your sample .ods file and upload it without modification.

When I use your xls file it imports, but "2 - Select sheet" doesn't let me choose any sheet.
Tried with FF, Chrome, Edge.
help ! :)
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: Studio 42 on April 05, 2017, 14:35:50 PM
HI aftertaf.
The sample in vm be pro, should work
Have you file permission problems?
You can always send me a mail from your order mail when you have buy Vm be Pro, i answer always(if i am not on holiday) the same day.
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: aftertaf on April 06, 2017, 21:03:17 PM
mailed the order Replied to with some files attached, cheers :)
file permission pbs?
david/@aftertaf
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: Studio 42 on April 07, 2017, 11:41:01 AM
If you see nothing after upload, this is perhaps that you have no permission to create folder and file in your images subfolders ?
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: aftertaf on April 07, 2017, 21:50:36 PM
on 755 for folders, 644 for files, owner is www-data. Nothing seems weird but i could be mistaken...

With decimal as . not , it still gets stuck on 2->choose sheet. sheet name = "product", can't be chosen.
PHP7 ?
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: aftertaf on April 07, 2017, 22:03:59 PM
ok. stripped of all formatting and saved as csv does the trick :)
works for me

Question : what data exactly do i need to add to one or more categories (that exist already) ?
i tried with categ1-alias,categ2-alias but products added without a category
thanks for helping me to dumb my way thru :)
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: Studio 42 on April 07, 2017, 23:35:13 PM
categ1-alias,categ2-alias or categ1-alias|categ2-alias is valid.
But if you don't used same column name, then you have to manually change it in the header (dropdown list) for each column you want to import.
In your case the column name is "categories.slug"
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: aftertaf on April 09, 2017, 19:55:57 PM
hmm, i still have issues and i dont get why...
here is the file i try to upload, any clue what is wrong with it ?
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: Studio 42 on April 11, 2017, 02:39:38 AM
First, you should not use manufacturer.slug and manufacturer.name in same sheet.
Only old Excel is supported and best is to use ods (or csv). You can convert it with google sheet for eg. it worked always for me and is 10 times faster as xls, because the format of xls is many more complex(ods is a zip with multiple xml and is perfect for ajax stream reading).
See the attached file, it imported all products
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: aftertaf on April 15, 2017, 15:02:25 PM
i dunno if it's excel365 that is killing the file format, but it keeps giving me HTTP 200:

"Fichier :Copy of Import-Virtuemart_with_VmBePro.ods (6 KB) 100% preloading sheets , this can take some secondes !
Error: -200, Message: HTTP Error., File: Copy of Import-Virtuemart_with_VmBePro.ods"

ill try with OoO
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: Studio 42 on April 15, 2017, 16:52:25 PM
As i said, this is typical a upload problem. Have you checked your folder rights in the images directory ?
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: aftertaf on April 15, 2017, 17:34:44 PM
i did and i didnt see anything wrong. But that could be a #fail on my behalf... ill let u know if i find anything
Title: Re: Best Multi Variant Bulk Editor Suggestions
Post by: aftertaf on April 16, 2017, 23:28:46 PM
I've fixed permissions with akeeba admin tools, just in case.
I've also tested some files i made, in .CSV.
3.csv is accepted fine and i can reach the 4.import button. I just can't figure out what the difference is between 3.csv and the other 2 files.