Getting Started - Importing Categories

Print Page | Close Window

Importing Categories

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=409
Printed Date: 20-May-2024 at 1:19pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Importing Categories

Posted By: OSG_Grady
Subject: Importing Categories
Date Posted: 25-August-2006 at 12:10pm

I get a datafeed from a distributor that I manage in a FileMaker (FM)
database. I am able to export the data from FileMaker (via excel) to
populate product cart. I have created the categories and subcategories in
PC and in FM so that they match. This works fine for the first two
category levels (see attached). In FM the CATEGORY NAME and PARENT
CATEGORY are both identified.

I am stuck on how to map the import for the third and fourth level. I
would prefer that the 3rd level be BRAND (e.g. HP, Brother, etc.) and the
4th level be the Product Name.

Suggestions woudl be greatly appreciated!

[IMG]uploaded_images/OSGGrady/2006-08-25_120936_Picture_5.gif[/
IMG]

-------------
Grady Lucas
IDG Warehouse

Replies:

Posted By: OSG_Grady
Date Posted: 25-August-2006 at 12:13pm

Navigation can be viewed at:

http://www.idgwarehouse.com

screenshot would not upload.

-------------
Grady Lucas
IDG Warehouse

Posted By: netprofits
Date Posted: 25-August-2006 at 2:38pm

If you have all of your categories and subcategories entered into Product Cart, then the import only needs the product's category and parent category. It will find the correct path back to the top level categories using that information.

The only potential problem is if your 3rd and 4th level categories are duplicated under other 2nd level categories. In that case Product Cart won't know how to match up your categories.

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

Certified ProductCart Developer

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

Posted By: OSG_Grady
Date Posted: 25-August-2006 at 3:00pm

So, it sounds like, in my FM database, I will only need to enter the
CATEGORY and the PARENT for that CATEGORY and the import script will do
the rest? I�ll give that a shot!

Thanks so much for the input.

-------------
Grady Lucas
IDG Warehouse

Posted By: netprofits
Date Posted: 25-August-2006 at 3:04pm

Yes, the key is that all of your third level categories (the parent category in the imoprt file) are unique. If not then the import won't know how to link them products to the correct category.

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

Certified ProductCart Developer

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