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..

Hi again πŸ™‚ In `stores.php` we have : `storesWithSharedPersistence` `countries

UM9F81RCP
UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

Hi again πŸ™‚

In stores.php we have :
storesWithSharedPersistence
countries

can some one please help me understand how do these values affect the operation of Spryker?

thanks a lot

Comments

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    and in case I am running multi stores on one database , should I set countries to all the stores?

    Example I have DE,CH,AT using one DB
    should I set countries to ['DE','AT,'CH']?

  • Jeremy Fourna
    Jeremy Fourna Lead Product Manager Posts: 130 πŸ§‘πŸ»β€πŸš€ - Cadet

    storesWithSharedPersistence is to share stock between warehouses and databases. In our demo shop Spryker comes with 2 database
    β€’ Europe = DE and AT stores
    β€’ America = US stores
    If those 3 stores have the same warehouses to serve your customer the shared persistence will help you by making sure that the availability between stores and database for your product are synchronous.

    countries is used to defined into which countries this store can deliver. If you define for example FR and DE for a given store, then your customer can only create addresses for delivery in those 2 countries.

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    sounds good thank you very much …

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    the reason I am asking is that I have a multi store setup that does not work properly

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    I dont see products on any store except the default store

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    I am trying to debug it πŸ™‚

  • Jeremy Fourna
    Jeremy Fourna Lead Product Manager Posts: 130 πŸ§‘πŸ»β€πŸš€ - Cadet

    The store assignment for a product is done via this CSV file if you used data import https://github.com/spryker-shop/b2c-demo-shop/blob/master/data/import/icecat_biz_data/product_abstract_store.csv

  • Jeremy Fourna
    Jeremy Fourna Lead Product Manager Posts: 130 πŸ§‘πŸ»β€πŸš€ - Cadet

    Example for the B2C demo shop

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    mine is B2B

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    is there anything different?

  • Jeremy Fourna
    Jeremy Fourna Lead Product Manager Posts: 130 πŸ§‘πŸ»β€πŸš€ - Cadet
  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    ok I have the same format here ! I have mapping between all the stores and SKUs

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    in theory all the products should be available in all the stores

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    but thats not the case πŸ˜•

  • Jeremy Fourna
    Jeremy Fourna Lead Product Manager Posts: 130 πŸ§‘πŸ»β€πŸš€ - Cadet

    what do you see inside your database, only assignment to the default store?

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    in this spy_product_abstract_store

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    there are all the store mappings

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    executing this

    select count(*), fk_store
    from spy_product_abstract_store
    group by fk_store;
    

    will show a table with all the stores along with the equal count of all products

  • Jeremy Fourna
    Jeremy Fourna Lead Product Manager Posts: 130 πŸ§‘πŸ»β€πŸš€ - Cadet

    so where do you not see this assignment? in the back office or the store front?

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    in Yves

  • Jeremy Fourna
    Jeremy Fourna Lead Product Manager Posts: 130 πŸ§‘πŸ»β€πŸš€ - Cadet

    Do the products have been pushed to the queues (publish & sync)?

  • UQJBF1UKW
    UQJBF1UKW Posts: 5 πŸ§‘πŸ»β€πŸš€ - Cadet

    Maybe check the stocks in the storage table for the particular store. That is a good starting point on where to look next (either redis/P&S or the config)

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    for some reason importing data on DE does not populate data to storage tables except for DE store