ProductCart Shopping Cart Software Forums : Creating Product Database from existing website... https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 12:35:52 +0000 Mon, 24 Nov 2008 02:58:13 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=2177 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Creating Product Database from existing website... : Thanks again for your help Greg ...]]> https://forum.productcart.com/creating-product-database-from-existing-website_topic2177_post7494.html#7494 Author: BlackReefDesigns
Subject: 2177
Posted: 24-November-2008 at 2:58am

Thanks again for your help Greg]]> Mon, 24 Nov 2008 02:58:13 +0000 https://forum.productcart.com/creating-product-database-from-existing-website_topic2177_post7494.html#7494 <![CDATA[Creating Product Database from existing website... : Ya, Access should allow you to...]]> https://forum.productcart.com/creating-product-database-from-existing-website_topic2177_post7492.html#7492 Author: Greg Dinger
Subject: 2177
Posted: 24-November-2008 at 1:23am

Ya, Access should allow you to export the table to either format.  Copy/Paste is one way, but not the easiest.
 
The directions to do that will vary based on the version of Access you have, but that can easily be googled.
]]> Mon, 24 Nov 2008 01:23:00 +0000 https://forum.productcart.com/creating-product-database-from-existing-website_topic2177_post7492.html#7492 <![CDATA[Creating Product Database from existing website... : Greg -Thanks for the help. I...]]> https://forum.productcart.com/creating-product-database-from-existing-website_topic2177_post7491.html#7491 Author: BlackReefDesigns
Subject: 2177
Posted: 23-November-2008 at 11:37pm

Greg -

Thanks for the help.  I have an update.  The client just sent me his personal product database, however it is in a 'Microsoft Access' format.  I can only open it in Access - is there a way I can save it as a .XLS or .CSV?


EDIT: I think I can figure it out.  I am just Copying and Pasting from the Access spreadsheet into the Excel spreadsheet.  I will then save it and import it.


Edited by BlackReefDesigns - 23-November-2008 at 11:38pm]]> Sun, 23 Nov 2008 23:37:15 +0000 https://forum.productcart.com/creating-product-database-from-existing-website_topic2177_post7491.html#7491 <![CDATA[Creating Product Database from existing website... : If you can do so, I&#039;d get...]]> https://forum.productcart.com/creating-product-database-from-existing-website_topic2177_post7490.html#7490 Author: Greg Dinger
Subject: 2177
Posted: 23-November-2008 at 10:24pm

If you can do so, I'd get your hands on the login credentials to the site's current web hosting account control panel.  Poke around and see what you can find in terms of database references.
 
If Cart32 thinks they are losing one to the competition, they may have just decided to not be very helpful.  And if you are asking the client, they simply may not know enough about the underlying technology of the site to realize there's a db.
 
I realize that you state that you spoke with the Cart32 folks, but this really seems odd.
]]> Sun, 23 Nov 2008 22:24:07 +0000 https://forum.productcart.com/creating-product-database-from-existing-website_topic2177_post7490.html#7490 <![CDATA[Creating Product Database from existing website... : This article references a Access,...]]> https://forum.productcart.com/creating-product-database-from-existing-website_topic2177_post7489.html#7489 Author: Greg Dinger
Subject: 2177
Posted: 23-November-2008 at 10:12pm

This article references a Access, MSSQL or mySQL database
http://www.cart32.com/kbshow.asp?article=C008
 
Are you certain beyond doubt that the current site has NO database?  Really?
 
If you can find a database, be it mySQL, MSSQL or whatever, then the goal will be to export it to a worksheet so it can be imported using the PC import tool.


Edited by Greg Dinger - 23-November-2008 at 10:20pm]]> Sun, 23 Nov 2008 22:12:25 +0000 https://forum.productcart.com/creating-product-database-from-existing-website_topic2177_post7489.html#7489 <![CDATA[Creating Product Database from existing website... : I was wondering if you all could...]]> https://forum.productcart.com/creating-product-database-from-existing-website_topic2177_post7488.html#7488 Author: BlackReefDesigns
Subject: 2177
Posted: 23-November-2008 at 10:05pm

I was wondering if you all could help me and give me suggestions on how to build a database using an existing online store.

Basically I am building a new website for a customer using ProductCart.  Their current website setup uses Cart32.exe.  The client has over 700 products or so, and I need to create a new database with the product information.

Can you give me any recomendations on how I might be able to quickly create a database out of the 700 products? 

I contacted Cart32 to see if I could somehow export the product database to a spreadsheet.  They say the don't support that feature since all the products are added via HTML.

Do you guys have any suggestions on how I can quickly create the new Database?  What I have been doing thus far is going through his existing website and manually inputting information into an excel spreadsheet.....but it is taking forever and was wondering if there was a faster way.

Thanks
]]> Sun, 23 Nov 2008 22:05:45 +0000 https://forum.productcart.com/creating-product-database-from-existing-website_topic2177_post7488.html#7488