View Cart|Wish List|Login|Register | Thursday, February 09, 2012
 
 Search   ..:: Support &
    Service
  Forum
::..
 
    Minimize
www.catalooksupport.com ::: another place for CATALooK.netStore support

    Minimize
SearchForum Home
     
  DotNetNuke  CATALooK.netStore  Product Import ...
 Product Import and Export
 
 5/8/2010 9:14:10 AM
lalkumarlal
2 posts


Product Import and Export
I am using a Catalook module in a DNN site .
My Client requirements are

1) He should be able to import and export the products from and to EXCEL
2) He will give the exported excel sheet to data entry person so that he / she can add new data or Update the existing data or remove from the excel sheet .
3) Then this modified excel sheet is imported in the catalook store module to view the changes .

Overall Client want to manage the product from excel sheet that could be imported and exported.

How I should achieve the above task ?

Please help me ASAP..

 5/11/2010 1:21:24 PM
GRL570810
146 posts
www.epicservices.com.au
5th


Re: Product Import and Export
Yes, product creation and update can be achieved via spreadsheets although deletion of products is not supported you will have to mark them 'not published' instead. Read the manual.section 'Data Import'  around pp 283 et seq. in the latest version.

www.epicservices.com.au DNN websites - CATALooK specialists
 5/24/2010 1:24:44 PM
lalkumarlal
2 posts


Re: Product Import and Export
Thanks for your reply but
I have read the document and according to it
"To re-import data from product data export of module CAT_Products you must manually change the table, node or sheet name to 'items'"

I have done this and got the excel file from CAT_Products section

I have then uploaded this file (after changing the price of items ) in "Data Import " of  "CAT_StoreSettings "

I am getting message

"The following error occurred: External table is not in the expected format."

Can you tell me once i got the excel of current items i have changed some price and then where i should upload them, to update the data

Thank you for the help
  DotNetNuke  CATALooK.netStore  Product Import ...

    Minimize
www.excommerce.com ::: eXcommerce are a dedicated reseller of Catalook. If you want the features of catalook without the hassle of setup and maintenance and want some extra support options please check our services.
      

References / Live Stores | Forum | Trial Downloads | Resource Directory | Release History | Support Requests | Referral Program | Contact
CATALooK |  Terms Of Use |  Privacy Statement
Copyright 2002-2010 CATALooK