Skip ke Konten
Odoo Menu
  • Login
  • Uji coba gratis
  • Aplikasi
    Keuangan
    • Akuntansi
    • Faktur
    • Pengeluaran
    • Spreadsheet (BI)
    • Dokumen
    • Tanda Tangan
    Sales
    • CRM
    • Sales
    • POS Toko
    • POS Restoran
    • Langganan
    • Rental
    Website
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Rantai Pasokan
    • Inventaris
    • Manufaktur
    • PLM
    • Purchase
    • Maintenance
    • Kualitas
    Sumber Daya Manusia
    • Karyawan
    • Rekrutmen
    • Cuti
    • Appraisal
    • Referensi
    • Armada
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Acara
    • Otomatisasi Marketing
    • Survei
    Layanan
    • Project
    • Timesheet
    • Layanan Lapangan
    • Meja Bantuan
    • Planning
    • Appointment
    Produktivitas
    • Diskusi
    • Approval
    • IoT
    • VoIP
    • Pengetahuan
    • WhatsApp
    Aplikasi pihak ketiga Odoo Studio Platform Odoo Cloud
  • Industri-Industri
    Retail
    • Toko Buku
    • Toko Baju
    • Toko Furnitur
    • Toko Kelontong
    • Toko Hardware
    • Toko Mainan
    Makanan & Hospitality
    • Bar dan Pub
    • Restoran
    • Fast Food
    • Rumah Tamu
    • Distributor Minuman
    • Hotel
    Real Estate
    • Agensi Real Estate
    • Firma Arsitektur
    • Konstruksi
    • Estate Management
    • Perkebunan
    • Asosiasi Pemilik Properti
    Konsultansi
    • Firma Akuntansi
    • Mitra Odoo
    • Agensi Marketing
    • Firma huku
    • Talent Acquisition
    • Audit & Sertifikasi
    Manufaktur
    • Tekstil
    • Logam
    • Perabotan
    • Makanan
    • Brewery
    • Corporate Gift
    Kesehatan & Fitness
    • Sports Club
    • Toko Kacamata
    • Fitness Center
    • Wellness Practitioners
    • Farmasi
    • Salon Rambut
    Perdagangan
    • Handyman
    • IT Hardware & Support
    • Sistem-Sistem Energi Surya
    • Pembuat Sepatu
    • Cleaning Service
    • Layanan HVAC
    Lainnya
    • Organisasi Nirlaba
    • Agen Lingkungan
    • Rental Billboard
    • Fotografi
    • Penyewaan Sepeda
    • Reseller Software
    Browse semua Industri
  • Komunitas
    Belajar
    • Tutorial-tutorial
    • Dokumentasi
    • Sertifikasi
    • Pelatihan
    • Blog
    • Podcast
    Empower Education
    • Program Edukasi
    • Game Bisnis 'Scale Up!'
    • Kunjungi Odoo
    Dapatkan Softwarenya
    • Download
    • Bandingkan Edisi
    • Daftar Rilis
    Kolaborasi
    • Github
    • Forum
    • Acara
    • Terjemahan
    • Menjadi Partner
    • Layanan untuk Partner
    • Daftarkan perusahaan Akuntansi Anda.
    Dapatkan Layanan
    • Temukan Mitra
    • Temukan Akuntan
    • Temui penasihat
    • Layanan Implementasi
    • Referensi Pelanggan
    • Bantuan
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Dapatkan demo
  • Harga
  • Bantuan

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Akuntansi
  • Inventaris
  • PoS
  • Project
  • MRP
All apps
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Help

How to get Low Stock Notifications at stock levels other than 0

Langganan

Dapatkan notifikasi saat terdapat aktivitas pada post ini

Pertanyaan ini telah diberikan tanda
stockwarehouseodoo8
6 Replies
18325 Tampilan
Avatar
Travis Waelbroeck

In Magento, there is a module <a href='https://magegiant.com/magento-low-stock-email-notification-extension/'>Low Stock Email Notification</a> that allows you to set a low stock "threshold" for each product individually.


For example, I can set one product to be considered low when it's under 100, whereas another I want to be notified if it falls under 5,000. Daily, weekly, or monthly (set in configuration settings), I get an email notifying me of all products that are low and how many are in stock.


Is there anything existing in Odoo to mimic this feature? Or is there anything similar that we can use as a basis of developing this feature?

0
Avatar
Buang
Dr Obx

In my case, I developed a module which check stock levels every time product is taken, if stock level is less than value set for each product individually sending email with current stock and product name. You can set stock level manually or based on last 6 month sale.

Travis Waelbroeck
Penulis

Is your module publicly available for review/reference?

Avatar
Travis Waelbroeck
Penulis Jawaban Terbai

I was able to develop a module on my own to accomplish this goal.

Basically, it creates a new attribute for each product and will send an email each day with any products who are active, sellable, and below their "low stock" threshold (excluding any whose threshold is below 0).

You can see the code in my GitHub repository: https://github.com/travs-w/low_stock_notify

product.py

from openerp import models, fields, api

from datetime import date

import StringIO

import base64

class Product(models.Model):

_inherit = 'product.template'

qty_low_stock_notify = fields.Integer(string='Notify for Qty Below', default=80,

help='When stock on hand falls below this number, it will be included in the low stock report. Set to -1 to exclude from the report.')

def send_low_stock_via_email(self, cr, uid, context=None):

header_label_list=["SKU", "Name", "Qty On Hand","Qty Incoming","Low Stock Qty"]

## Get email template

template_obj = self.pool.get('email.template')

template_ids = template_obj.search(cr, uid, [('name', '=', 'Low Stock Automated Report')])

template = template_obj.browse(cr, uid, template_ids)

if template:

default_body = template.body_html

custom_body = """

<table>

<th>%s</th>

<th>%s</th>

<th style="text-align:center;">%s</th>

<th style="text-align:center;">%s</th>

<th style="text-align:center;">%s</th>

""" %(header_label_list[0], header_label_list[1], header_label_list[2], header_label_list[3], header_label_list[4])

## Check for low stock products

product_obj = self.pool.get('product.product')

product_ids = product_obj.search(cr, uid, [('active', '=', True), ('sale_ok', '=', True), ('default_code', '!=', False)])

for product in product_obj.browse(cr, uid, product_ids):

product_sku = product.default_code

if not product_sku or product_sku == '':

continue

qty_available = product.qty_available

qty_incoming = product.incoming_qty

qty_low_stock_notify = product.qty_low_stock_notify

if qty_available <= qty_low_stock_notify and qty_low_stock_notify >= 0: ## set low_stock_notify = -1 to never be notified

custom_body += """

<tr style="font-size:14px;">

<td>%s</td>

<td>%s</td>

<td style="text-align:center;">%s</td>

<td style="text-align:center;">%s</td>

<td style="text-align:center;">%s</td>

</tr>

""" %(product_sku, product.name, str(qty_available), str(qty_incoming), str(qty_low_stock_notify))

custom_body += "</table>"

template.body_html = default_body + custom_body

send_email = template_obj.send_mail(cr, uid, template.id, uid, force_send=True, context=context)

template.body_html = default_body

return True

product_template.xml

<?xml version="1.0"?>

<openerp>

<data>

<record id="view_low_stock_notify_product_form" model="ir.ui.view">

<field name="name">Add Low stock notify field product form</field>

<field name="model">product.template</field>

<field name="inherit_id" ref="product.product_template_only_form_view" />

<field name="arch" type="xml">

<xpath expr="//field[@name='state']" position="before" >

<field name="qty_low_stock_notify"/>

</xpath>

</field>

</record>

</data>

</openerp>

ir_cron.xml

<?xml version="1.0" encoding="utf-8"?>

<openerp>

<data noupdate="1">

<record id="ir_cron_send_low_stock_via_email" model="ir.cron">

<field name="name">Check Low Stock and Notify</field>

<field eval="True" name="active"/>

<field name="user_id" ref="base.user_root"/>

<field name="interval_number">1</field>

<field name="interval_type">days</field>

<field name="numbercall">-1</field>

<field name="doall" eval="False"/>

<field name="model" eval="'product.template'"/>

<field name="function" eval="'send_low_stock_via_email'"/>

<field name="args" eval="'()'"/>

</record>

</data>

</openerp>


3
Avatar
Buang
Damodar D.

Hi, is it for 9.0? could you post it in community repositorie? thanks

Travis Waelbroeck
Penulis

I updated my github repository with a version for 9.0 in addition to the 8.0 version. https://github.com/travs-w/low_stock_notify

Avatar
Nilim
Jawaban Terbai

Hi,

By default this feature is not available in Odoo. You need a customized module to AVAIL this feature.

We have an module with us which might serve your purpose, as it show you current stock and also you can set notifications/warnings messages in case of diminishing Stock level.

Go through the LINK once :- https://store.webkul.com/Odoo-Website-Stock-Notify.html


Hope this helps

Cheers!!

0
Avatar
Buang
Travis Waelbroeck
Penulis

I had not seen this module before. While I see its usefulness, I'm not sure it will be useful for our goals on this task, though.

Nilim

Okhay, No issues Travis. We are one of the leading provider of Odoo customized modules and Odoo- Magento-Brdiges and many more products and services, hence in case you require any customization feel free to get in touch with us anytime. We will be glad to help you. You can get in touch with us anytime@ http://webkul.com/ticket/

Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar
Post Terkait Replies Tampilan Aktivitas
Fraccionar lotes en / Splitting Lots in Odoo 18
stock warehouse
Avatar
Avatar
Avatar
2
Agu 25
1169
Inventory - How can I see stock levels at a specific date? How can I track product movements over time? Diselesaikan
stock warehouse
Avatar
Avatar
2
Agu 25
9024
The inventory module does not assign the next storage location but the central location.
stock warehouse
Avatar
Avatar
Avatar
2
Mei 25
1637
Negative Inventory Journal Entry - "Revaluation of PM/DO/XXX" Diselesaikan
stock warehouse
Avatar
Avatar
Avatar
2
Apr 25
2745
Error in setting outgoing-shipment steps Odoo
stock warehouse
Avatar
1
Apr 25
5631
Komunitas
  • Tutorial-tutorial
  • Dokumentasi
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Terjemahan
Layanan
  • Odoo.sh Hosting
  • Bantuan
  • Peningkatan
  • Custom Development
  • Pendidikan
  • Temukan Akuntan
  • Temukan Mitra
  • Menjadi Partner
Tentang Kami
  • Perusahaan kami
  • Aset Merek
  • Hubungi kami
  • Tugas
  • Acara
  • Podcast
  • Blog
  • Pelanggan
  • Hukum • Privasi
  • Keamanan
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo adalah rangkaian aplikasi bisnis open source yang mencakup semua kebutuhan perusahaan Anda: CRM, eCommerce, akuntansi, inventaris, point of sale, manajemen project, dan seterusnya.

Mudah digunakan dan terintegrasi penuh pada saat yang sama adalah value proposition unik Odoo.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now