Ok then have a look here: http://djangosnippets.org/snippets/2255/
This is, of course, just a quick and dirty solution which needs to be adjusted to your excel file. I'm still working on it and will probably be adding parent/child categories and product options. Alex: Right, I never even tried csv when I read that. Also xlwt is pretty cool and straight forward. Hope that helps Sebastian On Nov 10, 9:00 pm, Christopher Wilcox <[email protected]> wrote: > Hi there, > > I would also be interested in your script which imports spreadsheet data > into Satchmo. > > Would it be possible to share your script with me as well? > > Cheers, > -Chris > > On Wed, Nov 10, 2010 at 11:53 AM, Sebastian Zwack < > > > > > > > > [email protected]> wrote: > > My answer below had a little delay because this was my first post > > which had to be verified. > > > So basically I wrote a import script like you suggested. I used xlrd > > (http://www.python-excel.org/) instead of the csv module as it handles > > unicode out of the box. The Products and Categories show up correctly > > so I guess it's working. > > > Paul, if you want me to send the script just let me know. > > > Regards > > Sebastian > > > On Nov 9, 3:11 pm, Alex Robbins <[email protected]> wrote: > > > I don't think satchmo has anything specifically for this use case. > > > However, you could use python's csv module. > > > >http://docs.python.org/library/csv.html#csv.DictReader > > > > Basically, the script would look like this: > > > > from csv import DictReader > > > from product.models import Product > > > > reader = DictReader(open('products.csv')) > > > for line in reader: > > > Product.objects.create( > > > #Setup the mapping between csv columns and satchmo product > > > attributes here > > > title=line['title'], > > > slug=line['slug_field]' > > > ... > > > ) > > > > You'd probably want some error control and stuff like that, but that > > > is the basic idea. > > > > Hope that helps, > > > Alex > > > > On Mon, Nov 8, 2010 at 1:44 AM, Paul Walsh <[email protected]> wrote: > > > > Hi, > > > > > I am a new Satchmo user (and a very very novice Django beginner) - > > > > something that wasn't clear to me: > > > > > Is there a core module or an available extension to import data via > > > > CSV? I saw the product_feeds extension module but it only seems to > > > > deal with export. > > > > > If anyone can point me in the right direction that would be great! > > > > > Thanks, > > > > > Paul. > > > > > -- > > > > You received this message because you are subscribed to the Google > > Groups "Satchmo users" group. > > > > To post to this group, send email to [email protected]. > > > > To unsubscribe from this group, send email to > > [email protected]<satchmo-users%2bunsubscr...@goog > > legroups.com> > > . > > > > For more options, visit this group athttp:// > > groups.google.com/group/satchmo-users?hl=en. > > > -- > > You received this message because you are subscribed to the Google Groups > > "Satchmo users" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<satchmo-users%2bunsubscr...@goog > > legroups.com> > > . > > For more options, visit this group at > >http://groups.google.com/group/satchmo-users?hl=en. -- You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en.
