Basic Data
product_id is the fixed match key. model, price, and quantity are editable. name is reference-only.
This workflow also supports simple sale price updates using special_price, which applies the same special price to all customer groups with no date restrictions.
Optional fields can be enabled from module settings, including category assignment, images, manufacturer, stock status, and more.
Product Content and Product SEO
These workflows are language-based and require a selected language.
Use Product Content for name and description updates in product_description.
Use Product SEO for meta fields, tags, and seo_url keyword management.
Product Options
One row represents one product option value. The sheet includes product_option_value_id so existing IDs can be updated in place.
Blank IDs create new option value rows. This preserves compatibility with third-party extensions that depend on stable product_option_value_id values.
Discount and Product Special Prices
These are row-based pricing workflows. One row equals one pricing record.
Product Discounts manages quantity-based discount rows in product_discount.
Product Special Prices manages advanced product_special rows with customer group, priority, start date, and end date.