What are the Slack Archives?
Itβs a history of our time together in the Slack Community! Thereβs a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.
Because this space is not active, you wonβt be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..
Hello together, has any of you seen this kind of behaviour? There are several prices per store for t
Hello together, has any of you seen this kind of behaviour? There are several prices per store for the same product. Is the unique check done by price_data_checksum
?
Comments
-
price_data_checksum
is only forprice_data
column.It's possible to have not unique prices in this table, because main table for default product prices is
spy_price_product_default
which has reference tospy_price_product_store
0 -
And how does
spy_price_product_default
now, which price is the default for a specific store?In that example i would have multiple prices per store and multiple stores. But only one default price for alle stores. Or am i wrong?
0 -
At the end the SQL query will be like this:
SELECT * FROM spy_price_product_store pps INNER JOIN spy_price_product_default ppd ON pps.id_price_product_store = [ppd.fk](http://ppd.fk)_price_product_store WHERE ... store, type, gross/net ... conditions
0 -
Sorry, I still donβt understand that.
The default table has the product id and the id of the default price.
There are, for example, 12 prices distributed over 3 stores, a total of 4 prices per store.
But the default price is only valid for store number 1. Itβs the exact id of that
price_product_store
row, which contains the specific store id.How can I then determine via a join which price is relevant for store 2, 3 or 4?
0 -
Shouldnβt there be a match for each store in the
spy_price_product_default
table?0 -
let me share one document to help you https://documentation.spryker.com/docs/price-per-merchant-relation-feature-overview
0 -
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 75 Spryker News
- 921 Developer Corner
- 781 Spryker Development
- 88 Spryker Dev Environment
- 362 Spryker Releases
- 3 Oryx frontend framework
- 34 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 25 Job Opportunities
- 3.2K π Slack Archives
- 116 Academy
- 5 Business Users
- 370 Docker
- 551 Slack General
- 2K Help
- 75 Knowledge Sharing
- 6 Random Stuff
- 4 Code Testing
- 32 Product & Business Questions
- 70 Spryker Safari Questions
- 50 Random