We would like to import products listed in an excel spreadsheet into Merchello. I've not seen any topic that discusses this so I'm asking it here. To start with the import process, I observed how Merchello creates a product. I observed that the following tables are populated when a product is created:
- merchProduct
- merchProductVariant
- merchProductVariantIndex
- merchCatalogInventory
So I created an import application that inserts into those four tables. However, after the import and cheking back on the backend, there is no procuct listed. What I did then was created a new product on the UI and saw that those four tables were populated.
The question is, where does Merchello persists data? What are the things we need to be concerned with when importing products into Merchello?
Got it! The issue is that the index are not updated when doing inserts outside of Umbraco. So I have to rebuild the index for the products so that the imported products show up on the Catalog page.
I have a similar issue, what did you to update the product index, developer section -> click developer -> choose the Examine Management tab -> Merchello Product indexer -> index info & tools -> click the "rebuild index" button.
When I do the above I get the following in trace in the log.
2014-07-06 21:20:24,327 [15] ERROR Merchello.Examine.DataServices.MerchelloLogService - [Thread 8] Provider=MerchelloProductIndexer, NodeId=-1, MerchelloProductIndexSet
System.Exception: 666.000000 er ikke en gyldig værdi for Double. ---> System.FormatException: Inputstrengen var ikke i et korrekt format.
ved System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
ved System.Double.Parse(String s, NumberStyles style, IFormatProvider provider)
ved System.ComponentModel.DoubleConverter.FromString(String value, NumberFormatInfo formatInfo)
ved System.ComponentModel.BaseNumberConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
--- Slut på staksporing af indre undtagelser ---
ved System.ComponentModel.BaseNumberConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
ved System.ComponentModel.TypeConverter.ConvertFrom(Object value)
ved Examine.LuceneEngine.Providers.LuceneIndexer.TryConvert[T](String val, Object& parsedVal)
ved Examine.LuceneEngine.Providers.LuceneIndexer.AddDocument(Dictionary`2 fields, IndexWriter writer, Int32 nodeId, String type)
ved Examine.LuceneEngine.Providers.LuceneIndexer.ProcessIndexQueueItem(IndexOperation op, IndexWriter writer)
ved Examine.LuceneEngine.Providers.LuceneIndexer.ForceProcessQueueItems()
Hi Rusty, yes, I just deleted the indexes and let Umbraco rebuild it.
@Christian, the easier way (at least for me) is to go to {your_project_root}\App_Data\TEMP\ExamineIndexes\Merchello\Product\Index and delete all files in there. Then run your project and Umbraco will rebuild the index. Reindexing that way always works for me, although I'm not aware of any side-effects, if there's even any.
Guys did this spreadsheet import tool make it into the code base? I would love to use this code. I have another Merchello project underway that I will need it. Probably 1,000s of products and 100's of variants for a large segment of projects.
@von are you willing/able to share? @rusty is this already added to the repository and if so where do I start to look.
It would really help the client if we could have a field in the spreadsheet that an include a link to the primary image for the merchProduct and the same for the merchProductVariant.
@rusty I may need a recommendation for a western Canadian developer with experience in these kinds of extensions for additional support for my project.
Maybe not the answer you are looking for but I have a Test version of CMSImport Merchello providers. which allows you to import the catalog. If you are interested to test this please send an email to [email protected]
Importing products
We would like to import products listed in an excel spreadsheet into Merchello. I've not seen any topic that discusses this so I'm asking it here. To start with the import process, I observed how Merchello creates a product. I observed that the following tables are populated when a product is created:
Got it! The issue is that the index are not updated when doing inserts outside of Umbraco. So I have to rebuild the index for the products so that the imported products show up on the Catalog page.
Awesome that you figured that out Von. I am still tracking down a js error in the 1.3.0 build that is interfering with the Examine Management Console.
Did you just delete the indexes and have Umbraco rebuild?
Hi
I have a similar issue, what did you to update the product index, developer section -> click developer -> choose the Examine Management tab -> Merchello Product indexer -> index info & tools -> click the "rebuild index" button.
When I do the above I get the following in trace in the log.
2014-07-06 21:20:24,327 [15] ERROR Merchello.Examine.DataServices.MerchelloLogService - [Thread 8] Provider=MerchelloProductIndexer, NodeId=-1, MerchelloProductIndexSet System.Exception: 666.000000 er ikke en gyldig værdi for Double. ---> System.FormatException: Inputstrengen var ikke i et korrekt format. ved System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt) ved System.Double.Parse(String s, NumberStyles style, IFormatProvider provider) ved System.ComponentModel.DoubleConverter.FromString(String value, NumberFormatInfo formatInfo) ved System.ComponentModel.BaseNumberConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value) --- Slut på staksporing af indre undtagelser --- ved System.ComponentModel.BaseNumberConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value) ved System.ComponentModel.TypeConverter.ConvertFrom(Object value) ved Examine.LuceneEngine.Providers.LuceneIndexer.TryConvert[T](String val, Object& parsedVal) ved Examine.LuceneEngine.Providers.LuceneIndexer.AddDocument(Dictionary`2 fields, IndexWriter writer, Int32 nodeId, String type) ved Examine.LuceneEngine.Providers.LuceneIndexer.ProcessIndexQueueItem(IndexOperation op, IndexWriter writer) ved Examine.LuceneEngine.Providers.LuceneIndexer.ForceProcessQueueItems()Thanks, Christian
Hi Rusty, yes, I just deleted the indexes and let Umbraco rebuild it.
@Christian, the easier way (at least for me) is to go to {your_project_root}\App_Data\TEMP\ExamineIndexes\Merchello\Product\Index and delete all files in there. Then run your project and Umbraco will rebuild the index. Reindexing that way always works for me, although I'm not aware of any side-effects, if there's even any.
Von do you have a code sample you could share to show you achieved this?
We are also looking at Merchello but struggling with how to manage very large bulk imports.
@von @rusty
Guys did this spreadsheet import tool make it into the code base? I would love to use this code. I have another Merchello project underway that I will need it. Probably 1,000s of products and 100's of variants for a large segment of projects.
@von are you willing/able to share? @rusty is this already added to the repository and if so where do I start to look.
It would really help the client if we could have a field in the spreadsheet that an include a link to the primary image for the merchProduct and the same for the merchProductVariant.
@rusty I may need a recommendation for a western Canadian developer with experience in these kinds of extensions for additional support for my project.
Hi Glen,
Maybe not the answer you are looking for but I have a Test version of CMSImport Merchello providers. which allows you to import the catalog. If you are interested to test this please send an email to [email protected]
Best,
Richard
is working on a reply...