Changing Product ID

[goneflyfishin]

In my store we sell fishing flies and there are lots of different sizes and colours of some patterns so I want to make a "barcode" of sorts to attach to each product so I know when the orders come in, what to ship the customer. I came up with a barcode system that is an 8 digit number that relates to the pattern, size and colour of the item.

 

Is there a way to change the product ID's of each product individually to this 8 digit number? Right now it is on auto_increment in MySQL and is only a two digit number.

 

In the product attributes I have added size and colour categories but the ID is still just a 2 digit number.

 

Are there any contributions that will let you add a specific barcode to each item for inventory purposes?

 

Thanks guys

[bradkl]

In my store we sell fishing flies and there are lots of different sizes and colours of some patterns so I want to make a "barcode" of sorts to attach to each product so I know when the orders come in, what to ship the customer. I came up with a barcode system that is an 8 digit number that relates to the pattern, size and colour of the item.

 

Is there a way to change the product ID's of each product individually to this 8 digit number? Right now it is on auto_increment in MySQL and is only a two digit number.

 

In the product attributes I have added size and colour categories but the ID is still just a 2 digit number.

 

Are there any contributions that will let you add a specific barcode to each item for inventory purposes?

 

Thanks guys

 

Found this from a previous post:

Greetings! Product Model is generally used as the model number or sku, for the product you are selling. It may contain letters, numbers, or a combination. These could be from a manufacturer, or perhaps based on your own inventory numbering system.The default length is 12 characters but can be changed, in in the orders_products and products tables in your database.

 

hth

[insomniac2]

If you want to keep your Model Field intact and have an extra field for the barcode you can use a contrib like this one:

 

This will give you the capabilty to add UPC numbers, ISBN/ISSN numbers, SKUs, or other product identifiers to you catalog.

 

Add UPC numbers, SKUs, ISBN/ISSN, etc v1.1

 

Link:

http://www.oscommerce.com/community/contri...,all/search,UPC