class Goods(models.Model):
        category = models.ForeignKey(GoodsCategory, verbose_name='xxx')
        goods_sn = models.CharField(default='', max_length=50, verbose_name='xxx')
        name = models.CharField(max_length=300, verbose_name='xxx')
        click_num = models.IntegerField(default=0, verbose_name='xxx')
        sold_num = models.IntegerField(default=0, verbose_name='xxx')

from apps.goods.models import Goods, GoodsCategory, GoodsImage

from db_tools.data.product_data import row_data

for goods_detail in row_data:
    goods = Goods()
    goods.name = goods_detail['name']
    goods.market_price = float(int(goods_detail['market_price'].replace('￥', '').replace('&', '')))
    goods.shop_price = float(int(goods_detail['sale_price'].replace('&', '').replace('$', '')))
    goods.goods_brief = goods_detail['desc'] if goods_detail['desc'] is not None else ''
    goods_goods_desc = goods_detail['goods_desc'] if goods_detail['goods_desc'] is not None else ''
    goods.goods_front_image = goods_detail['images'][0] if goods_detail['images'] is not None else ''

    category_name = goods_detail['categorys'][-1]
    category = GoodsCategory.objects.filter(name=category_name)
    if category:
        goods.category = category[0]
    goods.save()

categories = GoodsCategory.objects.filter(name=category_name)
if categories.exists():
    category = categories[0]
else:
    category = GoodsCategory.objects.create(name=category_name)
goods.category = category[0]
goods.save()