Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For each sales channel, you will need to set up unified/detailed and full/diff queries.

Mettre plus de contexte

  • export_detailed_{countrysaleschannel}_full - This query can be created at the root to target the details of all stocks available for delivery. As the Ship From Store orchestration query, it should contain two aggregates "stores" and "warehouses" which are the two scopes of stock availability.
    - The “stores” aggregate should contains the items_sfs items query, which lists items eligible for order-taking, and the stores_sfs_{countrysaleschannel}_export stock locations query, which lists stores eligible for export with the Ship From Store module enabled. The parameter “Force usage of stock location filter requested” can be enabled for the stock locations query, this will allow you to filter on specific stock locations if necessary.
    - The “warehouses” aggregate should also use the items_sfs items query, and the warehouses_sfs_{countrysaleschannel}_export stock locations query, which lists warehouses eligible for export with the Ship From Store module enabled. The parameter “Force usage of stock location filter requested” can be enabled for the stock locations query, this will allow you to filter on specific stock locations if necessary.
    All aggregate deductions can be activated (buffers, reservations and unavailabilities) as well as the global reservations parameter.
    ThenNext, the export parameter should be enabled with the “Full” option. A scope key must be specified to identify the perimeter of the export and must be identical to the diff export. It could be, for example “detailed_fr”.

    • FinallyThen, the unified query export_unified_{countrysaleschannel}_full can be created by inheriting from the detailed one. The unification parameter should be changed (unification by sock locations and stock types enabled), and also the scope key of the export parameter should be changed. It could be, for example “unified_fr”.

  • export_detailed_{countrysaleschannel}_diff - This query can be created by inheriting from the “Full” one. Aggregates must remain unchanged.
    However, the export parameter must be changed to "Diff". Make sure the scope key remains the same as the full query, in my example “detailed_fr”. Then, the "Export stock difference instead of raw value" parameter can be activated or deactivated as needed for your project.

    • Then, the unified query export_

    detailed
    • unified_{

    country
    • saleschannel}_diff can be created by inheriting from the detailed one. The unification parameter should be changed (unification by sock locations and stock types enabled), and also the scope key of the export parameter. It could be, for example “unified_fr”.

    export_unified_{country}_diff

➡️ Here's what the export queries might look like, differentiating between the two sales channels/websites "FR" and "UK".

...

For the OIS catalog

For e-reservation

...