product_mpn in virtuemart_product_customfields what's it for?

[gregcr66]

Hi All,

I'm working with custom fields and noticed the datacolumn product_mpn in the customfields table of the DB.
I also see product_sku and product_gtin.

I don't see where this data may be used, but it may be helpful to my cause.

Can someone please let me know what these columns are intended for?

thanks!

[AH]

its the product Manufacturer Part Number

[jenkinhill]

And GTIN is Global Trade Item Number. SKU (stockkeeping unit) is obvious to all businesses.

[servlet]

Ok.
How to use product_mpn in virtuemart_product_customfields
When shopper fill custom fields there are only title, price, value
there is on fields for product_mpn or product_gtin
from other side is it possible to display it in confirmation email

[Studio 42]

It's only used for generic variant and multivariant.
I was wondering myself that this are not in the customfiel parameters, we have 2 columns only for this(or more?).

[servlet]

Thank you for replay
If I import values manually in database how to echo this values in cart or confirmation e-mail inline next to the selected field value
eg Material: WOOD mpn: W2032
Now it is possible to display
Material: WOOD

[Studio 42]

This is bad way to use this fields. And perhaps this get removed a day.
Simply use a customfield having attribute cart, this is displayed in the cart and in the order too.

[servlet]

I am using customfields with Cart Attribute but I want to add MPN for this field
now I can add CUSTOM VALUE and CUSTOM PRICE when I create product with custom fields. Where is the field for MPN of custom field. There is a column MPN in database but you cannot use it. This option is needed.

No matter it get removed some day. I want to display it in confirmation mail. How to do it.

[Studio 42]

Add a new custom field string and set it as cart attribute and name it MPN or Gtin or any you want add it to your product and fill your MPN and it work, it not need a hack

[servlet]

May be we dont understand each other.

Custom Fields of product

Sizes: 10m, 20m, 30m
Colors: Red, Blue

For what reason I have to add field with MPN field. Any size has own MPN
If user Select Size 20m MPN field will not change and I dont know which is the product in the store...

[jenkinhill]

As MPN has to be unique for each size variant, then surely each "variant" should be a different product, ie a child of the parent product.

[Studio 42]

If you need NMP for each variant
Sizes: 10m, 20m, 30m
Colors: Red, Blue
...
then use multi variant, because in this case the stock is not the same and perhaps other informations.
If only the color ahve NPM, then use genric variant for color and string list for sizes