When exporting product data into XLSX, you can choose which fields to include. Some fields are optional, while others are required to ensure your products can be created, updated, and published successfully. This reference defines each field and highlights which ones are required.
Product information
- Product name: The title of the product (required).
- Category before mapping: Original category of the product before mapping.
- Brand: Brand associated with the product (required).
- Brand before mapping: Brand value before normalization.
- Publish advert: Indicates whether the advert is active and visible (required).
Product details
- Main description: Long-form description shown to customers (required).
- Specifications: Structured attributes such as dimensions or material.
- Product features: Key highlights or selling points.
Pricing
- Base price: Primary listed price of the product (required).
- On sale price: Reduced promotional price.
- Price type: Defines how price is applied (fixed, tiered, subscription).
- Sale type: Type of discount or promotion applied.
- Price unit: Unit of measure for pricing (e.g., per kg).
- Advert item tax rate: Tax rate for the product.
- Advert tax code: Tax classification code.
- Domestic shipping cost: Cost for domestic shipping.
Media
- Images: Main product images (required).
- Image alt text: Accessibility description of an image.
- Variant images: Images tied to product variants.
- Variant image alt text: Alt text for variant images.
- Custom video thumbnail: Thumbnail for product video.
- YouTube URL: Link to hosted video.
- Documents: Extra files such as manuals or guides.
Variant
- Barcode: UPC/EAN code.
- SKU: Internal stock keeping unit.
- Stock level: Inventory count for that variant (required).
- Unlimited stock?: Flag for infinite availability.
- Variant allergen contains: Allergen content.
- Variant allergen may be present: Cross-contamination advisory.
- Variant consumer medicine information: Regulatory details for medicine.
- Variant external ID: Reference ID in external systems.
- Variant created at: Timestamp when created.
- Variant directions: Usage directions.
- Variant price: Variant-specific price.
- Variant sale price: Discounted variant price.
- Variant product warnings: Warnings.
- Variant health warnings: Health advisories.
- Variant ingredients: Ingredient list.
- Variant item tax rate: Tax rate for the variant.
- Variant storage instructions: Storage requirements.
- Variant suitable for/indications: Intended uses.
- Variant tax code: Variant-specific tax classification.
- Variant shipping profile: Shipping rules for the variant.
- Variant TGA warning: Therapeutic Goods Administration compliance warning.
- Variant updated at: Last update timestamp.
- Publish variant: Whether the variant is visible.
Shipping dimensions
- Advert shipping weight: Weight of the product.
- Advert shipping weight unit: Unit of weight.
- Advert shipping width/depth/height/length: Product dimensions.
- Advert shipping dimension unit: Unit of measure for dimensions.
- Variant shipping weight: Variant-specific weight.
- Variant shipping weight unit: Variant weight unit.
- Variant shipping width/depth/height/length: Variant dimensions.
- Variant shipping dimension unit: Variant dimension unit of measure.
Others
- Resubmit for vetting: Push product back into review.
- Advert created at: Creation timestamp.
- Advert updated at: Update timestamp.
- Vetted: Whether product passed review.
- Vetting rejected at: Rejection timestamp.
- Year: Model year.
- External ID: External system identifier.
- Gender: Target gender.
- Mapped: Whether mapped to marketplace taxonomy.
- Notes: Free-text notes.
Related articles