Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • von 61 posts 123 karma points
    Jul 02, 2014 @ 06:37

    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:

    - 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?
  • von 61 posts 123 karma points
    Jul 02, 2014 @ 12:39

    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.

  • Rusty Swayne 1655 posts 4993 karma points c-trib
    Jul 04, 2014 @ 00:06
    Rusty Swayne

    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?

  • Christian Thillemann 8 posts 73 karma points c-trib
    Jul 06, 2014 @ 22:06
    Christian Thillemann


    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

  • von 61 posts 123 karma points
    Jul 22, 2014 @ 11:44

    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.

  • Matt 91 posts 237 karma points
    Sep 15, 2015 @ 11:15

    So I created an import application that inserts into those four tables.

    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.

  • Glen Peters 24 posts 115 karma points
    Dec 07, 2016 @ 22:19
    Glen Peters

    @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.

  • Richard Soeteman 3990 posts 12598 karma points MVP
    Dec 09, 2016 @ 07:48
    Richard Soeteman

    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]



Please Sign in or register to post replies

Write your reply to: