1. raydekker
  2. RO CSVI
  3. Sunday, 14 August 2016
  4.  Subscribe via email
Good day,

I've almost got everything sorted with my imports and the frontend to go public :)
What I need to do now is set default selection to a stockable custom field variant.
So in the frontend (please see screenshot) this means that instead of the product saying "select" for every custom field it actually selects a default config for that product.
The way this works is by adding a new variant to the product, selecting "Use current/parent product as derived" and filling in the required values (see backend screenshot).
This works great but I want this to be in my excel files that I import.

At the moment what I import to get the stockable custom fields in the product builder to work is by following the csvi manual on how to import stickable custom fields.
So this includes first import the stockable variants (VM products) with custom multiple fields (Y~Y~Y~Y...), custom title and custom value fields.
Then the actual products get imported marked as child product of the above product and all with their own custom title and custom value fields.

This all works fine but I'm struggling with is how to add that last variant to the product via import???
Maybe use a new import file and template somehow? but with what fields? Sorry I'm a bit lost here ;)

Thanks, best regards, Ray
Accepted Answer Pending Moderation
Hello Ray,

Let me ask you another question before we dig into this. Where do you set that the option "Use current/parent product as derived"? I don't seem to be able to find it in my system but also have no clue where to look ;)
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi Roland, ok fair enough ;)
It's IN Virtuemart > Products > and then select a product with stockable custom fields (in my case for example SKU 99613: DDR4 Dual memory).
So a product configured with stockable custom field variants.
So then go to the Custom Fields tab where you see all the variants that are imported via the import file (I've attached mine just in case too).
Then at the bottom select "Add new variant" and that's where you can set this up (see screenshot in previous post called backens.jpg).

Your login details to get into the backend (user: csvi) should still work, Tharuna has got the login details and directory access details.

I hope this helps, thanks heaps!
Ray
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
The import file that adds the stockable custom field variant for some products... In my case the "Memory" category.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello Ray,
Sorry to say, i am still not able to figure out how to get the option "Use current/parent product as derived". I dont see it in my test site when i try to add a new variation on custom fields tab. I tried to check on your test website but access to your VirtueMart pages are disabled for the user details you had sent me. Can you provide me the access to those views so i can have a look at it?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
O no, sorry I thought it inherited the permissions but I forgot only "Super User" had the appropriate right.
I've changed the "administrator" (csvi) permissions so it should be good now. I hope this works, let me know :)
Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Yes, it works now. I will get back to you on what i find.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Ray,
Currently CSVI dont support the functionality of "Use current/parent product as derived". I am working on this functionality and will send you the patch file when it is ready.
Kind regards,

Tharuna

=========================
If you use CSVI, 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
Hello Ray,
The patch files for using "Use current/parent product as derived" is ready. You need to apply both of the patch files attached here.

1. A new available field product_as_derived is introduced to support this feature. So once you apply the patch files, make sure that you update your available fields.
2. In import file, you need to add a one more row for parent product and set product_as_derived as 1. I have attached an example csv file here. You can try initially with one product and if it works, continue with more to see how it goes.


patch_vm_scf_2016-08-17.zip

patch_scf_2016-08-17.zip

examplecsv.txt
Attachments (3)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hi Tharuna, thank you so much (again)!!

It works!!

However, the way I'm importing is a little bit different than the way you described as I've created a new Excel tab called "8) PB Default Variant" which will be exported as a separate tab separated file (txt) and imported at the end of everything that was working already.
In this tab I automatically let excel fill out all the values using the VLOOKUP function that gets it from my Products and categories sheet (2).

So all the rest I left the same and after the initital 6 files I'm importing, this additional file with the default values gets imported and voila... default values are filled out in the product builder :)

It somehow didn't work when I changed the custom multiple field in the original file and added another "~Y" (together with the custom_title and custom_multiple)...
But it DID work by just importing this additional file with the following content (for only 4 stockable custom variants):

Product SKU Default Product Custom Title Custom Value Product Derived
99611 50118 Mem Speed~Mem Size~Mem Color 1600MHz~8GB~Blue 1
99612 50612 Mem Speed~Mem Size~Mem Color 1600MHz~32GB~Black 1
99613 52311 Mem Speed~Mem Size~Mem Color 2133MHz~8GB~Black 1
99614 53211 Mem Speed~Mem Size~Mem Color 2133MHz~16GB~Black 1

The test website is still accessible for you in case you want to have a look at the backend / frontend.

Thanks again, another thing solved :)

Best regards, Ray
Attachments (7)
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello Ray,
It works!!

Thank you so much for confirming.

However, the way I'm importing is a little bit different than the way you described as I've created a new Excel tab called "8) PB Default Variant" which will be exported as a separate tab separated file (txt) and imported at the end of everything that was working already.
In this tab I automatically let excel fill out all the values using the VLOOKUP function that gets it from my Products and categories sheet (2).

So all the rest I left the same and after the initital 6 files I'm importing, this additional file with the default values gets imported and voila... default values are filled out in the product builder :)

It somehow didn't work when I changed the custom multiple field in the original file and added another "~Y" (together with the custom_title and custom_multiple)...

Adding this feature to stockablecustomfields import was bit tricky, the custom_multiple value will not be counted when we are setting the parent product value as derived and so it did not work. As said already the parent product has to be used as a different row to be used as derived.

But it DID work by just importing this additional file with the following content (for only 4 stockable custom variants):

Product SKU Default Product Custom Title Custom Value Product Derived
99611 50118 Mem Speed~Mem Size~Mem Color 1600MHz~8GB~Blue 1
99612 50612 Mem Speed~Mem Size~Mem Color 1600MHz~32GB~Black 1
99613 52311 Mem Speed~Mem Size~Mem Color 2133MHz~8GB~Black 1
99614 53211 Mem Speed~Mem Size~Mem Color 2133MHz~16GB~Black 1

You have made a separate import file instead of one and the details are filled as it has to be and it worked. That is a smart way of doing it :laugh:

Thanks again, another thing solved :)

Glad to know that we were able to help you here.
Kind regards,

Tharuna

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


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