When I make an import I first delete all categories and producs and then create new ones from the import file. The problem is that all categories and products gets new id's and that breaks the url and I start all over with Google index.
I never delete any categories or products once they have been added. All our import scripts checks if the category/product exists and then update/create based on that. Of course that costs some performance when importing but I can't really see a way to avoid this.
unfortunately i don't have the option to make update on products (it's a long story :)), but I am considering making my own url handling based on the product SKU, that should solve the problem and then just make updates on categories.
My case was that I had an live site with umbraco 4 and uCommerce I could not upgrade to umbraco 6. So I decidede to move the products to a clean umbraco 6 with the latest uCommerce. I have done that but then I discovered that I had an issuse with the shifting id's that whould breake the google index. Now I has auto generated some 301 code where I map the old id to the new id and tell google about the change.
url break when importing
When I make an import I first delete all categories and producs and then create new ones from the import file. The problem is that all categories and products gets new id's and that breaks the url and I start all over with Google index.
What can I do to avoid this?
Hi Kim.
I never delete any categories or products once they have been added. All our import scripts checks if the category/product exists and then update/create based on that. Of course that costs some performance when importing but I can't really see a way to avoid this.
/Michael
Hi Michael,
unfortunately i don't have the option to make update on products (it's a long story :)), but I am considering making my own url handling based on the product SKU, that should solve the problem and then just make updates on categories.
What is the reason for not using the SKU to id the product and update it (like Michael suggest) on import?
Hi Nicolaj,
My case was that I had an live site with umbraco 4 and uCommerce I could not upgrade to umbraco 6. So I decidede to move the products to a clean umbraco 6 with the latest uCommerce. I have done that but then I discovered that I had an issuse with the shifting id's that whould breake the google index. Now I has auto generated some 301 code where I map the old id to the new id and tell google about the change.
I guess you could make a small SQL script that makes a IDENTITY_INSERT and creates a basic product with the correct ID and SKU.
You could then make some sort of C# import to populate the more advanced product features.
I hope that makes sense :)
That was an good idea thanks, I will try that.
is working on a reply...