News:

Support the VirtueMart project and become a member

Main Menu

sku not allowed [solved]

Started by gpessoa, March 17, 2021, 21:04:08 PM

Previous topic - Next topic

gpessoa

Hi ppl,
I need to create a product with Sku 1310050111-8799050210-8786010210-1510050210, the problem is that VM doesn't allowed it...
It blows up!
I am thinking that this field is doing math... becouse, if I chande the fist digit from 1 to 9, like 9310050111-8799050210-8786010210-1510050210 it works as it should be!
Can somebody test this on your e-shops?
I need to know if this is a bug or something else...
Thank in advanced
J 4.4.4; VM 4.2.6; PHP 8.3.6

Jörgen

Virtuemart should not do any kind math on this. The field is a varchar with length of 255. Do You have some plugin or extension that maybe mistreats the field.? Check with phpmyadmin that the field is correct.

Jörgen
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

gpessoa

Maybe the problem is that I changed my Porduct_sku index on DB by recommendation of Rolland (CSVI)...
Proceeded like described on this link!
https://rolandd.com/documentation/ro-csvi/virtuemart/speed-up-product-import
So, How can I undo that?
J 4.4.4; VM 4.2.6; PHP 8.3.6

Jörgen

#3
Messing with the db is Always risky if you do not know what you are doing. The problem is not indexing, 25 characters is not enough for your specific needs. Change the size to match your sku length.

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

gpessoa

#4
Problem solved (increased index)
Thank you!  :)
J 4.4.4; VM 4.2.6; PHP 8.3.6