Product Creation and Management Overview

Hello Kevin,

We have recently made updates to our system that change how products and their variants are managed. Here’s a breakdown of the changes:

Previous System:

• Each variant was treated as a separate product, with size being the only variant option.
• Products could be created with a single request.
• We used one table to store all the product data.

Updated System:

• We now require more than two requests to create a product.
• We have organized the data into multiple tables to manage different aspects of the products:
  • Product Table: Basic product information.
  • Variant Table: Information about each product variant.
  • Meta Table: Metadata for products and variants.
  • Variant Options Table: Options like size, color, etc.
  • Tags Table: Tags for products.
  • SEO Table: SEO-related information for products.

Column Naming Conventions:

• Product Table:

  • Product Id
  • Handle
  • Body Html: The HTML description of the product.
  • Title: The title of the product.
  • Gift Card
  • Type
  • Product Category
  • Status
  • Tags
  • Template Suffix
  • Vendor

• SEO Table:

  • Seo Title
  • Seo Description

• Variant Table:

  • Variant Id
  • Variant Sku
  • Variant Barcode
  • Variant Taxable
  • Variant Inventory Policy
  • Variant Inventory
  • Variant Price
  • Variant Weight
  • Variant Cost

• Variant Options Table:

  • Options are named dynamically based on the product (e.g., Option Color, Option Size).

• Meta Table:

  • Meta Style Code
  • Meta Product Care
  • Meta Age

• Meta Variant Table:

  • Meta Variant Composition
  • Meta Variant Gender
  • Meta Variant Specifications
  • Meta Variant Volume
  • Meta Variant Measurement

Export File Column Naming:

• The export file will only include columns that have values. If a column has no value, it won’t be included in the export.
• The following columns are mandatory and will always be included in the export settings: product id, handle, variant id, and style_code.

Settings:

• To export specific types of data, select the corresponding category from the settings:
  • Meta: For general metadata.
  • Variant Meta: For metadata specific to variants.
  • Variant Options: For product options like color and size.

We hope this information helps you understand how our system works. Please save this document for future reference.

If you have any questions or need further assistance, feel free to reach out.

Best regards,

Apurba