how to upload multiple images and product by excel file in nopcommerce
I've Integrated an Excel Bulk File Upload due west/ Pictures (images)
- 135
- 1024
- 6/11/2010
- Ireland
nzmike wrote:
Glenn,
Thank you for your post on my thread regarding importing majority items - haven't tried your code still but volition do and then based on the answers to my Q's below (if y'all have a minute to respond).
Regarding products and variants and your code - all my items are i-offs (I sell "pre-loved" DVD'southward, books, CD's and LP's) so I *almost never* have more than than one of anything.... do I still demand a product and a product variant or are they one and the same anyhow (i.e: the product variant is the verbal same detail as the product in the tables)?
I'chiliad very new to nopCommerce and then deplorable if I'm not getting the gist just essentially I want to import from a file based on the existing nop import template forth with actress columns for image name (I only demand ane), category ID (I will add together categories into nop as I only accept a few) and item template ID (which I think would always be 5 for me as I take no variants) - is this essentially what your importer does or would I accept to further edit your code to enable this?
Thank you, I'm certain nosotros all capeesh the hard work you've put in to go this running!
Mike
Mike,
This is not actually my script, it is hrdfsique'southward, I just refered to it. Maybe he tin reply your questions.
- 8
- fifty
- 9/23/2010
- Australia
Oh sorry - I idea you were *both* Glenn'due south!
I'm working now to add code to hardfsique's solution to import a category ID cavalcade as well... for my purposes they will be categories already in the DB (since I don't need that many) so when I've got information technology working I can post my version if people are interested....
- 135
- 1024
- half-dozen/eleven/2010
- Ireland
Will that and so map the production to the corresponding category?
- eight
- 50
- ix/23/2010
- Commonwealth of australia
Yep, I am only adding an extra column to the spreadsheet and and then assigning the product to the category... oasis't had much adventure to work on it nevertheless but will get information technology working over the adjacent few days hopefully.
All credit to hardfsique though - am using his code to practice this pretty piece of cake addition!
- 135
- 1024
- 6/xi/2010
- Ireland
That sounds great, cheers.
And yes, all credit to hrdfsique, he has saved me so much time with this :o) I think information technology is so good that people like him are willing to put in what is obviously and then much piece of work and so to share this with others similar me. I only wish I had the skills to do the same. But hopefully my experiences so far tin also assist others...
- 11
- 75
- 8/26/2009
- Us
nzmike wrote:
Glenn,
...
Regarding products and variants and your code - all my items are 1-offs (I sell "pre-loved" DVD's, books, CD's and LP's) and so I *nearly never* have more than than one of anything.... practice I still need a production and a product variant or are they one and the same anyway (i.e: the product variant is the verbal same item as the product in the tables)?
...
Mike
Pitiful, coming late into the conversation, but I thought I might exist able to help with some clarification.
If information technology helps call up of the production as general data about the product (default picture, category and manufacturer mappings, etc). The product variant would be the more detailed information (price, weight, dimensions, inventory, etc).
In your situation say you have pre-endemic versions of "star wars" in vhs, dvd, and blueray you have options of how you could enter this into the database depending on how you want a customer view them.
1 y'all could make a production "star wars" then have a single production variant with a dropdown bill of fare(attributes) for choosing vhs, dvd, or blueray. The items would have toll adjustments based on which ane you choose.
2 you could make a production "star wars" and have three product variants...one each for vhs, dvd, and blueray. Each format of the pic would have it'southward own pricing and add-to-cart button.
___________________________________________________________
On a seperate note I was thinking multiple variants could be imported with an excel file with some programming changes. On the excel file add a column for Variant# with a default value of one. You would simply take to increment the number for subsequent variants of the aforementioned production(the rest of the product columns other than price etc staying the same). Then in the import routine when it runs across the a variant# >i it would use the last productID and add together a variant to the productvariant table. You could even alter the templateID on the chief product based on at that place being multiple variants.
- 79
- 496
- 5/31/2010
- United states
I (also as millions of others) would appreciate if y'all would share your bulk upload utility. This is the only obstacle keeping me from being an internet merchant! you run into, i have a subscription to Doba, I get a spreadsheet with with hundreds (mayhap thousands) of products with everything i need to upload into nopCommerce, however, I don't know how to do this bulk upload so that everything ends up in its advisable category and sub-category. I would like to do it on a daily footing in club to keep my prices upwardly to date.
I would appreciate your help. I'll send the spreadsheet via PM
Thanks for your help.
Robert Lobaina
world wide web.integratedbrands.biz
- 79
- 496
- 5/31/2010
- United States
nzmike wrote:
Oh sorry - I thought yous were *both* Glenn's!
I'm working now to add together code to hardfsique's solution to import a category ID cavalcade as well... for my purposes they will be categories already in the DB (since I don't need that many) and so when I've got information technology working I can post my version if people are interested....
I am very interested in having the productst end upward under their correct Category and Sub-Category...when you finish, would you mind please sharing it? I would be so grateful!!
Robert Lobaina
world wide web.integratedbrands.biz
- 8
- 50
- 9/23/2010
- Australia
I'll be working on this over the weekend folks - I wasn't planning to practice sub-categories simply thinking about it a bit more I will probably demand some sub-categories myself so will try and do this besides.
So, without making this *really* complicated can people who desire the category/sub-category characteristic tell me what they'd demand?
Just to re-iterate, what am (now) planning to do is just have 2 actress columns, one for category and one for sub-category and in that would exist the numeric ID of the category (so you lot will need to know these from the DB) and when the product is read in it simply assign that product to the category and sub-category. I will also add lawmaking to not assign the sub-category if it's not filled in.
Do you folks see the need for supporting more than i category/sub-category for a product? (e.g: a Japanese anime DVD may accept two categories ("Movies" and "DVD") and many sub-categories ("Anime", "Foreign Linguistic communication", "World Movie theatre", "One-act").... is this sort of thing that is going to be useful to people? I'm thinking in the category and subcategory columns users could just seperate the relevant categories and sub-categories past commas - this way you could have one or more than in each of the spreadsheet columns:
eg:
Category column = 1,four
Sub-category column: 6,12,14,22
You'll have to bare with me hither though - this needs to be written and tested properly and I'm very new to nop and I besides take a day job and a "life" so it may take me a little while to get it washed sorry.
Mike
- 11
- 75
- viii/26/2009
- United States
Mike,
If yous're going to do category with comma separated values, then at that place is actually no demand for category and subcategory fields. You could but put all applicable categoryID numbers in the one field(information technology doesn't really thing if they are a root category or sub-category)
Nevertheless accept questions or demand assistance?
Source: https://www.nopcommerce.com/en/boards/topic/6262/ive-integrated-an-excel-bulk-file-upload-w-pictures-images/page/3
0 Response to "how to upload multiple images and product by excel file in nopcommerce"
Post a Comment