Resolved i want to export product with custom fields

Hello Ben,

Please help me here.

I would love to but I can't help you if you don't help me with the information requested at the top of this page under Looking for a useful answer?

When I have export CSV file with the virtuemart product data and parent id

This is not recommended at all. Recommended is to use the product_sku and the product_parent_sku fields. Fields ending in _id are not set in stone.

When I have select the number of records to export up to 2 to 70, then they are exported

You cannot export all your products or you have no need for it?

Your topic title refers to custom fields but you don't mention them in your post. If you are looking for guidance on custom fields, have a look at the Custom fields import and export.

Hi Roland

Thank you for your time on this problem i am working with a friend (Jignesh) in india on this project who has created the virtuemart product and its custom fields for me and is trying to use CSVI to allow me to add new products with all attributes (including custom fields prices).

I will try to get him to explain exactly what the custom fields are and how he is attemting to use CSVI. I have read all of your help docs but still cant see exacly how the custom fields he has created will be exported.

Kind Regards
Ben Abbott

Hello Ben,

Any question you have feel free to post them but accompany them with the requested info at the top of the page. This will allow me to give you a useful answer to your question. It will also be useful to know how the custom fields are setup and what type they are (text, plugin etc.).

Hi Roland

CSVI 5.15 Pro
Virtuemart 2.0.26d
Joomla! 2.5.11

I purchased CSVI Pro with the understanding i can use it to add products and update all prices accross my virtuemart shop by importing/exporting custom fields containing the product options and prices is this correct?

I have the master product and all custom tables working in the test virtuemart installation and i now want to be able to export to Excel CSV and import into the identical production installation. But so far we have been unable to export all the relevant custom field data from the test site.

The end result would be to be able to update all products and options in one CSV is this possible?

And if it is possible do you know if there is a specific way the virtuemart custom fields have to be set up?

Thank you for your time.
Ben

Hello Ben,

I purchased CSVI Pro with the understanding i can use it to add products and update all prices accross my virtuemart shop by importing/exporting custom fields containing the product options and prices is this correct?

That is correct with one remark. If you are using a 3rd party custom field plugin, it may not be supported (yet). Are you using any 3rd party custom field plugins?

The end result would be to be able to update all products and options in one CSV is this possible?

That is possible.

And if it is possible do you know if there is a specific way the virtuemart custom fields have to be set up?

The Custom fields import and export tutorial I linked before is the document you will need to setup all fields.

Hi Roland

Thanks for the quick response.

I started by using the breezingforms custom fields plugin is this compatible?

But since Jignesh is using the VM - Custom, stckable variants plugin. I have attached details of what he has done along with a test csv i have output. I am confused as to how we export the option values in the Size/Quantity/Colour/Paper

Is there is a problem with our product setup in the VM - Custom, stckable variants in virtuemart or is it our setup of the CSVI.

I really apprieciate your help on this.

Thanks in advance,
Ben

Hey Ben,

I started by using the breezingforms custom fields plugin is this compatible?

This one is not compatible. It is yet another plugin I do not know the existence of

But since Jignesh is using the VM - Custom, stckable variants plugin

This plugin is already supported since it comes standard with VM.

I am confused as to how we export the option values in the Size/Quantity/Colour/Paper

It seems that you have default values set for these fields. Can you post a screenshot of your field configuration in the export template?

Hi Roland

In this Grab i have deleted all the defaults but my column output then comes out blank?

Thanks
Ben

Hello Ben,

Sorry to say but the field setup is pretty wrong. Let's start by cleaning that up. Here is the list to follow

1. Remove 2 of the custom_value fields, so only 1 is left over.
2. Empty all the Column header fields.
3. Fix the order column by clicking on the icon next to the word Order above the column. This will make the order sequential.

After these changes are applied, run a new export and let's check what you have in your file then.

Hi Roland

All changes made

All blank?

Hello Ben,

All blank?

Possible, do you already have custom fields assigned to products?

You may want to set the option Record Grouping to Yes on the File tab (1st tab). This will clean up the duplicates in the file.

product_sku custom_title custom_price product_parent_id custom_value custom_param
82
new2 0
new2 82

This is the only output.

That I would expect. You haven't answered my question yet:

do you already have custom fields assigned to products?

Hi

Sorry the last message was lost, there are no other custom fields in use.

we have tried several plugins so maybe there is a conflict somewhere.

Is the product set up correctly in Virtuemart in "Custom fields screengrab 000.JPG" and "Custom fields screengrab 001.JPG"?

I have another fresh installation i think i am going to try to set it up there.

Hey Ben,

The custom field should be assigned to the parent product. I can't tell if new2 is your parent product or not because the options are all related to products with the same name. I would expect to see the names of all your child products there. The product SKU must be unique for every child product, this is a requirement from CSVI.

See attached a screenshot of my stockable setup.

I think that's it no unique child SKU's

Thanks very much for your help i really apprieciate it. I will go back and try it myself.

Kind regards,
Ben Abbott

Keep me updated Ben.

I will be trying to set it up correctly today so may be in touch later thanks.

Hi Roland

Sorry this is a long one, i am stuck in the middle here!

We have had some success but we still need to work out how to add the products and there related custom fields at the same time.

When creating the template to import products we have so far added product_sku, product_name product_price, product_parent_sku, product_in_stock, custom_param, custom_title as seen in the file upload: product_import_csv_new4.csv.

To export the custom fields at the same time do we need to add:
plugin_name, custom_element, custom_title, custom_value, field_type as in the support here... http://www.csvimproved.com/frequently-asked-questions/778-custom-fields-import-and-export

Can we do this in the same csv as the products so everything is added at the same time the product its childeren and the custom fields so they are populated on import?

Is the best way to go about this to create the product and all custom fields in the test site and then to create an export template that contains all the required fields before attempting to import? sorry this is probably a stupid question but i need to clear this all up to pass on to the dev team.

Kind Regards
Ben Abbott