Stevo, >From your mezzanine project directory,
./manage.py product_db --import <datafile> where datafile is a tab delimited text file. If you have customized the product table, you need to do same to product_db and make sure the column names matches with your datafile... It's best to test it inside virtualenv. On Monday, August 4, 2014 7:43:56 AM UTC-5, Stevo wrote: > > Hi Ken, I think you got that right, coz when I tried again my error was > different: > > File > "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/django/conf/__init__.py", > > line 47, in _setup > % (desc, ENVIRONMENT_VARIABLE)) > django.core.exceptions.ImproperlyConfigured: Requested setting > INSTALLED_APPS, but settings are not configured. You must either define the > environment variable DJANGO_SETTINGS_MODULE or call settings.configure() > before accessing settings. > > If you could suggest a way to set it up properly, I'd be happy to start > over again - I haven't done any real work on the site yet. At this stage, I > just need to prove it can be done (by me at least). > What is supposed to happen when you run product_db.py? I can't see where > or how it would find a .csv file to upload. > Martin suggested "playing around with Cartridge api within a shell to play > around with the product database." I don't know how to do that either. > Sorry to ask dumb questions, but Ryan said to keep trying and not give up. > Cheers and thanks! > > > On Sunday, August 3, 2014 10:20:41 PM UTC+10, Kenneth Bolton wrote: >> >> sounds like you are running the script possibly with the wrong python, >> e.g. without your virtualenv activated. >> >> ken >> >> >> On Sun, Aug 3, 2014 at 6:57 AM, Stevo <[email protected]> wrote: >> >>> Thanks Ryan! - I tried to run the script from: >>> >>> myproject/lib/python2.7/site-packages/cartridge/shop/management/commands/product_db.py >>> but got an ImportError: No module name mezzanine.conf >>> I couldn't find anything in the Cartridge docs or in Mezzanine. So is it >>> in Django documentation? >>> Please, could you give me a couple more hints and/or tell me where to go >>> for more info on what to do? >>> I passed my python MOOC so I've got plenty of time on my hands now. Haha! >>> Regards, Stevo >>> >>> >>> On Saturday, August 2, 2014 12:54:26 AM UTC+10, Ryan Sadwick wrote: >>>> >>>> I recently made a script that calls Amazon's product api and inserts >>>> into cartridge for an affiliate mash up site. I based the script off of >>>> what Stephen linked earlier and the mezz/cartirdge chart: >>>> http://cartridge.jupo.org/_images/graph.png. The most products I've >>>> inserted at one time has been around 100 since I'm hand picking the >>>> products and I loop through a list of item numbers that call the script to >>>> insert into cartridge. >>>> >>>> I didn't run into any problems, everything works - ratings, images, >>>> categories. I'd suggestion playing around with Cartridge api within a >>>> shell to play around with the product database. >>>> >>>> I'd suggest to keep at it and don't give up. >>>> >>>> Ryan >>>> >>>> On Wednesday, July 30, 2014 9:35:35 PM UTC-4, Stevo wrote: >>>>> >>>>> My biggest product feed is JSON and has 20k skus and gets updated >>>>> every 2 weeks. Other files are .csv, and only 3-4k skus, updated every 2 >>>>> months or so. >>>>> My main needs are: a) quoting tool to guide/train/remind the user on >>>>> the process and options in quoting complex product bundles b) large >>>>> number >>>>> of products with lots of attributes c) speed for about 20 users, and >>>>> d) >>>>> easy coding to suit my high-level noobosity. >>>>> All I've tried so far is doing Dr Chuck's Python Course >>>>> <https://www.coursera.org/course/pythonlearn>, the Django tute >>>>> <https://docs.djangoproject.com/en/1.7/intro/tutorial01/>, Ross >>>>> Laird's tutes >>>>> <http://www.rosslaird.com/blog/first-steps-with-mezzanine/> and >>>>> installing Mezzanine <http://mezzanine.jupo.org/> and trying out >>>>> python-docx <https://python-docx.readthedocs.org/en/latest/> (How >>>>> cool is that gizmo?) >>>>> Like Mike, I love Mezzanine "out-of-the-box" plus its >>>>> not-insurmountable learning curve. I've had a look at OpenERP, Magento, >>>>> SugarCRM and vTiger and a few others. They all do a great job, but the >>>>> complexity of all that functionality is a problem for a web-admin person >>>>> in >>>>> a team of one, like me. So maybe it's better to do a bit of coding to get >>>>> one app to do more, rather than manage three apps from the admin >>>>> interface >>>>> and try to get them to talk to each other. >>>>> My thinking is to use Mezzanine as a kind of "intranet-hub" to other >>>>> apps, like the quoting tool. Or actually use Mezzanine and Cartridge to >>>>> do >>>>> the quoting tool itself. So I was just hoping for some advice before I >>>>> get >>>>> started. So if you think it not a dumb idea, I'll try Sam's Way first and >>>>> report back when I've got some results. >>>>> Best regards Ken et al, and many thanks for the prompt advice. >>>>> Stevo. >>>>> >>>>> On Wednesday, July 30, 2014 11:43:29 PM UTC+10, Kenneth Bolton wrote: >>>>>> >>>>>> What have you tried? What form do you currently have those "at least >>>>>> 20,000 products" in? >>>>>> >>>>>> The management command Stephen wrote about still works, afaik. And >>>>>> Sam's technique is a tried-and-true method of bulk-inserting complex >>>>>> data >>>>>> into Django already in use within Cartridge. >>>>>> >>>>>> ken >>>>>> >>>>>> >>>>>> >>>>>> On Wed, Jul 30, 2014 at 8:36 AM, Stevo <[email protected]> wrote: >>>>>> >>>>>>> Is there any chance of an update on this issue? I'd really love to >>>>>>> use Mezzanine rather than Magento, but I have to load up at least >>>>>>> 20,000 >>>>>>> products. I was hoping to use Cartridge as the foundation to allow >>>>>>> users to >>>>>>> do quite complex quotes and proposals and output them using >>>>>>> python-docx. Or >>>>>>> is this out of scope for Mezzanine? Any advice appreciated. >>>>>>> Regards. >>>>>>> >>>>>>> >>>>>>> On Monday, February 25, 2013 2:26:26 PM UTC+11, Martin Hickey wrote: >>>>>>>> >>>>>>>> I am non-programmer, but I have launched a number of Mezzanine >>>>>>>> sites. I love the framework and am looking forward to learning more. >>>>>>>> >>>>>>>> I am beginning to play around with a concept that would require >>>>>>>> Cartridge. I have gone through the documentation, but I am sure that >>>>>>>> it is >>>>>>>> possible I missed it. Is there a way to bulk upload products into >>>>>>>> Cartridge. I have considered integrating something like >>>>>>>> django-feedmapper, >>>>>>>> but sure would love to avoid the time involved in a custom >>>>>>>> integration. Can >>>>>>>> you let me know if this is my best bet at this point? >>>>>>>> >>>>>>>> Thanks >>>>>>>> >>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "Mezzanine Users" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to [email protected]. >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Mezzanine Users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- You received this message because you are subscribed to the Google Groups "Mezzanine Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
