Resolved Stockable custom field product import

Hello,

I am not able to import correctly some products using the stockable custom fields of breakdesign. I cannot see any cart selection in frontend, even if after import I can see custom fields set correctly (see image).
I followed instructions for the creation of the stockable custom field and instructions for the creation of csv file to be imported as well (http://www.csvimproved.com/support/import/203-virtuemart/833-stockable-variants-import). I downloaded, installed and enable the csviext plugin "CSVI Import Stockable Custom Fields", so CSVI should work properly.

These all looks good as per your log file. But the way custom fields added to stockable custom field seems to be wrong.

For example, shall I set category_path also for children? I did not by now.
Can you help me in understanding what's wrong with csv file?
I am attaching log file after the import.

Yes, you can add category_path to children but your CSV file was missing in your last post. I can help you more if i can have a look at the csv file. Please post it.

I have another question for you: in order to use stockable custom field, I have to first create the separate custom fields that I have to add to the stockable one. Anyone of these fields shall not be set as cart variant nor as cart input.
It's not clear to me if I shall use string custom fields (like I did) or if I can use also customfieldsforall fields (plugin custom field). And, in that case, if they shall/have to be set as cart variant and cart input.

To be able to import to stockable custom field, You need to first create a separate parent custom field and then add all these string custom fields to it. This is explained in the document you linked. To be frank we have not tried customfieldsforall fields with stockable custom fields but this seems to be a good idea to give a try. I will try it and post you on what i find.

Hi Tharuna,
I am attaching csv file. Just consider that last product does not contain all the children here: I split a big file into smaller files, so other children are contained in another file I did not imported yet. However this should not be a problem (I suppose!).
Time ago I read that children products shall not be cathegorized in order to import them correctly. This was related to default Virtuemart custom fields, so it's not dealing with customfieldsforall or stockable custom field. I do not know if this is still true, but this is why I left category_path empty for all children.
Let me know if csv file is wrong or if I setup custom fields badly.
If you try the combo stockablecustomfield + customfieldsforall and make it working, let me know. Maybe it shall work better even in frontend (searches results for example) with respect to use Vm custom fields.

Regards

Hello,

Time ago I read that children products shall not be cathegorized in order to import them correctly. This was related to default Virtuemart custom fields, so it's not dealing with customfieldsforall or stockable custom field. I do not know if this is still true, but this is why I left category_path empty for all children.

Yes, adding the category_path for children makes the child product to show as a regular product but not as child.

Let me know if csv file is wrong or if I setup custom fields badly.

Your CSV file looks good to me, so i doubt with the way stockable custom fields is created. Can you share a screenshot on how you have setup the stockable custom fields in virtuemart?

Hi Tharuna,
please give a look at the attached images.
i posted just one string custom field setting, since the others are configured the same way.

Regards

Hello,
You setup also looks good. I will run the import with your file and let you know on what i find.

Hello,
Testing with your import file here, I found that there is something missing in your CSV file. The custom_title value you have for parent products has only one value "StockableCustomField" whereas it has to be "StockableCustomField~StockableCustomField~StockableCustomField~StockableCustomField~StockableCustomField~StockableCustomField" Since you are importing 6 child products. Please correct this for all parent products and try doing the import again.

Hi, any news about this topic?
I have just tried to install both CSVI Pro 6.5.4 and latest version of breakdesigns plugins, I'll try to see what happens in the meanwhile.

Regards
Vittorio

Hello Vittorio,

Tharuna posted instructions a week ago. Make sure you follow them and then try your import again.

Hello,
please excuse me! I did not receive the automatic email informing me about your answer, and I did not check if there was any answer before writing you last time. Sorry..

I tried to follow Tharuna's indication, but unfortunately the problem is still here. I found a strange difference between, for instance, 2 parent products. I attach 2 screenshots about that: in first case, parent product has no custom fields at all... in the second case, the same data you can see are repeated for every child product (sku you see is always the parent one). So I can't understand the reason of this difference.
I attach also the updated import file I used for this test.

Let me know if you need further info.

Regards

Hello,
I did a test run of your file here and i dont see any issue with it except that i see there is same SKU for product and parent for "BCricCUS107_1377_BI" record. Can you try running import only with few records first and see how it goes? Please post the debug log of the import in case you see any issue.

Hi Tharuna,
it doesn't work. I imported a few products, just around 40 rows of the file I sent, but I still cannot see any dropdown list in the product detail. I see again the difference mentioned in my last post, between two kind of parents.
I attach the log file of that import.
Then, I tried to do the following. I first create a product manually, creating father and one son. Then I see the dropdown lists in frontend. After that, I tried to export all the products: I noticed some differences between the ones imported and the one created. Could this help understanding where's my problem?
Regards

Hello,

First thing I see on opening your CSV file is duplicate entries.

Then, I tried to do the following. I first create a product manually, creating father and one son. Then I see the dropdown lists in frontend.

Which product is that in the import file? I am guessing it is aaaaaaa and aaaaaab.

In your debug log I see you have 50 fields and your import file has only 12 fields. So you can change your template by setting the Use file for configuration to Yes. At least you will be using the correct fields. Second issue I see is you set the file extension to XLS but the file you posted is a CSV. I suggest you change this back to the original value of Use default.

After these changes run your import and see how it goes.

Hello,
actually in the export file I sent you the parents are duplicated. I guess why. However, only export file is csv; the file I imported was an xls file, as you can see from log file. The products I created manually are the ones you mentioned, aaaaaa and aaaaab. Their fields are slightly different.
About using file for configuration, unfortunately I cannot do as you suggest: If I set the template this way, as soon as I click on preview, CSVI tells me file does not contain any header. I tried then to analyze the file: there's an issue about the file, that contains MAC ending characters. Changing the template, setting "I'm MAC" to yes does not solve the problem. This is why I configure manually the fields in the template. Consider that the original file is "readable" only opening it with openoffice: I then do some actions in order to get an xls. I want in in xls since I am running some vba macros in order to create data the way I need them. This is the reason why I don't use "odt" file neither in the template config.
I tried also to change the template using the custom fields directly, like "Colore" and "Misura", but nothing significant happens. I can just see custom fields like "descriptions" in the product details, there's no dropdown list..

Regards

Hello,

Changing the template, setting "I'm MAC" to yes does not solve the problem.

That means then that your server does not support Mac line-endings. Only other option would be to save the file with Linux or Windows line-endings.

This is why I configure manually the fields in the template.

That is perfectly fine of course but you will need to make sure the fields in your template match the fields in your import file. They must be in the same order.

Consider that the original file is "readable" only opening it with openoffice

CSVI can export for both OpenOffice and Excel.

I want in in xls since I am running some vba macros in order to create data the way I need them.

I understand, CSVI can read XLS files as well as long as you make sure there is enough memory, otherwise CSV is needed.

I tried also to change the template using the custom fields directly, like "Colore" and "Misura", but nothing significant happens.

Nothing significant is happening because using them directly you are not triggering the stockable custom field plugin.

I can just see custom fields like "descriptions" in the product details, there's no dropdown list..

Let's get the template correct first. With an incorrect template you can never be sure what happens during import.

Hi,
ok let's see if template is fine then. Please give a look to attached images. About Import_preview, I split fields in two rows: any of them contain parent on first line, children on the second line. Consider also that I cut custom_title and custom_value values in the image since they were too long in horizontal..
Anyway, CSVI seems to read correctly fields I set manually in the template, so from this point of view the setting should be fine.

Let me know if you find something not okay.

Hello,

Does your import file have 53 columns?

Hi,
there are 51 columns. If you see, numbers from 46 to 48 are missing in the photo, probably cause some updates during its setting.

Hello,

If you see, numbers from 46 to 48 are missing in the photo

Oh yes, I didn't see that. The ordering of the fields is not sequential. When you edit a template field you can set the Ordering field, from the published field and onwards you can change that value to set them all in order. Please fix this as well.

So, out of the 51 columns you are importing 20 of them. If that is correct, then that part looks OK.

Your field custom_multiple has more values than the rest. Other than that it looks OK. I would say, go ahead with the import of this parent and child product. If it doesn't show up correctly, post the debug log again.

I see some odd things in your previous debug log but let's see if that is cleared in the new one.

Hi Roland,
I fixed the fields ordering them properly. Then I erased all the data (products, categories, manufacturers, medias..) and after that I imported the file. Same result
I'm attaching log file.

PS: what do you mean with custom_multiple having more values than the rest? I gave a look at the file, it seems that the "Y" appears the same number of times respect to "stockablecustomfield" and "StockableCustomField".
Just a question: which is the purpose of custom_multiple field?

Regards

Hello,

So, I have been checking the debug log and let me explain what I see.

First it looks for the custom field called StockableCustomField

SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `p0uel_virtuemart_customs` WHERE `custom_title` = 'StockableCustomField' AND `field_type` NOT IN ('C','R','Z')

It finds this custom field with ID 22.

Next it removes any reference between the product and the custom field.

DELETE  FROM `p0uel_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 1813 AND `virtuemart_custom_id` = 22

Then it adds a reference between the product and the custom field.

INSERT INTO `p0uel_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES  ('1813','22','stockablecustomfields','','0','0','1','2016-03-24 18:47:41','851','2016-03-24 18:47:41','851','0000-00-00 00:00:00','0','')

Next it deletes it again when there are no parameters.

DELETE  FROM `p0uel_virtuemart_product_customfields` WHERE `virtuemart_custom_id` = 22 AND `customfield_params` = ''

After that it adds it again but 10 times.

INSERT INTO `p0uel_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`disabler`,`override`,`customfield_params`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES  ('1813','22','stockablecustomfields','0','0','','1','2016-03-24 18:47:41','851','2016-03-24 18:47:41','851','0000-00-00 00:00:00','0','0')

That last part I don't get, so we will need to look further into that.

Can you post the file you used for this import as well? That will help me to see what data it is processing.

what do you mean with custom_multiple having more values than the rest?

In your screenshot Import_preview the custom_multiple has a lot of Y~Y values.

Just a question: which is the purpose of custom_multiple field?

See the explanation at the Product import with custom fields documentation. All the way at the bottom.