Resolved Stockable custom field product import

Ok thank you, will update you on what i find.

Hi Tharuna, I have just sent data via email.

Regards

Hello,
Can you send me the site login details and database login details? I will directly check into your site and debug the issue.

Hi Roland,
this sounds strange. I don't know which product you are referring to, but since one of them in my file has 11 children... could it be that the reason? First one is the one you mentioned, then the import deletes and adds references for the other children.. I am just trying to guess! Don't care!

Anyway, here is the initial xls file I imported.

PS: now custom_multiple meaning is clearer, thanks. I put as many "Y" as the number of children, like custom_value and custom_title fields. I read it here: https://www.csvimproved.com/support/import/203-virtuemart/833-stockable-variants-import.
I read the informations in that link in order to create xls file for this kind of import.

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.

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,

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,
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,

Does your import file have 53 columns?

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,

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.

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,

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.

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,
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.

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 Vittorio,

Tharuna posted instructions a week ago. Make sure you follow them and then try your 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,
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.

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