Hello,
I'm working on an e-commerce but i have a question and maybe someone in here has experience with this:
I'm working worldwide Belgium, Japan, US,... now for all the countries there are different shipping costs and also per weight.
Like for Belgium, UPS, Express Mail US Same but their are different prices how do i best fix this with different tables for prices and countries... ?
Best Regards
Kris
Countries Table
Moderator: General Moderators
- daven
- Forum Contributor
- Posts: 332
- Joined: Tue Dec 17, 2002 1:29 pm
- Location: Gaithersburg, MD
- Contact:
Ideally, something like this (yes, it is kind of excessive, but I am a stickler for DB normalization)
TABLE Country
TABLE Service // UPS, FedEx, etc
TABLE Weight // range of shipping weights. This table might be superfluous (not useful) if the various Services use vastly different weight tables
TABLE ShipCost
TABLE Country
Code: Select all
country_ID INT
country_Abbr VARCHAR
country_Name VARCHARCode: Select all
service_ID INT
service_Name VARCHARCode: Select all
weight_ID INT
weight REALCode: Select all
weight_ID INT
country_ID INT
service_ID INT
cost REAL