I’m trying to import new prices for a couple of thousand products – specifically to update current prices. However, the CMS import tool creates new products instead of updating existing.
I have my primary key set to ‘Name’ in the CMS import wizard, and instructed it to update not skip. I mapped according to property names etc. It all looks just as I would expect it to, but no luck getting anything to update.
I must admit I am confused by what ‘primary key’ is expected. I chose the ‘Name’ column in my spreadsheet to match to the ‘Name’ property of my product (a unique product code).
I also note that when I do an import, the CMS Import SQL table ‘CMSImportRelation’ is populated with data. Am I correct in thinking that updates can only be done on data that was previously inserted by the CMS Import tool? What is the purpose of this table? I note it was empty prior to attempting an update, not sure if that is relevant or not?
No updates occuring
Umbraco v6 CMSImport PRO 2.5.3
I’m trying to import new prices for a couple of thousand products – specifically to update current prices. However, the CMS import tool creates new products instead of updating existing.
I have my primary key set to ‘Name’ in the CMS import wizard, and instructed it to update not skip. I mapped according to property names etc. It all looks just as I would expect it to, but no luck getting anything to update.
I must admit I am confused by what ‘primary key’ is expected. I chose the ‘Name’ column in my spreadsheet to match to the ‘Name’ property of my product (a unique product code).
I also note that when I do an import, the CMS Import SQL table ‘CMSImportRelation’ is populated with data. Am I correct in thinking that updates can only be done on data that was previously inserted by the CMS Import tool? What is the purpose of this table? I note it was empty prior to attempting an update, not sure if that is relevant or not?
is working on a reply...