Perhaps you could use the CMSImport package done by Richard Soeteman for this? You can read more about CMS import here - be aware that there is a limited free license and some pro licenses.
I've heart some rumours about the uConnector tool which will be the import tool for UCommerce. I think the UCommerce team will reply on this topic about that. CMSImport can't help you with this since uCommerce is using its own data structure. CMSImport will only work on Umbraco content (nodes) and members.
We wrote a custom stored procedure to import Products from external stock CSV files. The basic data transfer was straightforward but there's obviously extra stuff to write if you are using a lot of extra properties (uCommerce_ProductProperty) or variants.
Our approach was to validate the CSV data in .NET, use a SQL bulk insert to inject the new data into a staging table (we have many 1000s of rows). Then we run the import procedure that actual does the insert/update to product / property tables.
Given the uCommerce product schema, I'm sure a package can be written to allow generic import from CSVs. The column/property mappings could all be handled in a DLL config or web.config group.
As Richard mentioned we're working on a new product called uConnector. Among its tricks it does exactly what you're describing, in fact we're testing a standard operation right now which imports from CSV and Excel. We're not quite there yet, but will be ready for external testing soon.
Let me know if you're interested in joining the beta.
Mass Import of Product?
Hi,
I am new to uCommerce, but is there anyway to mass import products from a CSV file? Or is there any packages that could do this?
Thanks
Jason
Hi Jason
Perhaps you could use the CMSImport package done by Richard Soeteman for this? You can read more about CMS import here - be aware that there is a limited free license and some pro licenses.
/Jan
Hi Jason,
I've heart some rumours about the uConnector tool which will be the import tool for UCommerce. I think the UCommerce team will reply on this topic about that. CMSImport can't help you with this since uCommerce is using its own data structure. CMSImport will only work on Umbraco content (nodes) and members.
Cheers,
Richard
Hi Jason,
We wrote a custom stored procedure to import Products from external stock CSV files. The basic data transfer was straightforward but there's obviously extra stuff to write if you are using a lot of extra properties (uCommerce_ProductProperty) or variants.
Our approach was to validate the CSV data in .NET, use a SQL bulk insert to inject the new data into a staging table (we have many 1000s of rows). Then we run the import procedure that actual does the insert/update to product / property tables.
Given the uCommerce product schema, I'm sure a package can be written to allow generic import from CSVs. The column/property mappings could all be handled in a DLL config or web.config group.
Cheers
Jamers
Hi Jason,
As Richard mentioned we're working on a new product called uConnector. Among its tricks it does exactly what you're describing, in fact we're testing a standard operation right now which imports from CSV and Excel. We're not quite there yet, but will be ready for external testing soon.
Let me know if you're interested in joining the beta.
Hi James and Soren,
Thanks very much for the replies, sounds like exactly what i need and would be very useful.
Soren I would be very interested in joining the Beta.
Thanks
Jason
Shoot me an e-mail at ssl AT ucommerce DOT dk and I'll let you know how to get it.
is working on a reply...