I have one Excel sheet with all the products of multiple categories.
I've created an recursive import, but I need to split up the Excel sheet. Per product category (which maps to a specific document type) I need one CSV.
That's cumbersome. I can think of two work arounds
1) The ability to select the document type, based on some value in the CSV
2) The ability to use the entire CSV with multiple import definitions, but the import definitions only imports records of a certain type and skips the others.
Option 2 seems the most feasible to me, but I can't think of a way to get this done properly.
The main import are the categories, then the products are the child import of the categories, and finally the product variants are the child imports of the products.
(This is for uWebshop obviously)
(uWebshop, the best package for ecommerce with Umbraco!) ;)
Well it is possible but you need to split up the Excel sheet for each doctype and then import one category at a time. Then pick one category and create child definitions for products and variants. CMSImport will know the relation and will automatically move the products to the correct category as long as the parent id exists that shouldn't be a problem..
But the other 2 options are not possible, for the first one the reason is that the event is raised after a document is created and you can't change document types and the second is you can't define a criteria that should cancel the import. If the criteria is the document type then my solution might be better.
And how could I forgot this should be for uWebshop ;-)
One CSV to import, multiple document types
I have one Excel sheet with all the products of multiple categories.
I've created an recursive import, but I need to split up the Excel sheet. Per product category (which maps to a specific document type) I need one CSV.
That's cumbersome. I can think of two work arounds
1) The ability to select the document type, based on some value in the CSV
2) The ability to use the entire CSV with multiple import definitions, but the import definitions only imports records of a certain type and skips the others.
Option 2 seems the most feasible to me, but I can't think of a way to get this done properly.
Any thoughts on this?
Hi Gijs,
Are the product category child imports?
Thanks,
Richard
Erm, I'm not sure I follow.
The main import are the categories, then the products are the child import of the categories, and finally the product variants are the child imports of the products.
(This is for uWebshop obviously)
(uWebshop, the best package for ecommerce with Umbraco!) ;)
Well it is possible but you need to split up the Excel sheet for each doctype and then import one category at a time. Then pick one category and create child definitions for products and variants. CMSImport will know the relation and will automatically move the products to the correct category as long as the parent id exists that shouldn't be a problem..
But the other 2 options are not possible, for the first one the reason is that the event is raised after a document is created and you can't change document types and the second is you can't define a criteria that should cancel the import. If the criteria is the document type then my solution might be better.
And how could I forgot this should be for uWebshop ;-)
Hope this helps,
Richard
is working on a reply...