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
import existing product from excel file into store.
Re: import existing product from excel file into store.
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
http://wiki.ablecommerce.com/index.php/ ... rt_Utility
Re: import existing product from excel file into store.
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??
We can't build out utility for this??
Re: import existing product from excel file into store.
Can you please let me know how these above URL's are useful/..??
Re: import existing product from excel file into store.
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.