I been trying for weeks to find and implement a Category and subcategory export/Import from Excel to expedite the creation and mapping of hundreds of automotive elements: so far I haven't been successful.
The most promissory plugin I found is Dennis fork on codeplex
http://nopcommerce.codeplex.com/SourceControl/network/forks/noptools/contributions/changeset/e08fa13cbdab
I need help (otherwise paid) for a straightforward way to accomplish this before embarking on the task of doing it one by one manually
I'm looking forward for a solution, can somebody help please?
Thank you!
Category and subcategory export/Import from Excel
MVP
- 11324
- 100972
- 5/22/2011
- United States
For initial creation , the mapping is probably the tricky part. I assume you probably already have a products list with category names. Two options:
a) Use the fork to import/export categories. You will then have Ids assigned. Then figure a way to map those ids to the category names in your products list - e.g. maybe "join" in SQL server or Excel (lookup).
b) Modify the existing product import to take the Category Names rather than Ids. Do category name lookup in code to get the id.
a) Use the fork to import/export categories. You will then have Ids assigned. Then figure a way to map those ids to the category names in your products list - e.g. maybe "join" in SQL server or Excel (lookup).
b) Modify the existing product import to take the Category Names rather than Ids. Do category name lookup in code to get the id.
- 39
- 387
- 2/21/2012
- India
We have done lot of work in import process of categories, products, manufacturers and their mappings so we have good hands on experiance on this process.
Below are few requirement related questions.
Import process questions:
1. As you are talking about category and subcategory, so there will be mapping of subcategory with parent category.
Now comes to import functionality approach, there are basically two approach to achieve this
i) Create single spreadsheet with data 'category name', its details and parent category id etc. and then import to database but here the point is to map with parent category you should have already creaded categories in database.
ii) Create two different excel sheets, one for category import and other for parent and child category mapping.
Now come on question, with which approach would you like to go with? my suggestion, go with second one as it easier to implement, easier to maintain as you could have multiple levels of parent and child category mappings.
2. For which NOP version you want to develope this import / export process? latest one is NOP 3.30
Export process questions:
1. The export of category to xml is already available in NopCommerce, so first question is you want similar export process to export in excel file?
2. again same question, do you want to export all categories in single sheet or two different sheets, one for category information and other for parent child mapping
3. do you want exported sheet reusable for re import? show less
Below are few requirement related questions.
Import process questions:
1. As you are talking about category and subcategory, so there will be mapping of subcategory with parent category.
Now comes to import functionality approach, there are basically two approach to achieve this
i) Create single spreadsheet with data 'category name', its details and parent category id etc. and then import to database but here the point is to map with parent category you should have already creaded categories in database.
ii) Create two different excel sheets, one for category import and other for parent and child category mapping.
Now come on question, with which approach would you like to go with? my suggestion, go with second one as it easier to implement, easier to maintain as you could have multiple levels of parent and child category mappings.
2. For which NOP version you want to develope this import / export process? latest one is NOP 3.30
Export process questions:
1. The export of category to xml is already available in NopCommerce, so first question is you want similar export process to export in excel file?
2. again same question, do you want to export all categories in single sheet or two different sheets, one for category information and other for parent child mapping
3. do you want exported sheet reusable for re import? show less
- 56
- 300
- 12/4/2014
- United Kingdom
top-nop wrote:
we import from access database..products categories, so i want to know on importing categories which table are required to filled, i'll be using nop 3.4..as i have seen urlrecord table is required to be filled too..
We have done lot of work in import process of categories, products, manufacturers and their mappings so we have good hands on experiance on this process.
Below are few requirement related questions.
Import process questions:
1. As you are talking about category and subcategory, so there will be mapping of subcategory with parent category.
Now comes to import functionality approach, there are basically two approach to achieve this
i) Create single spreadsheet with data 'category name', its details and parent category id etc. and then import to database but here the point is to map with parent category you should have already creaded categories in database.
ii) Create two different excel sheets, one for category import and other for parent and child category mapping.
Now come on question, with which approach would you like to go with? my suggestion, go with second one as it easier to implement, easier to maintain as you could have multiple levels of parent and child category mappings.
2. For which NOP version you want to develope this import / export process? latest one is NOP 3.30
Export process questions:
1. The export of category to xml is already available in NopCommerce, so first question is you want similar export process to export in excel file?
2. again same question, do you want to export all categories in single sheet or two different sheets, one for category information and other for parent child mapping
3. do you want exported sheet reusable for re import? show less
Below are few requirement related questions.
Import process questions:
1. As you are talking about category and subcategory, so there will be mapping of subcategory with parent category.
Now comes to import functionality approach, there are basically two approach to achieve this
i) Create single spreadsheet with data 'category name', its details and parent category id etc. and then import to database but here the point is to map with parent category you should have already creaded categories in database.
ii) Create two different excel sheets, one for category import and other for parent and child category mapping.
Now come on question, with which approach would you like to go with? my suggestion, go with second one as it easier to implement, easier to maintain as you could have multiple levels of parent and child category mappings.
2. For which NOP version you want to develope this import / export process? latest one is NOP 3.30
Export process questions:
1. The export of category to xml is already available in NopCommerce, so first question is you want similar export process to export in excel file?
2. again same question, do you want to export all categories in single sheet or two different sheets, one for category information and other for parent child mapping
3. do you want exported sheet reusable for re import? show less
we import from access database..products categories, so i want to know on importing categories which table are required to filled, i'll be using nop 3.4..as i have seen urlrecord table is required to be filled too..
- 114
- 906
- 6/29/2009
- United States
"How do I find and edit/add "Category ID" using the administration webpage or upload an excel file with the new categories and sub categories?"I too have the above same problem.
Firstly, I'm looking to Map NopCommerce SAMPLE Excel table HEADERS to another suppliers mismatched HEADERS using excel Product list.
I guess I could import both the sample table from NOP, and the New product table list into MSaccess using my desktop, then simply join the two tables together using a simple query with NOP headers only. That would work assuming the data is clean of errors spacing and weird characters. I could filter out the bad data with query then correct it. Anyway, using a limited clean sample "How do I find and edit/add "Category ID" using the administration webpage or simply upload an excel file with the new categories and sub categories?" Cant find number 13 to edit it, or even a search in code for category.
In addition How do I upload the category names into the database first, so I then could then upload my new properly mapped table.
Using the sample NOP Database tables:
---------------------------------------------------------------
CategoryIds
13;
13;
13;
13;
Name
$100 Physical Gift Card
$25 Virtual Gift Card
$5 Virtual Gift Card
$50 Physical Gift Card
---------------------------------------------------------------
b) Modify the existing product import to take the Category Names rather than Ids. Do category name lookup in code to get the id. What am I doing wrong here.
Thanks
Mike
Firstly, I'm looking to Map NopCommerce SAMPLE Excel table HEADERS to another suppliers mismatched HEADERS using excel Product list.
I guess I could import both the sample table from NOP, and the New product table list into MSaccess using my desktop, then simply join the two tables together using a simple query with NOP headers only. That would work assuming the data is clean of errors spacing and weird characters. I could filter out the bad data with query then correct it. Anyway, using a limited clean sample "How do I find and edit/add "Category ID" using the administration webpage or simply upload an excel file with the new categories and sub categories?" Cant find number 13 to edit it, or even a search in code for category.
In addition How do I upload the category names into the database first, so I then could then upload my new properly mapped table.
Using the sample NOP Database tables:
---------------------------------------------------------------
CategoryIds
13;
13;
13;
13;
Name
$100 Physical Gift Card
$25 Virtual Gift Card
$5 Virtual Gift Card
$50 Physical Gift Card
---------------------------------------------------------------
b) Modify the existing product import to take the Category Names rather than Ids. Do category name lookup in code to get the id. What am I doing wrong here.
Thanks
Mike
MVP
- 11324
- 100972
- 5/22/2011
- United States
You can edit a specific Id by indicating it on the url - e.g. category Id "1" - put "1" at the end of the url ...
http://admin-demo.nopcommerce.com/Admin/Category/Edit/1
You can create SQL INSERT statements if you know SQL
INSERT INTO Category( ...fields...) VALUES ( ...values...)
(Get default values from an existing record)
Yes, an ASP.NET/C# developer can modify the source code of the Import to do a name lookup.
http://admin-demo.nopcommerce.com/Admin/Category/Edit/1
You can create SQL INSERT statements if you know SQL
INSERT INTO Category( ...fields...) VALUES ( ...values...)
(Get default values from an existing record)
Yes, an ASP.NET/C# developer can modify the source code of the Import to do a name lookup.