E-Commerce(B2B2C): SKU/SPU design

[hhstore]

B2B2C:

django:

• http://awesome-django.com/#projects-e-commerce

  • 电商项目列表

• https://github.com/django-oscar/django-oscar

• https://github.com/mirumee/saleor

• https://github.com/stephenmcd/cartridge

  • https://github.com/stephenmcd/mezzanine
  • 玩具项目

[hhstore]

SKU:

• http://book.51cto.com/art/201310/414900.htm
  • <淘宝十年产品事 苏杰>
• 09．向超市学习，前后台类目拆分
• 10．旧的新概念：SPU/SKU 及其他
  • 关于淘宝/天猫, SKU 设计历史.

SPU:

[hhstore]

product表设计:

• apps/catalogue/abstract_models.py

• /django-oscar/src/oscar/apps/catalogue/abstract_models.py

• 产品表关系:

[hhstore]

saleor:

product 产品表设计:

-saleor.saleor.product.models.Product()

# 集合:
class Collection(SeoModel):
    name = models.CharField(max_length=128, unique=True)
    slug = models.SlugField(max_length=128)
    # 商品
    products = models.ManyToManyField(
        Product, blank=True, related_name='collections')
    background_image = VersatileImageField(
        upload_to='collection-backgrounds', blank=True, null=True)
    is_published = models.BooleanField(default=False)

    objects = CollectionQuerySet.as_manager()

    class Meta:
        ordering = ['pk']

# 单个商品:
class Product(SeoModel):
    product_type = models.ForeignKey(
        ProductType, related_name='products', on_delete=models.CASCADE)
    name = models.CharField(max_length=128)
    description = models.TextField()
    category = models.ForeignKey(
        Category, related_name='products', on_delete=models.CASCADE)
    price = MoneyField(
        currency=settings.DEFAULT_CURRENCY, max_digits=12,
        decimal_places=settings.DEFAULT_DECIMAL_PLACES)
    available_on = models.DateField(blank=True, null=True)
    is_published = models.BooleanField(default=True)
    attributes = HStoreField(default={}, blank=True)
    updated_at = models.DateTimeField(auto_now=True, null=True)
    is_featured = models.BooleanField(default=False)
    charge_taxes = models.BooleanField(default=True)
    tax_rate = models.CharField(
        max_length=128, default=DEFAULT_TAX_RATE_NAME, blank=True)

    objects = ProductQuerySet.as_manager()

    class Meta:
        app_label = 'product'
        permissions = ((
            'manage_products', pgettext_lazy(
                'Permission description',
                'Manage products.')),)

graphql API 设计:

• /saleor/saleor/graphql
• 实现了 graphql API.