How to made & import custom fileds > 3000 products

[2dmaster]

Hello, How to made .CSV or import to Virtuemart over 1000 customfields for different product groups ?
Whats good solution ?? j3.5.1 vm 3.0.17

[GJC Web Design]

csvimproved?

https://www.csvimproved.com/

[Studio 42]

Hi,
Or my tool VM BE PRO : Batch process & edit ,see http://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm
And you can use .ODS(fastest),XLS(slow) with multi sheets or csv.
Since this month you can upload/import multiple images too with PHP(category,manufacturer,product and vendor).
To use multiple sheet in one time, you have simply to use the right sheet names : category,manufacturer,product,customfield.
and for multiple sheets with same type : customfield.color,customfield.size... is possible too.
Note: using ODS or CSV, you have virtually no max number of records limit(XLS is memory expensive) with the tool. Only your server php upload filesize is the limit.
Don't hesitate, if you need some information using the "Ask a question about this product" in the product page.
Regards,
Patrick

[servlet]

1000 per product?

[Studio 42]

I think not 1000 per product the title is 3000 products so i think total is more then 1000.
I think he is not stupid. TO add 1000 Custom fields in a product, you cannot edit or save the product in this case and give slow queries ...

[servlet]

Hello, How to made .CSV or import to Virtuemart over 1000 customfields for different product groups ?

I dont know what does it mean... That is the reason to ask..
It is possible to add unlimited custom fields per product via CSVI. But what happen in VM FE... slow load maybe...
I have for some products approximately 200 custom fields but everything is OK. For 1000 I dont know.

[PRO]

Hello, How to made .CSV or import to Virtuemart over 1000 customfields for different product groups ?

I dont know what does it mean... That is the reason to ask..
It is possible to add unlimited custom fields per product via CSVI. But what happen in VM FE... slow load maybe...
I have for some products approximately 200 custom fields but everything is OK. For 1000 I dont know.

you need 1000 customs for a product?

what type of customs are they?

[servlet]

I dont need 1000 @2dmaster needs them..
I am using approximately 200 custom fields per product for colors materials, sizes ... this is the minimum - For the web I am using only one color palette. In real business  I am using more than 10 palettes with 100 colors per palette...

It is so hard to use VM for print shop... there is no good extension or plugin for this business...

[Studio 42]

servlet, for a need of 1000 variations, you can use one customfield plugin for all.

Some thinking that standard field are here for all cases. But it's not possible.

I needed for a shop a simple images selector from a (selectable)folder. because using 25 custom image fields is very slower that this method.
I think that it's not a problem to do what you need, it simply need to develop the right solution with virtuemart or not.

A nice other example is one of my customer development , ski rent. I converted a oold VM1 shop to VM3 using 1 plugin for all options(12 options with 15 prices for each option and discount, depending the beegin date).
This mean 2 queries only for all. Before they used multiple table with prices and list and files ... and needed many queries call, core hacks ....

So yes, using only core fields can be very slow and is not the best way in all cases