1. DigitalDesignAgency
  2. RO CSVI
  3. Thursday, 14 April 2016
  4.  Subscribe via email
Hi there,

I have set up a parent product with 3 child products (sizes) using Break Design Stockable Custom Fields Plugin. Works perfectly fine on frontend and the select size dropdown is displayed.

When I export the product using CSVI Pro, it gives me the 4 rows and they all look correct as far as i'm aware (I have attached).

When I import the same file without making any changes the size dropdown dissappears from the front end. Perhaps I am missing an important field? I am reluctant to go on and add more products until I know I have one working on export/import.

Any help would be appreciated. Have attached .csv and export log. Can give backend access if needed.
Accepted Answer Pending Moderation
Hello,

Have you also installed the Stockable Custom Fields addon for CSVI? It looks like you have but just want to double-check. You can find the addon in the Downloads Extensions if you need it.

As for your import file, I am missing the field custom_multiple. This field is needed because you are adding multiple values to the same custom field. You can see that as well in the example in the Stockable variants import document.

Add that field and I think you should be good to go, if not, let's see what is happening in the new debug log.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi Roland,

Thanks for getting back to me. Yes I have the Stockable Custom Fields addon installed and working.
I have added the custom_mutiple field to the import and export template fields, however when I export the field is not displaying in the .csv file, I have attached the latest with log for you to see.

I could add the field in manually, but if the field custom_multiple is not recognised on the export I imagine it won't get picked up on import?

Many thanks,
Luke
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Luke,

The custom_multiple field is not in your export file because it is not in your export template. You will need to add this field to your export template so CSVI knows you want to export this file.

It is not picked up on the import because it is not in your import file. CSVI doesn't add any fields to any import or export by itself, it solely works based on the fields set in the template.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hi Roland,

Im sure I have added the custom_multiple field to the export and import templates, please see the screenshots. Any other field I add seems to work fine and exports to the .csv file. But not the custom_multiple field.

I have attached .csv and log from latest export using the template you see in the screenshot, but no luck. Any ideas?

Thanks,
Luke.
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Luke,

My apologies, I have been incorrect. There is no custom_multiple field for export because CSVI can't determine whether a value is multiple or not. Even more amazing is that you have a custom_multiple in your export template because it is not an available field for export but I think that happened because you made a copy of the import template and changed it?

The way to get the custom_multiple out is to create a field of the type custom, set the column header to custom_multiple and set a default value of Y~Y. Add more ~Y if you have more fields. As long as you have at least the same amount of Y values as you have fields, you are OK.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hi Roland,

I'm impressed I managed to use a filed that shouldn't be available?!

So I have set up the field custom, and set the column header to custom_multiple with default value of Y~Y (you can see the screenshot of this).
I exported using this template and you can see the export .csv attached, it put Y~Y in the custom_multiple column for parent and child product.
I amended so that only the parent product had the entry Y~Y~Y, as it has 3 child products. Then Imported using the import .csv and import template which are attached/screenshot.

Still no luck, the dropdown to select a child product still disappears from front end after import. I have attached both export and import logs.

Also, there will eventually be some products that do no have child products, so the value for custom_multiple will be 'N' correct?
Does this mean each time the list of products is exported that will be overwritten by Y~Y as you suggested ti use in the export template?

Many thanks,
Luke.
Attachments (4)
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Luke,

I exported using this template and you can see the export .csv attached, it put Y~Y in the custom_multiple column for parent and child product.
That should be OK if the children have the value as well as it is not used for them, but I will double check that for you.

You said in an earlier post:
Yes I have the Stockable Custom Fields addon installed and working.
now I wonder if we have a miscommunication here. When I asked about the Stockable Custom Fields addon I did not mean the plugin by Break Design but the plugin from CSVI. The reason I bring this up again is that in your logfile there is no trace of the CSVI plugin being alive. The expected notifications are not in the log file. So I am going to ask again if you have the CSVI plugin installed for Stockable Custom Fields, if so, can you check if it is enabled.

Also, there will eventually be some products that do no have child products, so the value for custom_multiple will be 'N' correct?
The custom_multiple is not related to the child products but to the number of duplicate custom_title values you have.

Does this mean each time the list of products is exported that will be overwritten by Y~Y as you suggested ti use in the export template?
Nothing will be overwritten by the Y~Y value, it is just a mechanism for telling CSVI there is more than one of the same value in the custom_title field. In your case you have 3 times the Option in there. If you do not have the custom_multiple set, the second Option overwrites the first option and the third overwrites the second one. Using the multiple, they remain as they are.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hi Roland,

I think we may have had a miscommunication as you suggested, I thought you were referring to the plugin by Break Design. My apologies.

I have now installed the Stockable Custom Fields Addon and the variant dropdown remains on the frontend after import!! So thank you!

I do however have a slight issue with the custom_multiple field now. On the import I set the parent to Y~Y~Y as it has 3 child products. I did not enter a value in this column for the child products, and it imports and works as expected. When I then export that same data, it is entering the default value as specified in the template field (Y~Y), for all products both child and parent. It is overwriting the Y~Y~Y which I used for the import. I have uploaded everything for you to see.

Will removing the Y~Y from the export template field 'custom' default value solve this?

Many thanks,
Luke.
Attachments (4)
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello Luke,
Will removing the Y~Y from the export template field 'custom' default value solve this?

Yes, you need to remove this default value from template fields as CSVI cannot identify that it is the parent row and so custom value should be added, It will be added to all records. After exporting you need to add this custom_multiple value to all parent rows and import it back.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello Luke,

The answer by Tharuna is correct but not practical I am afraid. Removing the custom_multiple field from the export template means, you will need to add this field manually to all parent products and that would be very cumbersome.

As I mentioned before I don't think having the custom_multiple for children is an issue as they are simply not used for them. Did you try importing the file with the custom_multiple field for all parents and children?

It isn't actually overwriting your custom_multiple on export, the custom_multiple isn't stored, it is only used as a control structure during import. So in your export template you can set the value to Y~Y~Y or even more, as long as you have at least the same number of Ys for the maximum number of children.

If you have a parent with 3 and a parent with 5 children, you will need the 5. Since 5 is more than 3, you are OK for the parent with only 3 children as only the first 3 will be used.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hi Roland,

Thanks for getting back to me. So am I correct in thinking that I should use Y~Y~Y in the custom template field for as many as I think I may need for all products?

So if I were to use Y~Y~Y~Y~Y~Y~Y~Y~Y~Y in the custom template field default value, it will appear like this Y~Y~Y~Y~Y~Y~Y~Y~Y~Y for all parent and children products on export, but on import it will only process as many as it needs?

If that's the case then great, I should be able to crack on and add more products.

Thanks very much,
Luke.
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Luke,

So am I correct in thinking that I should use Y~Y~Y in the custom template field for as many as I think I may need for all products?
Correct.

but on import it will only process as many as it needs?
Correct again.

If that's the case then great, I should be able to crack on and add more products.
You should be good to go. If you run into anything, we are here to help :)
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!