def update_products_from_es(request): """ """ products_fh = open("%s/products.csv" % UPDATE_PATH) reader = csv.reader(products_fh, delimiter=";", quotechar="'") for row in reader: try: price = float(row[7]) except: price = 0 try: product = Product.objects.get(sku=row[2]) except ObjectDoesNotExist: product = Product() product.slug = slugify(row[1]) product.sku=row[2] print "Created Product: %s" % row[2] else: print "Updated Product: %s" % product.id product.name = row[3] product.price = price product.short_description = row[6] product.description = row[5] product.meta_description = row[4] product.for_sale = int(row[15]) product.for_sale_price = row[16] product.stock_amount = row[10] product.manage_stock_amount = not int(row[9]) product.weight = row[11] product.height = row[13] product.length = row[12] product.width = row[14] product.save() return HttpResponse("")
def update_products_from_es(request): """ """ products_fh = open("%s/products.csv" % UPDATE_PATH) reader = csv.reader(products_fh, delimiter=";", quotechar="'") for row in reader: try: price = float(row[7]) except: price = 0 try: product = Product.objects.get(sku=row[2]) except ObjectDoesNotExist: product = Product() product.slug = slugify(row[1]) product.sku = row[2] print "Created Product: %s" % row[2] else: print "Updated Product: %s" % product.id product.name = row[3] product.price = price product.short_description = row[6] product.description = row[5] product.meta_description = row[4] product.for_sale = int(row[15]) product.for_sale_price = row[16] product.stock_amount = row[10] product.manage_stock_amount = not int(row[9]) product.weight = row[11] product.height = row[13] product.length = row[12] product.width = row[14] product.save() return HttpResponse("")