News:

Looking for documentation? Take a look on our wiki

Main Menu

product_mpn in virtuemart_product_customfields what's it for?

Started by gregcr66, February 05, 2016, 19:09:15 PM

Previous topic - Next topic

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

Regards
A

Joomla 3.10.11
php 8.0

jenkinhill

And GTIN is Global Trade Item Number. SKU (stockkeeping unit) is obvious to all businesses.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

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
Он-лайн магазин за фототапети http://mishelfoster.com

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
Он-лайн магазин за фототапети http://mishelfoster.com

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.
Он-лайн магазин за фототапети http://mishelfoster.com

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...
Он-лайн магазин за фототапети http://mishelfoster.com

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.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

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