Select the search type
 
  • Site
  • Web
Search

DotNetNuke Knowledge Base

DotNetNuke Ecommerce FAQ

License Key Request

DNN Module Downloads

Smith Cart change log

Dotnetnuke Store Roadmap

DNN Support

 
Community Forum
Free Community Support

Please note - this is a Community Forum and is intended mainly as a community resource rather than an official method of contacting support but responses will be given whenever possible. For Urgent Support, refer to our Priority Support Page.
HomeHome Product Genera... Product Genera...Product User Gu...Product User Gu...Smith Cart - Sample product import spreadsheet for cart version 3.97 - 4.28Smith Cart - Sample product import spreadsheet for cart version 3.97 - 4.28
Previous
 
Next
New Post
12/19/2010 3:23 PM
 
Dave Smith
1st Level Poster


Joined: 7/28/2009
Posts: 1243

The following is the field spec for cart version 3.97-4.28. Attached is a sample import spreadsheet.

   

 

  1. CategoryName
  2. SubcategoryName
  3. Manufacturer
  4. ProductSortOrder
  5. ProductSku
  6. ProductName
  7. UnitCost
  8. QuantityOnHand
  9. Weight
  10. Summary
  11. ProductDescription
  12. Description2
  13. Description3
  14. Description4
  15. Description5
  16. ThumbImage1
  17. LargeImage1
  18. ZoomImage1
  19. LargeImage2
  20. ZoomImage2
  21. LargeImage3
  22. ZoomImage3
  23. LargeImage4
  24. ZoomImage4
  25. LargeImage5
  26. ZoomImage5
  27. VariantGroup1
  28. VariantName1
  29. VariantPriceDif1
  30. VariantWeightDif1
  31. VariantImage1
  32. VariantDisplayType1
  33. VariantGroup2
  34. VariantName2
  35. VariantPriceDif2
  36. VariantWeightDif2
  37. VariantImage2
  38. VariantDisplayType2
  39. VariantGroup3
  40. VariantName
  41. VariantPriceDif3
  42. VariantWeightDif3
  43. VariantImage3
  44. VariantDisplayType3
  45. VariantGroup4
  46. VariantName4
  47. VariantPriceDif4
  48. VariantWeightDif4
  49. VariantImage4
  50. VariantDisplayType4
  51. VariantGroup5
  52. VariantName5
  53. VariantPriceDif5
  54. VariantWeightDif5
  55. VariantImage5
  56. VariantDisplayType5
  57. VariantSku
  58. VariantQtyOnHand
   


To upload products and categories navigate to the cart admin menu and click "Import Products".

 

If your using version 3.97 you need to remove the Product Sort Order from the spreadsheet.

 

 

 

David H. Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
 Login to download attachment
New Post
1/14/2011 7:11 AM
 
Chuck Chapman
No Ranking

Joined: 11/16/2010
Posts: 18

I created this spreadsheet and none of the images are showing up even though they are in the folder.
 
New Post
1/21/2011 3:49 PM
 
Christian K
8th Level Poster

Joined: 1/20/2011
Posts: 263

I just updated the sample spreadsheet, please try this and if your still having issues please post the xls you are using and I will take a look.

Christian
 
New Post
1/24/2011 7:54 AM
 
Tim Hardin
No Ranking

Joined: 10/7/2010
Posts: 13

OK, if I might make a suggestion, I am having a hard time getting my product to add/update well, and it is somewhat frustrating that the "success" message tells me nothing. Right now, after I do an import, all it says is:

"Products Imported Sucessfully"

In reality, I know that it didn't import them correctly...

Two things would be nice:

1. The ability to match fields (think about doing an import in Excel) -- this would make the column order insignificant and upgrades would not be a bugger is the columns change.

2. More detail about what was imported, sorta like:

322 Products Imported Sucessfully

172 Products Were Updated

150 New Products Were Added

8 New Categories were Created

17 New Sub Categories were Created

5 Products were not added (see error log here)

This way we know what was actually done...

Just a thought for a future upgrade...

Thanks

Tim
 
New Post
1/24/2011 8:02 AM
 
Tim Hardin
No Ranking

Joined: 10/7/2010
Posts: 13

Sorry, two more questions...

  1. Are there prohibited characters in any of the fields (like quotation marks -- my client has categories that include inch measurements eg - 6" Barrel)
  2. Are any of the columns format specific -- I noticed that some in your original sample were formatted "Number" or "Currency" -- just curious if I need to keep those designations...

Thanks

Tim

PS -- did you mean to overwrite your extensive furniture sample data with my three minimal rows of gun barrel data in the attached sample?
 
New Post
1/24/2011 8:39 AM
 
Tim Hardin
No Ranking

Joined: 10/7/2010
Posts: 13

OK, doing some trials, it looks like the quotation marks are killing my import (they seem to be shifting a column). Can I put in a " instead?
 
New Post
1/24/2011 2:32 PM
 
Christian K
8th Level Poster

Joined: 1/20/2011
Posts: 263

Yes single quotes, double quotes, and percent signs are reserved fields in SQLServer so it would be best to remove those characters before importing your products.

Christian
 
New Post
1/25/2011 9:09 AM
 
Tim Hardin
No Ranking

Joined: 10/7/2010
Posts: 13

So, in an ideal world, clients won't use punctuation, right?

My client sells things of specific length, and that defines many of his categories. Example:

Commander - 4.25"

After trolling around a bit for info, I did a bit of trial and error and came up with a solution to keep the quoation mark. To do that, in the excel import sheet, I preceded the name of the subcategory with a single quote and it worked (It did not work when I tried to close that quote at the end):

'Commander - 4.25"

Also, it seems that the quotation marks i have in the description comes through OK.

Hope this helps some other poor soul trying to get their quotation marks to upload!

Tim
 
New Post
1/30/2011 11:30 PM
 
Dave Smith
1st Level Poster


Joined: 7/28/2009
Posts: 1243

You're right you should be able to have specials characters like the single and double quotes in the import data. I added this to the dev list and will postback when we have an eta. Thanks for reporting the issue!

David H. Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
7/5/2011 5:28 AM
 
Angus Beare
No Ranking

Joined: 7/5/2011
Posts: 16

Hi

 

I am testing import functionality because we have a very large number of products to import.

I am using the latest version of the module and I am trying the sample xls file on this thread that includes variants.

The import fails with this error:

"product import failed width"

So, you example does not work and I am stuck.

Please help.

thanks

Gus
 
New Post
7/5/2011 5:30 AM
 
Angus Beare
No Ranking

Joined: 7/5/2011
Posts: 16
we are using Smith Cart 4.36. Is there an updated spreadsheet for this version?
 
New Post
7/6/2011 12:04 AM
 
Kevin
1st Level Poster


Joined: 4/6/2011
Posts: 1993

Hi Angus,

Yes, we do have an updated import spreadsheet, you must have just missed the new Sample product import spreadsheet for Cart versions 4.30+.

Please see the following forum post:
http://www.smith-consulting.com/Forum...

Thanks

Kevin Carlson
Tech Support
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
1/8/2012 10:52 AM
 
Pierre Clouthier
No Ranking


Joined: 1/4/2011
Posts: 20
Tim Hardin wrote:

So, in an ideal world, clients won't use punctuation, right?

Hope this helps some other poor soul trying to get their quotation marks to upload!

Tim

Thank you very much for sharing this tip! All my product descriptions contain quotes, this has saved me a lot of time.

It seems the "Summary" field, which is empty in my case, copies the first character of the following field ("Description").

Shoulda stayed with CSV.
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Genera... Product Genera...Product User Gu...Product User Gu...Smith Cart - Sample product import spreadsheet for cart version 3.97 - 4.28Smith Cart - Sample product import spreadsheet for cart version 3.97 - 4.28