Le Comptoir de Steph et Jo

Ajouter produit

Nom produit

Catégorie

Fournisseur

Origine

Quantité / poids stock

Unité

Stock minimum

Vente moyenne / jour

Prix achat

Prix vente

Date DLC

Emplacement

Code-barres

Photo produit

Notes

Détail produit

📷 Rechercher photo libre de droit

Photos libres de droit provenant de Pixabay. Clique sur une photo pour l'associer au produit.

Nouvelle commande client

Civilité

Mr Mme Mlle

Nom / prénom client

Téléphone

Adresse

Code postal

Ville

Produit commandé

Prix unitaire fiche stock

Type de commande

Quantité

Unité

Prix unitaire HT

TVA %

Statut commande

Paiement

Date et heure retrait / livraison

Frais de port

Calcul commande

Total HT0,00 €

Total TTC produits0,00 €

Distance livraisonLe Thor : gratuit

Total TTC avec livraison0,00 €

Le Thor = gratuit. Autres communes : 1 € / km depuis Le Thor. Le calcul se fait automatiquement après la saisie de l’adresse.

Notes / détails commande

☁️ Synchro Supabase

L'appli fonctionne sans Supabase. Pour plusieurs appareils, colle ici ton URL et ta clé anon.

URL Supabase Clé anon publicClé OpenRouteService (calcul km livraison)Nom utilisateur sur cet appareil

SQL à copier dans Supabase

create table if not exists products (id text primary key,name text,category text,unit text,stock numeric default 0,stock_min numeric default 0,avg_sales numeric default 0,purchase_price numeric default 0,sale_price numeric default 0,supplier text,origin text,location text,barcode text,photo_data text,photo text,photo_url text,notes text,dlc_days integer,dlc_date text,created_at timestamptz default now(),created_by text,updated_at timestamptz default now(),updated_by text,deleted_at timestamptz);
alter table products add column if not exists created_at timestamptz default now();
alter table products add column if not exists created_by text;
alter table products add column if not exists updated_by text;
alter table products add column if not exists deleted_at timestamptz;
alter table products add column if not exists dlc_date text;
alter table products add column if not exists promo_percent numeric default 0;
alter table products add column if not exists promo_price numeric default 0;
alter table products add column if not exists promo_until text;
alter table products add column if not exists promo_active boolean default false;
alter table products add column if not exists photo text;
alter table products add column if not exists photo_url text;
alter table products add column if not exists photo_data text;
alter table losses add column if not exists deleted_at timestamptz;
alter table suppliers add column if not exists deleted_at timestamptz;
alter table purchase_items add column if not exists received_at timestamptz;
alter table purchase_items add column if not exists received_by text;
create table if not exists losses (id text primary key,label text,product_id text,product_name text,quantity numeric default 0,unit text,reason text,amount numeric default 0,created_by text,created_at timestamptz default now(),deleted_at timestamptz);
alter table losses add column if not exists product_id text;
alter table losses add column if not exists product_name text;
alter table losses add column if not exists quantity numeric default 0;
alter table losses add column if not exists unit text;
alter table losses add column if not exists reason text;
alter table losses add column if not exists created_by text;
create table if not exists suppliers (id text primary key,name text unique,updated_at timestamptz default now(),deleted_at timestamptz);
create table if not exists deleted_products (id text primary key,deleted_at timestamptz default now());
create table if not exists purchase_items (id text primary key,product_id text,product_name text,quantity numeric default 0,unit text,supplier text,note text,created_at timestamptz default now(),created_by text,updated_at timestamptz default now(),updated_by text,bought boolean default false,deleted_at timestamptz,received_at timestamptz,received_by text);
alter table products enable row level security; alter table losses enable row level security; alter table suppliers enable row level security; alter table deleted_products enable row level security; alter table purchase_items enable row level security;
drop policy if exists "public products" on products; drop policy if exists "public losses" on losses; drop policy if exists "public suppliers" on suppliers; drop policy if exists "public deleted_products" on deleted_products; drop policy if exists "public purchase_items" on purchase_items;

create table if not exists stock_movements (id text primary key,product_id text,product_name text,type text,quantity numeric default 0,unit text,before_stock numeric default 0,after_stock numeric default 0,reason text,created_by text,created_at timestamptz default now());
create table if not exists customer_orders (id text primary key,client text,phone text,address text,product_id text,product_name text,order_type text,quantity numeric default 0,unit text,price_ht numeric default 0,vat_rate numeric default 5.5,total_ht numeric default 0,total_ttc numeric default 0,total numeric default 0,due_datetime text,due_date text,note text,status text,created_by text,created_at timestamptz default now(),updated_at timestamptz default now(),updated_by text,deleted_at timestamptz);
alter table customer_orders add column if not exists phone text;
alter table customer_orders add column if not exists address text;
alter table customer_orders add column if not exists product_id text;
alter table customer_orders add column if not exists product_name text;
alter table customer_orders add column if not exists quantity numeric default 0;
alter table customer_orders add column if not exists unit text;
alter table customer_orders add column if not exists price_ht numeric default 0;
alter table customer_orders add column if not exists vat_rate numeric default 5.5;
alter table customer_orders add column if not exists total_ht numeric default 0;
alter table customer_orders add column if not exists total_ttc numeric default 0;
alter table customer_orders add column if not exists due_datetime text;
alter table customer_orders add column if not exists civility text;
alter table customer_orders add column if not exists street text;
alter table customer_orders add column if not exists postal_code text;
alter table customer_orders add column if not exists city text;
alter table customer_orders add column if not exists payment_status text;
alter table customer_orders add column if not exists distance_km numeric default 0;
alter table customer_orders add column if not exists delivery_fee numeric default 0;
alter table customer_orders add column if not exists grand_total_ttc numeric default 0;
alter table stock_movements enable row level security; alter table customer_orders enable row level security;
drop policy if exists "public stock_movements" on stock_movements; drop policy if exists "public customer_orders" on customer_orders;
create policy "public stock_movements" on stock_movements for all using (true) with check (true); create policy "public customer_orders" on customer_orders for all using (true) with check (true);
create policy "public products" on products for all using (true) with check (true); create policy "public losses" on losses for all using (true) with check (true); create policy "public suppliers" on suppliers for all using (true) with check (true); create policy "public deleted_products" on deleted_products for all using (true) with check (true); create policy "public purchase_items" on purchase_items for all using (true) with check (true);

create table if not exists app_history (
  id text primary key,
  table_name text,
  action text,
  item_id text,
  item_name text,
  old_value text,
  new_value text,
  user_name text,
  device_name text,
  created_at timestamptz default now()
);
alter table app_history enable row level security;
drop policy if exists "public app_history" on app_history;
create policy "public app_history" on app_history for all using (true) with check (true);

-- Colonnes de compatibilité historique V67 (anciens/nouveaux noms)
alter table app_history add column if not exists table_name text;
alter table app_history add column if not exists action text;
alter table app_history add column if not exists item_id text;
alter table app_history add column if not exists item_name text;
alter table app_history add column if not exists user_name text;
alter table app_history add column if not exists device_name text;
alter table app_history add column if not exists action_type text;
alter table app_history add column if not exists action_label text;
alter table app_history add column if not exists entity_type text;
alter table app_history add column if not exists entity_id text;
alter table app_history add column if not exists entity_name text;
alter table app_history add column if not exists details text;
alter table app_history add column if not exists created_by text;
alter table app_history add column if not exists device text;

-- Activer Supabase Realtime pour la synchro instantanée V67
alter publication supabase_realtime add table products;
alter publication supabase_realtime add table purchase_items;
alter publication supabase_realtime add table suppliers;
alter publication supabase_realtime add table losses;
alter publication supabase_realtime add table customer_orders;
alter publication supabase_realtime add table stock_movements;
alter publication supabase_realtime add table app_history;