I've been out of the Merchello game for a while but I'm excited to be back and see all the progress that has been made :))
I'm currently working on an existing custom built ecommerce solution that I think would benefit from a migration to Merchello and so I want to get a rough idea of the migration process.
Products and Variants are currently Umbraco nodes whereas Orders, Baskets, Addresses have their own custom tables so I don't envisage too much of a problem.
How would you recommend performing the migration, via code or SQL, any pitfalls to be aware of?
I don't think it will be too much of a job to get the products migrated if you use the product service - it really depends on the number of products and the complexity of the set e.g. options, variants, inventory ...
There's only about 260 products in the system, I don't even think there would be a problem if those had to be re-created manually.
My concern is around the migration of orders, does Merchello maintain a relationship between orders and the products that were part of the order? So before migrating orders would I have to migrate the products that were ordered so as to satisfy any foreign key relationships?
Ideally I would just migrate over the orders and let the client create their products / variants themselves.
Tim, I had already found a thread that mentioned that, will be very useful for the future as the client wants to be able to bulk upload their products from a spreadsheet going forward. On a side note, I'm using your 404 handler package on this project and I've used UI-O-Matic in the past, great work man!
Migrate existing store to Merchello
Hi Rusty,
I've been out of the Merchello game for a while but I'm excited to be back and see all the progress that has been made :))
I'm currently working on an existing custom built ecommerce solution that I think would benefit from a migration to Merchello and so I want to get a rough idea of the migration process.
Products and Variants are currently Umbraco nodes whereas Orders, Baskets, Addresses have their own custom tables so I don't envisage too much of a problem.
How would you recommend performing the migration, via code or SQL, any pitfalls to be aware of?
Cheers and hope all is well, Martin
Hi Martin,
I don't think it will be too much of a job to get the products migrated if you use the product service - it really depends on the number of products and the complexity of the set e.g. options, variants, inventory ...
How many products would you say there are?
Comment author was deleted
Think I've also seen that cmsimport supports Merchello (https://our.umbraco.org/projects/developer-tools/cmsimport/)
Hi guys,
apologies for the delayed response.
There's only about 260 products in the system, I don't even think there would be a problem if those had to be re-created manually.
My concern is around the migration of orders, does Merchello maintain a relationship between orders and the products that were part of the order? So before migrating orders would I have to migrate the products that were ordered so as to satisfy any foreign key relationships?
Ideally I would just migrate over the orders and let the client create their products / variants themselves.
Tim, I had already found a thread that mentioned that, will be very useful for the future as the client wants to be able to bulk upload their products from a spreadsheet going forward. On a side note, I'm using your 404 handler package on this project and I've used UI-O-Matic in the past, great work man!
Comment author was deleted
Thanks Martin :)
I would love an answer on this Rusty!
is working on a reply...