mugitty Posted January 3, 2003 Posted January 3, 2003 I suspect that I already know the answer to this one, but thought I'd ask any way. Does one need to have totally unique model numbers throughout the entire catalog, or can there be identical model numbers as long as they don't occur in the same category or sub-category? ... if you want to REALLY see something that doesn't set up right out of the box without some tweaking, try being a Foster Parent!
smiley Posted January 3, 2003 Posted January 3, 2003 The first field in the products table is auto_increment:- products_id int(5) NOT NULL auto_increment, This is the value used by the database - not model numbers so it shouldn't matter. :P HTH Neil Common sense is genius dressed in working clothes. Ralph Waldo Emerson
Guest Posted January 3, 2003 Posted January 3, 2003 Not questioning your inventory practices, but doesn't using a model number multiple times make inventory tracking difficult in the back office?
mugitty Posted January 3, 2003 Author Posted January 3, 2003 Thanks for the response, Neil. I guess I should have expanded a little more in my original question... I'm looking specifically at the use of EasyPopulate and remember seeing Tim's caveat against using 'Test' as a model number for everything when doing an upload, so I'm curious if I would be able to use identical model numbers while using this tool, as long as they were in different categories? Any opinions and/or definitive answers are much appreciated :huh: ... if you want to REALLY see something that doesn't set up right out of the box without some tweaking, try being a Foster Parent!
mugitty Posted January 3, 2003 Author Posted January 3, 2003 Excellent question, Wayne. We generally use a resource prefix tied to the manufacturer's part number when dealing with things internally: Briggs & Stratton part #123456 is BS 123456 Murray part #123456 is MUR 123456 The incidence of having identical manufacturer part numbers is fairly limited, but it does happen. I suppose I could preface every model (part) number with the resource prefix, but I'm trying to avoid that X 20 or 30 thousand, if I can do it without messing something up. ... if you want to REALLY see something that doesn't set up right out of the box without some tweaking, try being a Foster Parent!
smiley Posted January 3, 2003 Posted January 3, 2003 I think it comes back to being able to uniquely identify a product - frontend and backend. If you can add a field that does this to EasyPopulate then the issue is solved. :) HTH Neil Common sense is genius dressed in working clothes. Ralph Waldo Emerson
wasson65 Posted January 3, 2003 Posted January 3, 2003 Thanks for the response, Neil. I guess I should have expanded a little more in my original question... I'm looking specifically at the use of EasyPopulate and remember seeing Tim's caveat against using 'Test' as a model number for everything when doing an upload, so I'm curious if I would be able to use identical model numbers while using this tool, as long as they were in different categories? Any opinions and/or definitive answers are much appreciated :huh: Defnitively, using the same model number for different products will not work with EP. EP was specifically designed to allow the placement of a single product into multiple categories, and that's what it would think you were doing. So, short answer, model number must be unique. Tim
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.