Sales stage probability not changing automatical


#1

Hello,

When I change Opportunity sales stage, probability not changing automatical like on SugarCRM


#2

Please look at your table spicebeanguidestages and if not set, set a primary key to id and execute the following SQL statement:

SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = “+00:00”;

REPLACE INTO spicebeanguidestages (id, spicebeanguide_id, sales_stage_probability, stage, secondary_stage, stage_sequence, stage_color, stage_add_data) VALUES
(‘35807c0e-2b71-4f83-a9c9-4b079e284668’, ‘a3b2a07a-dd8e-4578-b567-140f4ecf2f31’, 85, ‘Negotiation’, NULL, 4, NULL, ‘{“probability”: 85}’),
(‘213ae43d-4501-4356-8728-d35a1ab3be2b’, ‘a3b2a07a-dd8e-4578-b567-140f4ecf2f31’, 60, ‘Proposal’, NULL, 3, NULL, ‘{“probability”: 60}’),
(‘50d2480b-b961-4800-9a2d-8aa1d422b05e’, ‘a3b2a07a-dd8e-4578-b567-140f4ecf2f31’, 45, ‘Proposition’, NULL, 2, NULL, ‘{“probability”: 45}’),
(‘1308628e-bca6-49b8-ad60-5167149716b9’, ‘a3b2a07a-dd8e-4578-b567-140f4ecf2f31’, 25, ‘Analysis’, NULL, 1, NULL, ‘{“probability”: 25}’),
(‘383f8d0e-ade0-4fe7-a66f-3a5c9235596e’, ‘a3b2a07a-dd8e-4578-b567-140f4ecf2f31’, 10, ‘Qualification’, NULL, 0, NULL, ‘{“probability”: 10}’),
(‘96acb7aa-d1b9-47ef-b109-168275b5b4cf’, ‘a3b2a07a-dd8e-4578-b567-140f4ecf2f31’, 100, ‘Closed’, ‘Won’, 5, NULL, ‘{“probability”: 100}’),
(‘7348c94b-94a2-4a95-93ea-f42776454dc2’, ‘a3b2a07a-dd8e-4578-b567-140f4ecf2f31’, 0, ‘Closed’, ‘Discontinued’, 7, NULL, ‘{“probability”: 0}’),
(‘8837a4eb-ae6d-4d1b-89a4-32daba0ae155’, ‘a3b2a07a-dd8e-4578-b567-140f4ecf2f31’, 0, ‘Closed’, ‘Lost’, 6, NULL, ‘{“probability”: 0}’),
(‘11bf1756-90c5-494b-90cb-7f59a5adca56’, ‘e539aac5-d6b3-4c88-b858-bd8fcb357a27’, NULL, ‘Deferred’, NULL, 4, NULL, NULL),
(‘2bdd9ed5-d6a4-4722-a164-220ef88405ae’, ‘7ab5d2a9-871e-428d-928d-02674298af37’, NULL, ‘In Process’, NULL, 2, NULL, NULL),
(‘30a7993c-1cd4-40dc-a4e6-772f34d53b6b’, ‘7ab5d2a9-871e-428d-928d-02674298af37’, NULL, ‘closed’, ‘dead’, 4, NULL, NULL),
(‘30e916d7-9b5d-45a1-b44c-20f37079544c’, ‘7ab5d2a9-871e-428d-928d-02674298af37’, NULL, ‘Assigned’, NULL, 1, NULL, NULL),
(‘44fa9544-b3a8-4a19-9df8-177ec239f56c’, ‘e539aac5-d6b3-4c88-b858-bd8fcb357a27’, NULL, ‘In Progress’, NULL, 1, NULL, NULL),
(‘646d8cde-03aa-4688-abb8-51bb74d55c2e’, ‘e539aac5-d6b3-4c88-b858-bd8fcb357a27’, NULL, ‘Completed’, NULL, 3, NULL, NULL),
(‘66e492a9-ce06-4749-b4c0-12e97cb15dbf’, ‘e539aac5-d6b3-4c88-b858-bd8fcb357a27’, NULL, ‘Pending Input’, NULL, 2, NULL, NULL),
(‘96a8f932-d158-4e8d-8bfe-b1d436d4f855’, ‘7ab5d2a9-871e-428d-928d-02674298af37’, NULL, ‘New’, NULL, 0, NULL, NULL),
(‘e3f7f97f-eb75-4c8d-89e5-58d0240fb2e9’, ‘7ab5d2a9-871e-428d-928d-02674298af37’, NULL, ‘closed’, ‘converted’, 3, NULL, NULL),
(‘f2bd43b5-d671-415e-a992-02c48c8fa1e9’, ‘e539aac5-d6b3-4c88-b858-bd8fcb357a27’, NULL, ‘Not Started’, NULL, 0, NULL, NULL),
(‘f93f179c-3fd9-489f-af13-c747ea4d8bb1’, ‘7ab5d2a9-871e-428d-928d-02674298af37’, NULL, ‘Recycled’, NULL, 5, NULL, NULL);


#3

I don’t know how to do this in phpMyAdmin

Can you please explain what steps I need to do


#4

To set the primary key to id, execute the following statement:

ALTER TABLE spicebeanguidestages ADD PRIMARY KEY(id);

After that, just execute the query I posted above and reload your the detail site.