Angeladdie Posted February 21, 2007 Share Posted February 21, 2007 I am looking to change product IDs to numbers of my choice but I can't work out how to do this. I want to do this in order to bring them inline with a paper catalogue which is already in use. Is there a simple way of doing it? Thanks. Link to comment Share on other sites More sharing options...
Guest Posted February 21, 2007 Share Posted February 21, 2007 I am looking to change product IDs to numbers of my choice but I can't work out how to do this. I want to do this in order to bring them inline with a paper catalogue which is already in use. Is there a simple way of doing it? Thanks. You should use the products model instead (this can be set to whatever you need upto 12 charaters) as the product id is used to reference the product to other database tables. It would be quite a lot of work to change all the references to the product_id throughout the store and is probably not for the faint hearted! ;) Regards, *Ringo* Link to comment Share on other sites More sharing options...
Angeladdie Posted February 21, 2007 Author Share Posted February 21, 2007 You should use the products model instead (this can be set to whatever you need upto 12 charaters) as the product id is used to reference the product to other database tables. It would be quite a lot of work to change all the references to the product_id throughout the store and is probably not for the faint hearted! ;) Regards, *Ringo* I'm not sure this will work for me as i need individual product codes for what is in the database as one product with different attributes. can i set a model for each size attribute for example? Link to comment Share on other sites More sharing options...
Guest Posted February 21, 2007 Share Posted February 21, 2007 I'm not sure this will work for me as i need individual product codes for what is in the database as one product with different attributes. can i set a model for each size attribute for example? Hmm.. i'm not too clued up on product attributes i'm affraid but a quick look a the attribute table uses the products_id as a reference. And i believe that you cannot assign a model for attributes. I think this type of attribute/product code system is maybe slated for the next release of oscommerce 3.0 but I don't think that will be available anytime soon. This thread has some discussion on how product codes should be assigned with the addition of attribute information but the thread is kind of bloated now and i couldn't find the specific post i was looking for! One way round would be to add the product multiple times setting the prices indivdually without attributes at all (not the best i know). And i don't know how this would affect your particular shop implementation. For example : Model: 12345L Description: T-Shirt - Large Price: £12.99 Model: 12345S Description: T-Shirt - Small Price: £11.99 Sorry i can't be of more help! :( Regards, *Ringo* Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.