Getting Started - Product database

Print Page | Close Window

Product database

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Getting Started
Forum Description: Installing, activating, and getting started with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=192
Printed Date: 10-May-2024 at 11:14am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Product database

Posted By: vppaul
Subject: Product database
Date Posted: 05-May-2006 at 3:23pm

I have created my categories thru the control panel and added my products to one of the categories and it seems to be working fine (althought I have not connected it to my merchant account yet). I have used the (dmnXlprice.asp) Export a price list to Excel from your developer corner and it shows me my products and categories but I can't use that form to add on to and then upload.
My question is:
1 - Can I download the actual database to add on to and than upload and save on my computer?
2 - If I can not do that and have to use the sample import file to append products to my other categories is there a chance that I can screw up what I have already posted?
It has taken me forever to post what I have done so far and I would go crazy if I had to do it over.

Replies:

Posted By: ProductCart
Date Posted: 05-May-2006 at 3:47pm

We would not recommend that you make changes directly to the database, but if you do... make sure to save a backup copy in the event you need to revert. Keep in mind that the Import Wizard does include an "undo" feature that allows you to undo the last import or append.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: vppaul
Date Posted: 05-May-2006 at 4:49pm

How do I get to the database (location) and how would I open it after download? I would like to look at it and see how it is formatted although I would must likely take your advice and not make any changes.

Posted By: ProductCart
Date Posted: 05-May-2006 at 4:58pm

For security reasons, please contact mailto:support@earlyimpact - support@earlyimpact directly for this.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: vppaul
Date Posted: 05-May-2006 at 5:04pm

Another thought. I am using Dreamweaver to link to my products with the productCart Link and I need to get the product ID# after I list the product. So I need to input the products first to get the ID# before I can adjust the database, is this right? Is there anything I can do besides listing each product and then going back to get the ID# and then linking them in dreanweaver one at a time? Doing it that way will take take a very long time.

Posted By: netprofits
Date Posted: 27-May-2006 at 4:49pm

Not sure if you decided what to do with your products but we regularly import products using the Import Product Wizard and it works very well. The key is in the Product SKU. If you want to import new products, they must all have unique product SKUs so they don't conflict with existing products. You can also do an update of existing products by importing a file with matching product SKUs and the fields of data you want to change, i.e. a bulk price update.

See the "Importing an Existing Product Database" in the User's Guide for complete details on importing products.

-------------
NetProfits Internet Consulting

Certified ProductCart Developer

http://www.nicwebdesign.com" rel="nofollow - Our Site