HomeHome Product Discus... Product Discus...SmithCartSmithCartSample product upload spreadsheetSample product upload spreadsheet
Previous
 
Next
New Post
4/21/2010 10:03 AM
 

Attached is a sample xls to upload products and categories from the cart admin menu


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
 Login to download attachment
New Post
6/5/2011 7:34 AM
 

Here are SQL statements to add some things not included in the spreadsheet:

  • Set "Max Order Quantity" to -1 (unlimited)
    UPDATE Smith_Products SET MaxOrderQty=-1
  • Set the Download URL:
    UPDATE Smith_Products SET DownloadUrl='http://acme.com/Product1Download.aspx' WHERE ModelNumber='Prod1'; 
    UPDATE Smith_Products SET DownloadUrl='http://acme.com/Product2Download.aspx' WHERE ModelNumber='Prod2';
    UPDATE Smith_Products SET DownloadUrl='http://acme.com/Product3Download.aspx' WHERE ModelNumber='Prod3'; etc.
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartSample product upload spreadsheetSample product upload spreadsheet