Store Prices in HQ not updated

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi guys!

When I change an item's price or set sales price from store manager, the "Store Prices" tab under Headquarters Manager item properties doesn't update even after running Style 401 Worksheet.

The price under the "Store Prices" tab shows zero for all items.

I'm wondering if this is a bug or it's built this way?

Please help.

Thank you,

Nelson

*This post is locked for comments

All responses (3)

Answers (0)

Chris Rayment on at

Like (0)

Report

RE: Store Prices in HQ not updated

Nelson, I'm having the same issue. The "Price" column in the "Store Prices" tab is being populated by the "Price" field in table itemdynamic instead of using the "SnapshotPrice" from the itemdynamic table. The "Price" field in the itemdynamic table is NOT the store price. I think this is a bug, but considering the end of life, I double MS will fix this.

You can fix this by running this query daily or setting up a daily job to run it.

update itemdynamic

set itemdynamic.price=itemdynamic.snapshotprice
Community Member Microsoft Employee on at

Like (0)

Report

RE: Store Prices in HQ not updated

Hi Antonijo,

I've checked those Worksheet styles (Style XX worksheets does not change HQ data) but it doesnt seem to update the HQ item properties store prices.

When I generate a Snapshot Item Price list report, the prices listed in the report reflect the correct price that is set on the Store. But when I go to the particular item property in HQ manager and view the price under the "Store Prices" Tab, it doesnt update anything.

Thanks!

Nelson
Suggested answer

Antonijo Todorovik 4,025 on at

Like (0)

Report

RE: Store Prices in HQ not updated

Hi Nelson,

Check the HQ Configuration (File / Configuration) and see if the checkboxes for different Worksheets styles are checked.

Regards, A.