Auto Update Prices From Master List
up vote
-1
down vote
favorite
I run a fairly basic website for the company I work for and up till now we've been content to use a PDF price list available for download from our website however some of our customers struggle to use it or even find it.
Taking this into account we would like to put the prices of products on each product page. This represents a lot of work to keep up to date as we have a lot of product pages, I don't mind setting this up initially but as prices increase, fluctuate or change I would prefer to only be updating the one page/file/database which the product pages then pull their prices from.
I have searched and searched for a way to do this but to no avail, hopefully asking directly myself will turn up a result!
Is is possible to have one central price list database that all the product pages pull their prices from? If so, what is the best way to go about this? Are there any common examples available for reference?
Thank you for your help in advance.
A
javascript php html database-design
add a comment |
up vote
-1
down vote
favorite
I run a fairly basic website for the company I work for and up till now we've been content to use a PDF price list available for download from our website however some of our customers struggle to use it or even find it.
Taking this into account we would like to put the prices of products on each product page. This represents a lot of work to keep up to date as we have a lot of product pages, I don't mind setting this up initially but as prices increase, fluctuate or change I would prefer to only be updating the one page/file/database which the product pages then pull their prices from.
I have searched and searched for a way to do this but to no avail, hopefully asking directly myself will turn up a result!
Is is possible to have one central price list database that all the product pages pull their prices from? If so, what is the best way to go about this? Are there any common examples available for reference?
Thank you for your help in advance.
A
javascript php html database-design
Use a database (I recommend using MySQL or PDO) to store everything : each product, with price, picture, description, and so on...
– Jean-Marc Zimmer
Nov 9 at 13:10
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I run a fairly basic website for the company I work for and up till now we've been content to use a PDF price list available for download from our website however some of our customers struggle to use it or even find it.
Taking this into account we would like to put the prices of products on each product page. This represents a lot of work to keep up to date as we have a lot of product pages, I don't mind setting this up initially but as prices increase, fluctuate or change I would prefer to only be updating the one page/file/database which the product pages then pull their prices from.
I have searched and searched for a way to do this but to no avail, hopefully asking directly myself will turn up a result!
Is is possible to have one central price list database that all the product pages pull their prices from? If so, what is the best way to go about this? Are there any common examples available for reference?
Thank you for your help in advance.
A
javascript php html database-design
I run a fairly basic website for the company I work for and up till now we've been content to use a PDF price list available for download from our website however some of our customers struggle to use it or even find it.
Taking this into account we would like to put the prices of products on each product page. This represents a lot of work to keep up to date as we have a lot of product pages, I don't mind setting this up initially but as prices increase, fluctuate or change I would prefer to only be updating the one page/file/database which the product pages then pull their prices from.
I have searched and searched for a way to do this but to no avail, hopefully asking directly myself will turn up a result!
Is is possible to have one central price list database that all the product pages pull their prices from? If so, what is the best way to go about this? Are there any common examples available for reference?
Thank you for your help in advance.
A
javascript php html database-design
javascript php html database-design
asked Nov 9 at 13:04
Alex
1
1
Use a database (I recommend using MySQL or PDO) to store everything : each product, with price, picture, description, and so on...
– Jean-Marc Zimmer
Nov 9 at 13:10
add a comment |
Use a database (I recommend using MySQL or PDO) to store everything : each product, with price, picture, description, and so on...
– Jean-Marc Zimmer
Nov 9 at 13:10
Use a database (I recommend using MySQL or PDO) to store everything : each product, with price, picture, description, and so on...
– Jean-Marc Zimmer
Nov 9 at 13:10
Use a database (I recommend using MySQL or PDO) to store everything : each product, with price, picture, description, and so on...
– Jean-Marc Zimmer
Nov 9 at 13:10
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
Alex,
It would be helpful to know more about how your website is currently structured and what technologies you are currently using.
If I were starting from scratch, I would make a template product page with javascript that makes an XMLHTTPRequest
to an api on the backend (php is the most common, nodejs is also great). This backend api will make the calls to your database and return the values to the client in a JSON document where the js renders the page.
If you want to do server-side rendering, you once again have a template product page (PHP is the most common). When the page is called, PHP then queries the database and puts together the HTML, then ships it to the client.
NEVER allow the client to interact with the database directly!
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f53226265%2fauto-update-prices-from-master-list%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
up vote
0
down vote
Alex,
It would be helpful to know more about how your website is currently structured and what technologies you are currently using.
If I were starting from scratch, I would make a template product page with javascript that makes an XMLHTTPRequest
to an api on the backend (php is the most common, nodejs is also great). This backend api will make the calls to your database and return the values to the client in a JSON document where the js renders the page.
If you want to do server-side rendering, you once again have a template product page (PHP is the most common). When the page is called, PHP then queries the database and puts together the HTML, then ships it to the client.
NEVER allow the client to interact with the database directly!
add a comment |
up vote
0
down vote
Alex,
It would be helpful to know more about how your website is currently structured and what technologies you are currently using.
If I were starting from scratch, I would make a template product page with javascript that makes an XMLHTTPRequest
to an api on the backend (php is the most common, nodejs is also great). This backend api will make the calls to your database and return the values to the client in a JSON document where the js renders the page.
If you want to do server-side rendering, you once again have a template product page (PHP is the most common). When the page is called, PHP then queries the database and puts together the HTML, then ships it to the client.
NEVER allow the client to interact with the database directly!
add a comment |
up vote
0
down vote
up vote
0
down vote
Alex,
It would be helpful to know more about how your website is currently structured and what technologies you are currently using.
If I were starting from scratch, I would make a template product page with javascript that makes an XMLHTTPRequest
to an api on the backend (php is the most common, nodejs is also great). This backend api will make the calls to your database and return the values to the client in a JSON document where the js renders the page.
If you want to do server-side rendering, you once again have a template product page (PHP is the most common). When the page is called, PHP then queries the database and puts together the HTML, then ships it to the client.
NEVER allow the client to interact with the database directly!
Alex,
It would be helpful to know more about how your website is currently structured and what technologies you are currently using.
If I were starting from scratch, I would make a template product page with javascript that makes an XMLHTTPRequest
to an api on the backend (php is the most common, nodejs is also great). This backend api will make the calls to your database and return the values to the client in a JSON document where the js renders the page.
If you want to do server-side rendering, you once again have a template product page (PHP is the most common). When the page is called, PHP then queries the database and puts together the HTML, then ships it to the client.
NEVER allow the client to interact with the database directly!
edited Nov 9 at 13:25
answered Nov 9 at 13:19
Gordon A.
507
507
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2fstackoverflow.com%2fquestions%2f53226265%2fauto-update-prices-from-master-list%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
Use a database (I recommend using MySQL or PDO) to store everything : each product, with price, picture, description, and so on...
– Jean-Marc Zimmer
Nov 9 at 13:10