Resolved Stockable CF in PB, import default variant

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

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

The import file that adds the stockable custom field variant for some products... In my case the "Memory" category.

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?

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

Yes, it works now. I will get back to you on what i find.

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.

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

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

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.