Manage relationship between product and stock using SKU
My e-commerce database model has these tables.
My question is how can i manage relationship between stock and product. Since a product has a color, brand, sub_category and a size, should I use another table
to store SKU for each variation and connect it with stock ? or do you suggest another approach ?
Thank you
mysql database-design erd
asked May 6 '18 at 14:01
DilshanDilshan
1
add a comment |
My e-commerce database model has these tables.
My question is how can i manage relationship between stock and product. Since a product has a color, brand, sub_category and a size, should I use another table
to store SKU for each variation and connect it with stock ? or do you suggest another approach ?
Thank you
mysql database-design erd
asked May 6 '18 at 14:01
DilshanDilshan
1
add a comment |
My e-commerce database model has these tables.
My question is how can i manage relationship between stock and product. Since a product has a color, brand, sub_category and a size, should I use another table
to store SKU for each variation and connect it with stock ? or do you suggest another approach ?
Thank you
mysql database-design erd
asked May 6 '18 at 14:01
DilshanDilshan
1
My e-commerce database model has these tables.
My question is how can i manage relationship between stock and product. Since a product has a color, brand, sub_category and a size, should I use another table
to store SKU for each variation and connect it with stock ? or do you suggest another approach ?
Thank you
mysql database-design erd
mysql database-design erd
asked May 6 '18 at 14:01
DilshanDilshan
1
asked May 6 '18 at 14:01
DilshanDilshan
1
asked May 6 '18 at 14:01
DilshanDilshan
1
asked May 6 '18 at 14:01
DilshanDilshan
1
asked May 6 '18 at 14:01
DilshanDilshan
1
1
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Answer left as a comment by sticky bit
Seems like you have a row for each product variant in product. So a foreign key referencing product.idproduct in stock should be enough. You can get the color, brand, etc. by joining the respective tables.
Or are there reasons why you don't want that?
answered 17 mins ago
Comment ConverterComment Converter
1,2471325
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f205978%2fmanage-relationship-between-product-and-stock-using-sku%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Answer left as a comment by sticky bit
Seems like you have a row for each product variant in product. So a foreign key referencing product.idproduct in stock should be enough. You can get the color, brand, etc. by joining the respective tables.
Or are there reasons why you don't want that?
answered 17 mins ago
Comment ConverterComment Converter
1,2471325
add a comment |
Answer left as a comment by sticky bit
Seems like you have a row for each product variant in product. So a foreign key referencing product.idproduct in stock should be enough. You can get the color, brand, etc. by joining the respective tables.
Or are there reasons why you don't want that?
answered 17 mins ago
Comment ConverterComment Converter
1,2471325
add a comment |
Answer left as a comment by sticky bit
Seems like you have a row for each product variant in product. So a foreign key referencing product.idproduct in stock should be enough. You can get the color, brand, etc. by joining the respective tables.
Or are there reasons why you don't want that?
answered 17 mins ago
Comment ConverterComment Converter
1,2471325
Answer left as a comment by sticky bit
Seems like you have a row for each product variant in product. So a foreign key referencing product.idproduct in stock should be enough. You can get the color, brand, etc. by joining the respective tables.
Or are there reasons why you don't want that?
answered 17 mins ago
Comment ConverterComment Converter
1,2471325
answered 17 mins ago
Comment ConverterComment Converter
1,2471325
answered 17 mins ago
Comment ConverterComment Converter
1,2471325
answered 17 mins ago
Comment ConverterComment Converter
1,2471325
1,2471325
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f205978%2fmanage-relationship-between-product-and-stock-using-sku%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
