Product ID still only 12 Chars?

[Guest]

Hi,

 

After 10 Years of OSCommerce, I had to restart from scratch and ran again into an old OSC problem:

 

The product ID is still 12 Chars only.

 

Why so narrow?

We don't have to spare every byte any more, do we?

 

The international ISBN standard for books is 13 chars and will not fit into OSCommerce ProductID, EAN is 13 chars as well, many product codes in the industry are wider.

 

OK the fix is easy, but wouldn't it be as easy to extend it to 16 or better 24 Chars in the standard and to avoid future trouble?

 

Regards

RIN

 

[multimixer]

How is the products_id related to EAN code or ISBN or anything else?

 

It is used only internally

[burt]

I think @@rin67630 refers to products_model...

 

And, ummmmm, taken direct from the install SQL

 

 

products_model varchar(64)

[multimixer]

Yes, products model make a sense

 

I just downloaded osCommerce from here and in the install sql it is

  products_model varchar(12),

So I guess that OP is right

[burt]

Hmm.  That's the normal osCommerce, if you're using that, a model of 12 is the least of your worries.

 

Anyone starting from scratch would be best advised to use the Responsive osCommerce.  

[burt]

Split => chit-chat about Responsive vs Normal @ http://www.oscommerce.com/forums/topic/408917-responsive-vs-normal/

[♥bruyndoncx]

if database size/space is no concern, and you want to search efficiently on products model, I think you should be using a char field that has fixed length for each entry and your index will be much more performant

[Guest]

if database size/space is no concern, and you want to search efficiently on products model, I think you should be using a char field that has fixed length for each entry and your index will be much more performant

 

Performance should only be a concern for really huge shops. With some thousand products I don't have to worry about the product indexing.

[Guest]

I think @@rin67630 refers to products_model...

 

And, ummmmm, taken direct from the install SQL

Yes thanks for the precision.

[♥bruyndoncx]

Performance should only be a concern for really huge shops. With some thousand products I don't have to worry about the product indexing.

lucky you :D