inventory-report.rb

enterprise = Enterprise.find_by_permalink("bawbawfoodhub")
scoper = OpenFoodNetwork::ScopeVariantToHub.new(enterprise)

#producer,distributor,name,display_name,variant_unit_name,sku,units,unit_type,price,on_hand,on_demand
data = enterprise.inventory_items.visible.map do |item|
  variant = item.variant
  scoper.scope(variant) if variant
  product = variant&.product
  {
    producer: product&.supplier&.name,
    distributor: enterprise&.name,
    product_name: product&.name,
    display_name: variant&.display_name,
    variant_unit_name: product&.variant_unit_name,
    sku: variant&.sku || product&.sku,
    unit_size: product&.group_buy_unit_size,
    price: variant&.price,
    on_hand: variant&.total_on_hand,
    on_demand: variant&.on_demand,
  }
end.select { |row| row[:product_name].present? }

CSV.open("inventory.csv", "wb") do |csv|
  csv << data.first.keys
  data.each { |row| csv << row.values }
end