473,737 Members | 1,817 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Shop online

Hi
I want to build a shop from scratch,
i'm laying down all the possible problem i can find during the way.
how can i structure the database to be able to add unlimited properties
or attribute to different kind of product ?
like if i sell a t-shirt i will hate to chose size and colour
if i sell a plate probable the model and the colour
i'm looking into other open source shop like oscommerce and the
structure of the database is really to big for my knowledge so i cant
really understand it.
i now that i neet to divide all in table as much i can but how?
thanks
D
Feb 15 '07 #1
7 1777
On Feb 15, 2:19 pm, Daniele <"dmassaiu{["@]}yahoo.co.ukwro te:
Hi
I want to build a shop from scratch,
i'm laying down all the possible problem i can find during the way.
how can i structure the database to be able to add unlimited properties
or attribute to different kind of product ?
like if i sell a t-shirt i will hate to chose size and colour
if i sell a plate probable the model and the colour
i'm looking into other open source shop like oscommerce and the
structure of the database is really to big for my knowledge so i cant
really understand it.
i now that i neet to divide all in table as much i can but how?
How about:

table product: id, name

table properties: product_id, property_name, property_value - maybe
even type/type_id?

table property_type: id, name

You can add endless rows/properties for a product. The type might help
to check propery values. Just remember to store everything as
strings...
Order, if you like to show properties is a specific order.

BR
S

Feb 15 '07 #2
Daniele wrote:
Hi
I want to build a shop from scratch,
You're insane. Why create the wheel from scratch? As a programmer I know
that there will always be bugs in any code, but thanks to open source
there are 100,000 eyes looking at the code and debugging it. For most
products that you want there is already a well beaten up open source
alternative. For something as basic as a shopping cart there are at
least three alternative open source projects that are out there that
provide a base from which to start. Some are great (like oscmax) some
are buggy and suck (oscloaded). But a cart from scratch?

[disclaimer: note that my company uses oscmax as our base, we also hand
built a CMS system - so we are only 1/2 nuts. :-) ]
Feb 15 '07 #3
Daniele wrote:
Hi
I want to build a shop from scratch,
i'm laying down all the possible problem i can find during the way.
how can i structure the database to be able to add unlimited properties
or attribute to different kind of product ?
like if i sell a t-shirt i will hate to chose size and colour
if i sell a plate probable the model and the colour
i'm looking into other open source shop like oscommerce and the
structure of the database is really to big for my knowledge so i cant
really understand it.
i now that i neet to divide all in table as much i can but how?
thanks
D
You'd first have to construct your data model, normalize it to get to a
working and practical database setup. Honestly, judgeing from the way
your question is formulated, you are way over your head here.

I could give you an ad hoc answer for the exact examples you mention but
I am afraid it would not be a serious step towards solving the bigger
problem here.

If I'm wrong, and you are in fact comfortable with the challenge ahead,
then it's silly not to 'steal with pride' from existing
scripts/packages. There's literally hundreds if not thousands of
solutions out there, varying from incredibly simple and feature limited
to full fledged high-tech online shopping systems including credit-card
processing features, advanced logistics modules and what have you.

Not the answer you hoped for I guess, but perhaps the one you knew was
coming?

Regards,
Sh.
Feb 15 '07 #4
JM Ivler wrote:
Daniele wrote:
>Hi
I want to build a shop from scratch,

You're insane. Why create the wheel from scratch? As a programmer I know
that there will always be bugs in any code, but thanks to open source
there are 100,000 eyes looking at the code and debugging it. For most
products that you want there is already a well beaten up open source
alternative. For something as basic as a shopping cart there are at
least three alternative open source projects that are out there that
provide a base from which to start. Some are great (like oscmax) some
are buggy and suck (oscloaded). But a cart from scratch?

[disclaimer: note that my company uses oscmax as our base, we also hand
built a CMS system - so we are only 1/2 nuts. :-) ]
I'm willing to go in that direction because I need the possibility to
edit and change template in all the way i will need and many shop do not
allow me to do that
yes i can change template but oscommerce and osmax i think ( not sure )
allow to change color css ecc but not the real structure on the front
and,i'm thinking in use just the back-end and build a new front-end but
i think i will have first to understand how 100.000 people structured
the back end to build the other part.
does anyone think like me ?
or can you just advice shop that i can just use and change the front-end
in the way i want ?
thanks
Feb 15 '07 #5
Schraalhans Keukenmeester wrote:
Daniele wrote:
>Hi
I want to build a shop from scratch,
i'm laying down all the possible problem i can find during the way.
how can i structure the database to be able to add unlimited properties
or attribute to different kind of product ?
like if i sell a t-shirt i will hate to chose size and colour
if i sell a plate probable the model and the colour
i'm looking into other open source shop like oscommerce and the
structure of the database is really to big for my knowledge so i cant
really understand it.
i now that i neet to divide all in table as much i can but how?
thanks
D

You'd first have to construct your data model, normalize it to get to a
working and practical database setup. Honestly, judgeing from the way
your question is formulated, you are way over your head here.

I could give you an ad hoc answer for the exact examples you mention but
I am afraid it would not be a serious step towards solving the bigger
problem here.

If I'm wrong, and you are in fact comfortable with the challenge ahead,
then it's silly not to 'steal with pride' from existing
scripts/packages. There's literally hundreds if not thousands of
solutions out there, varying from incredibly simple and feature limited
to full fledged high-tech online shopping systems including credit-card
processing features, advanced logistics modules and what have you.

Not the answer you hoped for I guess, but perhaps the one you knew was
coming?

Regards,
Sh.
Hi
I resolve my problem on my own about the properties of the product

about the size of the project yes i agree with you is way to big but
is not the good way to learn that ?
no one born with the knowledge and we learn to walk drooping on the
floor,i want to be realistic with myself so for this before write
anything i want to lay down all the project
i want to be optimistic not an idiot
Feb 15 '07 #6
Daniele wrote:
JM Ivler wrote:
>Daniele wrote:
>>Hi
I want to build a shop from scratch,

You're insane. Why create the wheel from scratch? As a programmer I
know that there will always be bugs in any code, but thanks to open
source there are 100,000 eyes looking at the code and debugging it.
For most products that you want there is already a well beaten up open
source alternative. For something as basic as a shopping cart there
are at least three alternative open source projects that are out there
that provide a base from which to start. Some are great (like oscmax)
some are buggy and suck (oscloaded). But a cart from scratch?

[disclaimer: note that my company uses oscmax as our base, we also
hand built a CMS system - so we are only 1/2 nuts. :-) ]
I'm willing to go in that direction because I need the possibility to
edit and change template in all the way i will need and many shop do not
allow me to do that
yes i can change template but oscommerce and osmax i think ( not sure )
allow to change color css ecc but not the real structure on the front
and,i'm thinking in use just the back-end and build a new front-end but
i think i will have first to understand how 100.000 people structured
the back end to build the other part.
does anyone think like me ?
or can you just advice shop that i can just use and change the front-end
in the way i want ?
thanks
On OSCMax I have total control over the template system. I can
center-align a shop, have right/left or no infoboxes, do whatever I
want. The template system is very powerful.

BUT! as I tell my customers... "People are very used to a specific sales
experience online. You may have this great idea on how you want to
effect it, but will people feel comfortable with being in that format?
Will you lose customers?" See, the overall goal is to obtain a customer
and a final sale, not look cool (or Kewl if you so prefer). So, in a
cart you are looking for the following:

1) good indexing for google (whomever) - this is marketing
2) comfort for the buyer - it has to feel natural to transverse, search,
explore the store
3) expected simplicity in product selection - adding a product to the
cart should be one click, getting additional information should be one
click, etc.
4) cross-sell and up-sell opportunities - this is the ability to show
the customer sonething else that they might want based on what they have
already stated that they want. It's what turns a single small sale into
a larger sale.
5) simple checkout process - data should be entered only once (ie:
billing address and shipping address) with the ability to change if they
need to. The steps should be clear and concise. The process should
"flow" from page to page in a logical and clear manner.

Following these simple rules ensures that a store on-line can fulfill
all the things that it needs to do process-wise. Then it's just a matter
of loading the products and making sure that your images and details
sell the items.

Feb 15 '07 #7
Daniele wrote:
Hi
I want to build a shop from scratch,
i'm laying down all the possible problem i can find during the way.
how can i structure the database to be able to add unlimited properties
or attribute to different kind of product ?
like if i sell a t-shirt i will hate to chose size and colour
if i sell a plate probable the model and the colour
i'm looking into other open source shop like oscommerce and the
structure of the database is really to big for my knowledge so i cant
really understand it.
i now that i neet to divide all in table as much i can but how?
thanks
D
There are two answers to the database structure question.

One school of thought, to which I belong, says that your best short-term,
mid-term, and long-term solution is to build a database whose tables
reflect the actual information you are trying to store. To take this path,
you need to read up on Normalization.

If you take the route of building proper databases, you do run into a
significant problem with updates to the structures, which don't go the same
way as modifying code. This drives some people to what I can only call
half-wit schemes, such as the infamous Entity-Attribute-Value error. In
this scheme you build one table with columns Entity, Attribute, Value (and
key, but that's not part of the name). You never have to restructure
anything because you only have one table. You also have to re-invent SQL
because you've thrown that out, you kiss performance goodbye, and basically
you spend the rest of your life trying to recode everything you threw away
by using only one table.

In the end you need a tool that can help you maintain code and data
together. I have my own solution to this, mentioned in an [ANNOUNCE]
posting earlier today, as do countless other people and organizations.



--
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@(Sec )ure(Dat)a(.com )
Feb 15 '07 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
900
by: Lad | last post by:
Is there an online shop e-commerce solution available in Python? I know about some ( e.g. http://www.oscommerce.org/) but they are in php only. Thanks for reply Lad
2
2736
by: DarkElf | last post by:
MAGIA WEB DESIGN SHOP www.qesign.com/download HTML templates & PSD graphics with detailed description, screenshots, FAQ, and free technical support. Buy - Download - Use! Dating Site Design 100% editable beautiful Photoshop design with orange and blue color schemes for your dating, personals, marriage agency or matchmaking website. Online dating is an ever expanding industry!
90
5152
by: Bret Pehrson | last post by:
This message isn't spam or an advertisement or trolling. I'm considering farming some of my application development to offshore shops (I'm in the US). I have absolutely *no* experience w/ this, and therefore I'm looking for comments, suggestions, etc. on how to go about this w/o getting screwed. My current application development is primarily database-driven apps in C++/C#, so I'm looking for programmers w/ up-to-date skills.
2
2015
by: Konrad | last post by:
Hi Can you point me examples of virtual shops written in ASP.NET and C# or VB. Thanks Konrad
2
2264
by: John Dalberg | last post by:
I installed the Pet Shop 4.0 app. However everytime I try to create a new user, I get a "Please enter a more secure password" error. I tried all kinds of passwords. I looked at the membership provider for SQL Server and I don't see any settings for passwords. So why is this error hapenning? Also the link on MS's site to Pet Shop 4.0 is broken: http://search.microsoft.com/results.aspx?q=Microsoft+.NET+Pet+Shop+4&l=3&mk
52
3618
by: Steve Holden | last post by:
I've been thinking (and blogging) about python evangelism since PyCon, as a result of which I created a squidoo lens: http://www.squidoo.com/pythonlogy Imagine my surprise at discovering that this has gone up in rank (by number of views) from # 442,000 or so to #153! Clearly there's some mileage in marketing Python, and I'd like to keep the buzz going if it means more people will adopt the language.
56
4222
by: richard | last post by:
So I wrote PyPI back a couple of years ago. It was just a simple cgi script and some distutils code. I needed to call it *something* and "Python Package Index" seemed like a fairly obvious name. Unfortunately, it's also quite a mouthful. A friend suggested "PyPI" as a good shorter name. He also indicated that it should be pronounced "Pippy" but that never really caught on (just a little too cutesy for most people, I suppose). ...
8
1415
by: | last post by:
I need source control to serve just one developer: me. Can someone suggest a system that would suit my needs? I am the only person writing code, and I manage the servers. Many of the SC solutions out there seem premised around the needs of a large team and coordinating their work. That's not me. Data points that might help: I'm on MSDN Universal. My environment is VS.NET 2005, multiple Windows 2003 Server boxes with replicated...
1
5194
by: DOA | last post by:
simulation of the sleeping barber problem. The given program first creates a barber thread. The barber thread calls callNext to get a customer, waits a random amount of time (to simulate the time it takes to cut hair), and then repeats the process. After the barber thread is created, the program creates customer threads at random intervals. The customer threads call enter to enter the shop and then wait for the barber to complete the haircut...
0
8786
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9331
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9257
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8203
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6052
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4567
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3278
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2744
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2192
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.