Publishing Products to Alvio via CSV Import

CSV format

The CSV of products must contain the following columns to be a valid CSV and every product variation needs to be a new row in the CSV file.

  1. Product ID (required)
  2. Variant ID (required)
  3. Title (Specified on the first row)(required)
  4. Body (Specified on the first row)(required)
  5. Vendor (Specified on the first row) (required)
  6. Product Type (Specified on the first row) (required)
  7. Tags (Specified on the first row)
  8. Published (Specified on the first row)
  9. Option1 Name (Specified on the first row)
  10. Option1 Value
  11. Option2 Name (Specified on the first row)
  12. Option2 Value
  13. Option3 Name (Specified on the first row)
  14. Option3 Value
  15. SKU
  16. Barcode
  17. Grams
  18. Price (required)
  19. Compare At Price
  20. Requires Shipping
  21. Taxable
  22. Image Src (Required in the first row)
  23. Image Alt Text (Specified on the first row)
  24. Weight Unit
  25. Cost per item
  26. Status (Specified on the first row)
  27. Qty

The CSV first row is not processed as it is expected to be the headers.

The CSV can have empty cells for the information that does not apply to the product.

Guides