Copied to clipboard

Flag this post as spam?

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

  • Sudarshan 10 posts 30 karma points
    Jun 16, 2014 @ 13:57

    Data Sync issue: Does not sync data whose 'Deleted' flag is true in database


    We have installed same version of uCommerce Sync on 2 Umbraco + uCommerce installations. We are trying to sync uCommerce data from one site to other.

    For that we choose 'Export' option which will export all data. We then copied files and tried to import data on another installation. In the import process we are facing issues.

    When we looked into the issues, we found that: 'uCommerce Sync' is NOT generating XML for data for row in table whose 'Deleted' column value is 'True'. But while generating data for foreign table its NOT excluding rows where deleted flag id is referred.

    For example, we have table in database named 'uCommerce_DefinitionField', whose data looks like

    Master Data

    During data generation for this table tool excludes rows with 'DefinationFieldId' values 2, 4, 5 because 'Deleted' column value is 'True'.

    But now when it generates data for 'uCommerce_CategoryProperty' table who refers 'DefinationFieldId', it does NOT exclude rows where 'DefinationFieldId' values are 2, 4, 5.

    FK Data

    Because of this when tool imports data it fails.

    Can you please suggest us how to handle such situation?

    Thank you for your help!

  • Kenn Jacobsen 133 posts 791 karma points MVP 4x c-trib
    Jun 16, 2014 @ 19:05
    Kenn Jacobsen

    Hey. I'm able to reproduce this problem now. I'll see about fixing it when I can find the time...

    Until then you should be able to work around it by skipping the import of product categories.


  • Kenn Jacobsen 133 posts 791 karma points MVP 4x c-trib
    Sep 28, 2014 @ 19:26
    Kenn Jacobsen

    Alright this has been a long time coming, sorry for the wait. It should be fixed in

Please Sign in or register to post replies

Write your reply to: