Forums › Forums › OroCommerce › Can't make price lists to work
This topic contains 8 replies, has 3 voices, and was last updated by 
r.grabosz 6 years, 9 months ago.
Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.
- CreatorTopic
- July 17, 2017 at 10:15 am #31909
Hello,
I can’t get prices to display for logged in customer and also not logged in one. I see “Price not available” message under each product.
I added all products to store and I have one active price list – the default one. I configured prices for every product in a way 1 qty = X price. VPS is running 2x message queue processes via supervisor.
I changed “Offset of processing CPL prices” value to 1 and I tried also to click “Recalculate prices” in pricing list buttons. One day later nothing changes, no errors in logs, no jobs failed and no prices in front.
Any ideas? Maybe I did something wrong?
- CreatorTopic
- AuthorReplies
- July 18, 2017 at 3:59 am #31910
I configured taxes, shipping methods, payment methods, but product prices still not showing in store front (catalog/product/shopping list) :/
July 18, 2017 at 10:23 am #31911You can start the message consumer in the debug mode as follows to see what it is doing:
Shell1php app/console oro:message-queue:consume --env=prod -vvvMake sure that your other consumers are stopped.
July 18, 2017 at 11:32 am #31912I did what you said – I stopped all supervisord processes, run single consumer with –env=prod -vvv. Then I clicked Recalculate prices and heres the output:
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134[info] Pre receive Message[info] Message received[debug] Headers: array ('content_type' => 'application/json','message_id' => 'oro.596e5207ba5e63.01255346','timestamp' => 1500402183,'priority' => 2,)[debug] Properties: array ('oro.message_queue.client.topic_name' => 'oro_pricing.price_rule.build','oro.message_queue.client.processor_name' => 'oro_message_queue.client.route_message_processor','oro.message_queue.client.queue_name' => 'oro.default',)[debug] Payload: '{"priceList":2,"product":null}'[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "default"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "config"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "message_queue_job"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "batch"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "search"[info] Message processed: oro.message_queue.consumption.ack[debug] Switch to a queue oro.default[info] Pre receive Message[info] Message received[debug] Headers: array ('content_type' => 'application/json','message_id' => 'oro.596e5207bc2959.82430631','timestamp' => 1500402183,'priority' => 2,)[debug] Properties: array ('oro.message_queue.client.topic_name' => 'oro_pricing.price_lists.cpl.resolve_prices','oro.message_queue.client.processor_name' => 'oro_message_queue.client.route_message_processor','oro.message_queue.client.queue_name' => 'oro.default',)[debug] Payload: '{"priceList":2,"product":null}'[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "default"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "config"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "message_queue_job"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "batch"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "search"[info] Message processed: oro.message_queue.consumption.ack[debug] Switch to a queue oro.default[info] Pre receive Message[info] Message received[debug] Headers: array ('content_type' => 'application/json','message_id' => 'oro.596e5207ba5e63.01255346','timestamp' => 1500402183,'priority' => 2,)[debug] Properties: array ('oro.message_queue.client.topic_name' => 'oro_pricing.price_rule.build','oro.message_queue.client.processor_name' => 'oro_pricing.async.price_list_rule_processor','oro.message_queue.client.queue_name' => 'oro.default',)[debug] Payload: '{"priceList":2,"product":null}'[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "default"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "config"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "message_queue_job"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "batch"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "search"[info] Message processed: oro.message_queue.consumption.ack[debug] Switch to a queue oro.default[info] Pre receive Message[info] Message received[debug] Headers: array ('content_type' => 'application/json','message_id' => 'oro.596e5207bc2959.82430631','timestamp' => 1500402183,'priority' => 2,)[debug] Properties: array ('oro.message_queue.client.topic_name' => 'oro_pricing.price_lists.cpl.resolve_prices','oro.message_queue.client.processor_name' => 'oro_bundle_pricing.async.price_list_processor','oro.message_queue.client.queue_name' => 'oro.default',)[debug] Payload: '{"priceList":2,"product":null}'[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "default"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "config"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "message_queue_job"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "batch"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "search"[info] Message processed: oro.message_queue.consumption.ack[debug] Switch to a queue oro.default[info] Pre receive Message[info] Message received[debug] Headers: array ('content_type' => 'application/json','message_id' => 'oro.596e52081a35b0.12040909','timestamp' => 1500402184,'priority' => 2,)[debug] Properties: array ('oro.message_queue.client.topic_name' => 'oro_pricing.price_lists.cpl.resolve_prices','oro.message_queue.client.processor_name' => 'oro_message_queue.client.route_message_processor','oro.message_queue.client.queue_name' => 'oro.default',)[debug] Payload: '{"priceList":2,"product":null}'[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "default"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "config"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "message_queue_job"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "batch"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "search"[info] Message processed: oro.message_queue.consumption.ack[debug] Switch to a queue oro.default[info] Pre receive Message[info] Message received[debug] Headers: array ('content_type' => 'application/json','message_id' => 'oro.596e52081a35b0.12040909','timestamp' => 1500402184,'priority' => 2,)[debug] Properties: array ('oro.message_queue.client.topic_name' => 'oro_pricing.price_lists.cpl.resolve_prices','oro.message_queue.client.processor_name' => 'oro_bundle_pricing.async.price_list_processor','oro.message_queue.client.queue_name' => 'oro.default',)[debug] Payload: '{"priceList":2,"product":null}'[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "default"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "config"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "message_queue_job"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "batch"[debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "search"[info] Message processed: oro.message_queue.consumption.ack[debug] Switch to a queue oro.default[info] Pre receive Message[info] Idle[debug] Switch to a queue oro.default[info] Pre receive Message[info] Idle[debug] Switch to a queue oro.default[info] Pre receive Message[info] IdleAfter that three last lines are repeating.
July 19, 2017 at 12:23 am #31913Hello,
please make sure that newly created Price List is properly assigned to one of Customer, Customer Group, Website or System level.
For example to make Price List available for whole System, go to System Configuration and set:
You can read more about Pricing here https://oroinc.com/b2b-ecommerce/documentation/current/user-guide/pricing
Best Regards,
Daniel NahrebeckiJuly 19, 2017 at 2:10 am #31914Hello,
the price list is default website price list and is connected to customer. It also has all products linked, but it does not work.
July 19, 2017 at 2:43 am #31915After your new Price List is added to “Default Price Lists” for whole System you should be able to see records in database when querying:
Combined Price List relations:
PgSQL1SELECT t.* FROM public.oro_cmb_pl_to_pl t WHERE price_list_id = <<PRICE_LIST_ID>>Combined Product Prices:
PgSQL1SELECT t.* FROM public.oro_price_product_combined t WHERE product_id = <<PRODUCT_ID>>Please check these tables, and also make sure that your read guide from my previous link (i edited it) and that CONSUMER is working.
Best Regards,
Daniel NahrebeckiJuly 19, 2017 at 3:10 am #31916Consumers are working:
1234$ sudo systemctloro_message_queue:oro_message_queue_00 RUNNING pid 30268, uptime 15:31:44oro_message_queue:oro_message_queue_01 RUNNING pid 30267, uptime 15:31:44Price list is setted up as default price list and is assigned with customer.
Tables from your post are empty in database. Meanwhile i noticed something – I don’t have section Display currencies in Commerce > Catalog > Pricing.
July 19, 2017 at 3:34 am #31917I tried to run price recalculation from console and this is what happens:
12345678php app/console oro:price-lists:recalculate --all --env=prod -vvvStart processing of all Price rulesStart combining all Price Lists[Doctrine\DBAL\Exception\NotNullConstraintViolationException]An exception occurred while executing 'INSERT INTO oro_cmb_pl_to_pl (sort_order, merge_allowed, combined_price_list_id, price_list_id) VALUES (?, ?, ?, ?)' with params [0, null, 6, 2]:SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'merge_allowed' cannot be nullI’m using minimal price strategy.
EDIT: And update this column to be NULLABLE DOES THE TRICK.
Thank you for your replies.
- AuthorReplies
The forum ‘OroCommerce’ is closed to new topics and replies.