/    Sign up×
Community /Pin to ProfileBookmark

I’m sure there must be a simple way to …

Copy linkTweet thisAlerts:
Jun 15.2007

I’m sure there must be a simple way to do this but I can’t figure out how!
We don’t sell our products online but we do give pricing info on the web site.
So … I’d like to have our product ID #, and our price appear for various items.
We have an extensive Quickbooks item listing and ideally I’d like to be able to link our product ID# and sales price from that. However, I know that’s not something that can be done directly.
Going onto each web page and updating prices accurately also gets very time-consuming.
I’m currently using Frontpage but getting ready to update to Expression Web, which looks like it makes extensive use of asp. Is there a simple way to have a database (which would have product ID, description, sales price, etc.) exported to some external program from Quickbooks, which would update to the web site?

Am I asking for too much? If anyone could point me in the direction of where to start looking and how hard this would be to do, I’d be grateful!

to post a comment
Full-stack Developer

4 Comments(s) ↴

Copy linkTweet thisAlerts:
@ray326Jun 16.2007 — I'd guess you'll have to export the product info from Quickbooks in some standard flat file format like CSV, TSV, fixed field or XML then import that into a database table. Of course you have to have an instance of the database server accessible to your web/app server.
Copy linkTweet thisAlerts:
@Tweak4Jun 19.2007 — Given that Expression is an MS product, it would probably integrate the most easily with an SQL database (though my company's website is all in C# .Net, and we use DB2 on the back end). As long as there is some way within Quickbooks to export your data and get into a database, retrieving it on the web side should be pretty easy. Just make sure you know something about databases and SQL/queries before you begin, or you're probably in for a lot of frustration later on.
Copy linkTweet thisAlerts:
@LeeUJun 19.2007 — You might look at NetObjects Fusion. When I reviewed it a few years ago they had an importing tool. It might be what you need, though not sure.
Copy linkTweet thisAlerts:
@ray326Jun 20.2007 — The big problem will be the export I'm afraid.
×

Success!

Help @andy2007 spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.2,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,
)...