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("")
