Hello community, after a recent update (spryker/product-management 0.19.16 > 0.19.17) the product-management GUI in zed stopped working. The ajax-request which fetches the table-data fails with this error:

Cannot determine the column to bind to the parameter in clause "SpyProductAbstractLocalizedAttributes.fkLocale = ?".

I kinda tracked it down to this line: https://github.com/spryker/product-management/blob/master/src/Spryker/Zed/ProductManagement/Communication/Table/ProductTable.php#L147 If changed from

fkLocale

to

fk_locale

(like the database-column-name) it works. Is it a known problem or do I have do update other dependencies to get it back working again?

Hello, is it possible in spryker to remove a buffered value from the storage client? I want to reload a value that changed meanwhile in the storage since it was loaded first. I saw

unsetCachedKey()

but the value still remains in the buffer, so it seems the buffer is not touched when removing the key. Any suggestions?

hi! Help me please. How i can create new template in Pyz/Yves/ShopUi/Theme/default/templates for home page?

Hey Guys, is there any way for pass first form transfer object to second form, like checkout process, I'm creating multi-step form. Anyone have solution/idea please share, thanks

hi, I had to override one of customer facade methods, but it seems that when I call this method in one of my modules, the original method is called, in my module Im uding factory getContainer()->getLocator()->customer()->facade() to access customer facade, am I doing something wrong? what do I have to do to use my custom facade?

Hey when I am extending a db table can I not add a unique column?

<table name="spy_stock">
            <unique name="spy_stock-other_id">
                <unique-column name="other_id" type="VARCHAR" size="10" required="false"/>
            </unique>
...

Executing migration PropelMigration_1615322855 up
Propel\Runtime\Exception\RuntimeException - Exception: <error>Failed to execute SQL "CREATE UNIQUE INDEX `spy_stock-other_id` ON `spy_stock` (`other_id`(10))". Aborting migration.</error>

FYI: https://github.com/spryker/product-attribute-gui/blob/master/src/Spryker/Zed/ProductAttributeGui/Presentation/View/_partials/add-attribute-form.twig#L17 there is an accidental

c

which shows up when managing attributes for an abstract product

Hello o/, we updated our dependencies. one of the dependency that has been updated was

spryker/discount

from

9.11.0

to

9.11.3

Version

9.11.3

updated the dependency

@spryker/jquery-query-builder

from

~2.5.2"

to

~2.5.2-spryker.1

[1]

Spryker/jquery-query-builder

requires

jQuery.extendext

[2] but does not contain this dependency in the

package.json

[3], like in the original

package.json

[4]. due to this missing dependency our deployment is faulty and our zed ui backoffice is without any asset. can someone help? what migration steps are needed to be done or can we create an bug ticket $somewhere? thanks in advance :) [1] https://github.com/spryker/discount/compare/9.11.2...9.11.3 [2] https://github.com/spryker/jquery-query-builder/blob/2.5.2-spryker.1/README.md [3] https://github.com/spryker/jquery-query-builder/blob/2.5.2-spryker.1/package.json [4] https://github.com/mistic100/jQuery-QueryBuilder/blob/2.5.2/package.json#L15

I'm looking at generated order transfer and many (if not all) methods related to shipment are marked as deprecated, what should I use instead?

Hey Guys, I'm facing issue while login in Yves and Zed UI. Anyone have solution for this.

This message was deleted.

Sorry, for deleting my former post. But, since there is to much risk of exposing a possible XSS vulnerability in ZED, we decided to not talk publicly about it. The report is on it's way to security@

Hello, for the merchant relationship feature, there is a

spy_merchant_relationship

table which represents the m:n mapping between the

spy_merchant

and

spy_company_business_unit

using the the ids of both as foreign key in

spy_merchant_relationship

… However, there is another table

spy_merchant_relationship_to_company_business_unit

which represents another m:n relation between

spy_company_business_unit

and

spy_merchant_relationship

… Do i miss something or isn’t the second table some kind of redundant information since its already represented by the first one? I just wonder why my relation was not created but it seems my facade call didn’t consider this table. Best

Spryker\Yves\Kernel\Controller\AbstractController->redirectResponseExternal()

is deprecated and the doc block advises me to use

Spryker\Yves\Kernel\Plugin\EventDispatcher\RedirectUrlWhitelistValidationEventDispatcherPlugin

instead. But there's no such class available. What package do I need to update to get it?

hi, I've got a question regarding OMS: what does it mean that a path is happy?

Hey when you extend a DB table do you also need to extend the dataImport module that writes initial data? i.e. if I extended the spy_stock table with a field called

description

=>

console data:import:stock

then I would need to update the writer step or something?

What could be the reason for messages having acknowledge: true (in \Spryker\Zed\Queue\Business\Task\TaskManager::postProcessMessages) but not removed from the queue (items still visible in rabbit UI and rerunning the command parses same messages)?

is there a way to get sales order from a period of time using just facade?

Hello, I added 2nd store with shared persistence and same locale to our system and have one problem. Redis for first store contains 5k+ keys and for new store it contains less than 1k keys. It doesn't contain even glossary translations, just products, cms_pages and cms_blocks, but pages don't work (404). Main navigation also isn't rendered

Hi, we are facing the problem that not all used php modules are declared as composer platform dependencies. You are using a posix command in https://github.com/spryker/spryker-core/blob/master/Bundles/Kernel/src/Spryker/Zed/Kernel/RequestIdentifier.php but ext-posix is not declared as a dependency in https://github.com/spryker/spryker-core/blob/master/Bundles/Kernel/composer.json. Can you please fix this?

Hello, Do you know if it's possible to use multi store with same domain with path prefix (similar to language)? Eg shop.com/en and shop.com/de, but not for language, but for store

Hi everybody, since there are often questions in our teams when it comes to asynchronous calls from yves frontend to the zed backend (using ajax etc.) … “glue” is meant almost everytime and i am a bit unsure now^^ Does it make sense to involve the glue API here when we use yves general but want to make some of the parts of the page async loaded? For my understanding, when we use yves anyway it would make sense to stick to a controller in yves to render json for the frontend. Just to be sure: are there any cases/experiences when it make sense to involve the glue API? For my understanding not really, since glue is at the same level as yves on architecture, it should not be “mightier” than the yves framework, or am i completely wrong? In case of a product detail page for example i would render just json with the data that is required in the frontend instead of the whole html … on the other side, glue does have a “standardized” request/response flow which i can imagine would be easier to implement … any experiences here? Best regards

Hello, How can I find product URL? I have product entity and I'd like to return the URL. Is there any helper to do that or should I find it in the DB (where?)?

Howdy, in scope of our update schedule we noticed the spryker/category module was released in version 5.0 a month ago. Current category-gui module not yet supports that new version and also there is no migration guide so far. We do not use/need the gui, so what is your recommendation about updating the module? Is a migration guide planned? Thanks!

Heya, so I got some middleware and it's pulling in a file that represents the stock available at different warehouses. so I'm thinking that middleware should connect up with the ProductStockHydrator, only thing is, one of the columns in the hydrator is

name

which represents the name of the warehouse were the stock will reside. Cool. The incoming file has this data referenced as an external id that has already been written to the

spy_stock

table. This id is also available in the file coming in from the middleware... basically a foreign key for lookup. Question is do I need to build a repository with it's accompanying interface and plugin to it to lookup the name from the

spy_stock

table with the id? so I can make the product to the warehouse. and if Ido need to do that, is this is a decent example of that being done https://github.com/spryker/blog-example/blob/master/src/Spryker/Zed/Blog/Persistence/BlogRepository.php

Good morning everybody, we have a special problem (B2B): If a company user shares a shopping list with another company user, this share disappears after approx. 2 hours. It's like magic, we can't find where thats happens. Has anyone a similar problem before? 🙏

Good morning! Does anyone have experience with recalculating an already placed order? For example in case of cancelled positions by an external erp system? Usecase: an order is placed in the spryker shop, exported to an erp system and the erp system removes one or multiple items because of there was a problem with stock or the customer calls the support and asks for removing a position from an order or similar. Thanks in advance!

@mysterious-pencil-76046 did you try \Spryker\Zed\Sales\Business\SalesFacade::updateOrder ? as I see it is used in SalesReclamationToSalesFacadeBridge, RefundToSalesBridge, and in customer Update action. In my version of Spryker , it uses \Spryker\Zed\Sales\Business\Model\Order\OrderUpdater and inside there are methods

createOrderTotals
updateOrderItems
updateOrderExpenses

judging the names, looks promising 🙂 The only thing, you might probably need to create respective method in \Spryker\Client\Sales\SalesClient to call this SalesFacade::updateOrder()

I guess this one is for someone from spryker team, propel facade provides method getConsoleCommands which can be used in console data provider, I must say I was thinking about such solution as it improves code readability greatly, so instead of list of all commands you want to register, which may be quite a lot, you merge lists pulled from different modules, obvious negative side is that you have less control on which command is registered and which is not, also, I haven't seen this solution to be implemented in other packages is there any reason for that? would you encourage moving lists of commands and plugins to their respective modules? or would you advise againts it?

Hello, we are trying to extend the ProductController from the productdetailpage to provide another route for giving parts of the productview as json response. Since this not a usual route registered via RouterDependencyProvider but via StorageRouterDepedencyProvider we have no clue how to register a new route here … The matching action should be ‘detail’ but thats not the path from the url … url is something like “yves.local/en/test-product-with-a-speaking-url” which match the detail action automatically … how to add some route for providing data in json format?… Best