July 27, 2004 at 3:17 pm
I'm building a new e-commerce website for an apparel client. Their products need to be SKU or UPC code specific in order to accommodate color and size attributes.
Could anybody recommend an apparel SKU database design or a resource for an apparel SKU database design? I have a good idea what I would like to do but I'm sure there are proven standards and conventions for this type of project.
Thank you advance for your advice.
July 28, 2004 at 2:06 am
Actually I would approach your problem from a completely different angle.
There are out-of-the-box e-commerce solutions out there and I would simply choose the one that is nearest your requirements.
They are all relatively inexpensive and most do vastly more than you will be able to come up with at a reasonable cost and in a reasonable time.
You might want to look at some of the following.
The latter two are PHP MySQL based but I have to say that I was blown away by X-Cart and the support is pretty damn good.
The latter two also provide the source code so it is quite possible to port them to a SQL Server environment if you have to.
Again, I wouldn't bother. If you want MySQL data in SQL Server then there is an ODBC driver and you can simply DTS it in.
The only real down side to X-Cart is that it is so big that to plug your companies look and feel into every facility is going to take a long time. Your best bet would be to hide the facilities you don't need immediately and slowly make them visible as you add them.
I would say the big problem with cheap software is that people think cheap==quick.
In terms of SKU codes containing colour and size information, a simple VARCHAR or CHAR field will do the trick, but I would definitely have separate fields in addition to SKU to speed up searching for size and colour. I tend to look at SKU numbers as being a companies internal short-hand for their products. Human readable, but only by employees.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply