close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues


What do these words mean?

Thread began 12/01/2009 12:00 pm by rikagruenbaum326119 | Last modified 12/02/2009 6:52 am by rikaG_510 | 2254 views | 4 replies |


What do these words mean?


I just started to learn about MySQL using the starter kit and free eCommerce MySQL Database. Now I am building my own database for my shopping cart, I have some questions to ask.

1. I can't figure out the meaning of some Column titles in some tables.

In a columns under "product" table, there are cells such as;
-ProductSKU (what does SKU stand for?)
-ProductLive (what does this mean?)
-ProductUnlimited (what does this mean?)

I'd like to customize product table so I can start inputing product info, but can't figure out what these are.

2. There are tables for "option group" and "options", what exactly are these for?
What I mean is, are these options for products (like product description)?

Could anyone give me any idea please?
Thank you in advance.

Rika :-)

Sign in to reply to this post


Just solved one question...

I just googled again for SKU and I found that it stands for "stock keeping unit", which makes sense a lot...

Sign in to reply to this post

Office Guy-172461

SKU stands for Stock Keeping Unit. It is used to uniquely identify a model of a product (i.e. large blue widget has a different SKU than a Large green widget).

ProductLive indicates that the product will display on the site. This provides an easy way to temporarily take a product offline without deleting it.

Unlimited means there is unlimited inventory (i.e. downloadable product)

Options would be things like size and color.

Sign in to reply to this post

Neil Beadle

Hey Rika,

Those are great questions, and for future versions of this database, we'll try to provide comments on any less specific tables or columns.

Don't worry too much about some columns not making sense or appearing unnecessary. This database is intended to cover a wide spectrum of websites, and if you end up with some columns or tables not being used because you have no use for them, that is fine. Who knows, they may come in handy later.

Sign in to reply to this post



Thank you both, now I feel much better!

>This database is intended to cover a wide spectrum of websites.
I thought so, but just couldn't leave them or go to the next step not knowing what these were for.
(I bet there are other folks who feels the same way ).

I wondered for a moment if this question would be too basic, but I guess there's nothing to lose by asking any question!

Rika ;-)

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...