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
- raydekker
- RO CSVI
- Sunday, 14 August 2016
- Subscribe via email
0
Accepted Answer
Pending Moderation
Hello Ray,
Thank you so much for confirming.
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.
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:
Glad to know that we were able to help you here.
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
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
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
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Yes, it works now. I will get back to you on what i find.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
I've changed the "administrator" (csvi) permissions so it should be good now. I hope this works, let me know
Thanks
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?
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
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
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
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »