News:

Support the VirtueMart project and become a member

Main Menu

How to made & import custom fileds > 3000 products

Started by 2dmaster, June 19, 2016, 19:54:09 PM

Previous topic - Next topic

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

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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

Он-лайн магазин за фототапети http://mishelfoster.com

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

QuoteHello, 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.
Он-лайн магазин за фототапети http://mishelfoster.com

PRO

Quote from: servlet on October 26, 2016, 10:52:16 AM
QuoteHello, 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...
Он-лайн магазин за фототапети http://mishelfoster.com

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