>> print p.sku, p.items_in_stock >> #Returned only the last line >> BWC300SS 22 >> >> I don't get it why it didn't return the full excel feed again.
When in doubt, throw more print statement in! Try putting one after this line: p = Product.objects.get(sku=update_sku) To make sure you're actually getting a product instance in each loop. Also, why are you checking items in stock on line 38, when you've already zeroed them out above? One thing that might make the code more efficient (and possibly more pythonic) is to read the worksheet data into a dictionary (sku for key, stock for value), then loop over the Products, instead of the worksheet rows, and do a get() on the data dictionary: p.items_in_stock = datadict.get(p.sku, 0) p.save() That will cut down the code, and may also help reveal whatever's going wrong with your present code... Just a thought, Eric --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
