Page 1 of 1

import existing product from excel file into store.

Posted: Mon Apr 27, 2009 5:15 am
by mohit2009
My main issue is to import existing product from excel file into store....excel file have specific format and can't be changed

I checked your dataimport utility that will not works for me as i can't change Excel format...

I was checking with how the categories/products in Database are maintained...I have inserted the categories in following tables with appropriate relation
ac_Categories
ac_CategoryParents
ac_CatalogNodes

But neither products are coming nor category in store that i have configured at my local development environment

Re: import existing product from excel file into store.

Posted: Tue Apr 28, 2009 10:22 am
by mazhar
You can create a CSV file and then import it via dataport. Read following topic from WIKI about dataport
http://wiki.ablecommerce.com/index.php/ ... rt_Utility

Re: import existing product from excel file into store.

Posted: Fri May 01, 2009 12:19 am
by mohit2009
I already check the Dataport utility...As i mentioned earlier we cann't change the Excel Format...
We can't build out utility for this??

Re: import existing product from excel file into store.

Posted: Fri May 01, 2009 4:32 am
by mazhar

Re: import existing product from excel file into store.

Posted: Fri May 08, 2009 10:39 am
by mohit2009
Can you please let me know how these above URL's are useful/..??

Re: import existing product from excel file into store.

Posted: Mon May 11, 2009 4:40 am
by mazhar
Above links are related to custom import routines which may help you understand how to automate your import process with your custom code , instead of modifying database directly it would be better to make use of CommerceBuilder API to import data.