We have the following problem: We are working on a Virtuemart-Shop. Due to the several attributes like color, paper grade or dimension the price but also the SKU should change. By simple attributes the SKU stays always the same no matter which attributes are selected. We know we can use parent- and childproducts. But then there will be one huge drop down list and not, as we would prefer, single dropdown-lists for each attribute.
This is what we like to have as solution: For each product a basic SKU is specified (i.e. "ab123-"). There should be another textfield under "productstatus" next to the already existing attribute-fields, so we can enter a variable in this textfield (i.e. "r" for color, "a115" for paper grade and "a2" for dimension). This variable is added to the basic SKU, so there is a final SKU like "ab123-ra115a2" which appears in the checkout etc.
Please kindly send us an offer for coding of this function with exact description of the necessary timeframe.
[attachment cleanup by admin]
what version of virtuemart and joomla are you using ?
Joomla 1.5.14 and Virtuemart 1.1.4
Let's say we have a variable SKU as you wanted
When a user places an order the variable SKU will be stored in your order_item_sku in jos_vm_order_item table ?
How will you decipher that ? Will you do it manually ?
Meanwhile I am not an expert, but I will try and figure out the solution you want
and get back to you.
Give me say a week's time
Oh I am not a programmer so I don't know how it has to work. But I think the variable SKU should be stored where the order is stored. It only has to be linked to the individual order. This shall work automatically.
How much will it cost?
I will work out the solution and give it to you
If you are satisfied with what I have done, pay me what you feel like :)
ok let's see what you can do ;) and be sure that you will be payed if we are satisfied
hey can you provide those images in English please !!
else I will assume some dummy names and go on ;)
yes I can. But the extensions should work with every attribute no matter of the name
[attachment cleanup by admin]
Ok thank you, that helps.
Today is 9th December.
Give me time till say 16th or 17th December.
by the way I am an Indian, from which place are you ??
you can mail me at celestialcitizen@gmail.com
Hey I got it working
But i guess you will have to do extensive testing and get back to me if there are any bugs !!
One more thing, this modified sku var does not show up in the checkout process but shows up in the jos_vm_order_item order_sku feild
if you wanna that to show up in the checkout process as well I will do it.
i will mail you all the necessary files and instructions where to place what
I would be interested in this. I have contacted you by email.
I am also interested?
Interesting extension to be done, also some funding could be gathered by all of us for celestialcitizen to get this VM extended functionality.
I am actually looking for something very similar if there are any developers interested. Please PM me.
Hi people
I figured out that people like two versions of this.
One in which the base sku is appended to the variable sku.
and the other in which only the variable sku is used.
I have implemented both.
Also made 2 implementation in the last 2 months !! ;)
I thought attaching the screen shots might help :)
[attachment cleanup by admin]
Many Many Thanks to Celestialcitizen for the Variable Sku code! Your code worked perfectly and your continued support was well worth the $$. I'd recommend this code and Celestialcitizen to anyone needing help customizing Virtuemart.
Thanks again!
using child products will accomplish this
CelestialCitizen has customized our SKU vars and attributes and has done an absolutely amazing job.
His custom code modifications did not render any bugs with other functionality and is very easy to work with in the administrative control panel of VirtueMart.
On top of that, he is very quick with his work, provides backup files and copies of all of his modifications. His costs were very low compared to other developers I have worked with.
My website is: http://www.glgcp.com
Thanks again CelestialCitizen for your help with our needs! ;D
No it is not done manually
It is all done in the code
Hello celestialcitizen,
how did you solve these problems:
1. For certain products like shirts, not all combinations from color/size are available.
Is there a matrix that can be set according to the available products?
2. Products have to be imported via cvs_improved. Usually we would use attribute/s fields for this, depending on the use of parent/child skus or plain attributes that won't change the sku.
3. Can you do "+5%" prices? VM currently does not understand this syntax.
4. How will you keep your patches updated? VM 1.2, 1.9 and 2.0 are coming up soon.
We are also interested in the following 2 extensions:
1. Multistore addon, so that we can export products to certain shops at certain prices, export/import will be done via csv_improved and crontab
2. Compound products.
Example: a PC consists of a barebone (chassis + mainboard + power supply), a CPU, {0-2} optical drives, {1-4} magnetic drives of size {500,1000,2000} and {1..16} GByte of memory and assembly.
All the components have their own sku and prices.
Once the order is placed, all the sku nos and prices are imported into our system and the order goes straight to supply department (ordering any components from the warehouse) and then to assembly department.
This code could also be used for compound products like special occasions, where various products are bundled into one special offer.
So an admin menu for defining unlimited compound product lists would be necessary.
Please share your thoughts ::)
B.
Hi
My God, your post has set me :o
Well, first I think we need to be clear that variable sku is for advanced attributes and not child product attributes.
Secondly for handling +5% in attributes, it can be certainly achieved by hacking the system.
The rest of your requirements, well maybe we could take it offline , what do you say ?? :)
Can you tell me what is the variable for the product child sku?
I just want to echo it in my parent product template. Im using the addtocart_list_multi.tpl.php for customizing the product template.
Other issue, if you guys could help me, is how do I display in category mod only the parent products, since it display all, parent and child products.
Thanks for the guidelines.
Diogo Paiva from Portugal
Hi
Actually we are talking about advanced attributes in products and not about items
is this still alive ,we can help regarding to get to work :)
Hi, Celestialcitizen, would you tell me, where I can find your hack?
Hi
I can send the code across to you or maybe I can even help you apply the code on your site for a fee.
Please PM me or email me
I would be interested in this.
hai,
i need same functionallaty in my project please anyone can help me its urgent for me
Hi again celestialcitizen!
I've sent message to you, and copy to your e-mail, but you not reply.
Please contact me asap, I want buy your solution.
Or anyone who have this, if you can help me please contact me here or email: mystel@yandex.ru
the original post is over years old, so it predates VM2.0
was this ever upgraded?
Hi
I haven't updated the code for VM2 but it works fine on vm1.1.x
Hi Celestial. Very interested in hiring you for some work related to this - please could you contact me at natastna2 @ hotmail . com